I used the import data method to populate a newly created database on the new server.
The back up and restore method worked
The detatach and attached method also worked.
I went with the import method as this is the way you can upsize ms-access so I felt that this would be the best was to get the server to create a 2005 version of the database
On 4/5/06, Mark in Amador (sent by Nabble.com) <[EMAIL PROTECTED]> wrote:
Well at leasr get the nav tabs now but still.. in all frames
500
Query Of Queries runtime error.
coldfusion.sql.imq.ImqUnsupportedCastException: Query Of Queries runtime
error.
at coldfusion.sql.imq.rttExpr.castTo(rttExpr.java:536)
at coldfusion.sql.imq.imqTable.guessColumnType(imqTable.java :453)
at
coldfusion.sql.QueryTableMetaData.InferMetaDataTypes(QueryTableMetaData.java:350)
at coldfusion.sql.imq.TableList.validate(TableList.java:166)
at
coldfusion.sql.imq.rttSelectExprSpec.validate (rttSelectExprSpec.java:498)
at coldfusion.sql.imq.rttSelectStmt.validate(rttSelectStmt.java:84)
at coldfusion.sql.imq.jdbcStatement.fetchResult(jdbcStatement.java:538)
at coldfusion.sql.imq.jdbcStatement.execute (jdbcStatement.java:131)
at coldfusion.sql.Executive.executeQuery(Executive.java:719)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:240)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java :499)
at
cfprofiler2ecfm951467494$funcGETQUERIES.runFunction(C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF\debug\profiler.cfm:36)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:348)
at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:294)
at
coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke (UDFMethod.java:258)
at
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:211)
at coldfusion.runtime.UDFMethod.invoke (UDFMethod.java:173)
at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:1807)
at
cfprofiler2ecfm951467494._factor0(C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF\debug\profiler.cfm:202)
at
cfprofiler2ecfm951467494.runPage(C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF\debug\profiler.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
at coldfusion.tagext.lang.IncludeTag.doStartTag (IncludeTag.java:349)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:33)
at coldfusion.filter.BrowserDebugFilter.invoke (BrowserDebugFilter.java:72)
at
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at
coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java :115)
at coldfusion.CfmServlet.service(CfmServlet.java:107)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java :91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:259)
at
jrun.servlet.ServletEngineService.dispatch (ServletEngineService.java:541)
at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
--
View this message in context: http://www.nabble.com/farcry-over-ms-sql-2005-t991830c621.html#a3750020
Sent from the FarCry - Dev forum at Nabble.com.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "farcry-dev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/farcry-dev
-~----------~----~----~----~------~----~------~--~---
