I believe this is the driver that CF uses
MERANT DataDirect Connect ODBC
Version 4.00 for Windows
August 2001
http://www.datadirect-technologies.com/odbc/techresources/productdoc/otdocum
ent.asp
----- Original Message -----
From: "Jim McAtee" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, November 13, 2001 6:10 PM
Subject: Merant ODBC driver docs
> Where can I find documentation for the Merant drivers that ship with CF5?
> Specifically, we're trying to work out the kinks with the dBase driver.
> From some initial testing, there's definitely a big difference in the way
> this driver is parsing queries that were working fine with the older MS
Jet
> drivers. A couple of examples:
>
> <cfquery name="myQuery" datasource="somedBaseDSN">
> SELECT table1.*, table2.something, table3.somethingelse
> FROM (table1 INNER JOIN table2 ON table2.key1 = table1.key1)
> LEFT JOIN table3 ON table3.somefield = table1.somefield
> WHERE table1.id = #somevalue#
> </cfquery>
>
> produces the error:
>
> [MERANT][ODBC dBase driver]Cannot open file 'D:\DATA\(.DBF'.
>
> Apparently it see's the first paren as a table name???
>
>
> Even simpler:
>
> <cfquery name="myQuery" datasource="somedBaseDSN">
> SELECT table1.*, table2.something
> FROM table1 INNER JOIN table2 ON table2.key1 = table1.key1
> WHERE table1.id = #somevalue#
> </cfquery>
>
> gives an error:
>
> [MERANT][ODBC dBase driver]Extra characters at end of query: INNER.
>
>
> Is there some stricter form of ODBC syntax that we need to adhere to?
> Anyway, these drivers ARE documented somewhere, right?
>
> Thanks,
> Jim
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
