Hi

I've got a successfull site running Coldfusion v5 front end with Inmagic ODBC
v3.

I'm upgrading servers and looking at upgrading to Coldfusion MX 7 using
Inmagic ODBC v8.

I've installed a test server with Win2000, CFMX7 and Inmagic ODBC v8 server
driver but am getting the following error on queries:

I'm unsure if it's a CF or Inmagic ODBC issue. Works fine under CF5 just not
MX. Any ideas?

Thanks, David

--------
Error Occurred While Processing Request
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Inmagic, Inc.][DB/Text ODBC
Driver]Driver not capable

The error occurred in C:\....\directory\act_search.cfm: line 172
Called from C:\..............\directory\index.cfm: line 117
Called from C:\..............\index.cfm: line 189
Called from C:\..............\index.cfm: line 1
Called from C:\..............\directory\act_search.cfm: line 172
Called from C:\..............\directory\index.cfm: line 117
Called from C:\..............\index.cfm: line 189
Called from C:\..............\index.cfm: line 1

170 : AND internet <> ' '
171 : </cfif>
172 : </cfif>
173 : ORDER BY organisation
174 : </cfquery>

SQL SELECT organisation, acronym, address, postal, phone, email, number,
internet FROM directory WHERE (record_type <> 'data' OR record_type <>'see
also' OR record_type <>'recreation') AND (1 = 2 OR organisation like '%%' OR
knownas like '%%' OR parent like '%%' OR acronym like '%%' ) AND organisation
not like '% see %' AND (ORGANISATION like '%form.key%' OR ACRONYM like
'%house%' OR KNOWNAS like '%house%' OR PARENT like '%house%' OR NAME like
'%house%' OR POSITION like '%house%' OR ADDRESS like '%house%' OR POSTAL like
'%house%' OR PHONE like '%house%' OR HOURS like '%house%' OR BRANCH like
'%house%' OR ELIGIBILITY like '%house%' OR ACCESS like '%house%' OR FEES like
'%house%' OR SUMMARY like '%house%' OR KEYWORD like '%house%' OR DESCRIPTION
like '%house%' OR TARGET like '%house%' OR AGE like '%house%' OR AREA like
'%house%' OR REGION like '%house%' OR INTERNET like '%house%' OR STATE like
'%house%' OR EMAIL like '%house%' OR AGENCIES_OF_ORG like '%house%' OR
SERVICE_METHOD like '%house%' OR NAME_OF_CEO like '%house%') ORDER BY
organisation
DATASOURCE directory
VENDORERRORCODE 1010
SQLSTATE HYC00
Please try the following:

* Check the ColdFusion documentation to verify that you are using the correct
syntax.
* Search the Knowledge Base to find a solution to your problem.

Browser Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.8.0.3)
Gecko/20060426 Firefox/1.5.0.3
Remote Address 10.0.0.80
Referrer <a target=_blank class=ftalternatingbarlinklarge
href="http://endevmx/index.cfm?fuseaction=enablenet.directory
Date/Time">[url]http://endevmx/index.cfm?fuseaction=enablenet.directory[/url]
Date/Time</a> 29-May-06 06:15 AM
Stack Trace
at
cfact_search2ecfm13250451.runPage(c:\............. ..............enablenet\direct
ory\act_search.cfm:172) at
cfindex2ecfm2049446227.runPage(c:\................ ...........enablenet\directory
\index.cfm:117) at
cfindex2ecfm1022555808._factor30(c:\.............. .............enablenet\index.c
fm:189) at
cfindex2ecfm1022555808.runPage(c:\................ ...........enablenet\index.cfm
:1) at
cfact_search2ecfm13250451.runPage(c:\............. ..............enablenet\direct
ory\act_search.cfm:172) at
cfindex2ecfm2049446227.runPage(c:\................ ...........enablenet\directory
\index.cfm:117) at
cfindex2ecfm1022555808._factor30(c:\.............. .............enablenet\index.c
fm:189) at
cfindex2ecfm1022555808.runPage(c:\................ ...........enablenet\index.cfm
:1)

java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC
Socket][Inmagic, Inc.][DB/Text ODBC Driver]Driver not capable
at macromedia.sequelink.ssp.Diagnostic.toSQLException (Unknown Source)
at macromedia.sequelink.ssp.Chain.cnvDiagnostics(Unkn own Source)
at macromedia.sequelink.ssp.Chain.decodeDiagnostic(Un known 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.fe tch(Unknown Source)
at macromedia.jdbc.sequelink.SequeLinkImplStatement.f etchBatch(Unknown Source)
at macromedia.jdbc.sequelink.SequeLinkImplStatement.f etchRow(Unknown Source)
at macromedia.jdbc.sequelink.SequeLinkImplResultSet.f etchAtPosition(Unknown
Source)
at macromedia.jdbc.slbase.BaseImplResultSet.next(Unkn own Source)
at macromedia.jdbc.slbase.BaseResultSet.next(Unknown Source)
at coldfusion.sql.QueryTable.populate(QueryTable.java :286)
at coldfusion.sql.QueryTable.populate(QueryTable.java :215)
at coldfusion.sql.Executive.getRowSet(Executive.java: 296)
at coldfusion.sql.Executive.executeQuery(Executive.ja va:705)
at coldfusion.sql.Executive.executeQuery(Executive.ja va:638)
at coldfusion.sql.Executive.executeQuery(Executive.ja va:599)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:236)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.j ava:498)
at
cfact_search2ecfm13250451.runPage(c:\............. ..............enablenet\direct
ory\act_search.cfm:172)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java :152)
at coldfusion.tagext.lang.IncludeTag.doStartTag(Inclu deTag.java:343)
at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.j ava:1908)
at
cfindex2ecfm2049446227.runPage(c:\................ ...........enablenet\directory
\index.cfm:117)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java :152)
at coldfusion.tagext.lang.IncludeTag.doStartTag(Inclu deTag.java:343)
at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.j ava:1908)
at
cfindex2ecfm1022555808._factor30(c:\.............. .............enablenet\index.c
fm:189)
at
cfindex2ecfm1022555808.runPage(c:\................ ...........enablenet\index.cfm
:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java :152)
at coldfusion.tagext.lang.IncludeTag.doStartTag(Inclu deTag.java:343)
at coldfusion.filter.CfincludeFilter.invoke(Cfinclude Filter.java:65)
at coldfusion.filter.ApplicationFilter.invoke(Applica tionFilter.java:210)
at coldfusion.filter.PathFilter.invoke(PathFilter.jav a:86)
at coldfusion.filter.LicenseFilter.invoke(LicenseFilt er.java:27)
at coldfusion.filter.ExceptionFilter.invoke(Exception Filter.java:50)
at coldfusion.filter.BrowserDebugFilter.invoke(Browse rDebugFilter.java:52)
at
coldfusion.filter.ClientScopePersistenceFilter.inv oke(ClientScopePersistenceFilt
er.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilt er.java:38)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilt er.java:38)
at coldfusion.filter.DatasourceFilter.invoke(Datasour ceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:105)
at coldfusion.bootstrap.BootstrapServlet.service(Boot strapServlet.java:78)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker. java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvok erChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequ estDispatcher.java:257)
at jrun.servlet.ServletEngineService.dispatch(Servlet EngineService.java:527)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable( JRunProxyService.java:204)
at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invok eRunnable(ThreadPool.java:349)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRu nnable(ThreadPool.java:457)
at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeR unnable(ThreadPool.java:295)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java :66)