Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UfE22-0003qN-AF for pgsql-general@arkaria.postgresql.org; Wed, 22 May 2013 18:45:02 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UfE21-00073p-Q5 for pgsql-general@arkaria.postgresql.org; Wed, 22 May 2013 18:45:01 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UfE20-00073f-DS for pgsql-general@postgresql.org; Wed, 22 May 2013 18:45:00 +0000 Received: from hogranch.com ([75.101.82.47]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UfE1v-00046s-CS for pgsql-general@postgresql.org; Wed, 22 May 2013 18:45:00 +0000 Received: from [192.168.0.2] (porker [192.168.0.2]) by hogranch.com (8.11.6/8.11.6) with ESMTP id r4MIikl06750 for ; Wed, 22 May 2013 11:44:46 -0700 Message-ID: <519D1220.3060107@hogranch.com> Date: Wed, 22 May 2013 11:44:48 -0700 From: John R Pierce User-Agent: Mozilla/5.0 (Windows NT 6.2; WOW64; rv:17.0) Gecko/20130509 Thunderbird/17.0.6 MIME-Version: 1.0 To: "pgsql-general@postgresql.org" Subject: Re: [ODBC] ODBC constructs References: <87F42982BF2B434F831FCEF4C45FC33E64E81913@EXCHANGE.corporate.connx.com> <87F42982BF2B434F831FCEF4C45FC33E64E8199F@EXCHANGE.corporate.connx.com> <87F42982BF2B434F831FCEF4C45FC33E64E819C3@EXCHANGE.corporate.connx.com> <519C31DF.5010102@hogranch.com> <519C434B.8090307@hogranch.com> <519C5C6F.7000904@hogranch.com> In-Reply-To: Content-Type: multipart/alternative; boundary="------------030609020004070409020808" X-HawgScanner-Information: Please contact the ISP for more information X-HawgScanner: Found to be clean X-Pg-Spam-Score: -3.0 (---) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-general Precedence: bulk Sender: pgsql-general-owner@postgresql.org This is a multi-part message in MIME format. --------------030609020004070409020808 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit On 5/22/2013 11:24 AM, Dev Kumkar wrote: > Started first with looking more into building psqlODBC today why the heck are you not installing unixODBC-libs from RPMs ?!? yum install unixODBC64 unixODBC64-libs unixODBC64-devel should do it, unless you're on Red Hat Enterprise without a subscription, then you can do it the hard way... mkdir unixODBCdownloads && cd unixODBCdownloads wget http://mirrors.kernel.org/centos/5/os/x86_64/CentOS/unixODBC64-2.2.14-3.el5.x86_64.rpm wget http://mirrors.kernel.org/centos/5/os/x86_64/CentOS/unixODBC64-libs-2.2.14-3.el5.x86_64.rpm wget http://mirrors.kernel.org/centos/5/os/x86_64/CentOS/unixODBC64-devel-2.2.14-3.el5.x86_64.rpm rpm -Uvh *.rpm if you get any dependency errors, fetch the required RPMs from http://mirrors.kernel.org/centos/5/os/x86_64/CentOS/ and install manually with the rpm command. don't be surprised if the dependencies have dependencies, normally yum would sort that out automatically. if your application is 32bit, then you'll need to install 32bit ODBC instead of the 64bit stuff above. if you ARE on Red Hat Enterprise Linux without a RHN subscription, you really really should be on CentOS instead, its a 100% compatible distribution rebuilt from Red Hat sources with the branding and redhat network subscription stuff removed and replaced with open yum repositories. btw, i'm offline til next week. have fun with that. -- john r pierce 37N 122W somewhere on the middle of the left coast --------------030609020004070409020808 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit
On 5/22/2013 11:24 AM, Dev Kumkar wrote:
Started first with looking more into building psqlODBC today


why the heck are you not installing unixODBC-libs from RPMs ?!?

    yum install unixODBC64 unixODBC64-libs unixODBC64-devel

should do it, unless you're on Red Hat Enterprise without a subscription, then you can do it the hard way... 
mkdir unixODBCdownloads && cd unixODBCdownloads
wget http://mirrors.kernel.org/centos/5/os/x86_64/CentOS/unixODBC64-2.2.14-3.el5.x86_64.rpm
wget http://mirrors.kernel.org/centos/5/os/x86_64/CentOS/unixODBC64-libs-2.2.14-3.el5.x86_64.rpm
wget http://mirrors.kernel.org/centos/5/os/x86_64/CentOS/unixODBC64-devel-2.2.14-3.el5.x86_64.rpm
rpm -Uvh *.rpm
if you get any dependency errors, fetch the required RPMs from http://mirrors.kernel.org/centos/5/os/x86_64/CentOS/ and install manually with the rpm command.   don't be surprised if the dependencies have dependencies, normally yum would sort that out automatically.

if your application is 32bit, then you'll need to install 32bit ODBC instead of the 64bit stuff above.

if you ARE on Red Hat Enterprise Linux without a RHN subscription, you really really should be on CentOS instead, its a 100% compatible distribution rebuilt from Red Hat sources with the branding and redhat network subscription stuff removed and replaced with open yum repositories.

btw, i'm offline til next week.  have fun with that.


-- 
john r pierce                                      37N 122W
somewhere on the middle of the left coast
--------------030609020004070409020808--