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

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...).