On 9/7/07, Wil Genovese <[EMAIL PROTECTED]> wrote: > I'm thinking this got lost in yesterday's backlog. Does anyone have any > clues on this?
Not directly, but 2 years ago I did do some analysis of MSSQL JDBC drivers as part of a project and we ended up looking at both jTurbo (from NewAtlanta) and JTDS (open source http://jtds.sourceforge.net/) in addition to MS's driver. The MS driver was awful (this was the 1.0beta) and JTDS was *really* fast. Info is two years old, but it's pretty easy to try either the demo of jTurbo or the open source JTDS option to see if they address the issue. Ironically, about 80% of my ColdFusion work in the MX6->7 era was using non-bundled drives, JTDS in some cases for MSSQL and of course always the MySQL driver that supported MySQL 4.1+. Thankfully in CF8 there is a finally decent MySQL 4/5 driver > -- > Wil Genovese > > One man with courage makes a majority. > -Andrew Jackson > > A fine is a tax for doing wrong. A tax is a fine for doing well. > > > > Wil Genovese wrote: > > Ok, we recently switched to running MS SQL 2005 servers in an > > Active/Passive cluster on Win2003 (64Bit). While we were testing we had no > > issues with DB access. After migrating most of our databases to the SQL > > 2005 Cluster we are not getting the same error a few times a day that > > crashes our whole CFMX application (which is running behind a load balancer > > across three CFMX servers. > > > > The error we see is this: (note: az_tar is a valid name of a DB) > > > > Message: Error Executing Database Query. > > Detail: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot open database > > "az_tar" requested by the login. The login failed. > > Date: 09/05/2007 > > Time: 06:16:08 > > > > The login permissions are set right and have not changed from the previous > > server to this server cluster. Also, the logins work most of the day > > without an issue then all of a sudden for reasons unknown to us this error > > pops up across most or all the databases on this server. > > > > We found a MS JDBC driver (Microsoft SQL Server 2005 JDBC Driver 1.1) that > > they state "In its continued commitment to interoperability, Microsoft > > provides a Java Database Connectivity (JDBC) driver for use with SQL Server > > 2005." > > > > My questions are: > > Has anyone see this issue before? > > And if so, what was the problem/solution? > > Has anyone tried this MS JDBC Driver and what were your results? > > > > Thank You, > > Wil Genovese > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287995 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
