View Single Post
 
Old November 23rd, 2009, 03:39 PM
RinoDM RinoDM is offline
Friend of Wrox
Points: 550, Level: 8
Points: 550, Level: 8 Points: 550, Level: 8 Points: 550, Level: 8
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2006
Location: , , .
Posts: 112
Thanks: 12
Thanked 0 Times in 0 Posts
Default VB app connect to DB using DB_CONNECT???

Hi to all...

I have a VB app that I was using with SQL 2000 and was working fine...
I was connecting to the DB using the following

DB_CONNECT = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Connect Timeout=30000;Persist Security Info=False;User ID=sa;Initial Catalog=DBName;Data Source=ServerName"

Now we got a new server which has SQL 2008 studio...
and i used the above to connect and i get an error cannot open DB login failed...
i changed the user ID the data source to the new server info...

is it the correct line to us for SQL 2008 ???

thanking you in advance

Rino