Very Computer

by **atrigue..** » Sat, 23 Mar 2002 13:07:37

By using SQLOLEDB as the provider in my connection string, I am able to use
Standard Security. However, despite the fact that my development box has a
trusted connection with the SQL Server, I cannot login trusted. I
consistently get the error message, "Not associated with a trusted
connection" I have tested my trusted connection status via an ISQL window
and indeed I can connect as trusted, but my VB app cannot. Here is the
connection string I have been using:

Provider=SQLOLEDB;Integrated Security=SSPI;Persist Security
Info=true;database=DatabaseName; User ID=; password=; server=ServerName;"

Thanks
AW

by **Sue Hoegemeie** » Sat, 23 Mar 2002 13:56:53

AW,
Try removing the User ID and Password from the connection
string.

--Sue

On Fri, 22 Mar 2002 04:07:37 GMT,

>By using SQLOLEDB as the provider in my connection string, I am able to use
>Standard Security. However, despite the fact that my development box has a
>trusted connection with the SQL Server, I cannot login trusted. I
>consistently get the error message, "Not associated with a trusted
>connection" I have tested my trusted connection status via an ISQL window
>and indeed I can connect as trusted, but my VB app cannot. Here is the
>connection string I have been using:

>Provider=SQLOLEDB;Integrated Security=SSPI;Persist Security
>Info=true;database=DatabaseName; User ID=; password=; server=ServerName;"

>Thanks
>AW

Very Computer

sql 6.5 ado using vb6 trusted connection failure

sql 6.5 ado using vb6 trusted connection failure

sql 6.5 ado using vb6 trusted connection failure