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

[Roland Dumas]

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