|
I get an error like:
ADODB.Connection error '800a0ea9'
Provider is not specified and there is no designated default provider.
|
|
|
This can happen if you are using a 64-bit version of Windows with a SQL Server database. To correct the issue, you will need to use a different connection setting for gsConnect in your database configuration files. The setting should look like this:
gsConnect = "Provider=SQLOLEDB;User ID=SQLUser;Password=SQLPassword;Initial Catalog=YourDatabase;Data Source=YourServer;Network Library=DBMSSOCN;"
This should all be on a single line. You should replace "SQLUser" and "SQLPassword" with your username and password, "YourDatabase" with your database's name, and "YourServer" with the database server's IP address.
|
