No... when you are "using odbc" you are still using a JDBC Bridge driver. In the case of CF it's from sequelink and you can see it running in the task list as swsoc.exe.... it's what get's fired off with the Coldfusion ODBC Service.
Whats really happening under the hood is that a JDBC driver is connecting to a socket provided by sequelink's service and issue JDBC commands. Sequelink translates these commands or calls into ODBC Calls and connects to the datasource the Access file using ODBC. It get's the results and translates them back into JDBC and sends them up the chain to the JDBC bridge driver.... So even though you are ODBC'ing the datasource you are still using JDBC and bridging to it. This is one of the reasons why Access became a much worse idea as soon as CF moved to Java. Instead of using the ODBC subsystem directly it now requires an intermediate layer to connect. -Mark Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 Skype: markakruger www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -----Original Message----- From: rex [mailto:li...@pgrworld.com] Sent: Wednesday, December 22, 2010 6:11 PM To: cf-talk Subject: Re: CF 8.01 Services freezing up In CFAdmin, if I go into SERVER SETTINGS > Settings Summary, in the Database Data Sources section, it lists all my data sources. So, if I see everything using a JDBC URL, does that mean that I don't use ODBC data sources? On 12/22/2010 3:51 PM, Dave Watts wrote: >> If you have checked "Maintain connections across client requests", stopping >> ColdFusion 8 ODBC Server shuts down the websites? >> >> I had some sites stop working while others didn't. After investigating their >> datasource settings, this is what I found. > Are you sure you're not using any ODBC data sources? Maybe it would be > a good idea to list explicitly what database drivers you're using for > each data source. > >> So, do you recommend removing the selection for all websites and turning off >> ODBC Server? > I would generally not recommend unchecking that option in production, > as it'll make things slower and less efficient. But if shutting it off > keeps your server from crashing, go ahead and shut it off. > > I'd recommend turning off the two ODBC services if you're not using > them. But make sure you're not using them. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > http://training.figleaf.com/ > > Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on > GSA Schedule, and provides the highest caliber vendor-authorized > instruction at our training centers, online, or onsite. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340230 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
