Hi
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?
Thanks, Scott.
--
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.
