dbexpoda.dll v3.00 thinks it is v2.50.5 and does not like Oracle 10g too much

dbexpoda.dll v3.00 thinks it is v2.50.5 and does not like Oracle 10g too much

Postby chrispaskins » Tue 28 Feb 2006 16:04

D7. I've just downloaded the v3.00 driver and I can't help noticing that the file version of dbexpoda.dll is v2.50.5.0!! Also, it doesn't work with my schema using an entirely Oracle 10.1.0.5.0 environment. Happily this can be reproduced using the good ol' Scott starter database schema (EMP okay, DEPT raises exception).

Create a button, drop in this code, "Stop on Delphi Exceptions", and see what happens.

Code: Select all
procedure TForm1.Button1Click(Sender: TObject);
var
  myCRSQLConnection : TCRSQLConnection;
  pList: TStringList;
begin
  myCRSQLConnection := TCRSQLConnection.Create(nil);
  pList := TStringList.Create;
  try
    myCRSQLConnection.DriverName := 'Oracle (Core Lab)';
    myCRSQLConnection.LibraryName := 'dbexpoda.dll';
    myCRSQLConnection.VendorLib := 'OCI.DLL';
    myCRSQLConnection.GetDriverFunc := 'getSQLDriverORA';
    myCRSQLConnection.Params.Clear;
    myCRSQLConnection.Params.Values['DriverName'] := 'Oracle (Core Lab)';
    myCRSQLConnection.LoginPrompt := false;
    myCRSQLConnection.Params.Values['DataBase'] := edit1.text;
    myCRSQLConnection.Params.Values['User_Name'] := edit2.Text;
    myCRSQLConnection.Params.Values['Password'] := edit3.Text;
    myCRSQLConnection.Connected := True;

    myCRSQLConnection.GetFieldNames('EMP', pList);
    Memo1.Text := pList.Text;

    pList.Clear;
    myCRSQLConnection.GetFieldNames('DEPT', pList);
    Memo2.Text := pList.Text;
    //with dbexpoda.dll dated 9th Feb 2006 (v2.50.5.0 EH!?):
    //Memo2 is Empty
    //raised exception class EConvertError with message ''58?412' is not a valid integer value'

    //Note, okay with dbexpoda.dll dated 17th Oct 2005 (v2.50.6.0)
  finally
    pList.Free;
    myCRSQLConnection.Free;
  end;
end;
chrispaskins
 
Posts: 11
Joined: Tue 11 Oct 2005 10:32
Location: Windsor, UK

Postby PontusAtNilex » Wed 01 Mar 2006 13:46

Hello!

Yes it seems that the bug corrections in 2.50.6 is not in 3.00.2!
We noticed this when having problems with blob fields in Oracle 10g.

Regards

Pontus
PontusAtNilex
 
Posts: 16
Joined: Wed 03 Nov 2004 13:25

Postby Challenger » Thu 02 Mar 2006 14:44

Sorry for inconvenience. We have already changed versions of dbexpoda.dll and dbexpoda30.dll and fixed the problem with GetFieldNames function. This fixes will be included in the next build of DbxOda.
Challenger
Devart Team
 
Posts: 925
Joined: Thu 17 Nov 2005 10:53

Postby chrispaskins » Wed 22 Mar 2006 11:06

It's been nearly a month now, I was wondering when "the next build" with the fixes for GetFieldNames function will be available?
chrispaskins
 
Posts: 11
Joined: Tue 11 Oct 2005 10:32
Location: Windsor, UK

driver versions

Postby jms » Tue 04 Apr 2006 15:39

I just downloaded the trial versions of the Oracle & MS-SQL dbExpress drivers, and the "30" versions of both drivers (dbexpsda30.dll & dbexpoda30.dll) both show "2.50.5.0" via Windows Properties|Version|File Version.

Are these still the same pre-"next version" ones?
jms
 


Return to dbExpress driver for Oracle