Wednesday, March 7, 2012

Connecting to a named SQL2000 db instance from vbscript

My previous connection string looked like this:

strConnect = "Provider=SQLOLEDB.1;Password=Password=password;Per sistSecurity Info=True;User ID=TestUser;Initial Catalog=JabilDB;DataSource=corsqlv02;Use Procedure for Prepare=0"

The new connection string (that doesn't work) looks like this:

strConnect = "Provider=SQLOLEDB.1;Password=Password=password;Per sistSecurity Info=True;User ID=TestUser;Initial Catalog=JabilDBDev;DataSource=corsqlv02\JabilDB;Us e Procedure for Prepare=0"

Do i need to upgrade to the latest MDAC ?

Thanks

Digital_fXForget this. I just needed to install MDAC 2.6 and that solved the problem.

Cheers

No comments:

Post a Comment