The file unixodbc004.zip is on Hobbes http://hobbes.nmsu.edu...
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)
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)
- 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 004
- The postgreSQL driver now works with StarOffice 5.1
- The postgreSQL driver SQLTables function now works correctly this was causing the ODBC Data Manager to fetch multiple copies of the tables and schemas
- The mySQL driver now works with StarOffice 5.1 the field column layouts for catalog, stats, primary keys, etc did not match the layout expected by the libmysqC routines.
Update 003
- change install layout to place drivers in uodbcdll
corrects problem where dialog boxes for configuration would not display for some drivers
- correct failure when testing connection for a new mySQL DSN
Improvements:
Update 004
- PostgreSQL ODBC driver now has a new configuration GUI and there is also a GUI for configuring the driver defaults "Add" and "Configure" on the drivers page of the ODBC Administration notebook. The driver
has been rebuilt to support ODBC version 3.00 (was 2.5) All trace options are built into the driver.
- mySQL ODBC driver now has a new configuration GUI and there is also a GUI for configuring the driver defaults "Add" and "Configure" on the drivers page of the ODBC Administration notebook. The driver and the libmysqc library have been built with trace support and the trace file used can be specified on the "Trace" page. When you specify a driver letter the colon ":" must be doubled as in "C::/odbclog/mytrace.log"
Update 003:
- RexxSQL has been added to the package. RexxSQL.dll and RexxODBC.dll are installed to the package DLL directory and the RexxSQL.exe and RexxODBC.exe are installed to the BIN directory. These versions of the programs are specific to a 3.0 level of ODBC driver manager.
A Sample Rexx program has been added to the SAMPLES directory.
The web site for RexxSQL is http://rexxsql.sourceforge.net
- A fix has been made to the myODBC3 driver. The driver catalog functions did not return the correct size for some columns in the table and column catalogs.
- FreeTDS database driver for Sybase and MS SQL server has been added to the package. This driver is based on the 0.62.4 FreeTDS code and will be updated to the latest code in the near future. The current driver
version uses .conf files for some configuration information. The files are installed to uodbcconfigure.
The web site for FreeTDS is http://www.freetds.org
This is an beta driver - it works but not for everything.
Update 002:
The PM SQL Query window now provides for:
- load and save of query text to files
- saving query results to a command delimited text file
- prompting for user name and password when not present in the DSN
The PM ODBC Data Manager now provides for:
- prompting for user name and password when not present in the DSN
The package includes a port of the version 4 mySQL client library.
This library is named libmysqC.dll and should not interfere if you have a local mySQL database installation. This library is compiled with GCC 3.2.2. Thanks to all those people who did the port of the mySQL database to OS/2.
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
Source: