ODBC Connections and ColdFusion

I have installed the ODBC of eDirectory, and I can query from it fine 
using Crystal Reports or using Visual Basic .net. But I am currently 
working in ColdFusion, and I have set up a ColdFusion datasource that 
links to the ODBC that has been set up on the server (my local machine at 
this point) and everytime I try and run a query using cold fusion it 
errors out saying that 

"[Macromedia][SequeLink JDBC Driver][ODBC Socket][Novell][ODBC Driver For 
eDirectory] Driver not capable 

 : SELECT CN, "Internet EMail Address", NDS_Context FROM UserNDS
 

--------------------------------------------------------------------------
------
 
SQL        SELECT CN, "Internet EMail Address", NDS_Context FROM
UserNDS  
DATASOURCE         Novell 
VENDORERRORCODE   1010 
SQLSTATE          HYC00 
"

I belive that it is connecting to the database, because if I change a 
column to a name that doesn't exist it give me an error saying that the 
column doesn't exist. THerefore I am thinking that this is somekind of a 
permissions error. As a result I have changed four services to Launch 
under my username and password. These four services are COld Fusion 
services. This hasn't solved the problem either. I am looking for any 
suggestions as to a way to get this querying working using COldFusion MX 
7. Thank you,

Devin

Hi

Can you turn on traing in the odbc data source administrator, then run the
application until it gets the not capable error and then send sql.log file
to me?

Thanks
Susan

Thank you for responding. I am assuming that you mean the tracing below.
Please correct me if I am wrong.  Here is the trace information that I
recieve when the error occurs:




java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC
Socket][Novell][ODBC Driver For eDirectory] Driver not capable
	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:286)
	at coldfusion.sql.QueryTable.populate(QueryTable.java:215)
	at coldfusion.sql.Executive.getRowSet(Executive.java:296)
	at coldfusion.sql.Executive.executeQuery(Executive.java:705)
	at coldfusion.sql.Executive.executeQuery(Executive.java:638)
	at coldfusion.sql.Executive.executeQuery(Executive.java:599)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:236)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:498)
	at
cftestNovell2ecfm21497257.runPage(C:InetpubwwwrootAllUserstestNovell.cfm:11)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:343)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:210)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:50)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
	at
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilt
er.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.CfmServlet.service(CfmServlet.java:105)
	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:257)
	at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
	at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204)
	at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:349)

	at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:457)
	at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:295)
	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)


I appreciate the help.

Devin

Susan Perrin wrote:

> Hi

> Can you turn on traing in the odbc data source administrator, then run the
> application until it gets the not capable error and then send sql.log file
> to me?

> Thanks
> Susan

Just looked at my message "traing"... sorry!

What I meant to say is tracing from the data source administrator.  Run
start/programs/Novell ODBC Driver for NDS/Data Source Administrator  or run
control panel/Administrative tools/Data Sources (odbc).  When the data
source administrator is running, select the "Tracing" tab.  Select
"Start
Tracing Now".  Run your application and let it fail.  Then select
"Stop
Tracing Now".  You should then see a sql.log file on the root directory.
Post that here or send to me at sperrin at novell.com


Thank you
Susan