Re: ODBC problem - Mailing list pgsql-general

Thanks.. Im kind of new to this.. Can you explain to me the role of the
odbcinst.ini file and where that needs to be located..

I noticed in your odbc.ini you don't point directly to the driver
itself.  All the other examples Ive seen do this..  Can you explain how
this is working ?

Heiko Klein wrote:

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