Skip to main content
A
Anonymous
March 7, 2008
Question

ODBC vc. JDBC

  • March 7, 2008
  • 1 reply
  • 366 views
We are moving, (hopefully,) from CF5 to CF8, and from SQL Server 2000 to SQL Server 2005. My question is on the database access - is there a performance improvement going with JDBC instead of ODBC, and are there any gotchas?
This topic has been closed for replies.

1 reply

J
JR__Bob__Dobbs-qSBHQ2
Inspiring
March 8, 2008
I'd use JDBC, mainly because ODBC support in CF7+ seems be flaky based on the number of posts I've seen regarding the ColdFusion ODBC services. I've had to manually install them on a server when they failed to be setup properly by CF's installer.

Items to consider.

Changes to cfquery: Versions 6+ of ColdFusion drops support for including connection properties (such as the connectionstring attribute) in cfquery. You must use the datasource attribute to connect to your server.

Changes to cfprocparam: Named parameters using dbvarname are no longer supported.

JDBC Drivers: Note that in addition to the SQL Server JDBC driver bundled with ColdFusion you can also use Microsoft's JDBC driver.

http://msdn2.microsoft.com/en-us/data/aa937724.aspx
http://www.adobe.com/go/tn_18800
http://www.adobe.com/go/tn_19135
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices