then I get out the ODBC manager and create a user and a system DSN, having entered in the information about the driver.
Then, the next time I open the dev studio, it should just appear in the ODBC data sources? Is there some other incantation I need to do, because this doesn't work.
This is just on the local machine. Haven't gotten to the server yet.
On Wednesday, July 9, 2003, at 01:29 PM, Steve Smith wrote:
Unfortunately, as has been the case on the Mac platform for a number of years now (since Visigenic ODBC Driver Manager was available) you CANNOT create ODBC data sources from within the Dev Studio. If you have the Dev Studio open, then go to your ODBC Manager (such as iODBC or myodbc) to create and/or modify a data source, you need to close the Dev Studio and reopen it to see the data source changes.
I've been running ODBC datasources between Witango and MySQL successfully for a few months now. I use iODBC and have had better success with it. I did make an attempt to use myodbc but couldn't get it to work correctly.
Set your data source up as a system data source. Select the 'Add' button and the correct driver, then set up your data source by adding keywords for:
server database user password
where 'server' = either 'localhost' or the ip address of the machine running MySQL. Database is the name of the mysql database, user is the name of a user who has access privileges and rights to the database, and the password associated with that user.
You shouldn't have to create any new files.
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
