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

FYI
i got it to work it is the same for SQL 2008...

i was logged in as administrator running the exe i log in as the server name and that worked...

Thx Rino