DBD-ODBC
view release on metacpan or search on metacpan
Fixed issue with TRACESTATUS change in 20SqlServer.t tests 28, 31, 32
and 33 leading to those tests failing when testing with SQL Server 2005
or Express.
Many compiler warnings fixed - especially for incompatible types.
Add provisional Unicode support - thanks to Alexander Foken. This change
is very experimental (especially on UNIX). Please see ODBC.pm
documentation. Also see README.unicode and README.af. New database
attribute odbc_has_unicode to test if DBD::ODBC was built with UNICODE
support. New tests for Unicode. New requirement for Perl 5.8.1 if
Unicode support required. New -[no]u argument to Makefile.PL. New
warning in Makefile.PL if Unicode support built for UNIX.
Fix use of unitialised var in Makefile.PL.
Fix use of scalar with no effect on Makefile.PL
Added warning to Makefile.PL about building/running with LANG using
UTF8.
Added warning to Makefile.PL about using thread-safe ODBC drivers.
Updated MANIFEST to include more test code from mytest and remove
MANIFEST.SKIP etc.
Removed calls to get ODBC errors when SQLMoreResults returns
SQL_NO_DATA. These are a waste of time since SQL_NO_DATA is expected
and there is no error diagnostic to retrieve.
Changes to test 17 of 02simple.t which got "not ok 17 - Col count
matches correct col count" errors with some Postgres ODBC
drivers. Caused by test expecting column names to come back
uppercase. Fixes by uppercasing returned column names.
Changes to tests in 03batt.t which correctly expects an ODBC 3 driver to
return the column names in SQLTables result-set as per ODBC 3.0
spec. Postgres which reports itself as an ODBC 3.0 driver seems to
return the ODBC 2 defined column names. Changed tests to catch ODBC 2.0
names are pass test put issue warning.
For postgres skip test (with warning) checking $sth->{NAME} returns
empty listafter execute on update
Updated FAQ, added a few more questions etc.
DBD::ODBC requires at least 5.6.0 of Perl.
Many updates to pod documentation.
Removed some dead HTTP links in the pod I could not find equivalents for
- let me know if you have working replacements for ones removed
Add some HTTP links to useful tutorials on DBD::ODBC
1.13 2004-11-08
Fix inconsistency/bug with odbc_exec_direct vs. odbc_execdirect
settings. Now made consistent with odbc_exec_direct. For now, will
still look for odbc_execdirect in prepare, but not as DBH attribute as a
backup (which is what it was doing), but that support will be dropped at
some time in the future. Please use odbc_exec_direct from now on...
Fix handling of print statements for SQL Server thanks to Martin Evans!
Thanks for all your work on this!
Due to bug in SQL Server, you must use odbc_exec_direct. See
t/20SqlServer.t for example. You will need to call
$sth->{odbc_more_results} to clear out any trailing messages.
Change tests to use Test::More. Whew, that's much nicer!
Fix Oracle integral/numeric output params so that warning not printed
about value not being numeric (even though it is!)
1.12 2004-10-26
Fix bug with odbc_execdirect attributed thanks to Martin Evans
Fix bug(s) with odbc_query_timeout and tested with SQL*Server. Oracle
tests failed with setting timeout. Probably not handled by Oracle's
ODBC driver
1.11 2004-10-11
Added odbc_timeout, but untested
1.10 2004-09-08
Fixed bug in Makefile.PL.
Added pod.t test, taken from DBI.
Fixed various small POD issues, discovered during the pod test.
Fixed bug in bind_param_inout
1.09 2004-03-10
Duh. I forgot to add new dbivport.h to MANIFEST and SVN before
submitting. Fixed.
1.08 2004-03-06
Added check in Makefile.PL to detect if the environment variable LANG is
Set. If so, prints a warning about potential makefile generation
issues.
Change to use dbivport.h per new DBI spec.
Add ability to set the cursor type during the connect. This may allow
some servers which do not support multiple concurrent statements to
permit them -- tested with SQL Server. Thanks to Martin Busik! See
odbc_cursortype information in the ODBC POD.
1.07 2004-02-19
Added to Subversion version control hosted by perl.org. Thanks Robert!
See ODBC.pm POD for more information.
Added contributing section to ODBC.pm POD -- see more details there!
Added Support for esodbc (per Martin Evans)
Added Support for Easysoft (per Bob Kline)
Changed table_info to produce a list of views, too.
Fixed bug in SQLColumns call.
Fixed blob handling via patches from Jochen Wiedmann.
Added data_sources capability via snarfing code from DBD::Adabas (Jochen
Wiedmann)
0.20 1998-08-14
SQLColAttributes fixes for SQL Server and MySQL. Fixed tables method by
renaming to new table_info method. Added new tyoe_info_all method.
Improved Makefile.PL support for Adabase.
0.19 Unknown
Added iODBC source code to distribution.Fall-back to using iODBC header
files in some cases.
0.18 Unknown
Enhancements to build process. Better handling of errors in error
handling code.
0.17 Unknown
This release is mostly due to the good work of Jeff Urlwin. My eternal
thanks to you Jeff.
Fixed "SQLNumResultCols err" on joins and 'order by' with some drivers
(see Microsoft Knowledge Base article #Q124899). Thanks to Paul
O'Fallon for that one.
Added more (probably incomplete) support for unix ODBC in Makefile.PL
Increased default SQL_COLUMN_DISPLAY_SIZE and SQL_COLUMN_LENGTH to 2000
for drivers that don't provide a way to query them dynamically. Was 100!
When fetch reaches the end-of-data it automatically frees the internal
ODBC statement handle and marks the DBI statement handle as inactive
(thus an explicit 'finish' is *not* required).
Also:
LongTruncOk for Oracle ODBC (where fbh->datalen < 0)
Added tracing into SQLBindParameter (help diagnose oracle odbc bug)
Fixed/worked around bug/result from Latest Oracle ODBC driver where in
SQLColAttribute cbInfoValue was changed to 0 to indicate fDesc had a value
Added work around for compiling w/ActiveState PRK (PERL_OBJECT)
Updated tests to include date insert and type
Added more "backup" SQL_xxx types for tests
Updated bind test to test binding select
NOTE: bind insert fails on Paradox driver (don't know why)
Added support for: (see notes below)
SQLGetInfo via $dbh->func(xxx, GetInfo)
SQLGetTypeInfo via $dbh->func(xxx, GetTypeInfo)
SQLDescribeCol via $sth->func(colno, DescribeCol)
SQLColAttributes via $sth->func(xxx, colno, ColAttributes)
SQLGetFunctions via $dbh->func(xxx, GetFunctions)
SQLColumns via $dbh->func(catalog, schema, table, column, 'columns')
Fixed $DBI::err to reflect the real ODBC error code which is a 5 char
code, not necessarily numeric.
Fixed fetches when LongTruncOk == 1.
Updated tests to pass more often (hopefully 100% <G>)
Updated tests to test long reading, inserting and the LongTruncOk attribute.
Updated tests to be less driver specific.
They now rely upon SQLGetTypeInfo I<heavily> in order to create the
tables. The test use this function to "ask" the driver for the name of
the SQL type to correctly create long, varchar, etc types. For example,
in Oracle the SQL_VARCHAR type is VARCHAR2, while MS Access uses TEXT
for the SQL Name. Again, in Oracle the SQL_LONGVARCHAR is LONG, while
in Access it's MEMO. The tests currently handle this correctly (at
least with Access and Oracle, MS SQL server will be tested also).
( run in 3.013 seconds using v1.01-cache-2.11-cpan-98e64b0badf )