[ANN] DbxoODBC 2.015 - Kylix/Delphi Open Source ODBC dbExpress driver

From: Vadim V.Lopushansky (vadim_at_unknown.net)
Date: 05/24/04


Date: Mon, 24 May 2004 14:48:59 +0300

Hello, All!

DbxoODBC 2.015 - Kylix/Delphi Open Source ODBC dbExpress driver.

WhatNews:

  Version 2.015, 2004-05-23
-------------------------

  [ Dmitry Arefiev <darefiev@gs-soft.ru> ]

+ changed: ISqlCommandOdbc now supported by TSqlCommandOdbc
+ added: TSQLMetaDataOdbc.SetOption supports schema and catalog names.
    Also other metadata related code uses these option values.
+ changed: extended Unicode support
+ added: optimized routines string <-> bcd conversions
+ changed: beginTransaction set SQL_ATTR_TXN_ISOLATION only if it was
changed.
  It allows to overcome issue with DB2& "CLI0126E".
+ changed: TSqlCommandOdbc.Get/Set Option was returning error for
    xeCommTransactionID option. I have removed that, to make driver more
    compatible with Borland ones.
+ changed: fixed TSqlCommandOdbc.setParameter. It was transmiting wrong
length
    values to SQLBindParameter when length was around 256. And made uniform
    handling for variable length data types.
+ changed: fixed TSqlCursorMetaDataIndexes.getString. It was returning wrong
  data in PKEY_NAME column.
+ changed: optimized BLOB fetching. Now cursor keeps BLOB buffers allocated
    until cursor will be closed.
+ changed: replaced AllocMem by GetMem to exclude not required memory
filling
    by zeros

  [ Vadim V.Lopushansky pult@ukr.net ]

+ Added unit SqlExprFix.pas:
  Some runtime memory fixes of Borland Delphi (6 Upd2, 7, 7 Upd1) system
  modules. For correction of errors it is enough to include this module
  in your project or in any package used by your project. After loading
  such package in IDE the bugs in standard packages will be corrected.
  Fixed units (db.pas, dbCommon.pas, Provider.pas, SqlExpr.pas):
    "SqlExpr.pas"
        TSQLConnection
          - added to Delphi6 connection handling options from Delphi7:
               CUSTOM_INFO = 'Custom String'
               SERVERPORT = 'Server Port'
               MULTITRANSENABLED = 'Multiple Transaction'
               TRIMCHAR = 'Trim Char'
               CONN_TIMEOUT = 'Connection Timeout'
               OSAUTHENTICATION = 'Os Authentication'
          - fixed clone connection

        TCustomSQLDataSet
          Delphi6: // 6, 6 Upd2
            - GetRecord: fixed check error code in Delphi 6.
          Delph7: // can be applied to Delphi6 ...
            - SetSchemaOption: fixed buffer oveflow:
              Crash of the application when the name of the database
              exceeds 256 characters.
            - GetQueryFromType: fixed added delimiter '.' when
              SchemaName is empty.

+ Map compiler directive _InternalCloneConnection_ to connection option
  'ICLONECON'. It is possible to set _InternalCloneConnection_ in a line
   of connection or in properties of connection:
    SQLConnection.Params.Values['Custom String'] := 'ICLONECON=1;...

+ Added field fCursorPreserved. When fCursorPreserved = False then
    problems are possible at work with transactions for open cursors
    (MSAccess, ...). In such situations it is recommended to set
    TClientDataSet.PackedRecords equal "-1". To find out value
    fCursorPreserved for the current connection it is possible at
    use ISqlConnectionOdbc.
    The general recommendation:
      Always establish in line ODBC of connection or in properties
      of ODBC DSN then "Cursor Behavior" = "Preserved".
      Examplpe connection string for INFORMIX ODBC Driver:
       "DRIVER={INFORMIX 3.82 32 BIT};DATABASE=test165;HOST=pult;"+
       "SRVR=ol_pult;SERV=turbo;PRO=olsoctcp;CLOC=ua_UA.1251;"+
       "DLOC=ua_UA.1251;VMB=0;CURB=1;OPT=;SCUR=0;ICUR=0;OAC=1;"+
       "OPTOFC=1;RKC=0;ODTYP=0;DDFP=0;DNL=0;RCWC=0"
      But not all ODBC the driver support fCursorPreserved = True.
      Example:
      "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=\dbdemos.mdb".

[...]

Home page:
  http://open-dbexpress.sourceforge.net/
SourceForge Project Home Page:
https://sourceforge.net/projects/open-dbexpress/

 First, you must test with the latest version from the CVS area:

Project Sources:

  I recommend Tortoise CVS as the easiest to use Windows CVS client, from
  http://www.tortoisecvs.org
  You will need to enter the CVS path (all on one line, including the
  leading colon:

:pserver:anonymous@cvs.open-dbexpress.sourceforge.net:/cvsroot/open-dbexpres
s

  or

  Example of loading/updating of the project from CVS by means of a batch
  file. For work it is necessary to edit a path to cvs.exe.

load_cvs_dbxoodbc.bat
=================================================================
@echo off
set path=C:\Program Files\WinCVS\CVSNT;%path%
rem set path=D:\CygWin\bin;%path%
echo **********************************************
echo - When prompted for a password for anonymous,
echo simply press the Enter key.
echo **********************************************
set cvsproj=cvs-pserver.sourceforge.net:80/cvsroot/open-dbexpress
echo on
cvs -d:pserver:anonymous@%cvsproj% login
cvs -z3 -d:pserver:anonymous@%cvsproj% co dbxoodbc
=================================================================

--
Vadim


Relevant Pages

  • [ANN] DbxoODBC 2.014 - Kylix/Delphi Open Source ODBC dbExpress driver
    ... Changed TSqlCommandOdbc - added stored procedure support. ... fixed memory leak in TSqlCursorMetaDataProcedureParams.Destroy ... I recommend Tortoise CVS as the easiest to use Windows CVS client, ... echo - When prompted for a password for anonymous, ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Source control for LaTeX projects
    ... Subversion is far superior to cvs and rcs, ... couple LaTeX packages that you can use to automatically stamp your ... they better support merging changing from different branches, ... Git, bazaar, and mercurial would all work fine. ...
    (comp.text.tex)
  • Re: CVS hosting
    ... this is how we share the internet connection. ... >>The problem is will i be able to host a cvs with our current setup? ... >Go spend $20 on a router that can do NAT for you. ... I second the NAT router suggestion, your brother will also then have the ...
    (Fedora)
  • CFT: 802.11 vap code
    ... A patch to integrate my multi-bss (aka vap) support for wireless can be ... Note this is a shell script that overlays the CVS contents for HEAD. ... significant changes to all wireless drivers. ...
    (freebsd-current)
  • Re: Source Code Control
    ... remote connection causing Visual SourceSafe to drop ... SVN intends to be a better CVS than CVS, not just a different solution for the sake of being different. ... worth noting that the worst you can do to a cvs server by using flaky network connections is mess up your current check-in. ... If your connection dies while checking in a bunch of files, some might be checked in, some not, and perhaps one in the middle will be stuck half-way. ...
    (comp.arch.embedded)