RESOLVED: odbc driver manager and postgresql odbc driver

Поиск
Список
Период
Сортировка
От ricardd@mathstat.dal.ca
Тема RESOLVED: odbc driver manager and postgresql odbc driver
Дата
Msg-id 61008.24.222.143.8.1150323653.squirrel@24.222.143.8
обсуждение исходный текст
Ответ на Re: UNRESOLVED: odbc driver manager and postgresql odbc  (ricardd@mathstat.dal.ca)
Ответы Re: RESOLVED: odbc driver manager and postgresql odbc driver  ("Joshua D. Drake" <jd@commandprompt.com>)
Список 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@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



В списке pgsql-odbc по дате отправления:

Предыдущее
От: Hiroshi Inoue
Дата:
Сообщение: Re: Memory Leak ?
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: RESOLVED: odbc driver manager and postgresql odbc driver