The file unixodbc009.zip is on Hobbes http://hobbes.nmsu.edu/cgi-bin/...
The database drivers included in this release are:
- Flat text files (comma delimited ASCII)
- Flat DBF file
- postgreSQL database
- mySQL database
- FreeTDS (Sybase and MS SQL Server)
- SQLite ODBC driver and support library
Package Contents:
- driver manager (ODBC.DLL)
- installation API (ODBCCP.DLL)
- cursor library (ODBCCR.DLL)
- mySQL client library (libmysqC.dll)
- mySQL database driver and client (myODBC3.DLL libmysqC.dll)
- postgreSQL database driver (psqlODBC.dll)
- text file driver (ODBCtxt.dll ODBCtxtS.dll)
- DBF file driver (ODBCdbf.dll ODBCdbfS.dll)
- TDS database driver (ODBCtds.dll)
- SQLite file database driver (SQLLODBC.dll)
- PM ODBC Data Manager
- PM SQL Query
- RexxSQL modules for ODBC (RexxSQL and RexxODBC)
- Sample databases for text and DBF drivers
- Sample Rexx programs
- GCC 3.2.2 runtime (LIBC05.DLL)
Suggestions:
When using databases on your local network and you do not have a local DNS (Domain Name Server) you should have SET USE_HOSTS_FIRSTS=Y in the config.sys file and have your HOSTS file in mptnetc updated with the IP number to host names.
The myODBC3 driver and the FreeTDS driver have a very long timeout for DNS lookups and your system will appear to lock up until the DNS lookup times out and the local HOSTS file is checked unless you have USE_HOSTS_FIRST specified
Fixes:
Update 009
- The DBF ODBC driver configuration now allows 255 byte directory paths
- The text file ODBC driver configuration now allows 255 byte directory paths
- removed the "In connect" message displayed by SQLConnect
- SQLDriverConnect for the SQLite ODBC driver would not work
- SQLite ODBC driver did not report supporting SQLSetCursorName correctly
- mySQL ODBC driver was not returning correct maximum buffer size values for column descriptions of catalog functions
- mySQL ODBC driver was not testing for TRACE enabled correctly
- when mySQL ODBC was set to pad columns the PM ODBC DataMmanager program would crash and the request of tables for a specific database would fail
- RexxSQL was linked with an older version (pre Update 007) of ODBC.DLL
Known Problems:
- RexxSQL does not work properly with the ODBCtxt and ODBCdbf drivers
The problem is in the drivers, they have to be enhanced to support the functionality required by RexxSQL
Changes in the pipeline:
- make SQLDriverConnect work properly
- improvements to the PM ODBC Data Manager to allow you create tables in the database with "point and click" interface.
- data transfer utility that lets you move tables and data from one DSN to another.
feel free to e-mail me with comments or problems.
All programs are licensed under the LGPL with the exception of SQLite ODBC which is a BSD licence and SQLite itself which is public domain
Source: