unixODBC - Problems in the execution of isql

I installed the unixODBC driver but when I execute isql, returns the following error:

----- ERROR -----
[01000][unixODBC][Driver Manager]Can't open lib '/usr/local/lib/libmyodbc3.sl' : Call to mmap() failed - TEXT /usr/local/lib/libmyodbc3.sl
[ISQL]ERROR: Could not SQLConnect

----- DRIVER -----
/usr/local/lib
usrv45: ls -la libmyodbc3.sl
-rwxrwxrwx 1 ora817 dba 229376 Nov 30 18:40 libmyodbc3.sl

----- ODBC.INI -----
[ODBC Data Sources]
mysql1 = MySQL ODBC 3.51 Driver DSN
[mysql1]
Driver = /usr/local/lib/libmyodbc3.sl
Description = MySQL ODBC 3.51 Driver DSN
Setup = /usr/local/lib/libodbcmyS.sl
SERVER = <IP ADDRESS>
PORT = <PORT>
USER = teste
Password = testar
Database = banco_teste
OPTION = 3
SOCKET =

Why is this error occurring?

Please read the RULES. Cross and duplicate posting is not permitted. I will delete your duplicate thread from the HP-UX Forum.

Thanks,
ZB

I'm sorry.
This will not go to occurr again.

But on my question, it can be lack of permission in lib? Or because it was created by root, it only can be had access by root?

Somebody can help me?

Thank's

Paulo Cesar

Somebody can I help me?

Permissions are not the problem in this case since you are having read, write and execute for all users. I suspect it might have some problem with the installation.

On an unrelated note, I have usually seen the library as libmyodbc3.so

As an addition, check if you have the library object reference for your database in LD_LIBRARY_PATH

You may recall that I directed you to the forum rules earlier in the thread. If you had taken the time to read them you would have noticed that bumping up your posts is also forbidden.

Thanks
ZB

I did not understand its tip. You can give to better details to me?
Follow my environment variable:

server: echo $LD_LIBRARY_PATH
/usr/lib:/u00/app64/ora817/product/8.1.7/lib:/u00/app64/ora817/product/8.1.7/hs/lib:/usr/local/lib

PATH /usr/local/lib
/usr/local/lib
usrv45: ls -la libmy*
lrwxrw-r-x 1 ora817 dba 30 Dec 2 17:53 libmyodbc3.sl -> /usr/lib/libmyodbc3-3.51.06.sl

PATH /usr/lib/usr/lib
usrv45: ls -la libmy*
-rwxrwxrwx 1 root sys 229376 Nov 24 17:14 libmyodbc3-3.51.06.sl
-rwxrwxrwx 1 root sys 360164 Nov 24 17:14 libmyodbc3.a
-rwxrwxrwx 1 root sys 885 Nov 24 17:14 libmyodbc3.la
-rwxrwxrwx 1 root sys 877 Nov 24 17:14 libmyodbc3.lai
-rwxrwxrwx 1 root sys 229376 Nov 24 17:14 libmyodbc3.sl-old
-rwxrwxrwx 1 root sys 229376 Nov 24 17:14 libmyodbc3_r-3.51.06.sl
-rwxrwxrwx 1 root sys 360344 Nov 24 17:14 libmyodbc3_r.a
-rwxrwxrwx 1 root sys 826 Nov 24 17:14 libmyodbc3_r.la
-rwxrwxrwx 1 root sys 827 Nov 24 17:14 libmyodbc3_r.lai
-rwxrwxrwx 1 root sys 229376 Nov 24 17:14 libmyodbc3_r.sl

My lib is libmyodbc3.sl because my server is HP-UX version 11.11 .

In your ODBC ini, try setting the path to "/usr/lib/libmyodbc3-3.51.06.sl" rather than "/usr/local/lib/libmyodbc3.sl".

Also, shouldn't your thread be posted in the HP-UX forum rather than here?

I already tried this. He does not make difference.

Can move this Thread for HP-UX Forum, please?
My machine is HP-UX, Ok?!

Thanks,

Your wish is my command

Cheers
ZB