sql server connect: Connect to SQL 2005 from VB 6.0 with Ured ID and Passwoed -- sql server connect

Connect to SQL 2005 from VB 6.0 with Ured ID and Passwoed

Bob and Sharon Hiller
3/16/2006 1:35:37 PM

sql server connect:

I am trying to connect to a SQL 2005 Database from VB 6.0. If I use windows
log on all works well. If I try to use SQL server logon I always get this
error:
(Login failed for user '<LoginName>'. Reason: Not associated with a trusted
SQL Server connection)
I have setup many users in the Server security section and in my database
user section. All have full rights but still cannot log on. The Server is
set up in dual mode Windows and SQL

The SQL 2005 is running on Windows XP pro, not a server.

Thanks,
Bob Hiller

Re: Connect to SQL 2005 from VB 6.0 with Ured ID and Passwoed

Gabriele Bertolucci
3/16/2006 7:24:03 PM

[quoted text, click to view]

May you post the full connectionstring you are using?

--
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution