Difference: DatabaseInterfaceUpgrades (12 vs. 13)

Revision 132008-06-12 - JoeOrtagus

Line: 1 to 1

META TOPICPARENT	name="APPX43Features"

Database Interface Upgrades

Compatibility with newer versions of popular databases is among the many features of APPX 4.3.

Line: 476 to 476

[root@tubes mysql-connector-odbc.from.mysql.com]#

Added:

>
>

Determine where UnixODBC expects odbc.ini and odbcinst.ini configuration files to be located.

The odbc.ini and odbcinst.ini configuration files can be located on various places in your server's file system. The safest way to make sure you are working on the correct location is to run odbcinst -j. Here is an example:


[root@tubes tools]# odbcinst -j
unixODBC 2.2.11
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
USER DATA SOURCES..: /root/.odbc.ini
[root@tubes tools]#

Here you can see that UnixODBC is expecting the two system configuration files to be located at /etc/odbc.ini and /etc/odbcinst.ini. Now that we know the location, let's configure the files.

Configure /etc/odbc.ini

The odbc.ini file contains a list of Data Sources and any properties for each. There are two types of odbc.ini files; 1) System and 2) User. The System odbc.ini file usually exists as /etc/odbc.ini or /usr/local/etc/odbc.ini while the user usually exist as ~/.odbc.ini. We need to build the odbc.ini file. The odbc.ini file content is driver specific (MySQL, PostgreSQL, FreeTDS, MiniSQL etc...). My file looks like this:

View topic | History: r25 < r24 < r23 < r22 | More topic actions...