Re: Witango-Talk: Again, connecting MySQL/on osx Server to witango

[Robert Garcia]

no, but that bundle file, for instance, doesn't come from myqsl. And it also depends, on the version of iODBC on the system, either apple, or openlink 5.2, or 6.0, each act a bit different, unfortunately. Also, this is MUCH more tricky on intel mac. --  Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 13653 West Park Dr Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 [EMAIL PROTECTED] - [EMAIL PROTECTED] http://bighead.net/ - http://eventpix.com/ On Aug 15, 2006, at 8:07 AM, Roland Dumas wrote: I tibuktu'ed into his machine and resolved one set of issues - the user permissions in mysql. There is still an odbc problem that I can't figure out at all. Is the latest version of myodbc installing in different locations or something?   On Aug 15, 2006, at 3:22 AM, Robert Garcia wrote: There may be other issues, but your driver setup file is incorrect. Try both Driver File Name, and Setup File Name, as: /usr/lib/libmyodbc3.dylib Also, you only need SERVER and DATABASE for the DSN, as long as you use default port 3306, you can more as needed, but start with the least, and test with something NOT witango, like EXCEL, or just the iodbctest. --  Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 13653 West Park Dr Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 [EMAIL PROTECTED] - [EMAIL PROTECTED] http://bighead.net/ - http://eventpix.com/ On Aug 14, 2006, at 2:33 PM, Mark Weiss wrote: Hi All, I have been working a good part of the day trying to hook up witango 5.x to mysql via ODBC. I have installed the connector and this is what the odbc.ini file looks like. [SampleDS] Driver                 = /usr/lib/libmyodbc3.dylib Description   = Sample Mysql Data Source Port   = 3306 TRACE   = Off Tracefile   = stderr SERVER                 = localhost DATABASE               = test USER   = newuser PASSWORD   = newuser4 when I go to test this connectoin, it says: IM3 [idobc][Driver Manager] specified driver could not be loaded. and 00000 [iODBC[Driver Manager]NSLinkModuile() failed for dlopen() In defining the Driver I have set ODBC3.51 Driver File Name: /usr/lib/libmyodbd3.bundle Set up File name /Users/admin/library/odbc/odbcinst.ini With no definition pairs below that. I checked driver permissions in the usr/lib/   directory and they are all the same. It seems I am missing something in the driver set up. Any idea? Mark WEiss ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf