Wayne,
That error is being returned from the FileMaker JDBC layer, which means that the configuration in Witango is good and you are now talking to FMP. Unfortunately there’s not enough information there to know what the problem is. Try a few things: Turn on debug so that you can see what the actual query is. Try a simple Select action just getting one column from one table, something really simple. Verify the names of the database, layout, and column. Robert From: Wayne Irvine [mailto:[email protected]] Sent: Sunday, March 06, 2011 5:46 PM To: [email protected] Subject: Re: Witango-Talk: xDBC? On 05/03/2011, at 3:18 AM, Robert Shubert wrote: You do need to set the Witango data source name as both the value of the ID=”” attribute and the <DSN></DSN> element. I've now got: <?xml version="1.0" encoding="ISO-8859-1" ?> <!DOCTYPE JDBCINI SYSTEM "jdbcini.dtd"> <JDBCINI Version="0x00010000"> <DataSources> <DataSource ID="AIL-comments.fp7"> <DSN>AIL-comments.fp7</DSN> <DriverClass>com.filemaker.jdbc.Driver</DriverClass> <URL>jdbc:filemaker://203.24.144.42/AIL-comments.fp7</URL> <Properties> <Property ID=""> <Name></Name> <Value></Value> </Property> </Properties> </DataSource> </DataSources> </JDBCINI> Seems to get further but the latest error is: [FileMaker][FileMaker JDBC] FQL0001/(1:22): There is an error in the syntax of the query. 08007 This is from a simple Search Builder taf accessing three fields of the database. Wayne Irvine _____ To unsubscribe from this list, please send an email to [email protected] with "unsubscribe witango-talk" in the body. ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe witango-talk" in the body.
