Data source problems

Unable to add a Microsoft Access data source

Problem: When you try to add a Microsoft Access data source, the following error appears:

Unable to update the ColdFusion MX 7 ODBC Server.
Timeout period expired without completion of C:\CFusionMX7\db\slserver54\admin\swcla.exe

Solution: Install and start up the ODBC service, or use the Microsoft Access with Unicode driver.

Unable to use a data source created with UnixODBC

Problem: You cannot use a data source created with UnixODBC in ColdFusion MX 7.

Solution: You can use a driver such as the InterClient JDBC driver for InterBase available from Borland (www.borland.com/interbase/). Follow the documentation for setting up a data source using a third-party JDBC driver, Connecting to an external JDBC Type 4 data source, in conjunction with the InterClient documentation.