From: | ricardd(at)mathstat(dot)dal(dot)ca |
---|---|
To: | "Support for the unixODBC project" <unixodbc-support(at)easysoft(dot)com>, pgsql-odbc(at)postgresql(dot)org |
Cc: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
Subject: | RESOLVED: odbc driver manager and postgresql odbc driver |
Date: | 2006-06-14 22:20:53 |
Message-ID: | 61008.24.222.143.8.1150323653.squirrel@24.222.143.8 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Success. Thanks Josh for the no-nonsense reply.
Basically, I didn't know the location of the appropriate libraries, and I
was confused about all the options available.
I now have the packages "unixodbc-bin" and "odbc-postgresql" installed.
The files /etc/odbc.in and /etc/odbcinst.ini are as follows:
[postgreodbc]
Description = PostgreSQL ODBC driver
Driver = /usr/lib/odbc/psqlodbc.so
Setup = /usr/lib/odbc/libodbcpsqlS.so
Debug = 0
CommLog = 1
UsageCount = 2
[gfsDB]
Description = PostgreSQL ODBC
Driver = postgreodbc
Trace = No
TraceFile =
Database = mydatabase
Servername = localhost
UserName = postgres
Password =
Port = 5432
Protocol = 7.0
ReadOnly = No
RowVersioning = No
ShowSystemTables = No
ShowOidColumn = No
FakeOidIndex = No
ConnSettings =
A final question then, part of the original confusion. Where is the file
"/usr/lib/odbc/libodbcpsqlS.so" from? It doesn't seem to be from the
odbc-postgresql package:
ricardd(at)octopus:~$ dpkg -L odbc-postgresql
/.
/usr
/usr/lib
/usr/lib/postgresql
/usr/lib/postgresql/lib
/usr/lib/odbc
/usr/lib/odbc/psqlodbc.so
/usr/lib/odbc/psqlodbc.la
/usr/share
/usr/share/doc
/usr/share/doc/odbc-postgresql
/usr/share/doc/odbc-postgresql/docs
/usr/share/doc/odbc-postgresql/docs/howto-vb.html
/usr/share/doc/odbc-postgresql/docs/faq.html
/usr/share/doc/odbc-postgresql/docs/howto-accesslo.html
/usr/share/doc/odbc-postgresql/docs/howto-bo.html
/usr/share/doc/odbc-postgresql/docs/howto-ch.html
/usr/share/doc/odbc-postgresql/docs/index.html
/usr/share/doc/odbc-postgresql/docs/win32-compilation.html
/usr/share/doc/odbc-postgresql/docs/config.html
/usr/share/doc/odbc-postgresql/docs/howto-csharp.html
/usr/share/doc/odbc-postgresql/docs/howto-accessvba.html
/usr/share/doc/odbc-postgresql/docs/unix-compilation.html
/usr/share/doc/odbc-postgresql/docs/howto-vblo.html
/usr/share/doc/odbc-postgresql/README.Debian
/usr/share/doc/odbc-postgresql/copyright
/usr/share/doc/odbc-postgresql/examples
/usr/share/doc/odbc-postgresql/examples/odbc.ini.template
/usr/share/doc/odbc-postgresql/changelog.Debian.gz
/usr/share/psqlodbc
/usr/share/psqlodbc/odbcinst.ini.template
/usr/lib/postgresql/lib/psqlodbc.so
Thanks again.
Dan
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2006-06-14 22:26:03 | Re: RESOLVED: odbc driver manager and postgresql odbc driver |
Previous Message | Hiroshi Inoue | 2006-06-14 21:43:15 | Re: Memory Leak ? |