sql query using odbc

[caro]

I'm having a horrible time trying to figure out how to query data from a FileMaker database using ColdFusion. I've managed to set up a datasource linking to the FileMaker Pro database with "ODBC Socket" as the driver, but when I try to run a simple SELECT query, I get this error:

[Macromedia][sequeLink JDBC Driver][ODBC Socket][DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker]Parse Error in SQL

My select query is simply:

SELECT *

FROM testODBC

There are only three fields in the database, two text fields and a number field. I've tried querying one field at a time, and when I query one of the text fields I get the same error message. If I query the number field only, I get the following error message:

[Macromedia][sequeLink JDBC Driver][ODBC Socket][DataDirect][ODBC SequeLink driver]String data, right truncated.

I'm using ColdFusion MX and FileMaker Pro 7, although ideally I'd like this to run with FileMaker Pro 6. All we want to do to use data from an existing FileMaker database to populate a select input, we won't be writing to the FileMaker database at all. Any suggestions? Thanks!

[manfjon]

Since FileMaker discontinued the XML/CDML technology (Lasso) with version 7 I also try to establish a connection between the FM database and my ColdFusion MX application server via the newly suggested DataDirect 32-BIT SequeLink 5.4 client driver. However my horrible time already starts in an earlier phase than yours.

For some reason my ODBC Data Source Administrator version 3.5x somehow doesn't recognize this client driver in trying to set up the DSN. You seem to have experience. How did you install and configure this driver?? Could you please help me out (maybe we can help eachother in setting this up succesfully)??

(Should it install automatically with the FM Pro 7 installation?? I also downloaded and installed this driver from the DataDirect site, but this one is also not recognized by ODBC admin. On the other hand the Registry Editor on my server does state this new driver to be present...).

[manfjon]

Hi,

Just like you I'm trying to query data from a FileMaker Pro 7 database using ColdFusion. Last month you provided me some great guidelines via the FM Forums in getting the Datadirect ODBC driver working. In the mean time I got access to the FM Pro 7 CD and smoothly (unlike version downloaded earlier from the DataDirect site) installed the DataDirect 32-BIT SequeLink 5.4 client driver from the present xDBC directory. Also the configuration of the FileMaker Pro data source went quick and easy.

Now I the added the new ODBC DSN to the ColdFusion application server and try to query and publish data from this source (using Dreamweaver MX 2004). In the Databases- and Bindings I do properly see this Database, it's Tables and it's Fields. However, when I execute a simple select query SELECT * FROM test I get the following error message:

[Macromedia][sequeLink JDBC Driver][ODBC Socket][DataDirect][ODBC SequeLink driver]String data, right truncated.

I checked your earlier post in the FM Forums (dated May 11 2004) and apparently you faced the same error.

Did you ever succeed in getting this solved and if so, how???

Do I also have to install the Sequelink JDBC Driver as part of the xDBC directory of the FM Pro 7 CD?? If so, do you know where I can find the guidelines for this (not a standard installation)??

Thanks,

Manfred

[neonic]

I hate MS* programs!!!

After many tries and many hours I discovered that the error comes if you

have specified strange names (for Access) for the fields in FileMaker.

I have a database with a field called "FLAG 2"; well, it seems that Access

doesn't allow spaces in field names (at least importing data from

FileMaker with ODBC). I had your same error: "Parse error in SQL".

I changed the field name in FileMaker (FLAG 2 became FLAG2 without space)

and it worked!!!

Thank you Bill, you are always in our thoughts!!!