If you possibly do it, move to JDBC rather than ODBC. You'll be much
happier, the drivers are free, etc etc.
When you download the JDBC (thin) clients, just place them here
/Library/Java/Extensions
You're done.
The next hard part is figuring out how to "address" different
drivers. They all have different methods (so much for standardization).
Apple has a great web page on these addresses (even if it IS directed
towards Web Objects)
http://docs.info.apple.com/article.html?artnum=107856
The only other tricky thing to remember is that you have to be sure
to set up the SAME JDBC connections for BOTH editor and server.
Easiest thing to do is to set everything up in the Editor, then COPY
the resulting jdbc.ini file from the ~/Library/Preferences/Witango
directory TO the /Applications/WitangoServer/5.5/configuration directory
A "typical" mysql entry would look like this (from the jdbc.ini
file). Things you need to change in bold
<DataSource ID="how-you-refer-to-this-database (doesn't HAVE to be
the same as the DSN, but it's easier)">
<DSN>database-name</DSN>
<DriverClass>com.mysql.jdbc.Driver</DriverClass>
<URL>jdbc:mysql:/localhost:3306/database-name</URL>
<--- change to server DNS or IP if
different from localhost
<---- change port number if you're not
using the mysql default
<Properties>
<Property ID="server">
<Name>server</Name>
<Value>127.0.0.1</Value> <--- where you are on the same server,
e.g., localhost, else change
</Property>
<Property ID="port">
<Name>port</Name>
<Value>3306</Value> <--- change only
if not standard mysql default
</Property>
</Properties>
</DataSource>
To help in Witango and general connection troubleshooting...
Strongly advise your getting a good sql editor (I like Aqua
DataStudio from www.aquafold.com) and testing with that. If you
cannot connect with that, no way Witango's going to work... Most sql
editors these days use JDBC for connecting, too.
On Nov 28, 2006, at 1:01 PM, SA listreader wrote:
Could someone point me to an idiot's guide to installing ODBC
support for OS X? I know there have been instructions posted in the
past but I am onsite and don't have my Tango-Talk archive
accessible and can't find anything useful in the online Witango
Talk archive
I am trying to connect to a Filemaker 8.5 database on the same
machine as a Witango Lite 5.5 server running on OS X Server 10.4.8.
I am doing this because we plan to stay with Filemaker in the short-
term and then evaluate migrating to MySQL. We need the Filemaker
interface for letter & label printing, etc. I have the standard
install MySQL 4.1.13a running on the server and have installed
CocoaMySQL for testing purposes. I have downloaded Filemaker 8.5
test drive & built a test database on the server
Currently the database is in Filemaker 5 on OS 9 (sigh) and I'll
move it to 8.5 or 6 or whatever will work without having to buy
Filemaker server version
I know Witango & Filemaker pretty well but know nothing at all
about ODBC, JDBC, SQL & etc. I've looked at the OpenLink,
ActualTechnologies and DataDirect ODBC drivers and have installed
the ActualODBC pack for MySQL but I'm now in acronym hell without a
clue
Thanks
______________________________________________________________________
__
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
