ODBC to access MS Access

[Anonymous]

Is it possible to use ODBC to access data in Access, if Cloverleaf 5.2 is on AIX and the Access Db is on a

Topic

[Jonathan Hamilton]

Hey Karl,

I don’t believe you can do it out of the box with an Access database.  If it is possible it will require the Quovadx ODBC drivers.

You might find more information here http://support.microsoft.com/default.aspx/kb/253580/en-us

A third party option is this (really expensive and no Tcl support)

http://openaccesssoftware.com/products/openrda/unix_access.asp

Depending on the purpose of the database you could use Postgres or Mysql on AIX, then use Access as a user frontend to the databases.  Both of these databases have Tcl extension to make access from Cloverleaf real easy plus it would be easily upgradable in the future.  We use this method for connecting to our support database which houses all of our interface stats and confirgurations.

[garry r fisher]

Hi,

I would have thought this would be quite simple. You will need the ODBC Tcl extensions and a suitable database driver (obviously). Once you have these point your driver to the database location (this could be in odbc.ini but its depends on the OS).

The database does not need to reside on your Cloverleaf box so this method should work for any database you choose. One thing that might be of interest if you can program/complie your own code and want to use MySQL is: http://www.fastbase.co.nz/fbsql/index.html

Regards

Garry

[Author]

Replies