OLEDB vs. ODBC Connection
If you are given the choice to choose between using an OLEDB
or ODBC connections, you should always choose an OLEDB
connection. The ODBC connection type has been around for years
and is based on older and more bug laden technology. You should
of course check to see if your web hosting provider supports the
OLEDB connection in their web hosting environment.
Even Microsoft agrees and states it right on their web site:
"When you run Microsoft Jet in an IIS environment, it is
recommended that you use the native Jet OLE DB Provider in place
of the Microsoft Access ODBC driver. The Microsoft Access ODBC
driver (Jet ODBC driver) can have stability issues due to the
version of Visual Basic for Applications that is invoked because
the version is not thread safe. As a result, when multiple
concurrent users make requests of a Microsoft Access database,
unpredictable results may occur. The native Jet OLE DB Provider
includes fixes and enhancements for stability, performance, and
thread pooling (including calling a thread-safe version of
Visual Basic for Applications)."
Source link:
Microsoft Knowledgebase article ID: 299973
Connection Types:
- ODBC driver
- OLE DB Provider
Variable Legend
| Variable Name | Substitute variable with: |
|---|---|
| Server | Replace with your server host address. |
| DBName | Replace with your database name |
| User | Replace with your database's username |
| Password | Replace with your database's password |