I have been on vacation, but its tough to do, without seeing. Mark can look me up, and I can help him, he has before.

-- 

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

On Aug 15, 2006, at 8:53 AM, Roland Dumas wrote:

his is a PPC G4. 
I thought the myODBC file did come from mysql.
in any case, he's stuck in getting mysql odbc connection working. can anyone lend a hand?

On Aug 15, 2006, at 8:40 AM, Robert Garcia wrote:

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

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

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

________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Reply via email to