Bug #25155 libmyodbc3.so from MyODBC-3.51.07-ibm-aix5.1.0.0-powerpc.tar doesn't work
Submitted: 18 Dec 2006 21:09 Modified: 15 Mar 2007 20:54
Reporter: Veronika Vien Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / ODBC Severity:S1 (Critical)
Version:3.51.07-ibm-aix5.1 OS:IBM AIX (AIX 5.2)
Assigned to: Kent Boortz CPU Architecture:Any

[18 Dec 2006 21:09] Veronika Vien
Description:
Do the shared library files in this MyODBC-3.51.07-ibm-aix5.1.0.0-powerpc.tar work on AIX 5.2? When I try to use it with unixODBC isql on an AIX 5.2 server I get this error.

# isql -v testdb
[01000][unixODBC][Driver Manager]Can't open lib 
'/usr/local/lib/libmyodbc3.so' : 0509-026 System error: Cannot run a file 
that does not have a valid format. 
[ISQL]ERROR: Could not SQLConnect

Your INSTALL-BINARY instructions say to link libmyodbc3-$version.so to libmyodbc3.so, but this MyODBC-3.51.07-ibm-aix5.1.0.0-powerpc.tar doesn't have any ".so" file in it.  ".a" files are suppose to be the same as ".so" files, but the ".a" files in the tar do not work either.

 # isql -v testdb
[01000][unixODBC][Driver Manager]Can't open lib '/usr/local/lib/libmyodbc3.a' : 0509-026 System error: Cannot run a file that does not have a valid format.
[ISQL]ERROR: Could not SQLConnect

How to repeat:
Make sure /usr/local/lib is in LIBPATH
tar xvf MyODBC-3.51.07-ibm-aix5.1.0.0-powerpc.tar
cd MyODBC-3.51.07-ibm-aix5.1.0.0-powerpc
cp libmyodbc* /usr/local/lib

Download unixODBC version 2.1.2 from http://www.unixodbc.org/ 
tar xvf unixODBC-2.2.12.tar
cd unixODBC-2.2.12
./configure --enable-gui=no --enable-shared 
make 
make install 

Run /usr/local/bin/isql
[12 Jan 2007 12:18] Bogdan Degtyariov
Hello Veronika,

this bug has been fixed in later releases.
Please try to download the preliminary version of MyODBC from our FTP (note that the addresses might be wrapped in two or more lines automatically, so you will need to join them):

ftp://ftp.mysql.com/pub/mysql/download/connectors/odbc/mysql-connector-odbc-3.51.13r144_20...

ftp://ftp.mysql.com/pub/mysql/download/connectors/odbc/mysql-connector-odbc-3.51.13r143_20...

MyODBC 3.51.13 will be released soon.
[18 Jan 2007 20:46] Veronika Vien
I've tried the 64 bit version ftp://ftp.mysql.com/pub/mysql/download/connectors/odbc/mysql-connector-odbc-3.51.13r144_20...

What's the best way to test it?  I still get this error with isql:
# isql -v oms5
[01000][unixODBC][Driver Manager]Can't open lib '/usr/local/lib/libmyodbc3.so': 0509-026 System error: Cannot run a file that does not have a valid format.
[ISQL]ERROR: Could not SQLConnect

The /usr/local/etc/odbc.ini has:
[ODBC Data Sources]
myodbc3     = MySQL ODBC 3.51 Driver DSN

[myodbc3]
Driver       = /usr/local/lib/libmyodbc3.so
Description  = MySQL ODBC 3.51 Driver DSN
SERVER       = dev-oms5
PORT         =
USER         = sst
Password     =
Database     = oms5
OPTION       = 3
SOCKET       =

and the /usr/local/etc/odbcinst.ini has:
[MySQL]
Name: myodbc
Description: MySQL driver.
Driver: /usr/local/lib/libmyodbc3.so
Setup: /usr/local/lib/libmyodbc3S.so
FileUsage: 1
[19 Jan 2007 19:13] Veronika Vien
The 32bit version isn't working either. 
# isql -v myodbc3
[01000][unixODBC][Driver Manager]Can't open lib '/usr/local/lib/libmyodbc3.so' : No such file or directory
[ISQL]ERROR: Could not SQLConnect
[9 Feb 2007 4:51] Santanu Mitra
This is funny

This file mysql-connector-odbc-3.51.13r144_20061219_1515-aix5.2-powerpc-64bit.tar.gz contains a readme and this readme only talks about windows files. From  the name of this compresses tar file I understand that this is for AIX platform. What it has to do with Windows OS?

Readme talks about INSTALL file. There is not INSTALL file.
[15 Mar 2007 20:54] Kent Boortz
Thank you for your bug report. This issue has been fixed in
the latest released version of that product, which you can
download at

  http://www.mysql.com/downloads/

AIX has two different models for handling shared libraries,
from 3.51.14 we use the ".so" model that should match the
run time loading you are using. If not, please let us know.