Thanks for the link. The versions of the Merant drivers I have installed show version numbers of 3.70.00.xx, dated 4/4/2001 or 5/9/2001. Are there updated drivers to be had somewhere?
At any rate, I doubt much has changed with the dBase driver. The documentaion from the DataDirect site was helpful. Jim ----- Original Message ----- From: "Douglas L. Brown" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, November 13, 2001 7:41 PM Subject: Re: Merant ODBC driver docs > 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
