Which odbc driver is installed

You must obtain ODBC drivers from another vendor. However, the drivers are not configured automatically, so you must do this by using the operating system ODBC administrator privileges. There is also a bit variant. But for DataConnect, bit data sources are required. Open the ODBC icon. Target Table ACLs. The user you use to query the database must have read access for the tables that you want to query.

For example, a user with the itil role can read task tables, such as Incident. Target Table Web Service Access. The table you want to query must allow web service interaction. Note though that if you have both versions bit and bit of the driver installed and you have configured a User DSN in contrast to a System DSN , you will be able to use the same DSN for bit and bit applications see the Platform column in the screenshot below.

In a situation where you need to use an application that is available only in bit, the bit ODBC driver does the trick. An example is Apache OpenOffice, which is distributed as a bit application. How To. ODBC Drivers. What is an ODBC driver and a data source? Author Recent Posts.

DAC Team. Both kinds of drivers are provided in the same download package, and are both installed onto your systems by the installation program or script that comes with the download package.

For example, myodbc8w. Related: The previously described file names contain an "8", such as myodbc8a. File names with a "5", such as myodbc5a. ADO: rs. DAO: rs.