[unixODBC-support] Trouble connecting with PostgreSQL driver

Julie Reier jreier at videologygroup.com
Wed Jan 14 18:33:33 GMT 2015


Thanks!!

I changed the odbc.ini file to use a shorter name, and now I’m getting a
different error.

$ odbcinst -q -s
[RPTDB.tidaltv.com]
[OPTDB.tidaltv.com]
[rndredshift.gio.videologygroup.com]
[rndredshift]

$ isql -v rndredshift readonly ********
[01000][unixODBC][Driver Manager]Can't open lib
'/usr/lib64/libodbcpsql.so' : file not found
[ISQL]ERROR: Could not SQLConnect



But it looks like the file exists and is a link to libodbcpsql.so.2.0.0 :
$ ls -al /usr/lib64/libodbcpsql*
-rwxr-xr-x 1 root root     753 Jan  9 18:39 /usr/lib64/libodbcpsql.la
-rwxr-xr-x 1 root root     736 Jan  9 18:39 /usr/lib64/libodbcpsqlS.la
lrwxrwxrwx 1 root root      20 Jan 12 20:10 /usr/lib64/libodbcpsql.so ->
libodbcpsql.so.2.0.0
lrwxrwxrwx 1 root root      20 Jan 12 18:18 /usr/lib64/libodbcpsql.so.1 ->
libodbcpsql.so.1.0.0
-rwxr-xr-x 1 root root 1517993 Jan  9 18:39 /usr/lib64/libodbcpsql.so.1.0.0
lrwxrwxrwx 1 root root      20 Jan  9 18:41 /usr/lib64/libodbcpsql.so.2 ->
libodbcpsql.so.2.0.0
-rwxr-xr-x 1 root root 1539570 Jan  9 18:39 /usr/lib64/libodbcpsql.so.2.0.0
-rwxr-xr-x 1 root root 1539570 Jan  9 18:39 /usr/lib64/libodbcpsql.so.2.BAK
-rwxr-xr-x 1 root root 1539570 Jan  9 18:39 /usr/lib64/libodbcpsql.so.BAK
lrwxrwxrwx 1 root root      21 Jan 12 18:00 /usr/lib64/libodbcpsqlS.so ->
libodbcpsqlS.so.2.0.0
lrwxrwxrwx 1 root root      21 Jan 12 18:18 /usr/lib64/libodbcpsqlS.so.1
-> libodbcpsqlS.so.1.0.0
-rwxr-xr-x 1 root root   31722 Jan  9 18:39
/usr/lib64/libodbcpsqlS.so.1.0.0
lrwxrwxrwx 1 root root      21 Jan 12 18:00 /usr/lib64/libodbcpsqlS.so.2
-> libodbcpsqlS.so.2.0.0
-rwxr-xr-x 1 root root    6768 May  6  2014
/usr/lib64/libodbcpsqlS.so.2.0.0


Here’s the trace:
[ODBC][22499][1421260351.056803][__handles.c][460]
Exit:[SQL_SUCCESS]
Environment = 0x8d7750
[ODBC][22499][1421260351.056886][SQLAllocHandle.c][375]
Entry:
Handle Type = 2
Input Handle = 0x8d7750
[ODBC][22499][1421260351.056941][SQLAllocHandle.c][493]
Exit:[SQL_SUCCESS]
Output Handle = 0x8d8050
[ODBC][22499][1421260351.057007][SQLConnect.c][3727]
Entry:
Connection = 0x8d8050
Server Name = [rndredshift][length = 11 (SQL_NTS)]
User Name = [readonly][length = 8 (SQL_NTS)]
Authentication = [**********][length = 10 (SQL_NTS)]
UNICODE Using encoding ASCII 'UTF-8' and UNICODE 'UCS-2LE'


[ODBC][22499][1421260351.059488][SQLConnect.c][1138]Can't open lib
'/usr/lib64/libodbcpsql.so' : file not found
[ODBC][22499][1421260351.059567][SQLError.c][434]
Entry:
Connection = 0x8d8050
SQLState = 0x7fffdae6a570
Native = 0x7fffdae6a588
Message Text = 0x7fffdae6a370
Buffer Length = 500
Text Len Ptr = 0x7fffdae6a58e
[ODBC][22499][1421260351.059634][SQLError.c][471]
Exit:[SQL_SUCCESS]
SQLState = 01000
Native = 0x7fffdae6a588 -> 0
Message Text = [[unixODBC][Driver Manager]Can't open lib
'/usr/lib64/libodbcpsql.so' : file not found]
[ODBC][22499][1421260351.059706][SQLError.c][434]
Entry:
Connection = 0x8d8050
SQLState = 0x7fffdae6a570
Native = 0x7fffdae6a588
Message Text = 0x7fffdae6a370
Buffer Length = 500
Text Len Ptr = 0x7fffdae6a58e
[ODBC][22499][1421260351.059753][SQLError.c][471]
Exit:[SQL_NO_DATA]
[ODBC][22499][1421260351.059800][SQLError.c][514]
Entry:
Environment = 0x8d7750
SQLState = 0x7fffdae6a570
Native = 0x7fffdae6a588
Message Text = 0x7fffdae6a370
Buffer Length = 500
Text Len Ptr = 0x7fffdae6a58e
[ODBC][22499][1421260351.059844][SQLError.c][551]
Exit:[SQL_NO_DATA]
[ODBC][22499][1421260351.059908][SQLFreeHandle.c][284]
Entry:
Handle Type = 2
Input Handle = 0x8d8050
[ODBC][22499][1421260351.059960][SQLFreeHandle.c][333]
Exit:[SQL_SUCCESS]
[ODBC][22499][1421260351.060019][SQLFreeHandle.c][219]
Entry:
Handle Type = 1
Input Handle = 0x8d7750


On 1/14/15, 12:00 PM, "unixodbc-support-request at mailman.unixodbc.org"
<unixodbc-support-request at mailman.unixodbc.org> wrote:

>Re: Trouble connecting with PostgreSQL  driver
This email is intended only for the use of the individual(s) to whom it is addressed. If you have received this communication in error, please immediately notify the sender and delete the original email.


More information about the unixODBC-support mailing list