You don't have to use the SQL Server drivers that come with CF. I know people using different JDBC drivers, and I know I am personally using ADO to connect in one instance.
> -----Original Message----- > From: Russ [mailto:[EMAIL PROTECTED] > Sent: Friday, September 29, 2006 1:48 PM > To: CF-Talk > Subject: RE: CF vs. .NET presentations? > > Also the JDBC-ODBC bridge is not used when talking to SQL server. I'm not > sure what the performance difference is between JDBC and ODBC, maybe > someone > can pitch in here. > > Russ > > > -----Original Message----- > > From: Phillip B. Holmes [mailto:[EMAIL PROTECTED] > > Sent: Friday, September 29, 2006 1:19 PM > > To: CF-Talk > > Subject: RE: CF vs. .NET presentations? > > > > >I imagine it will be the same with ASP. > > > > DB Session handling in ASP.NET is a native functionality of .NET which > you > > flip the setting in the web.config file and setup your SQL DB that > handles > > only those requests...the process and DB hit are incredibly thin and > fast. > > Remember ADO needs no ODBC bridge (like JDBC). DB hits to MS SQL are > going > > to naturally be faster. > > > > --Phil > > > > > > > > -----Original Message----- > > From: Russ [mailto:[EMAIL PROTECTED] > > Sent: Friday, September 29, 2006 11:57 AM > > To: CF-Talk > > Subject: RE: CF vs. .NET presentations? > > > > There are a few lines that you can add to CF config files and it will > > store > > all session data in the db. I tried it and it proved to be a bit slow, > > and > > I imagine it will be the same with ASP. CF has an arguably better > > solution > > where it shares the data between all the servers directly, instead of > > loading the db server on every request. > > > > Russ > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254806 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4