This may have something to do with the version of the Dev Studio I'm using and I have reported it on the Beta list but I haven't heard back from With on this.
Hope this helps,
Steve Smith
Oakbridge Information Solutions
Office: (519) 624-4388
GTA: (416) 606-3885
Fax: (519) 624-3353
Cell: (416) 606-3885
Email: [EMAIL PROTECTED]
Web: http://www.oakbridge.ca
On Wednesday, July 9, 2003, at 04: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.
If you need more assistance, I'd be happy to help one-on-one. Please feel free to contact me off of the list.
Hope this helps,
Steve Smith
Oakbridge Information Solutions
Office: (519) 624-4388
GTA: (416) 606-3885
Fax: (519) 624-3353
Cell: (416) 606-3885
Email: [EMAIL PROTECTED]
Web: http://www.oakbridge.ca
On Wednesday, July 9, 2003, at 03:36 PM, Roland Dumas wrote:
Can someone help a newbie out here? I'm completely lost without how-to documentation. I'm floundering around trying to get my first witango/mysql test application running.
I've installed mysql and myodbc on my dev machine
(the server has mysql and iodbc pre-insalled with OS X Server.)
in the ODBC admin, I've set the driver, per instruction from serverlogistics.
The instructions don't say whether to set the driver as 'system' or 'user'. 'User" is the default.
There seems to be a few other moving parts that aren't defined and everyone seems to intuitively know so well that there aren't instructions:
- What do I put for system dsn?
- what do I put for user dsn?
- do I create files somewhere? what would I put in them?
- do I modify something in witango configuation files? Which ones and what do I put?
- do I create a set of files or entries someplace for each database or just one for mysql? Do I use a text editor or is there an interface I should be using?
- what's the sequence?
- When I open the witango dev studio and tell it to create a new odbc data source, nothing happens. No dialogue or anything. Is this because I haven't modified some files someplace?
Any chance there will be instructions on how to configure and use witango with mysql on os x? please? Anyone?
Yes, I read, sort of, the pdf file at witango.com (iODBC_unixODBC_OracleOCI.pdf) I read through the "you might do this" and "enter something like this" and scratch my head (only few hairs left there)
I'm still looking for instructions that look like this;
For OS X Server, do this to get it working..... and do this for each database you have.... and do this for each user...
and for your dev machine, do this..... so that your dev studio can see your server...
Because I'm running OS X server, and it installs iODBC and MySQL, I'm hesitant to install over versions, etc., as I'll end up with a mess, multiple versions of similar functions, and in the next update, Apple will install over everthing. So my question is: How do I use what's there and make it talk to witango?
This is my monthly plea for guidance.
Yours truly,
The list idiot.
On Wednesday, June 25, 2003, at 11:01 AM, Phil Wade wrote:
Get the MySQL/MyODBC install from here:
http://www.serverlogistics.com/mysql.php
It installs easily and works.
ODBC ini entries will look like this:
[Testdb]
Driver = /Library/MyODBC/lib/libmyodbc3_r.bundle
Description = MySQL ODBC 3.51 Driver DSN
SERVER = 127.0.0.1
PORT =
USER = myuser
Password =
Database = Testdb
OPTION = 0
SOCKET =
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
