| Bug #44837 | undefined SQLInstallDriverExW trying to install mysql-connector-odbc | ||
|---|---|---|---|
| Submitted: | 13 May 2009 0:05 | Modified: | 20 May 2009 22:32 |
| Reporter: | Owen Townsend | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | Connector / ODBC | Severity: | S1 (Critical) |
| Version: | 5.1 | OS: | Linux (5.1) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | connector-odbc, install, SQLInstallDriverExW, unixODBC | ||
[13 May 2009 0:16]
MySQL Verification Team
Changing Category isn't Server install issue.
[13 May 2009 20:34]
Owen Townsend
I reported the problem to Peter Harvey (associated with unixODBC.org)
Peter Harvey asked:
> Q. Why are you using " --force"?
> Q. As root user do a "find / -name lib*odbcinst.so". What do you get?
> Q. Try "nm libodbcinst.so | grep SQLRemoveDriverW". What do you get?
> Send this information to the support folks at MySQL and see what they say.
> They will know what environment they have built the driver for.
> Peter
1) Why I used --force
When I 1st installed on May 11 I got the undefined SQLInstallDriverExW error
I thought I should have installed unixODBC-2.2.14 1st, so I tried to erase,
but rpm -e reported it was not installed,
At this point I installed unixODBC-2.2.14 OK I think
rerunning rpm -i did not get very far (forget exact msgs)
rerunning rpm -i got further - back to the undefined SQLInstallDriverExW
2) results of find / -name lib*odbcinst.so
2a. --> /usr/local/lib/libodbcinst.so
2b. --> .../unixODBC-2.2.14/odbcinst/.libs/libodbcinst.so
2b is where I installed unixODBC from (dont think this matters)
(results of configure, make,& make install)
3) results of nm libodbcinst.so | grep SQLRemoveDriverW (& SQLInstallDriverExW)
3a. --> 48:0000000000006ec0 T SQLRemoveDriverW
3b. --> 26:00000000000058e0 T SQLInstallDriverExW
Q#1 - I tried to install mysql-connector-odbc-5.1.5-0.x86_64.rpm on May 11 & 12
- but got undefined errs (as above)
On May 13 I installed mysql-connector-odbc-3.51.27-0.x86_64.rpm
- and it seemed to work, I get
[myodbc3i.c][589][INFO] Driver Registered usage count 1 location /etc
BUT, all files in /usr/local/... are still dated prior to May 13
- maybe all from unixODBC install & mysql-connector is in /etc/... & elsewhere - correct ?
Q#2 - How to really remove the rpm packages & start again ?
- rpm -e says not installed
[20 May 2009 6:46]
Tonci Grgin
Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely to be the same. Because of this, we hope you add your comments to the original bug instead. Thank you for your interest in MySQL. Explanation: Owen, you know we're discussing this in Bug#40289, please post findings there.
[20 May 2009 14:14]
Owen Townsend
Tonci Grgin: OK, Sorry, I have added following info to both, Owen I gave up on 5.0=5.1 version & installed the 3.51 mysql-connector-odbc and that works. With 'isql' I can execute queries on the mysql database. My Micro Focus COBOL connect does not work, but I think that is a Micro Focus COBOL problem and I have submitted a bug report to them. Thanks, Owen
[20 May 2009 22:32]
Owen Townsend
As noted above - this is a duplicate of 40289 Only 40289 will be updated from May 20/2009 onwards Moderator - you can cancel this bug Thanks, Owen Townsend
Description: I want to use openESQL to access MySQL from COBOL programs with 'EXEC SQL' - using Micro Focus COBOL on RHEL 5.0 on AMD Opteron 64 I have installed MySQL 5.0 & tested OK with demo programs & C-API some time ago (all documented at www.uvsoftware.ca/sqldemo.htm) On May 11/2009 I downloaded/installed MySQL connector/ODBC as follows rpm -i mysql-connector-odbc-5.1.5-0.x86_64.rpm I got ERROR undefined symbol: SQLInstallDriverExW I searched mysql site & somebody said solution was to install unixODBC from www.unixodbc.org I downloaded/installed unixODBC-2.2.14 BUT still get same error (undefined symbol SQLInstallDriverExW) Question --> what is mysql-connector-odbc-setup-5.1.5-0.x86_64.rpm ? --> Am I supposed to install that before connector-odbc ? --> the refman 5.1 doc makes no mention of it ? Hope somebody knows how to resolve undefined SQLInstallDriverExW ? Thanks, Owen Townsend, owen@uvsoftware.ca How to repeat: On Red Hat Enterprise Linux 5.1 on AMD Opteron 64 download & install unixODBC-2.2.14 from www.unixodbc.org download: mysql-connector-odbc-5.1.5-0.x86_64.rpm from www.mysql.com Install: rpm -i mysql-connector-odbc-5.1.5-0.x86_64.rpm Note Error: undefined symbol SQLInstallDriverExW