> > 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: libodbc.so.1()(64bit) is needed by package > postgresql91-odbc-09.00.0310-1PGDG.rhel5.x86_64 (pgdg91) > Error: Missing Dependency: libodbcinst.so.1()(64bit) is needed by package > postgresql91-odbc-09.00.0310-1PGDG.rhel5.x86_64 (pgdg91) > > > that should have come from the base repository... > > # yum provides libodbc.so.1 > Loaded plugins: fastestmirror, priorities > Loading mirror speeds from cached hostfile > * base: centos.mirrors.hoobly.com > * extras: centos.mirror.freedomvoice.com > * updates: centos-distro.cavecreek.net > unixODBC-libs-2.2.11-10.el5.i386 : The shared libraries required by > programs that use unixODBC > Repo : base > Matched from: > Other : libodbc.so.1 > > unixODBC-libs-2.2.11-10.el5.i386 : The shared libraries required by > programs that use unixODBC > Repo : installed > Matched from: > Other : Provides-match: libodbc.so.1 > > (on a 32bit EL5 system) >
Ya it should have been with base registry. Where to get unixODBC-libs-2.2.11-10.el5.i386? Since ODBC driver was missing, downloaded unixODBC-2.3.0.tar.gz and configured/make this. Now "which odbc_config" works # which odbc_config /usr/local/bin/odbc_config # odbc_config --libs -L/usr/local/lib -lodbc But still 'yum install postgresql91-odbc' is giving errors. Error: Missing Dependency: libodbc.so.1()(64bit) is needed by package postgresql91-odbc-09.00.0310-1PGDG.rhel5.x86_64 (pgdg91) Error: Missing Dependency: libodbcinst.so.1()(64bit) is needed by package postgresql91-odbc-09.00.0310-1PGDG.rhel5.x86_64 (pgdg91) I tried the other way then, building psqlodbc itself: Downloaded psqlodbc driver from http://psqlodbc.projects.postgresql.org/and tried configuring it. It also gave error saying 'libpq' not found. Then ran "yum -y install postgresql91-devel" and then configured with "$ ./configure --with-libpq=/usr/pgsql-9.1/bin/pg_config" this worked without 'libpq error'. But still no real success as there were many errors thrown for 'SQLExtendedFetch' and 'SQLROWSETSIZE'. Suggestions? Regards...