Text 38, 273 rader
Skriven 2004-11-15 15:22:48 av madodel@ptdprolog.net
Ärende: [VOICENWS] SW: unixODBC for OS/2 version 0.10 released
==============================================================
[204.186.29.136])
with qmail-scanner-1.20
(authenticated:madodel@[24.238.72.16])
From: lsunleyDESPAM@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@mb.sympatico.ca
--
Lorne Sunley
Url: http://hobbes.nmsu.edu
From: Lorne Sunley (lsunleyDESPAM@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@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@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@os2voice.org
---
* Origin: Waldo's Place USA Internet Gateway (1:3634/1000)
|