PostgreSQL9 for ODBC setting?

Help
Anonymous
2012-04-04
2013-05-01

  • Anonymous
    2012-04-04

    Below dbxConnections.ini is can connect to PostgreSQL:

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

    Below dbxConnections.ini is can not connect to PostgreSQL:

    DriverName=DbxOpenOdbc
    GetDriverFunc=getSQLDriverODBCW
    VendorLib=psqlodbc35w.dll
    Database=?
    User_Name=postgres
    Password=123456
    BlobSize=-1
    RowsetSize=20
    OpenOdbc TransIsolation=ReadCommited
    Trim Char=True
    ConnectionString=Database=SLS;coNetPacketSize=8192;coLockMode=17;coBlobChunkSize=40960;SERVER=127.0.0.1;PORT=5432;Socket=4096;UnknownSizes=0;MaxVarcharSize=2048;MaxLongVarcharSize=8190;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;;LFConversion=1;UpdatableCursors=0;DisallowPremature=0;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=0;UseServerSidePrepare=0;coLockMode=-1;coCatPrefix=DATABASE
    MetaDataPackageLoader=TDBXOpenODBCMetaDataCommandFactory
    DriverPackageLoader=TDBXDynalinkDriverLoaderOpenOdbc

    It's reference the setting in the "dbx3-connections.ini".
    But, I can not connect to PostgreSQL by . Why?

     

  • Anonymous
    2012-04-04

    Use , I get the error message:
    " Access violation at address 500412B5 in module 'rtl150.bpl'. Read of address 00000000."
    when TSQLConnection.Connected set True.

     
  • 1)
    Most likely you need to specify the full path:
    VendorLib = C:\?????\psqlodbc35w.dll

    or copy psqlodbc35w.dll to %path% or into your application directory

     
  • 2)  Call stack is empty. Set in the project settings create detailed 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".

     

  • Anonymous
    2012-04-04

    Ohhhhh!!!
    Step1 is right!!!
    I add full path in VendorLib, it's OK!!!

    Pult, thank you!!!

    Well…
    Step2. It's hard…

     
  • Driver updated for PostgreSQL and others