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
Wednesday, March 7, 2012
Connecting to a named SQL2000 db instance from vbscript
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment