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
