Results 1 to 1 of 1
  1. #1
    Join Date
    Jun 2010
    Posts
    1

    Unanswered: Pstgree 8.4.4 on AIX OS 6.1

    Dear All,

    I am trying to connect my application developed on C++ and trying to connect to postgree ddatabase on 8.4.4 on AIX 6.1. But not able to get it done for so many days now and following error comes;

    UNLOCKING AFTER DB CONNECT IN EXCEPTION
    ==> Error : [unixODBC][Driver Manager]Data source name not found, and no default driver specified
    ==> SQL :
    ==> Variable :

    I am using;

    unixODBC-2.3.0
    psqlodbc-08.04.0200
    gcc version 4.2.0

    odbc.ini
    [PostgreSQL]
    Description = PostgreSQL Connection
    Driver = /usr/local/pgsqlodbc/lib/psqlodbc.o
    Trace = Yes
    TraceFile = /tmp/odbc.log
    Database = bbb
    Servername = xx.xx.xx.xx
    UserName = bbb_d_swt
    Password =
    Port = 5432
    Protocol = 6.4
    ReadOnly = Yes
    RowVersioning = No
    ShowSystemTables = No
    ShowOidColumn = No
    FakeOidIndex = No
    ConnSettings =

    [Default]
    Driver = /usr/local/pgsqlodbc/lib/psqlodbc.o
    Description = PostgreSQL Data Source
    Server = xx.xx.xx.xx
    Port = 5432
    UserName = swt
    Password =
    Database = bbb
    ;Socket = 4096

    odbcinst.ini
    [PostgreSQL]
    Description=ODBC for PostgreSQL
    Driver=/usr/local/pgsqlodbc/lib/psqlodbc.o
    FileUsage=1
    UsageCount=1


    should anybody required further details, just post here.
    Last edited by interblocks; 06-24-10 at 10:33.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •