|
sql server 2000 validation problems
I am having trouble connecting vb program to sql server 2000 developer's edition database. Here is line I used in program to attempt to connect to database:
connect.Open "provider=sqloledb;server=falcon;database=unbound" , "jdoe2", "falcon2"
the error I receive from vb6 was: "log in failed for jdoe2,Reason:Not associated with a trusted sql server connection."
I gave account jdoe2 permission to access the unbound database in sql server 2000 Security folder. What am I doing wrong? Thanks for help. cm
|