February 5, 2010 at 3:34 am
Hi,
My connection string inside visual basic 6.0, to connect to SQL Server 2000 is this one:
"Provider=SQLOLEDB;Integrated Security=SSPI;Initial Catalog=test;Data Source=servername;"
At the company we have changed our SQL Server engine to the 2005 version.
I need to alter this connection string inside my vb 6.0 apps so that they can connect to SQL Server 2005 and i want to change the connection type too (from windows authentication to SQL Server authentication).
Can someone help?
Thank you.
February 5, 2010 at 4:57 am
Using SQL OLEDB:
Provider=SQLOLEDB;Integrated Security=SSPI;User ID=myUserID;Initial Catalog=myDataBase;Data Source=myServerAddress;Password=myPassword;
Using SQL Native Client:
Provider=SQLNCLI;Server=myServerAddress;Database=myDataBase;Uid=myUsername; Pwd=myPassword;
--Ramesh
February 5, 2010 at 7:21 am
Thank you for reply.
Wen you talk about "Using SQL OLEDB" you are talking about connection using the MDAC, correct?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply