Running a VBS that open a connection to SQL Server from a 64bit server is a little different than 32bit...
You can experience the following error:
"Provider not specified and there is no designated default provider"
This occurs because there is no 64-bit version of MSDASQL.DLL which is Ole db provider for ODBC drivers. If you want to to connect from 64-bit world you need to use an OLEDB provider, in SQL server case it will be SQLOLEDB.
Just replace Driver={SQL Server} or DSN=MyDSN with Provider=SQLOLEDB into the connection string.
Home /
64bit
/
Scripting
/
SQL
/
64bit: Provider is not specified and there is no designated default provider.
- Blogger Comment
- Facebook Comment
Subscribe to:
Post Comments
(
Atom
)
1 commenti:
Thanks - this just came up (moving to a new server), and it was exactly the problem, and the solution.
Post a Comment