Re: [GENERAL] ODBC constructs

From: Dev Kumkar [mailto:devdas(dot)kumkar(at)gmail(dot)com]
Sent: Tuesday, May 21, 2013 1:59 PM
To: Dann Corbit
Cc: John R Pierce; pgsql-general(at)postgresql(dot)org; pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] [GENERAL] ODBC constructs

[snip]
I already have installed this on Linux from above link some days back but not able to find library. Can you point me to the same?
Also this link says to compile if its non-windows - http://psqlodbc.projects.pgfoundry.org/faq.html#1.2 Check 1.3

Can you point me to samples out there?

Regards...
>>
When you install an ODBC driver, it does not install a library. It installs a DLL or shared object.
If you have already installed the driver, then set up your data source with a data source manager.

IODBC is a popular driver manager:
http://www.iodbc.org/dataspace/iodbc/wiki/iODBC/

and UNIXODBC is another popular choice for an ODBC driver manager:
http://www.unixodbc.org/

You link your application against the ODBC library for your platform. Then it works with any data source you have configured using your driver manager.

Here is a little blurb about driver managers:
http://dev.mysql.com/doc/connector-odbc/en/connector-odbc-driver-manager.html

Here is an outline of using ODBC with IODBC:
http://www.iodbc.org/dataspace/iodbc/wiki/iODBC/ODBCOnUnix

Here are the UNIXODBC manuals:
http://www.unixodbc.org/doc/

<<