Um. JDBC will. I don't know what kdnc is (I am presuming, a typo...)
On Nov 28, 2006, at 1:43 PM, Driscoll, Kevin wrote:
Will kdnc work with masql server 2003?
--------------------------
Sent from my BlackBerry Wireless Handheld
-----Original Message-----
From: Dale Graham
To: [email protected]
Sent: Tue Nov 28 13:27:21 2006
Subject: Re: Witango-Talk: OS X Setup
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 <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
______________________________________________________________________
__
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
