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)?

     
  • Vadim V.Lopushansky

    yes

     
  • Vadim V.Lopushansky

    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?

     
  • Vadim V.Lopushansky

    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)

     
  • Vadim V.Lopushansky

    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?

     
  • Vadim V.Lopushansky

    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…

     
  • Vadim V.Lopushansky

    - 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.

     
  • Vadim V.Lopushansky

    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.

     
  • Vadim V.Lopushansky

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

     
  • Anonymous - 2012-04-03

    Is this?

     
  • Vadim V.Lopushansky

    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_"

     
  • Vadim V.Lopushansky

    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?

     
  • Vadim V.Lopushansky

    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

     
  • Vadim V.Lopushansky

    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)

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks