Skip to main content
Participant
October 4, 2010
Question

Failed to add ODBC Data source on CFMX7

  • October 4, 2010
  • 1 reply
  • 688 views

Hi,

We have a windows 2003 server where ColdFusion MX7 is installed, it was working properly for that last few years, recently it started giving errors while adding MS Access Database as ODBC data source. Every time we add a ODBC data source(MS Access), we get this following errors:

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

From the event viewer, we have found the following errors:

The description for Event ID ( 0 ) in Source ( SequeLink ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Failed to load configuration file from C:\CFusionMX7\db\slserver54\cfg\swandm.ini.

while investigating the swandm.ini file, we found that one unexpected character(;t;) was added in the bottom of the file.

Here is the last section of the file:

---------------------------------------------------------------

[MGSSMechanism_5]

Type=12

MGSSMechanismName=OSLogon(UID,PWD,NPWD)

MGSSMechanismProviderName=OSLogon

MGSSMechanismProviderMechanism=OSLogon(UID,PWD,NPWD)

MGSSMechanismLoadType=Dynamic

MGSSMechanismLocator=C:\CFusionMX7\db\slserver54\bin\cmgss_hu.dll

MGSSMechanismInitRoutine=CMGSS_OSLogon_Init

;

t

;

------------------------------------------------------------

if we we delete the character, then the data source works fine. can any body help us to resolve this issue?

Thanks in Advance

Mamun

    This topic has been closed for replies.

    1 reply

    October 5, 2010

    Did you reinstalled ODBC services, if not , ido so.

    http://kb2.adobe.com/cps/191/tn_19135.html