psqlODBC won't load after installing MS SQL ODBC driver on RHEL 6
Posted
by
Kapil Vyas
on Stack Overflow
See other posts from Stack Overflow
or by Kapil Vyas
Published on 2012-12-11T23:19:57Z
Indexed on
2012/12/12
5:04 UTC
Read the original article
Hit count: 205
I had the PostgreSQL drivers working on my RHEL 6. But after I installed Microsoft® SQL Server® ODBC Driver 1.0 for Linux I can no longer connect to PosgreSQL data sources. I can connect to SQL Server data sources fine.
When I had this same issue a week ago I uninstalled MS SQL Server ODBC driver from Linux and it fixed the issue. I had to copy the psqlodbcw.so files from another machine to replenish the files. I don't want to do the same this time.
I want both drivers to work on Linux.
This time around the setup files got deleted: /usr/lib64/libodbcpsqlS.so
. Replenishing it did not fix the issue. I kept getting the following error in spite of the file being present with rwx
permisions:
[root@localhost lib64]# isql -v STUDENT dsname pwd12345
[01000][unixODBC][Driver Manager]Can't open lib '/usr/lib64/psqlodbc.so' : file not found
[ISQL]ERROR: Could not SQLConnect
[root@localhost lib64]#
Here is a printout of the file permissions:
[root@localhost lib64]# ls -al p*.so
lrwxrwxrwx. 1 root root 12 Dec 7 09:15 psqlodbc.so -> psqlodbcw.so
-rwxr-xr-x. 1 root root 519496 Dec 7 09:35 psqlodbcw.so
and my odbcinst.ini
file looks as follows:
[PostgreSQL]
Description=ODBC for PostgreSQL
Driver=/usr/lib/psqlodbc.so
Driver64=/usr/lib64/psqlodbc.so
Setup=/usr/lib/libodbcpsqlS.so
Setup64=/usr/lib64/libodbcpsqlS.so
FileUsage=1
UsageCount=4
I also referred to this link: http://mailman.unixodbc.org/pipermail/unixodbc-support/2010-September.txt
© Stack Overflow or respective owner