ok here is my problem..
I had an application that worked perfectly on CF 5.0 using the Minisoft
ODBC driver for Image/sql on an HP3000 with mpe/ix 6.0.
When i moved that application over to the CFMX server and set up the
ODBC socket dsn i get a weird error when trying to execute any simple
query. I also found out that if i put a syntax error on the query the
ODBC driver will let me know of the incorrect syntax... so the queries
seem to be going through but when it gets back with the results the
SequeLink JDBC Driver seems to hang.
am i doing something wrong? or is the ODBC socket function on CFMX
buggy? Bellow is the exact error i get..
Error Occurred While Processing Request
Error Executing Database Query.
[MERANT][SequeLink JDBC Driver]An internal error occurred.
The Error Occurred in C:\Inetpub\wwwroot\test.cfm: line 3
1 : <cfquery datasource="hp3000" name="GetHP">
2 : Select * from rimdb.schedule_mst
3 : </cfquery>
SQL
Select * from rimdb.schedule_mst
DATASOURCE
hp3000
VENDORERRORCODE
7368
SQLSTATE
HY000
Please Try The Following:
Check the CFML Reference Manual to verify that you are using the correct
syntax.
Search the Knowledge Base to find a solution to your problem.
Browser
Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
Remote Address
127.0.0.1
Referer
Date/Time
18-Jul-02 05:36 AM
Stack Trace (click to expand)
at cftest2ecfm511402424.runPage(C:\Inetpub\wwwroot\test.cfm:3) at
cftest2ecfm511402424.runPage(C:\Inetpub\wwwroot\test.cfm:3)
java.sql.SQLException: [MERANT][SequeLink JDBC Driver]An internal error
occurred.
at com.merant.sequelink.ssp.Diagnostic.ClientCoreError(Unknown
Source)
at
com.merant.sequelink.variables.CursorVariables.getColumnMetaData(Unknown
Source)
at com.merant.sequelink.variables.CursorVariables.make(Unknown
Source)
at
com.merant.sequelink.ctxt.stmt.StatementContext.makeCursorVariables(Unknown Source)
at com.merant.sequelink.jdbc.SequeLinkResultSet.(Unknown Source)
at
com.merant.sequelink.jdbc.SequeLinkStatement._getResultSet(Unknown
Source)
at
com.merant.sequelink.jdbc.SequeLinkStatement.getResultSet(Unknown
Source)
at jrun.sql.JRunStatement.getResultSet(JRunStatement.java:318)
at coldfusion.sql.Executive.getRowSet(Unknown Source)
at coldfusion.sql.Executive.executeQuery(Unknown Source)
at coldfusion.sql.Executive.executeQuery(Unknown Source)
at coldfusion.sql.SqlImpl.execute(Unknown Source)
at coldfusion.tagext.sql.QueryTag.doEndTag(Unknown Source)
at cftest2ecfm511402424.runPage(C:\Inetpub\wwwroot\test.cfm:3)
at coldfusion.runtime.CfJspPage.invoke(Unknown Source)
at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source)
at coldfusion.filter.CfincludeFilter.invoke(Unknown Source)
at coldfusion.filter.ApplicationFilter.invoke(Unknown Source)
at coldfusion.filter.PathFilter.invoke(Unknown Source)
at coldfusion.filter.ExceptionFilter.invoke(Unknown Source)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(Unknown
Source)
at coldfusion.filter.BrowserFilter.invoke(Unknown Source)
at coldfusion.filter.GlobalsFilter.invoke(Unknown Source)
at coldfusion.filter.DatasourceFilter.invoke(Unknown Source)
at coldfusion.CfmServlet.service(Unknown Source)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
at
jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241)
at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:198)
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)
______________________________________________________________________
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
