Dan,
This is the experience the QA guys had with FMSA 8 xDBC.
Don't deploy FM8 xDBC on OS X 10.3.9, 10.4.3+ is the version to use.
Install the J2SE 5.0 and use it as the default JVM.
To use FM JDBC simply put the sljc.jar file in the /Library/Java/
Extensions/ directory and set up a JDBC datasource like this:
<DataSource ID="test">
<DSN>test</DSN>
<DriverClass>com.ddtek.jdbc.sequelink.SequeLinkDriver</DriverClass>
<URL>jdbc:sequelink://127.0.0.1:2399;ServerDatasource=test;</URL>
<Properties />
</DataSource>
Check the witangoevents.log file to ensure that the JVM has loaded
and the JDBC interface is enabled:
[ 1058] 2006-03-01 12:22:54 START INFO Java Virtual Machine:
Attempting to load /System/Library/Frameworks/JavaVM.framework/JavaVM
[ 1058] 2006-03-01 12:22:56 START INFO Java Virtual Machine:
Enabled
[ 1058] 2006-03-01 12:22:57 START INFO JDBC Interface: Enabled
Watch out for spaces in column and table name and if you have used
punctuation in column and table names remove them before you start
programming.
Also watch out for the case sensitivity of FM xDBC in your queries
e.g. a search on "FileMaker" will not return "fileMaker".
Make sure that you have enabled xDBC on FMSA and the permissions on
the FM db allow for the login to access the database via xDBC.
Regards
Phil
On 15/03/2006, at 2:27 AM, Dan Urlich wrote:
Hi,
I am trying for the first time to connect to Filemaker 8 Server
Advanced via JDBC. Testing with MacOS X 10.4.5 client but I will
deploy on 10.3.9 Server. I have installed the JDBC Client Driver
into "/Library/Java/Extensions/".
I get a "No suitable driver" error message.
Any ideas?
Thanks,
Dan
______________________________________________________________________
__
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
