Skip to main content
S
SafariTECH
Inspiring
October 25, 2007
Question

Cold Fusion ODBC Server (CF7)

  • October 25, 2007
  • 3 replies
  • 410 views
Just curious as to why there is a CF ODBC Server that is run be default?

I thought it was necessary to run this to use data connections with CF, but it turns out all of our sites run 100-fold faster and better with the darn thing turned off and there is no issue connecting to data sources!?

So why is it there at all? Just curious more than anything.

    This topic has been closed for replies.

    3 replies

    S
    SafariTECHAuthor
    Inspiring
    October 26, 2007
    We only have one small site running Access as a backend, everything else connects to a pair of remote SQL servers for data. We run nothing using the actual ODBC Socket type.

    I was just curious and now that we know that we don't require it to run SQL connections, I will probably impirt the Access database to one of our SQL servers and just deactivate it completely.

    S
    SafariTECHAuthor
    Inspiring
    October 26, 2007
    interesting

    is it possible that when it is on, it actually handles all data connections, not just Access? But when off the SQL connections run through the native ODBC handlers?

    I only ask because our server was bogging down yesterday and as soon as I turned off the CF ODBC Server it was faster than it had ever been in the past year or so!

    Leaving the service off, the server is still way better than it ever has been today.
    A
    Anonymous
    October 26, 2007
    Perhaps by stopping it you have killed a number of applications that were using ODBC connections and gumming up your server. You might want to review if you have any DSNs of type ODBC Socket listed. If so, try to determine if any applications are really using these DSNs. If you can live without ODBC, great.
    A
    Anonymous
    October 26, 2007
    You use the CF ODBC server to connect to Microsoft Access databases or if you elect to use ODBC connections instead of JDBC connections.

    If you're doing neither of those, it is safe to disable those services.
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices