December 8, 2006 at 8:16 am
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
ok, just found the answer:
Provider=SQLNCLI
December 12, 2006 at 5:36 pm
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. SelburgViewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply