Thanks Phil
on 3/15/06 17:46, Phil Wade at [EMAIL PROTECTED] wrote: > 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 > -- -- Dan Stein FileMaker 7 Certified Developer Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Cell: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000, MySQL, CWP [EMAIL PROTECTED] www.dss-db.com "It is perfectly safe to stand nowhere." ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
