Difference between revisions of "Access databases (MS Access)"
From Hostek.com Wiki
| Line 5: | Line 5: | ||
NOTE: MS Access 97 and later versions are supported. However, when possible we suggest you upgrade the database to MS Access 2000 or later. Further, we strongly suggest converting the database to MySQL or MS SQL. | NOTE: MS Access 97 and later versions are supported. However, when possible we suggest you upgrade the database to MS Access 2000 or later. Further, we strongly suggest converting the database to MySQL or MS SQL. | ||
| + | |||
| + | == Troubleshooting == | ||
| + | ===800a0e7a Error=== | ||
| + | |||
| + | <pre> | ||
| + | ADODB.Connection error '800a0e7a' | ||
| + | |||
| + | Provider cannot be found. It may not be properly installed. | ||
| + | |||
| + | /config.inc.asp, line 21 | ||
| + | </pre> | ||
| + | |||
| + | If you receive the error above it may be because you are on a Windows 2008 Server and need to update your connection string to use the 64-bit Access driver: | ||
| + | |||
| + | CHANGE: | ||
| + | <pre> | ||
| + | Provider=Microsoft.Jet.OLEDB.4.0; | ||
| + | </pre> | ||
| + | TO: | ||
| + | <pre> | ||
| + | Provider=Microsoft.ACE.OLEDB.12.0; | ||
| + | </pre> | ||
| + | |||
| + | === 80004005 Error === | ||
| + | |||
| + | <pre> | ||
| + | Microsoft OLE DB Provider for ODBC Drivers error '80004005' | ||
| + | |||
| + | [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified | ||
| + | |||
| + | /config.inc.asp, line 31 | ||
| + | </pre> | ||
| + | |||
| + | If you receive the error above it may be because you need to update the Access driver in your code as shown below: | ||
| + | |||
| + | CHANGE: | ||
| + | <pre> | ||
| + | Driver={Microsoft Access Driver (*.mdb)}; | ||
| + | </pre> | ||
| + | TO: | ||
| + | <pre> | ||
| + | Driver={Microsoft Access Driver (*.mdb, *.accdb)}; | ||
| + | </pre> | ||
[[Category:Databases-Access]] | [[Category:Databases-Access]] | ||
Revision as of 07:00, 5 July 2012
Contents
MS Access Databases - General Information
We do support MS Access databases on our Windows servers.
We support both DSN and DSN-less connections. The DSN can be set up through your Account Control Panel.
NOTE: MS Access 97 and later versions are supported. However, when possible we suggest you upgrade the database to MS Access 2000 or later. Further, we strongly suggest converting the database to MySQL or MS SQL.
Troubleshooting
800a0e7a Error
ADODB.Connection error '800a0e7a' Provider cannot be found. It may not be properly installed. /config.inc.asp, line 21
If you receive the error above it may be because you are on a Windows 2008 Server and need to update your connection string to use the 64-bit Access driver:
CHANGE:
Provider=Microsoft.Jet.OLEDB.4.0;
TO:
Provider=Microsoft.ACE.OLEDB.12.0;
80004005 Error
Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified /config.inc.asp, line 31
If you receive the error above it may be because you need to update the Access driver in your code as shown below:
CHANGE:
Driver={Microsoft Access Driver (*.mdb)};
TO:
Driver={Microsoft Access Driver (*.mdb, *.accdb)};