Re: ODBC problem - Mailing list pgsql-general

Hmmmm, tried setting it up the same as yours and still seem to be having
the same problems..

You mentioned that you were seeing a similar thing.. Was it just
changing around the odbc.ini and odbcinst.ini file that changed it , or
was there anything else you needed to do ?

Thanks for the help..

Heiko Klein wrote:

>I can't explain it really. I know, that iodbc examples use allways only
>one file, and I think, even in unix-odbc you can live with one file (not
>sure on this). But I liked the idea of having the driver describtion
>odbcinst.ini separated from the database-setup. The Driver in odbc.ini
>points to the [PostgreSQL] entry in odbcinst.ini. Both files need to be
>in the etc directory of your installation or in ~/.odbc.ini
>~/.odbcinst.ini (I did it the first way, so I cannot guarantee about the
>second).
>
>Heiko
>
>mark writes:
> >
> >
> > 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:
> >
> > >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)
> > >
> > >
> >
> >
>
>