Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

XE2 support

Help
bdw_11
2011-10-11
2013-08-07
  • bdw_11
    bdw_11
    2011-10-11

    do you have any plans to support XE2 ?

     
  • XE2 now has its own driver odbc express. I'm still lost in thought on your question. Is there a need? I think …

     
  • bdw_11
    bdw_11
    2011-10-11

    yes I should have explained further.

    I have a legacy ms access database that I was wanting to use with dbExpress and odbc rather than dbGo (ado).  Was thinking that it might also be possible to cross compile to osx with a FireMonkey app.

     
  • embarcadero odbx dbXpress driver supports osx

     
  • bdw_11
    bdw_11
    2011-10-12

    Are you saying that XE2 odbc dbexpress can talk to ms access directly without a LibraryName set, I was thinking it would need the the dbxooodbc.dll to work on XE2 ?

    After looking at the dbx_access_connect.pas file that I got going in a C++ XE project I see it is using the odbcjt32.dll vendor lib, so to get this going under XE2 and osx one would also need a compatible odbc ms access dll.  As far as I know MS doesn't support os x so probably a no go.

     
  • XE2 ODBC DBExpress driver is available in the fullness of "$ (DELPHI) \ sources". It does not use external dbxpress dll.

     
  • bdw_11
    bdw_11
    2011-10-26

    Thanks for your help and info,  I hadn't noticed that the sources were there.

    I had just before your post come across the actualtech one and one by OpenLink, I haven't investigated that aspect any further at this stage.

    In terms of using XE2 and dbExpress via TSQLConnection can you point me in the direction of how this can be setup to access a MS Access MDB ?

    I haven't come across any documentation in regard to this.  What would the dbxdrivers.ini look like e.g. LibraryName and GetDriverFunc ?

    Thanks again for any help.

     
  • XE2

    "C:\Users\Public\Documents\RAD Studio\dbExpress\9.0\dbxdrivers.ini"

    Odbc=1

    DriverUnit=Data.DBXOdbc
    DriverPackageLoader=TDBXOdbcDriverLoader,DBXOdbcDriver160.bpl
    DriverAssemblyLoader=Borland.Data.TDBXOdbcDriverLoader,Borland.Data.DbxOdbcDriver,Version=16.0.0.0,Culture=neutral,PublicKeyToken=91d62ebb5b0d1b1b
    MetaDataPackageLoader=TDBXOdbcMetaDataCommandFactory,DbxOdbcDriver160.bpl
    MetaDataAssemblyLoader=Borland.Data.TDBXOdbcMetaDataCommandFactory,Borland.Data.DbxOdbcDriver,Version=16.0.0.0,Culture=neutral,PublicKeyToken=91d62ebb5b0d1b1b

    "C:\Users\Public\Documents\RAD Studio\dbExpress\9.0\dbxconnections.ini"

    DriverName=Odbc
    DataBase=Database Name
    User_Name=user
    Password=password
    IsolationLevel=ReadCommitted
    RowSetSize=20
    ConnectionString=

    Data.DBXOdbc.pas

    procedure TDBXOdbcConnection.DerivedOpen;

      if ConnectionString <> '' then
        ErrorCode := FMethodTable.SQLDriverConnect(FConnectionHandle, 0, PSqlWChar(ConnectionString),
                                                   Length(ConnectionString), nil, 0, BufLen, SQL_DRIVER_NOPROMPT)
      else
        ErrorCode := FMethodTable.SQLConnect(FConnectionHandle, PSqlWChar(DataSourceName), Length(DataSourceName),
                                             PSqlWChar(UserName), Length(UserName), PSqlWChar(Password), Length(Password));

    Connect string like dbxoodbc (excluding options dbxoodbc). The connection string is constructed on the basis of the documentation for odbc driver.

     
  • bdw_11
    bdw_11
    2011-10-26

    Ahhh, I do appreciate the info.

    It seems why I couldn't figure out the ODBC files is that I don't have the DbxOdbcDriver160.bpl files let alone the source files on my install.

    By any chance is ODBC not available on XE2 Pro ?

    doh!

     

  • Anonymous
    2011-10-26

    Have dbxconnections.ini and dbxdrivers.ini
    for XE(8.0) setting??

     
  • bdw_11
    bdw_11
    2011-10-26

    Yep found the feature matrix last night, thanks.

    Shame its not part of Pro, so after all this maybe there is a need still for opendbx ? :-)

    Thanks again for you time in responding.

    I originally had used the dbx forum which led me to this site.

     
  • >Shame its not part of Pro, so after all this maybe there is a need still for opendbx ? :-)

    it may depend on the number of willing and available time

     

  • Anonymous
    2012-07-16

    Hi
    I try the ODBC dbexpress's driver in XE2.

    I think…
    I still like "Open dbExpress"!!!

    When will the introduction of support XE2?

    I very much expect!!!

     

  • Anonymous
    2012-07-17

    Oh YA!!
    pult!
    I love U!
    Thank you for all your assistance!

     

  • Anonymous
    2012-07-24

    Cool!
    I add a Install technical articles for Chinese language in my blogger

     
  • Eden
    Eden
    2013-08-07

    Hello!

    Could you follow current Delphi version to updated Open Dbexpress driver?

    This dbx driver is best!!!