64bit: Provider is not specified and there is no designated default provider.

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.
Tags: , ,

About author

Vittorio Pavesi

1 comments

  1. Thanks - this just came up (moving to a new server), and it was exactly the problem, and the solution.

Post a Comment