take jdbc - its much easier.
I may repeat myself, but ODBC is from my point of view just second
choice. I tried for a long time to use, but that failed.
Think of any ODBC on the mac as ODBC(Client)->JDBC(Client)->JDBC
(Server)->ODBC(Server)
So JDBC is more directly on the Mac.
You find a howto on http://www.apocm.de/witango/
Maybe there is a newer driver for mysql, please check.
chris
Am 05.07.2005 um 01:18 schrieb Richard Bates:
Please - suggestions to getting Witango Server v5.5 working with
Apache v1.3 and MySQL v4.1.12 on OS X v10.4.1
I've tried various ODBC drivers, but none with success:
- MySQL ODBC v3.51.11
- Actual ODBC Driver for OpenBase
- OpenLink MySQL
I've added the lines in /Library/StartupItems/Witango_5.5/
Witango_5.5 so that ODBCINI and ODBCINSTINI variables are exported.
I think I've got closest to success with the OpenLink driver.
When I use /Applications/iODBC/iODBC Test.command I can
successfully execute SQL commands on the database via the OpenLink
driver
The witangoevents.log includes the line
[ 192] 2005-07-04 18:07:58 START INFO ODBC Interface:
Enabled
which I guess is good.
Now trying to access this database - called 'family' - via a
simple .taf file with a 'search' command, with Witango debug turned
on, I get:
[Application File] [7] START /~rjsb/family.taf
WitangoServer
[Results Action] [7] Results
[Search Action] [9] Search : family
[Datasource] [9] No existing connection to the data
source found, creating a new connection. DSN: odbc.family; User:
root;
[Error] [4683] -4 Unable to connect to the specified
data source. OpenLink MySQL Lite Driver
[Datasource] [4683] Unable to open a connection to
odbc.family due to an unknown error during connection
[Datasource] [4684] Total Connection in Datasource Pool:
0; Max connections for the host: 0; Current connections in use for
the host:
[Error] [4684] -4 Unable to connect to the specified
data source. Verify that data source is properly configured and
that database server is online.
Please - what I'm doing wrong.
Thanks very much.
Richard
______________________________________________________________________
__
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
