trusted connection

I have a connect string like following:

sConnString = "Provider=SQLOLEDB.1;User ID=sa;password=mypassword;Initial
Catalog=MyDatabase;Data Source =MyServer;Use Procedure for Prepare=1;Auto
Translate=True;Packet Size=4096"

I got error connection.
I think I have trusted connection to SQL server.

Can you please advise me how to connect SQL server with trusted connection?
Your information is great appreciated,

Re: trusted connection

Souris wrote:
> I have a connect string like following:
>
> sConnString = "Provider=SQLOLEDB.1;User
> ID=sa;password=mypassword;Initial Catalog=MyDatabase;Data Source
> =MyServer;Use Procedure for Prepare=1;Auto Translate=True;Packet
> Size=4096"
>
> I got error connection.
> I think I have trusted connection to SQL server.
>
> Can you please advise me how to connect SQL server with trusted
> connection? Your information is great appreciated,

You can find examples at
www.connectionstrings.com
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Re: trusted connection

Thanks millions,



"Bob Barrows [MVP]" wrote:

> Souris wrote:
> > I have a connect string like following:
> >
> > sConnString = "Provider=SQLOLEDB.1;User
> > ID=sa;password=mypassword;Initial Catalog=MyDatabase;Data Source
> > =MyServer;Use Procedure for Prepare=1;Auto Translate=True;Packet
> > Size=4096"
> >
> > I got error connection.
> > I think I have trusted connection to SQL server.
> >
> > Can you please advise me how to connect SQL server with trusted
> > connection? Your information is great appreciated,
>
> You can find examples at
> www.connectionstrings.com
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
>
>