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.
Share on Google Plus

About Vittorio Pavesi

    Blogger Comment
    Facebook Comment

1 comments:

Robert said...

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