Re: ODBC problem

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