Bug #605 MyODBC 3.51.06 not compatible with MySQL 4.0.12
Submitted: 6 Jun 2003 5:56 Modified: 10 Apr 2008 13:29
Reporter: Gemma Burman Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / ODBC Severity:S1 (Critical)
Version:MyODBC 3.51.06 OS:IBM AIX (AIX 4.3.x)
Assigned to: CPU Architecture:Any

[6 Jun 2003 5:56] Gemma Burman
Description:
Reference :- Kerry Ancheta

Any MySQL client program which uses ODBC interface to connect to a MySQL server should link to the libmyodbc3.a library of MyODBC. This library has a dependency on libmysqlclient.a library of MySQL. It looks for a shared object libmysqlclient.so.10 inside the archive libmysqlclient.a. But the library libmysqlclient.a shipped by MySQL AB for AIX 4.3.x platform doesn’t consist of this shared object. This results in the program  not being able to load the required shared object.  The version used for MySQL is 4.0.12 and MyODBC is 3.51.06. The “dump –H libmyodbc3.a” log is provided below. This shows the dependencies in the Import File Strings section.

libmyodbc3.a[libmyodbc3-3.51.06.so]:

			***Loader Section***
                      Loader Header Information
VERSION#         #SYMtableENT     #RELOCent        LENidSTR
0x00000001       0x00000135       0x0000062e       0x00000100       

#IMPfilID        OFFidSTR         LENstrTBL        OFFstrTBL
0x00000003       0x00006740       0x00001271       0x00006840       

			***Import File Strings***
INDEX  PATH                          BASE                MEMBER              
0      /home/mysqldev/venu/local/mysql/lib:/home/mysqldev/venu/local/mysql/lib/.libs:/usr/local/lib/gcc-lib/powerpc-ibm-aix4.3.2.0/3.2:/usr/local/lib/gcc-lib/powerpc-ibm-aix4.3.2.0/3.2/../../..:/usr/lib:/lib                                         
1                                    libmysqlclient.a    libmysqlclient.so.10
2                                    libc.a              shr.o               

How to repeat:
Refer to description
[6 Jun 2003 11:53] Venu Anuganti
Thank you for your bug report. This issue has been fixed in the latest
development tree for that product. You can find more information about
accessing our development trees at 
    http://www.mysql.com/doc/en/Installing_source_tree.html
[8 Jun 2003 22:46] Gemma Burman
Can we get the prebuilt binaries for the fixed version
[9 Jun 2003 12:57] Venu Anuganti
Hi !!

I am in the process of making a patched version for AIX 4.3, so that the client library is linked statically.

Mean while you can also build the driver yourself by downloading the following MySQL client headers and shared libraries(3.23 version) for AIX 4.3:

ftp://support.mysql.com/pub/mysql/hidden/odbc/mysql-client-ibm-aix4.3.2.0-powerpc.tar.gz

Thanks
Venu
[18 Jun 2003 12:27] Venu Anuganti
Any update or luck ? Or you want me to provide a customized driver binary for this platform ?

Thanks
venu
[19 Jun 2003 2:38] Goutham S Mohan
Hi,
  To summarize: (Platform AIX 4.3)
  We are using the static version of the libraries for linking with our client program. We are doing this as we donot intend to use any Driver Manager. 
  We intend to statically link libmyodbc3.a and libmysqlclient.a with the client program. But libmyodbc3.a has a dependency on libmysqlclient.so.12 within libmysqlclient.a which should not be the case, since libmysqlclient.a has only .o files within the archive.
  So we need a libmyodbc3.a library(MyODBC 3.51.06) which works with the static library libmysqlclient.a(MySQL 4.0.12/3.23.56) on AIX 4.3.x. We are waiting for the pre-build binaries from you in this regard.

Regards,
Goutham S Mohan
[8 Jul 2004 19:27] Dan Parker
I have this same problem with the HP-UX 11.11 binary distributions.  I must say that I find it exceedingly silly that the binary distribution of the ODBC/Connector product, which serves absolutely NO purpose other than to provide access to MySQL Server, will not work with the binary distribution of the latter, and that one is expected to jump through the hoops of custom builds in order to make the ODBC component function.  I further fail to understand why MySQL binaries are not packaged with BOTH static and shared object versions of 'libmysqlclient', which would completely eliminate problems like this.  I like many of MySQL's features and have been trying very hard to advocate its use within my company, but issues like this one make the product set appear somewhat amateurish and complicate my efforts a great deal.
[8 Jul 2004 19:36] Dan Parker
A P.S...

I note from the dates of the comments here that this has been an issue for over a year now.  I downloaded the latest 4.1.x beta binaries for MySQL as well as the ODBC/connector binaries...and the problem STILL hasn't been addressed.  Not a very encouraging sign, to say the least.
[26 Aug 2004 21:17] MySQL Verification Team
Please try the latest package 3.51.9 which doesn't need anymore the
shared library.

Thanks
[14 Feb 2005 22:54] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[1 Jun 2005 20:05] Gerardo Narvaja
The bug seems to still be present in the current Connector/ODBC distributions.
[10 Apr 2008 13:29] Bogdan Degtyariov
MyODBC 3.51 driver is now built for AIX 4.3/5.2