Re: [ODBC] [GENERAL] ODBC constructs

On Wed, May 22, 2013 at 6:06 PM, Dev Kumkar wrote: > On Wed, May 22, 2013 at 4:10 PM, Devrim GÜNDÜZ 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.

Re: [ODBC] [GENERAL] ODBC constructs

On Tue, May 21, 2013 at 11:28 PM, Dev Kumkar wrote: > On Tue, May 21, 2013 at 10:49 PM, John R Pierce 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

Re: [ODBC] [GENERAL] ODBC constructs

On Tue, May 21, 2013 at 7:25 PM, Dann Corbit 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 i

Re: [ODBC] [GENERAL] ODBC constructs

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

On Wed, May 22, 2013 at 4:10 PM, Devrim GÜNDÜZ 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!) mentioned wer

Re: [ODBC] [GENERAL] ODBC constructs

[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 dis

Re: [ODBC] [GENERAL] ODBC constructs

On Wed, May 22, 2013 at 11:44 AM, John R Pierce 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 the hard way.

Re: [ODBC] [GENERAL] ODBC constructs

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 subsc

Re: [ODBC] [GENERAL] ODBC constructs

On Tue, May 21, 2013 at 10:49 PM, John R Pierce 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 unixODBC-libs' only. Hmm

Re: [ODBC] [GENERAL] ODBC constructs

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. --

Re: [ODBC] [GENERAL] ODBC constructs

On Tue, May 21, 2013 at 8:40 PM, Dann Corbit 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 distributi

Re: [ODBC] [GENERAL] ODBC constructs

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 app

Re: [ODBC] [GENERAL] ODBC constructs

On Tue, May 21, 2013 at 7:40 PM, John R Pierce 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 unixODBC-2.3.0.t

Re: [ODBC] [GENERAL] ODBC constructs

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 withou

Re: [ODBC] [GENERAL] ODBC constructs

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

Re: [ODBC] [GENERAL] ODBC constructs

On Tue, May 21, 2013 at 7:35 PM, John R Pierce 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 library was not in

Re: [ODBC] [GENERAL] ODBC constructs

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 unixODBC-2.3

Re: [ODBC] [GENERAL] ODBC constructs

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 p

Re: [ODBC] [GENERAL] ODBC constructs

> > 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 Dependenc

Re: [ODBC] [GENERAL] ODBC constructs

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 mailto:dcor...@connx.com

Re: [ODBC] [GENERAL] ODBC constructs

On Tue, May 21, 2013 at 7:09 PM, Dann Corbit 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

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

On Tue, May 21, 2013 at 5:21 PM, Dann Corbit 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 is a popul

Re: [ODBC] [GENERAL] ODBC constructs

On 5/21/2013 3:49 PM, Dev Kumkar wrote: On Tue, May 21, 2013 at 3:17 PM, John R Pierce > 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

Re: [ODBC] [GENERAL] ODBC constructs

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

On Tue, May 21, 2013 at 3:17 PM, John R Pierce 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 variety of redhat/f

Re: [ODBC] [GENERAL] ODBC constructs

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

On Tue, May 21, 2013 at 12:45 PM, Dann Corbit 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, Windows

Re: [ODBC] [GENERAL] ODBC constructs

[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

On Tue, May 21, 2013 at 12:35 PM, Guy Rouillier wrote: > 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.

Re: [ODBC] [GENERAL] ODBC constructs

On Tue, May 21, 2013 at 12:32 PM, Dev Kumkar wrote: > On Tue, May 21, 2013 at 12:16 PM, John R Pierce 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

Re: [ODBC] [GENERAL] ODBC constructs

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 (pgsql-gen

Re: [ODBC] [GENERAL] ODBC constructs

On Tue, May 21, 2013 at 12:16 PM, John R Pierce 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? thats the perfect

Re: [ODBC] [GENERAL] ODBC constructs

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 polling

Re: [ODBC] [GENERAL] ODBC constructs

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

On 21.05.2013 08:11, Dev Kumkar wrote: On Mon, May 20, 2013 at 9:12 PM, Atri Sharma 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 work in C and found l