Skip to main content
Participant
May 1, 2008
Question

Problem connecting through an OBDC Socket

  • May 1, 2008
  • 1 reply
  • 934 views
I am having a problem getting a connection setup in the ColdFusion Administrator. The machine I am dealing with is running ColdFusion MX 7 on Windows Server 2003. I have been able to successfully create the ODBC connection from the "Data Sources (ODBC)" windows application and am able to connect. When I go into the ColdFusion Administrator and try to create a new ODBC Socket that uses the ODBC connection I setup, I get the following error message:

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

When I look in the Event log after receiving this error, I find the entry below:

The description for Event ID ( 0 ) in Source ( ColdFusion MX 7 ODBC Server ) 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: ColdFusion MX 7 ODBC Server@LOCALHOST,ErrorCode=3059,ErrorMessage=The specified data source is not defined.,ClientHost=127.0.0.1,Session=12.

I tried to enable debugging by following the instructions at http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_19205&sliceId=2, but receive the following error when trying to execute the command "swcla -l"

[SequeLink error 6516] A generic error occurred. Minor MGGS state is %d.
[SequeLink error 6853] Failed to access configuration at sptterm02:19995.

Can anyone provide some help on how to resolve this issue?
    This topic has been closed for replies.

    1 reply

    Inspiring
    May 7, 2008
    I've had the same problem setting up a ODBC socket on CF8 developer edition and am also interested in the solution.
    May 16, 2008
    Codetacular, it would appear your ODBC services were never installed. Check the services plugin and make sure the 2 ODBC services are there and running.
    If they are not there or running try updating cf_root\lib\adminconfig.xml. Update the runsetupwizard to true and the install option for odbc to true. Save the file. Open the administrator and the configuration wizard should run and install ODBC. Then try again.

    ajdklfajdlk, take a look at Manual installation of the ODBC Services (ColdFusion 8). Note this is for CF8 only, not 801. If running 801 use the procedure as documented in the administrators guide to uninstall and reinstall the ODBC services.