[unixODBC-support] Datasource not found under Fedora 6 with Postgres

paul_deg paul_deg at yahoo.com
Thu Jun 14 00:30:20 BST 2007

I keep getting this message trying to connect to
PostgreSQL 8.1.  Unix ODBC and Postgres came with the
installation dvd. I use isql to test the connection. I
used dltest to test the drivers - loaded OK.
odbcinst -j shows  config  files location under /etc.
What can be wrong? Debud log from unix ODBC is not
very useful. Here are my ini files from /etc:


# Included in the unixODBC package
Description     = ODBC for PostgreSQL
Driver          = /usr/lib64/libodbcpsql.so
Setup           = /usr/lib64/libodbcpsqlS.so
FileUsage       = 1

# Driver from the MyODBC package
# Setup from the unixODBC package
#Description    = ODBC for MySQL
#Driver         = /usr/lib/libmyodbc.so
#Setup          = /usr/lib/libodbcmyS.so
#FileUsage      = 1

TraceFile = /tmp/sql.log
Trace = Yes


Description         = Test to Postgres
Driver              = PostgreSQL
Trace               = Yes
TraceFile           = sql.log
Database            = mydb
Servername          = localhost
UserName            = admin
Password            = password
Port                = 5432
Protocol            = 8.1
ReadOnly            = No
RowVersioning       = No
ShowSystemTables    = No
ShowOidColumn       = No
FakeOidIndex        = No
ConnSettings        =

Pinpoint customers who are looking for what you sell. 

More information about the unixODBC-support mailing list