Re: [ODBC] ODBC constructs - Mailing list pgsql-general

From Dev Kumkar
Subject Re: [ODBC] ODBC constructs
Date
Msg-id CALSLE1NSGa_Dz3mnUiUNRCgW41VquJ6bJgix0eezThsT82R2Eg@mail.gmail.com
Whole thread Raw
In response to Re: [ODBC] ODBC constructs  (Dann Corbit <DCorbit@connx.com>)
List pgsql-general
On Tue, May 21, 2013 at 7:25 PM, Dann Corbit <DCorbit@connx.com> 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.

pgsql-general by date:

Previous
From: Dev Kumkar
Date:
Subject: Re: [ODBC] ODBC constructs
Next
From: Tom Lane
Date:
Subject: Re: Contents of data/base/ and no corresponding entry in pg_database