Skip to main content
L
lanl8y
Participant
September 11, 2006
Question

CF MX 7 Standard Edition

  • September 11, 2006
  • 2 replies
  • 391 views
We're using Windows 2003 Server for both a SQL server 2000 database and a seperate ColdFusion MX 7 webserver. I created an odbc connection on the webserver but when I try to add the ODBC socket connection inside the ColdFusion Administrator page under "Data & Services, Data Sources" the drop down list (which should show the newly created DSN) is empty.

I checked the ODBC connection in the registry and it shows there as being created. Has anyone seen this before? Frustrated!
    This topic has been closed for replies.

    2 replies

    T
    tinu8805
    Known Participant
    September 19, 2006
    I also reported that. I first met the problem on a Win2K3 Standard R2 Server for 64 bit.

    The drop down list never picked up the newly created ODBC System DSNs.

    Up to today, nobody had hints or help. While we abandoned the 64 bit version in favor of the normale 32 bit version, the problem with ODBC persists on that box. Here, the ODBC droplist picked up the DSNs, but ODBC connections time out. And even in the CF Admin, the connection to the cf odbc server timed out and remained within the digital nirvana - cannot stop the cf odbc server without killing the entire process tree.

    So, moving to Win2K3 is still a no-go solution ... however, I cannot change the decisions done by ohters.
    A
    Anonymous
    September 13, 2006
    The odbc datasource must be created on the same server as CFMX and it should be a machine datasource. Perhaps you created a user datasource.

    Regardless, ODBC datasources for CFMX connections to SQL server is a really bad choice. You are much better off using JDBC and create a datasource of type MS SQL Server. The latest Macromedia drivers even offer NTAuthentication. Is there a reason you are trying to create an odbc datasource for cfmx?
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices