Date: Mon, 15 Nov 2004 15:22:48 -0500 From: madodel at ptdprolog.net Subject: [VOICENWS] SW: unixODBC for OS/2 version 0.10 released From: lsunleyDESPAM at mb.sympatico.ca unixODBC for OS/2 version 0.10 released. This is a replacement for other ODBC driver managers and will work with the QE database drivers supplied with DBExpert and with the drivers release with Louts Smartsuite for OS/2. The OS/2 DB2 driver also works. The file unixodbc010.zip is on Hobbes http://hobbes.nmsu.edu/cgi-bin/h-search?key=unixodbc010.zip 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 \mptn\etc 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 010 - The DBF ODBC driver had several bugs (update 009 shipped a copy of the driver that was half way through being updated :-( This version will operate with Star Office 5.1 in read only mode and PMODBCDM will correctly display the tables and columns for DBF files. RexxSQL will also work with the driver. - RexxSQL fixed SQLDataSources 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 Update 008 - The ODBC DBF file driver has been fixed so that it now works to some extent with IBM VA Smalltalk v6.0 and Star Office 5.1. The driver will only work in "read only" mode with Star Office. The driver will now allow you to bind columns after SQLPrepare as well as SQLExecute. Update 007 - the "Test connection" button was missing on the mySQL driver connection page. - Some functions were not exported in ODBC.DLL that caused the driver manager to fail when used with Visualage Smalltalk versions 5.5 and 6.0 - experimental work on allowing update cursors in mySQL ODBC (incomplete for testing only) Update 006 - PMODBCDM program would fail if drivermanager DLL was loaded by Star Office - mySQL driver did not load driver defaults when no DSN was present in connection string Update 005 - The postgreSQL driver set SQL_DATETIME as an "unknown" data type - The mySQL driver set SQL_DATETIME as an "unknown" data type 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 \uodbc\dll 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 010 - SQLite ODBC driver is updated to version 0.66 of the code - new sample \uodbc\samples\rexx\souresa.cmd shows how to use the SQLDataSources procedure Update 009 - The SQLite ODBC driver has been updated to the v0.65 code. The driver also supports "memo" as a datatype for compatibility with code written for DBF ODBC drivers. Update 008 - the SQLite ODBC driver is now included in the package. The supporting SQLITE28.DLL is also installed. Update 007 - The PM Datamanager program will now allow you to connect to a database with SQLDriverConnect when "Connect" is selected for a database Driver. If the connection is successful the driver entry has a database tree showing the tables present in the database. - the mySQL driver now supports prompting for SQLDriverConnection 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 \uodbc\configure. 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 driver The problem is in the driver, it has to be enhanced to support the functionality required by RexxSQL Changes in the pipeline: - make SQLDriverConnect work properly for all drivers - 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 lsunleyDESPAM at mb.sympatico.ca -- Lorne Sunley Url: http://hobbes.nmsu.edu From: Lorne Sunley (lsunleyDESPAM at mb.sympatico.ca) Submitted with the form on http://www.os2world.com/submit_news.php -- Warpstock Europe 2004, Arnhem, The Netherlands, November 26-28th, 2004 http://www.warpstock.net Warpstock 2005 - Where/When? Stay tuned to http://www.warpstock.org [Moderator's note: All posts are sent without guarantee to the accuracy of the content. We try to verify details and URLs but this is an entirely volunteer run list, so 100% fact checking and the quality/useability of products announced here is impossible. If you respond to this post please remove the DESPAM from the poster's email addresses. Please do not send requests for information about a specific post to the moderator unless it is an update or I sent it.] -- To unsubscribe yourself from this list, send the following message to majormajor at os2voice.org unsubscribe news end Or, visit http://www.os2voice.org/MailingLists.html If you have an announcement you would like posted to the VOICE News list, please send it to submit at os2voice.org. Please include a valid reply address and a real contact name. If you wish to comment on this post, please reply to feedback at os2voice.org