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

Close

XE support?

Help
Anonymous
2012-03-27
2013-05-01
1 2 > >> (Page 1 of 2)

  • Anonymous
    2012-03-27

    When did it support the Delphi XE(Ver. 15)?

     
  • yes

     
  • wn32 only

     

  • Anonymous
    2012-03-28

    Is PkgDbxXXDrv2011.bpl?
    I can to Install in Delphi XE. But, Not show on the Data Explorer

    How to correct setup dbxodbc in Delphi XE?

     
  • Need correct your files:
    dbxdrivers.ini
    dbxconnections.ini

    Look for these files should be of the entries in the registry:

    "Connection Registry File"="C:\\Documents and Settings\\All Users\\Documents\\RAD Studio\\dbExpress\\8.0\\dbxconnections.ini"
    "DLLPATH"="C:\\Documents and Settings\\All Users\\Documents\\RAD Studio\\dbExpress\\8.0"
    "Driver Registry File"="C:\\Documents and Settings\\All Users\\Documents\\RAD Studio\\dbExpress\\8.0\\dbxdrivers.ini"

    Examples of changes to these files, you may find in the following files:
    $(dbxoodbc)\driver\binary\
      dbx4-drivers.ini
      dbx4-connections.ini

    More examples are for previous versions:
    dbx2-drivers.ini
    dbx3-connections.ini

    You can adapt them for yourself.

     

  • Anonymous
    2012-03-28

    ;VendorLibLinux=odbc32.so
    ;Prepare SQL=False
    ;Custom String=coNetPacketSize=8192;coLockMode=17;coBlobChunkSize=40960
    drivername=DbxOpenOdbc
    getdriverfunc=getSQLDriverODBCW
    vendorlib=odbc32.dll
    database=DSN=SLS
    user_name=postgres
    Password=12345
    blobsize=-1
    rowsetsize=20
    openodbc transisolation=ReadCommited
    trim char=True
    connectionstring=coNetPacketSize=8192
    colockmode=17
    coblobchunksize=40960
    server=127.0.0.1
    port=5432
    metadatapackageloader=TDBXOpenODBCMetaDataCommandFactory
    driverpackageloader=TDBXDynalinkDriverLoaderOpenOdbc

    I get a error, when test connection:
    The located assembly's manifest definition does not match the assembly reference. (Exeception from HRESULT: 0x80131040)

     
  • I can only guess to what file is your code ().
    Obviously you have changed both files but did not specify in what have changed.

    First try to get connected to the independent application (runtine, not IDE).
    It was only after the success you can move on to configuring IDE.

     

  • Anonymous
    2012-03-30

    >First try to get connected to the independent application (runtine, not IDE).
    >It was only after the success you can move on to configuring IDE.

    You are right. I drop a TSQLConnection and set propertys.
    It can connect my PostgreSQL, and can work to DBGrid.

    So, I copy the ConnectionString and modify dbxconnections, below code :

    DriverName=DbxOpenOdbc
    GetDriverFunc=getSQLDriverODBCW
    VendorLib=odbc32.dll
    Database=?
    User_Name=postgres
    Password=123456
    BlobSize=-1
    RowsetSize=20
    OpenOdbc TransIsolation=ReadCommited
    Trim Char=True
    ConnectionString=DSN=SLS;coNetPacketSize=8192;coLockMode=17;coBlobChunkSize=40960
    MetaDataPackageLoader=TDBXOpenODBCMetaDataCommandFactory
    DriverPackageLoader=TDBXDynalinkDriverLoaderOpenOdbc

    Restart Delphi XE.
    Now, Data Explorer get the new property - "PostgreSQLConnection". But I click "Tables", when get same a error message: 
    The located assembly's manifest definition does not match the assembly reference. (Exeception from HRESULT: 0x80131040)

     

  • Anonymous
    2012-04-02

    I get simple file: $(BDS)\bin\DataExplore.exe
    It can test dbxconnections.ini and dbxdrivers.ini

    My code below:
    dbxconnections.ini

    DriverName=DbxOpenOdbc
    ; is customized:
    GetDriverFunc=getSQLDriverODBCW
    ; is customized:
    VendorLib=odbc32.dll
    Database=?
    User_Name=postgres
    Password=123456
    BlobSize=-1
    RowsetSize=20
    OpenOdbc TransIsolation=ReadCommited
    Trim Char=True
    ConnectionString=DSN=SLS;coNetPacketSize=8192;coLockMode=17;coBlobChunkSize=40960
    MetaDataPackageLoader=TDBXOpenODBCMetaDataCommandFactory
    DriverPackageLoader=TDBXDynalinkDriverLoaderOpenOdbc

    dbxdrivers.ini

    LibraryName=dbxoodbc.dll
    ProductName=DbxOpenODBC
    MetaDataPackageLoader=TDBXOpenODBCMetaDataCommandFactory
    DriverPackageLoader=TDBXDynalinkDriverLoaderOpenOdbc

    DriverAssemblyLoader=Borland.Data.TDBXDynalinkDriverLoader,Borland.Data.DbxCommonDriver,Version=15.0.0.0,Culture=neutral,PublicKeyToken=91d62ebb5b0d1b1b
    GetDriverFunc=getSQLDriverODBCW
    VendorLib=odbc32.dll

    DirtyRead=0
    ReadCommited=1
    RepeatableRead=2
    =================

    Now, I get the error message:
    "No metadata could be loaded for: DbxOpenODBC."

    I find "TDBXOpenODBCMetaDataCommandFactory" in DbxXXDrv.pas.
    It can not found for PostgreSQL's and paramters, why?

     
  • It is necessary to first worked for your application, and then to transfer the settings into  IDE.

    "TDBXOpenODBCMetaDataReader" should be universal. But now it is not fully implemented for DBX 3.4 (Delphi 2007 Up). But for the most popular DBMS they are implemented "Dbx34DrvDbms.pas" using SQL queries to read the metadata.

     

  • Anonymous
    2012-04-03

    >It is necessary to first worked for your application, and then to transfer the settings into  IDE.
    Yes, I do it, after save to Data Explorer.
    But, it can not Open Data Explorer…

    >"TDBXOpenODBCMetaDataReader" should be universal. But now it is not fully implemented for DBX 3.4 (Delphi 2007 Up). But for the most popular DBMS they are implemented "Dbx34DrvDbms.pas" using SQL queries to read the metadata.
    I do not understand…

     
  • - Data Explorer is your app with source code? You can show the call stack when an error occurs?

    - see source Dbx34DrvDbms.pas. It unit implement metadata reader for some popular dbms. There's nothing for PostgreSQL.

     

  • Anonymous
    2012-04-03

  • Data Explorer is part of Delphi IDE. I say that first you have to create your application and try it to find out why. This will give you the opportunity to see the code, in which place there is a problem. Otherwise, you will not be able to find out.

     
  • This is a development environment IDE. User application - it is compiled and running your application.

     

  • Anonymous
    2012-04-03

    Is this?

     
  • Which operation is performed when an error occurs?
    Call stack is empty. Set in the project settings create map file and add the module to the project "dbxoodbc \ demos \ third-party \ jcl \ ExceptDlg.pas". Maybe this will give the opportunity to see all call stack. As well, it would be add the module to the project "DbxOpenOdbcStatic.pas". In the project settings, add the option "Project / Options / Delphi Compoler / Conditional Defines" == "_DEBUG_; _TRACE_CALLS_"

     
  • After run your application see Event Log

     

  • Anonymous
    2012-04-03

    ……
    Could you give me a snapshot about Data Explorer have show Tables list in picture?

     
  • Today I installed a PostgreSQL. Need a little wait.

     

  • Anonymous
    2012-04-04

    Hi
    Not necessarily for PostgreSQL.
    MS SQL have same question too.
    Maybe all database product have situation.
    Because the  Data Explorer being written in .NET and the driver

     
  • for mssql is demos "dbxoodbc\demos\dbms\mssql\"
    it work fine
    for correctly fill TSQLConnection see
    "bxoodbc\demos\connections\dbx_mssql_connect.pas"

     

  • Anonymous
    2012-04-04

    Yes, That demos is OK. It can run. I like it.
    I tested it at some time in the past.

    Do you known "$(BDS)\bin\DataExplore.exe"?
    My question is it. It cannot run dbxconnections.ini setting.

     
1 2 > >> (Page 1 of 2)