Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    Posts
    2

    Arrow Unanswered: Connecting to a named SQL2000 db instance from vbscript

    My previous connection string looked like this:

    strConnect = "Provider=SQLOLEDB.1;Password=Password=password;Pe rsistSecurity 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;Pe rsistSecurity 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_fX

  2. #2
    Join Date
    Feb 2002
    Posts
    2
    Forget this. I just needed to install MDAC 2.6 and that solved the problem.

    Cheers

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •