Post reply

VBSCript Connection string 2005 64 Bit

  • December 8, 2006 at 8:16 am

    #69447

    Hi

    The following connection string works fine in 2000, but fails in 2005, 64 Bit:

    Provider=MSDASQL;Persist Security Info=False;Extended Properties=DRIVER=SQL Server;SERVER=%InstanceName%;APP=Worker;DATABASE=Job;Trusted_Connection=Yes

    Its used in a piece of VBSCRIPT. I'm not a developer, so would appreciate some help in getting this to work in 2005 64bit.

    It errors with "Provider cannot be found. It may not be properly installed."

    Thanks

    Andy

  • December 8, 2006 at 8:24 am

    #676921

    ok, just found the answer:

    Provider=SQLNCLI

  • December 12, 2006 at 5:36 pm

    #677675

    For future reference, the site below has it all!!

    http://www.connectionstrings.com

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply