I saw the docs as well... is this a limitation of the JDBC-ODBC bridge or the native driver in CFMX? So the "ODBC Socket" or "SQL Server" drivers provided with CFMX are pure Java Type IV native drivers? No ODBC involved... can your confirm this?.
Joe ----- Original Message ----- From: "Dave Watts" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, September 08, 2002 8:32 PM Subject: RE: CFObject in CFMX (Connection String) > > It looks like "connectstring" and some other params of > > query are deprecated in CFMX.. so how do you go about > > doing a DNS-less connection in CFMX? > > Dynamic connections aren't supported in CF MX. This is documented in the > release notes, I think, or in the regular documentation set itself. If I > recall correctly, this is a limitation of JDBC. > > > Where are Java JDBC driver info's stored in CFMX? I would > > like to use the TYPE IV Java drivers making direct calls > > to the DB.. Theoretically.. this would give the best > > performance..since u bypass the ODBC layer right? > > There's no ODBC layer used when you create a CF MX datasource anyway, if > you're using a Type 4 driver. So, I don't think you'd get any performance > increase even if you could build a dynamic connection. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 > > ______________________________________________________________________ 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
