Hi, Has anyone connected Coldfusion CFMX 6.1 to Oracle Rdb 7 on VMS?
We have a ODBC driver for this database. We are able to use this DSN in MS Access and Crystal Reports to connect to the database. We are able to create and verify an ODBC Socket datasource in coldfusion to the DSN. When we try to perform a basic query we get the resulting error: Detail [Macromedia][SequeLink JDBC Driver][ODBC Socket]internal error: Driver does not support this function ErrorCode IM001 Message Error Executing Database Query. Stack Trace java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket]internal error: Driver does not support this function at macromedia.sequelink.ssp.Diagnostic.toSQLException(Unknown Source) at macromedia.sequelink.ssp.Chain.cnvDiagnostics(Unknown Source) at macromedia.sequelink.ssp.Chain.decodeDiagnostic(Unknown Source) at macromedia.sequelink.ssp.Chain.decodeBody(Unknown Source) at macromedia.sequelink.ssp.Chain.decode(Unknown Source) at macromedia.sequelink.ssp.Chain.send(Unknown Source) at macromedia.sequelink.ctxt.stmt.StatementContext.fetch(Unknown Source) at macromedia.jdbc.sequelink.SequeLinkImplStatement.fetchBatch(Unknown Source) at macromedia.jdbc.sequelink.SequeLinkImplStatement.fetchRow(Unknown Source) at macromedia.jdbc.sequelink.SequeLinkImplResultSet.fetchAtPosition(Unknown Source) at macromedia.jdbc.slbase.BaseImplResultSet.next(Unknown Source) at macromedia.jdbc.slbase.BaseResultSet.next(Unknown Source) at coldfusion.sql.QueryTable.populate(QueryTable.java:230) at coldfusion.sql.QueryTable.populate(QueryTable.java:159) at coldfusion.sql.Executive.getRowSet(Executive.java:505) at coldfusion.sql.Executive.executeQuery(Executive.java:974) at coldfusion.sql.Executive.executeQuery(Executive.java:886) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:229) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:447) at cfOCDE102eCFM436993178.runPage(D:\CFWebSites\OnCall\OCDE10.CFM:32) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107) at coldfusion.filter.PathFilter.invoke(PathFilter.java:80) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:105) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) I'd love some advice if this is possible and how to do it. Cheers, --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
