Date: Sat, 25 Sep 2004 20:21:06 -0300 From: madodel at ptdprolog.net Subject: [VOICENWS] SW: Update 3 for unixODBC for OS/2 From: lsunleyDESPAM at mb.sympatico.ca I have released the third version of unixODBC for OS/2 The file unixodbc003.zip is on Hobbes Download: http://hobbes.nmsu.edu/pub/incoming/unixodbc003.zip Search: http://hobbes.nmsu.edu/cgi-bin/h-search?key=unixodbc003.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) 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 \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 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 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 and ODBCdbf drivers The problem is in the drivers, they have to be enhanced to support the functionality required by RexxSQL - ODBC Data Manager will end up fetching multiple repeats of schemas and their tables from MS SQL Server. 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 lsunleyDESPAM at mb.sympatico.ca Url: http://hobes.nmsu.edu Submitted with the form on http://www.os2world.com/submit_news.php -- Warpstock 2004, Denver, Colorado, October 21 - 24, 2004 http://www.warpstock.org Warpstock Europe 2004, Arnhem, The Netherlands, November 26-28th, 2004 http://www.warpstock.net [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