Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 .NET Inside SQL Server (2005)
 Connectivity

Author  Topic 

pdset
Constraint Violating Yak Guru

310 Posts

Posted - 2010-03-04 : 20:19:14

Can anyone please help in this connectivity problem?

When I tried to login from the VB Platform using this Syntax then I have problem not able to connect:

Error:
“Invalid object name <table name>”.

SYNTAX for the Connectity:

myconn.ConnectionString = "Driver={SQL Server}; Server=GRKLM; DataSource=GRKLM; userid=CHAN/ADMINISTRATOR; password=;"

Even with SA as USERID is also giving the ABOVE mentioned Error.

In the place of USERID substituted with 'BUILTIN\Administrator' OR 'sa'

Can anyone help in this regard.

mdgryn
Starting Member

6 Posts

Posted - 2010-03-24 : 06:17:42
you must be using sspi
Go to Top of Page
   

- Advertisement -