Data Direct Patch

[Guest]

We have been having some issues with our queries since testing our app in CF 8. I tracked down the issue as being the jdbc driver and found this link that verifies our issue
http://knowledgebase.datadirect.com/KBase.nsf/SupportLink+Online/2466912PG?OpenDocument

I was able to find this info by using the SpyAttributes() parameter in our jdbc url.

The only way you can get this patch is to have an existing contract with DataDirect.

Does anyone know if there is a way to get this patched? Our queries are blowing up in quite a few places because of this.

Thanks,
Ben

[Guest]

I will look into seeing if Adobe will be distributing a patched version of the DataDirect MS SQL driver or if there are any plans to release an updated set of our drivers. Generally, this does not occur quickly given we need to do lots of QA testing before releasing new DD drivers.

I would recommend testing with Microsoft's own JDBC driver. You could use their driver exclusively if it works for you. Or use their driver only for your compound sql statements that hit the bug. You can get their driver here. Unlike earlier MS JDBC drivers, the 2005 driver is their own and not just a repackaged DD driver.

[conanbarb]

Ken-
Do you know if Adobe plans on releasing the SQL 2005 DataDirect Drivers for ColdFusion 7?

Any info is appreciated.

Thanks,
Christian

[Guest]

There are no current plans for updating the cfmx7 drivers further at this point. That may change in the future. However cfmx7 was never tested or designed around MSSQL 2005 so I would not expect support for any new features in cfmx7 for MSSQL 2005. The JDBC driver is only one part of this.

Obviously, there is nothing to keep you from using Microsoft's own MS SQL 2005 JDBC driver. It is their own driver and designed for the DBMS. This is not simply a rebranded driver that MS is distributing.

[conanbarb]

Ken-
Thank you for your quick response. I have one other question. According to the ColdFusion support matrix located at http://www.adobe.com/products/coldfusion/coldfusion7/pdfs/cfmx7_systemsupportmatrix.pdf, ColdFusion 7.0.2 is supported on "MS SQL Server 2003 (MS SQL 2000 functionality only)." I assume that is a typo and it should be MS SQL Server 200 5 since I'm not aware of a MS SQL Server 2003. Am I correct in thinking we can use the existing DataDirect 3.5 drivers to connect to a MS SQL Server 2005 database as long as we only use MS SQL 2000 functions?

Thanks,

[Guest]

Correct