Re: [ODBC] [GENERAL] ODBC constructs

2013-05-23 Thread Dev Kumkar
On Tue, May 21, 2013 at 7:25 PM, Dann Corbit dcor...@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

Re: [ODBC] [GENERAL] ODBC constructs

2013-05-23 Thread Dev Kumkar
On Tue, May 21, 2013 at 11:28 PM, Dev Kumkar devdas.kum...@gmail.comwrote: On Tue, May 21, 2013 at 10:49 PM, John R Pierce pie...@hogranch.comwrote: its looking for the RPM installed packages it was linked against. its not looking to see if any same named files just happen to be on your

Re: [ODBC] [GENERAL] ODBC constructs

2013-05-23 Thread Dev Kumkar
On Wed, May 22, 2013 at 6:06 PM, Dev Kumkar devdas.kum...@gmail.com wrote: On Wed, May 22, 2013 at 4:10 PM, Devrim GÜNDÜZ dev...@gunduz.org wrote: Yes, or, as mentioned before, you can simply download the RPM directly from the repo. Thanks Devrim! Installed postgres-92 server from

Re: [ODBC] [GENERAL] ODBC constructs

2013-05-22 Thread Dev Kumkar
On Tue, May 21, 2013 at 10:49 PM, John R Pierce pie...@hogranch.com wrote: its looking for the RPM installed packages it was linked against. its not looking to see if any same named files just happen to be on your system. Oh, got it. So the only way is to do bless it thru 'yum install

Re: [ODBC] [GENERAL] ODBC constructs

2013-05-22 Thread John R Pierce
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

Re: [ODBC] [GENERAL] ODBC constructs

2013-05-22 Thread Dev Kumkar
On Wed, May 22, 2013 at 11:44 AM, John R Pierce pie...@hogranch.com wrote: 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

Re: [ODBC] [GENERAL] ODBC constructs

2013-05-22 Thread Dann Corbit
[snip] You want me clean some stuff. Because I installed 'unixODBC-2.3.0'? I guess that if you did a successful make install of unixODBC-2.3.0 it will work as your ODBC driver manager. On the other hand, it is easier and more trouble free to use the standardized package installer for your

Re: [ODBC] [GENERAL] ODBC constructs

2013-05-22 Thread Dev Kumkar
On Wed, May 22, 2013 at 4:10 PM, Devrim GÜNDÜZ dev...@gunduz.org wrote: Yes, or, as mentioned before, you can simply download the RPM directly from the repo. Thanks Devrim! Installed postgres-92 server from postgresql92-server-9.2.4-1PGDG.rhel5.x86_64.rpm, actually links which John (Thanks!)

Re: [ODBC] [GENERAL] ODBC constructs

2013-05-22 Thread Dann Corbit
From: Dev Kumkar [mailto:devdas.kum...@gmail.com] Sent: Tuesday, May 21, 2013 7:33 PM To: Dann Corbit Cc: John R Pierce; pgsql-general@postgresql.org; pgsql-o...@postgresql.org Subject: Re: [ODBC] [GENERAL] ODBC constructs [snip] Thanks for the info. Its Red Hat Enterprise Linux Server release 5.5

Re: [ODBC] [GENERAL] ODBC constructs

2013-05-21 Thread Heikki Linnakangas
On 21.05.2013 08:11, Dev Kumkar wrote: On Mon, May 20, 2013 at 9:12 PM, Atri Sharmaatri.j...@gmail.com wrote: If you wish to work in C,then,I would suggest libpq.I would wait for more replies on this,as I have little knowledge about psqlODBC. Thanks for the comments. Yes objective is to

Re: [ODBC] [GENERAL] ODBC constructs

2013-05-21 Thread Dev Kumkar
On Mon, May 20, 2013 at 11:32 PM, Heikki Linnakangas hlinnakan...@vmware.com wrote: libpq is generally-speaking better than psqlodbc. The advantage of ODBC is that if you have a suitable driver, you can connect to other DBMS' as well, while libpq will only work with PostgreSQL. Unless you

Re: [ODBC] [GENERAL] ODBC constructs

2013-05-21 Thread John R Pierce
On 5/21/2013 11:58 AM, Dev Kumkar wrote: Thanks everyone for sharing comments, really useful ones. Yes the requirement is not connecting to other DBMS but only Postgres and libpq is the correct way so far from comments here. Regarding libpq performance wanted to discuss about connection

Re: [ODBC] [GENERAL] ODBC constructs

2013-05-21 Thread Dev Kumkar
On Tue, May 21, 2013 at 12:16 PM, John R Pierce pie...@hogranch.com wrote: for pooling, check out pgbouncer. IMHO its a better basic pooler than pg_pool. Sure, looks like its more light weight. And I hope, its not related to the decision between libpq and psqlODBC. And will work with both?

Re: [ODBC] [GENERAL] ODBC constructs

2013-05-21 Thread Guy Rouillier
On 5/21/2013 3:32 PM, Dev Kumkar wrote: Well to work with psqlODBC, will I need to recompile the psqlODBC binary and any additional stuff to get ODBC working? No, you don't need to recompile any libraries. You just use them. -- Guy Rouillier -- Sent via pgsql-general mailing list

Re: [ODBC] [GENERAL] ODBC constructs

2013-05-21 Thread Dev Kumkar
On Tue, May 21, 2013 at 12:32 PM, Dev Kumkar devdas.kum...@gmail.comwrote: On Tue, May 21, 2013 at 12:16 PM, John R Pierce pie...@hogranch.comwrote: for pooling, check out pgbouncer. IMHO its a better basic pooler than pg_pool. Sure, looks like its more light weight. And I hope, its not

Re: [ODBC] [GENERAL] ODBC constructs

2013-05-21 Thread Dev Kumkar
On Tue, May 21, 2013 at 12:35 PM, Guy Rouillier guy.rouill...@gmail.comwrote: On 5/21/2013 3:32 PM, Dev Kumkar wrote: Well to work with psqlODBC, will I need to recompile the psqlODBC binary and any additional stuff to get ODBC working? No, you don't need to recompile any libraries. You

Re: [ODBC] [GENERAL] ODBC constructs

2013-05-21 Thread Dann Corbit
[snip] Yeah, hope you got my confusion and inclination now. Well to work with psqlODBC, will I need to recompile the psqlODBC binary and any additional stuff to get ODBC working? http://www.postgresql.org/ftp/odbc/versions/src/ has sources for windows or am I missing something here? Regards...

Re: [ODBC] [GENERAL] ODBC constructs

2013-05-21 Thread Dev Kumkar
On Tue, May 21, 2013 at 12:45 PM, Dann Corbit dcor...@connx.com wrote: Just install the driver and use it. You don’t have to build the driver. It is already built for you. Look here if you need Solaris or BSD: http://www.postgresql.org/download/ Or go directly here for Mac,

Re: [ODBC] [GENERAL] ODBC constructs

2013-05-21 Thread John R Pierce
On 5/21/2013 1:59 PM, Dev Kumkar wrote: 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

Re: [ODBC] [GENERAL] ODBC constructs

2013-05-21 Thread Dev Kumkar
On Tue, May 21, 2013 at 3:17 PM, John R Pierce pie...@hogranch.com wrote: what specific non-Windows operating system distribution are you using? ODBC stuff is packaged for most of them. for instance, the yum.postgresql.org repository has it packaged as postgresql92-odbc, available for a

Re: [ODBC] [GENERAL] ODBC constructs

2013-05-21 Thread Dann Corbit
From: Dev Kumkar [mailto:devdas.kum...@gmail.com] Sent: Tuesday, May 21, 2013 1:59 PM To: Dann Corbit Cc: John R Pierce; pgsql-general@postgresql.org; pgsql-o...@postgresql.org Subject: Re: [ODBC] [GENERAL] ODBC constructs [snip] I already have installed this on Linux from above link some days

Re: [ODBC] [GENERAL] ODBC constructs

2013-05-21 Thread John R Pierce
On 5/21/2013 3:49 PM, Dev Kumkar wrote: On Tue, May 21, 2013 at 3:17 PM, John R Pierce pie...@hogranch.com mailto:pie...@hogranch.com wrote: what specific non-Windows operating system distribution are you using? ODBC stuff is packaged for most of them. for instance, the

Re: [ODBC] [GENERAL] ODBC constructs

2013-05-21 Thread Dev Kumkar
On Tue, May 21, 2013 at 5:21 PM, Dann Corbit dcor...@connx.com wrote: 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

Re: [ODBC] [GENERAL] ODBC constructs

2013-05-21 Thread Dann Corbit
From: Dev Kumkar [mailto:devdas.kum...@gmail.com] Sent: Tuesday, May 21, 2013 7:03 PM To: Dann Corbit Cc: John R Pierce; pgsql-general@postgresql.org; pgsql-o...@postgresql.org Subject: Re: [ODBC] [GENERAL] ODBC constructs [snip] The link http://www.enterprisedb.com/products-services-training

Re: [ODBC] [GENERAL] ODBC constructs

2013-05-21 Thread Dev Kumkar
On Tue, May 21, 2013 at 7:09 PM, Dann Corbit dcor...@connx.com wrote: The ODBC library is contained in either the iodbc or unixodbc RPMs. The correct RPM to use will depend on your operating system. Where are these located?

Re: [ODBC] [GENERAL] ODBC constructs

2013-05-21 Thread Dann Corbit
From: Dev Kumkar [mailto:devdas.kum...@gmail.com] Sent: Tuesday, May 21, 2013 7:13 PM To: Dann Corbit Cc: John R Pierce; pgsql-general@postgresql.org; pgsql-o...@postgresql.org Subject: Re: [ODBC] [GENERAL] ODBC constructs On Tue, May 21, 2013 at 7:09 PM, Dann Corbit dcor...@connx.commailto:dcor

Re: [ODBC] [GENERAL] ODBC constructs

2013-05-21 Thread Dev Kumkar
Currently looking for RHEL 5. Thanks! yes looked into my machine and yum list postgres* listed postgresql91-odbc.x86_64 But when trying to install, then found the base ODBC library itself are missing and those needs to be configured first on test machine. Error: Missing Dependency:

Re: [ODBC] [GENERAL] ODBC constructs

2013-05-21 Thread John R Pierce
On 5/21/2013 7:02 PM, Dev Kumkar wrote: The link http://www.enterprisedb.com/products-services-training/pgdownload#windows which you had earlier provided was postgres installation. It installed libpq but odbc library was not installed. I hope am looking at correct things. after installing

Re: [ODBC] [GENERAL] ODBC constructs

2013-05-21 Thread John R Pierce
On 5/21/2013 7:27 PM, Dev Kumkar wrote: Ya it should have been with base registry. Where to get unixODBC-libs-2.2.11-10.el5.i386? # yum install unixODBC-libs should install the latest version from the distribution base repositories. Since ODBC driver was missing, downloaded

Re: [ODBC] [GENERAL] ODBC constructs

2013-05-21 Thread Dev Kumkar
On Tue, May 21, 2013 at 7:35 PM, John R Pierce pie...@hogranch.com wrote: On 5/21/2013 7:02 PM, Dev Kumkar wrote: The link http://www.enterprisedb.com/products-services-training/pgdownload#windows which you had earlier provided was postgres installation. It installed libpq but odbc

Re: [ODBC] [GENERAL] ODBC constructs

2013-05-21 Thread Dann Corbit
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Dev Kumkar Sent: Tuesday, May 21, 2013 7:27 PM To: John R Pierce Cc: pgsql-general@postgresql.org; pgsql-o...@postgresql.org Subject: Re: [ODBC] [GENERAL] ODBC constructs [snip] Suggestions? https

Re: [ODBC] [GENERAL] ODBC constructs

2013-05-21 Thread John R Pierce
On 5/21/2013 7:33 PM, Dev Kumkar wrote: Red Hat Enterprise Linux Server release 5.5. 5.5 is a fairly old release of Red Hat Enteprise Linux Server release 5, they are up to 5.9 now. simply running `yum update` should get you the latest incremental files now, if you're running RHEL

Re: [ODBC] [GENERAL] ODBC constructs

2013-05-21 Thread Dev Kumkar
On Tue, May 21, 2013 at 7:40 PM, John R Pierce pie...@hogranch.com wrote: # yum install unixODBC-libs should install the latest version from the distribution base repositories. Its not finding it. May be I need to get on another box then, not sure. Since ODBC driver was missing, downloaded

Re: [ODBC] [GENERAL] ODBC constructs

2013-05-21 Thread John R Pierce
On 5/21/2013 8:33 PM, Dev Kumkar wrote: I can do 'yum update' and its started to update 1st package. Although I exit, just want to confirm there is no unixODBC-libs package so it will not update it. Is that correct? I have no idea what you're saying here. what 1st package? you should

Re: [ODBC] [GENERAL] ODBC constructs

2013-05-21 Thread Dev Kumkar
On Tue, May 21, 2013 at 8:40 PM, Dann Corbit dcor...@connx.com wrote: I guess that if you did a successful make install of unixODBC-2.3.0 it will work as your ODBC driver manager. On the other hand, it is easier and more trouble free to use the standardized package installer for your

Re: [ODBC] [GENERAL] ODBC constructs

2013-05-21 Thread John R Pierce
On 5/21/2013 10:37 PM, Dev Kumkar wrote: BTW where does the 'postgresql91-odbc.x86_64' looking for libodbc.so.1 and libodbcinst.so.1 files. its looking for the RPM installed packages it was linked against. its not looking to see if any same named files just happen to be on your system.