I would probably start by updating the Data Direct drivers to the latest version you can get for 6.1.
I found this (v 3.5): http://helpx.adobe.com/coldfusion/kb/updated-datadirect-jdbc-drivers-version-1.html --- there might be newer ones though, not sure. If that doesn't help, you could try to use a totally different JDBC driver, for instance: http://jtds.sourceforge.net/ or http://www.microsoft.com/en-au/download/details.aspx?id=11774 If that doesn't help either you might have to face the reality and accept that you're running a CF server from 2003 against a database server that was released 9 years later :) In that case my suggestion would be to move to Railo or a more modern version of Adobe CF. Cheers Kai > A recent database upgrade from MS SQL2005 to 2012 has caused ( I believe) the > following error to occur intermittently ( about 10 times today): > > Macromedia][SQLServer JDBC Driver][Macromedia][SQLServer JDBC Driver]The > requested instance is either invalid or not running. > > java.sql.SQLException: [Macromedia][SQLServer JDBC > Driver][Macromedia][SQLServer JDBC Driver]The requested instance is either > invalid or not running. at > macromedia.jdbc.base.BaseExceptions.createException(Unknown Source) at > macromedia.jdbc.base.BaseExceptions.getException(Unknown Source) at > macromedia.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source) at > macromedia.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source) at > macromedia.jdbc.base.BaseConnection.connect(Unknown Source) at > macromedia.jdbc.base.BaseConnection.setupImplConnection(Unknown Source) at > macromedia.jdbc.base.BaseConnection.open(Unknown Source) at > macromedia.jdbc.base.BaseDriver.connect(Unknown Source) at > macromedia.jdbc.MacromediaDriver.connect(Unknown Source) at > coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:559) > at > coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(ConnectionRunner.java:64) > at java.lang.Thread.run(Thread.java:534) > > The queries that I have seen fail are quite simple ones, and are often not > even the first on the .cfm page. > > I use the Microsoft SQL option on my DSN. The database is on a named > instance. e.g.: Server\InstanceName > > The @@version of the MS SQL 2012 server is: > > Microsoft SQL Server 2012 (SP1) - 11.0.3349.0 (X64) Mar 8 2013 17:33:56 > Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows > NT 6.1 <X64> (Build 7601: Service Pack 1) > > There are no obvious errors reported\logged on the SQL server itself, so I > can only assume it might be some sort of jdbc driver problem. > > The following code returns my JDBC version 3.40 > <cfset jdbcDriver = CreateObject("java", > "macromedia.jdbc.sqlserver.SQLServerDriver")> > <cfoutput> > #jdbcDriver.getMajorVersion()#.#jdbcDriver.getMinorVersion()# > </cfoutput> > > Given the age of CFMX6.1, I don't know quite where to start, and many > websites detailing potential solutions to this error are very out-dated. > > Can anyone shed any light on the problem or offer solutions? > > -- Kai Koenig - Ventego Creative Ltd ph: +64 4 889 3626 - mob: +64 21 928 365 / +61 435 179 091 web: http://www.ventego-creative.co.nz Blog in Black: http://www.bloginblack.de 2DDU Podcast: http://www.2ddu.com/ Twitter: @AgentK -- -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/groups/opt_out.
