 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion GroupsGeneralPHPASPPerlColdFusionFlashHTML, CSS, ScriptsBrowsers |
Webmaster Forum / ColdFusion / Server Administration / October 2007Cold Fusion ODBC Server (CF7)
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. 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. 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. 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. 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 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. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.