Skip to main content
M
mani_bono
Participant
October 12, 2011
Question

ColdFusion 8 Problem Connecting to Excel with ODBC Socket

  • October 12, 2011
  • 1 reply
  • 1169 views

Platform: Windows Server 2003

Version: ColdFusion 8

Created System DSN connected to an Excel file, when trying to add odbc data source in ColdFusion Administrator using ODBC Socket and selecting that DSN recieves error:

Unable to update the ColdFusion ODBC Server.

Timeout period expired without completion of E:\ColdFusion8\db\slserver54\admin\swcla.exe

in a new ODBC Socket Data Source Dialog Username is system, password is empty, and "Trusted Connection" is unchecked. tested both checking trusted connection, or specifying Administrator user and password without any luck.

Both ColdFusion ODBC Services "ColdFusion 8 ODBC Agent" and "ColdFusion 8 ODBC Server" are running.

I'm server administrator trying to make this code running, it has been running on another server, so changing the code is not an option here.

any ideas?

This topic has been closed for replies.

1 reply

M
mani_bonoAuthor
Participant
October 12, 2011

OK I Checked the log file in E:\ColdFusion8\db\slserver54\logging and it says:

Wed Oct 12 11:45:42 2011:SLX ODBC Socket. Build 009711

Wed Oct 12 11:45:42 2011:Connection request from 127.0.0.1, client application JDBC

Wed Oct 12 11:45:42 2011:BEHIN-EB416F081(4 CPU) - Microsoft Windows 2000(5.2-Service Pack 2 (Build 3790))

Wed Oct 12 11:45:42 2011:The specified data source is not defined.

why it detects OS as Microsoft Windows 2000?!!

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices