Re: [ODBC] ODBC constructs

[Dev Kumkar <devdas.kumkar@xxxxxxxxx>]

On Tue, May 21, 2013 at 7:25 PM, Dann Corbit <DCorbit@xxxxxxxxx> wrote:

>> 

I do not know if you have 64 bit or 32 bit Linux and if it is Redhat or Mandrake or whatever.

To be clear:

The PostgreSQL distribution allows you to download the PostgreSQL ODBC driver.  The PostgreSQL ODBC driver is not a library.  It is a shared object that uses a standardized API to communicate with the PostgreSQL database.  This allows standards based tools to access the data by linking to a single library (the ODBC library) and then connecting to as many different database systems as you like that have well written ODBC drivers.

In order to use an ODBC driver, you do need an ODBC library.  Microsoft has one that comes installed.  For Posix systems, you can choose between IODBC and UNIXODBC implementations.   I would probably try them both if I were you and choose the one that I like best. 

Maybe this google query can help you:

https://www.google.com/search?q=%28iodbc+OR+unixodbc%29+postgresql+tutorial&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:unofficial&client=firefox-nightly#client=firefox-nightly&hs=6pK&rls=org.mozilla:en-US%3Aunofficial&sclient=psy-ab&q=%28iodbc+OR+unixodbc%29+postgresql+tutorial&oq=%28iodbc+OR+unixodbc%29+postgresql+tutorial&gs_l=serp.12...0.0.0.39894.0.0.0.0.0.0.0.0..0.0...0.0...1c..14.psy-ab.E8PvcYa5HCc&pbx=1&bav=on.2,or.r_qf.&bvm=bv.46751780,d.cGE&fp=9deb35a4864e0689&biw=1920&bih=1027

<< 

Thanks for the info. Its Red Hat Enterprise Linux Server release 5.5.

Please also take a look at my previous reply too.