Connecting to databases directly without client libraries installed
|Top Previous Next|
You can connect to MySQL, PostgreSQL, Oracle, and SQLite databases without having to install the corresponding database engine's client connectivity libraries.
For MySQL, you have the option to connect directly, or use the libmysqld.dll client library.
For PostgreSQL, Access OLE Export always connects directly to the server, without the need for any client libraries to be installed.
For Oracle, you can connect directly to a server without using the Oracle Call Interface (OCI) library. However, there are some limitations to using the direct mode, the details of which can be found here.
For SQLite, you can connect directly, or use the sqlite3.dll file. If you choose to connect directly, Access OLE Export uses version 3.7.13 of the SQLite engine.