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:\blackstone\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.

ColdFusion 9 | ColdFusion 8 | ColdFusion MX 7 | ColdFusion MX 6.1 | ColdFusion MX | Forums | Developer Center | KnowledgeBase | Bug Reporting

Version 7

Comments

Add Comment

ASandstrom said on Jul 13, 2005 at 11:19 AM :

The tech note "Updated DataDirect JDBC drivers (version 3.4)" provides updated DataDirect JDBC version 3.4 drivers, which resolve issues in earlier versions of the drivers. The tech note is available at:
http://www.macromedia.com/go/1a3c2ad0

rainbird said on Sep 4, 2006 at 7:36 AM :

With regards to the "Unable to add Microsoft Access data source" there may be another reason for this problem. We recently have migrated from one server to another be sure any file paths defined in the configuration files are correct. For instance look in C:\blackstone\db\slserver54\admin\swcla.ini, make sure the file paths are valid, this can sometime cause the exeto timeout. The error message could be made more helpful by checking the path is valid.

RSS feed | Send me an e-mail when comments are added to this page | Comment Report

Current page: http://livedocs.adobe.com/coldfusion/7/htmldocs/00000059.htm

Add Comment