Re: ODBC problem

Hi,

last week, I had similar problems. First I couldn't get jdbc running
correctly with staroffice (I haven't found anybody who could), then I
didn't manage to connect anyhow with iodbc and then I had problems with
the postgres odbc driver in and unix-odbc.

But at the end (after two days), taking the unix-odbc driver included
with unix-odbc, I got a stable connection :-) to my pg7.2 server. And
even staroffice worked with it together.

Heiko

odbc.ini:
[Emep]
Description         = Test to Postgres
Driver              = PostgreSQL
Trace               = Yes
TraceFile           = /tmp/sql.log
Database            = emep
Servername          = localhost
UserName            =
Password            =
Port                = 5432
Protocol            = 7.2
ReadOnly            = No
RowVersioning       = No
ShowSystemTables    = No
ShowOidColumn       = No
FakeOidIndex        = No
ConnSettings        =

odbcinst.ini:
[PostgreSQL]
Description = PGSQL 7.2
Driver = /usr/emep/lib/libodbcpsql.so
Setup  = /usr/emep/lib/libodbcpsqlS.so
FileUsage = 1
Debug = 0



mark writes:
 >
 >
 >
 > Hi
 >
 > Please help... Im trying to connect to postgresql via ODBC using the
 > iodbc driver manager.   As part of that package theres a odbctest
 > program that can be ran, however it appears to be failing.   Im kind of
 > stumped as to where to go next as the error isn't too usefull.
 >
 > The error I am getting in the iodbc tracefile is..
 >
 > SQLDriverConnect( ... )
 > SQL_NO_DATA_FOUND
 >
 > odbctest just exits with no usefull information..
 >
 > When I run odbctest I connect to it using the connect string :
 > DSN=Postgres    and It seems to be finding my odbc.ini file okay.   My
 > odbc.ini file looks like
 >
 > ;
 > ;  odbc.ini
 > ;
 > [ODBC Data Sources]
 >   Postgres    = Postgres
 >
 > [Postgres]
 >   Driver        = /usr/local/pgsql/lib/libpsqlodbc.so.0
 >   Host            = localhost
 >   Database    = marksdb
 >   TraceFile       = /tmp/odbc.trace
 >   Trace           = 1
 >
 > Im pretty new to this so its almost certainly an education problem.   Is
 > there any better documentation on ODBC installation/configuration at all
 > for postgresql
 >
 > Mark
 >
 >
 >
 > ---------------------------(end of broadcast)---------------------------
 > TIP 2: you can get off all lists at once with the unregister command
 >     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)