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