Issue 119602

Summary:	ODBC connection using 32bit mysql odbc connector on Mac OSX fails to display any table data
Product:	Base	Reporter:	iplaw67
Component:	code	Assignee:	AOO issues mailing list <issues>
Status:	UNCONFIRMED ---	QA Contact:
Severity:	Normal
Priority:	P3	CC:	bjdujing, issues
Version:	recent-trunk
Target Milestone:	---
Hardware:	Mac
OS:	Mac OS X 10
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

Description iplaw67 2012-05-30 14:43:39 UTC

Hi,

Since the mysql native connector extension is no longer supported by the project, I downloaded and installed the 32bit ODBC connector for Mac available on the mysql download website. I also set up a system DSN that I can see in my odbc.ini file. The driver is located at /usr/local/lib/libmyodbc5.so on the Mac.


ODBC connection on MAC using the mysql 32bit connector does not display any of the Tables. You can create an ODB file, get a connection (at least according to the successful test message), but no data is returned. It just silently fails, leaving the user with a blank Table list window.

Alex

Comment 1 iplaw67 2012-05-30 14:52:35 UTC

If you use the 64bit ODBC Connector DMG, you get the following error message :


Statut SQL: 00000
Code d'erreur: -1073750968

[iODBC][Driver Manager]dlopen(/usr/local/lib/libmyodbc5.so, 6): no suitable image found.  Did find:
	/usr/local/lib/libmyodbc5.so: mach-o, but wrong architecture


Alex

Comment 2 iplaw67 2012-05-30 14:57:00 UTC

(In reply to comment #1)
> If you use the 64bit ODBC Connector DMG, you get the following error message
> :
> 
> 
> Statut SQL: 00000
> Code d'erreur: -1073750968
> 
> [iODBC][Driver Manager]dlopen(/usr/local/lib/libmyodbc5.so, 6): no suitable
> image found.  Did find:
> 	/usr/local/lib/libmyodbc5.so: mach-o, but wrong architecture
> 
> 
> Alex

Which is logical because AOO is a 32bit app. So that means that all of the recent Snow Leopard configurations do not work, and none of the OSX Lion configs will work, since they are 64bit OS arch only. At least with Snow Leopard you could switch to 32bit kernel mode. Will try that also just to test.

Alex

Comment 3 Du Jing 2012-06-14 07:58:47 UTC

I can reproduce in AOO3.4.
besides this,when you create a table by wizard and then select a database,it will pop up "No database selected".