Failed to add ODBC Data source on CFMX7
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
