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(at)postgresql(dot)org)
> >
> >
>
>