OK, I downloaded microsoft's sql server JDBC driver for unix, and installed the three .jar files in /library/java/extensions. After realizing that the jdbc config box did not like to have the database name in the url string (I needed to add it in the properties name-value pair below--see attachment, although the databasename property is truncated in the picture), I was able to connect just fine. I don't know how the driver will stand up to load, but now I can at least develop on the mac.
John -----Original Message----- From: John Newsom Sent: Friday, April 30, 2004 8:58 AM To: [EMAIL PROTECTED] Subject: Witango-Talk: JDBC Questions So, my next questions. 1) filemaker: it sounds like 7 will only be useful as a datasource in the advanced server version, and the jdbc drivers are not yet out for OS X. Where can I get the older 1.2 jdbc driver which is referenced in the witango server install docs? I don't have filemaker developer version, which is where the driver was distributed, I think. Also, does one have to run FM in a user space when using JDBC? 2) sql server: I downloaded the jtds driver from http://jtds.sourceforge.net/, and followed the directions in the FAQ, but I get the no suitable driver message. Does this driver not work with the witango jdbc implementation? I put the driver in the same place as the mysql jdbc driver (/library/java/extensions/). Here is the jdbc.ini file: <?xml version="1.0" encoding="ISO-8859-1" ?> <!DOCTYPE JDBCINI SYSTEM "jdbcini.dtd" > <JDBCINI Version="0x00010000"> <DataSources> <DataSource ID="mysql-staff"> <DSN>mysql-staff</DSN> <DriverClass>com.mysql.jdbc.Driver</DriverClass> <URL>jdbc:mysql://localhost:3306/test</URL> <Properties> <Property ID="server"> <Name>server</Name> <Value>localhost</Value> </Property> <Property ID="port"> <Name>port</Name> <Value>3306</Value> </Property> </Properties> </DataSource> <DataSource ID="sql-sis"> <DSN>sql-sis</DSN> <DriverClass>net.sourceforge.jtds.jdbc.Driver</DriverClass> <URL>jdbc:jtds:sqlserver://172.16.1.46:1433/sis-project</URL> <Properties> <Property ID="server"> <Name>server</Name> <Value>172.16.1.46</Value> </Property> <Property ID="port"> <Name>port</Name> <Value>1433</Value> </Property> </Properties> </DataSource> </DataSources> </JDBCINI> Any ideas? Thanks! John ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
<<attachment: jdbcconfig.jpg>>