Error Message Says File Doesn't Exist...

hello. i'm trying install cf website on same server asp website , running. both sites access same foxpro data, may lead conflicts i'll have work around, first there's problem have solve: when try sql select statement, i'm being told error message table want not exist, false. specifically, both asp site , own site use same odbc connection, specifies visual foxpro driver , path foxpro tables (which need foxpro tables through odbc).

it might appear should have connection of own different name, seems unlikely because have, in fact, set separate connection in odbc, different dsn (obviously), , pointing entirely different directory have placed clones of foxpro tables want access. , did not forget change dsn name appropriately in sql select statement. nonetheless, receive same error message in situation. full error message provided after double lines below.

i should mention have pointed coldfusion adminstrator both odbc connections (both 1 used asp site , 1 used clone tables), , have clicked verify connections button, , received response of 'ok' both of them.

i should mention site (including odbc access clones of same foxpro tables) works fine on desktop pc @ home, , on laptop.

it occurs me write foxpro installed on same directory 1 accessed via odbc asp site, understanding that should not matter. allegedly, need odbc driver. come think of it, foxpro on different directory tables on pc @ home , on laptop.

another point think should not matter asp site , own are, in sense, same site. different people use them, , there no transportation 1 other, both accessed same root url until such time company manager decides separate domain name mine. concrete, asp site in 'inetpub\wwwroot\acrc' directory while mine in 'inetpub\wwwroot\reporters'. both subdirectories of default web site in iis, inetpub\wwwroot, accessible domain name 'acrga2.com'. understanding things should work if asp dnd cfm pages were intermixed in same directory.

any suggestions?

=================== full error message below ================

error executing database query.
[macromedia][sequelink jdbc driver][odbc socket][microsoft][odbc visual foxpro driver]file 'joblog.dbf' not exist.

the error occurred in c:\inetpub\wwwroot\reporters\listjobs.cfm: line 6

4 : <cfquery name='jobs' datasource='acrdb' debug>
5 : select job_no, job_date, job_time, am_pm, caller_
6 : joblog reporter_='#ucase(session.username)#' , year(bill_date) < 2000 , year(date_chg) < 2000
7 : </cfquery>
8 :

sqlstate 42s02
sql select job_no, job_date, job_time, am_pm, caller_ joblog reporter_='mmm' , year(bill_date) < 2000 , year(date_chg) < 2000
vendorerrorcode 173
datasource acrdb
resources:

* check coldfusion documentation verify using correct syntax.
* search knowledge base find solution problem.

browser mozilla/5.0 (windows; u; windows nt 5.0; en-us; rv:1.8.1.12) gecko/20080201 firefox/2.0.0.12
remote address 127.0.0.1
referrer http://localhost/reporters/reporterlogin.cfm
date/time 07-mar-08 12:23 pm
stack trace
at cflistjobs2ecfm1841761115.runpage(c:\inetpub\wwwroot\reporters\listjobs.cfm:6) @ cflistjobs2ecfm1841761115.runpage(c:\inetpub\wwwroot\reporters\listjobs.cfm:6)

java.sql.sqlexception: [macromedia][sequelink jdbc driver][odbc socket][microsoft][odbc visual foxpro driver]file 'joblog.dbf' not exist.
@ macromedia.sequelink.ssp.diagnostic.tosqlexception(unknown source)
@ macromedia.sequelink.ssp.chain.cnvdiagnostics(unknown source)
@ macromedia.sequelink.ssp.chain.decodediagnostic(unknown source)
@ macromedia.sequelink.ssp.chain.decodebody(unknown source)
@ macromedia.sequelink.ssp.chain.decode(unknown source)
@ macromedia.sequelink.ssp.chain.send(unknown source)
@ macromedia.sequelink.ctxt.stmt.statementcontext.execdirect(unknown source)
@ macromedia.jdbc.sequelink.sequelinkimplstatement.execute(unknown source)
@ macromedia.jdbc.slbase.basestatement.commonexecute(unknown source)
@ macromedia.jdbc.slbase.basestatement.executeinternal(unknown source)
@ macromedia.jdbc.slbase.basestatement.execute(unknown source)
@ coldfusion.server.j2ee.sql.jrunstatement.execute(jrunstatement.java:254)
@ coldfusion.sql.executive.executequery(executive.java:1196)
@ coldfusion.sql.executive.executequery(executive.java:1008)
@ coldfusion.sql.executive.executequery(executive.java:939)
@ coldfusion.sql.sqlimpl.execute(sqlimpl.java:325)
@ coldfusion.tagext.sql.querytag.executequery(querytag.java:831)
@ coldfusion.tagext.sql.querytag.doendtag(querytag.java:521)
@ cflistjobs2ecfm1841761115.runpage(c:\inetpub\wwwroot\reporters\listjobs.cfm:6)
@ coldfusion.runtime.cfjsppage.invoke(cfjsppage.java:192)
@ coldfusion.tagext.lang.includetag.dostarttag(includetag.java:366)
@ coldfusion.filter.cfincludefilter.invoke(cfincludefilter.java:65)
@ coldfusion.filter.applicationfilter.invoke(applicationfilter.java:279)
@ coldfusion.filter.requestmonitorfilter.invoke(requestmonitorfilter.java:48)
@ coldfusion.filter.monitoringfilter.invoke(monitoringfilter.java:40)
@ coldfusion.filter.pathfilter.invoke(pathfilter.java:86)
@ coldfusion.filter.exceptionfilter.invoke(exceptionfilter.java:70)
@ coldfusion.filter.clientscopepersistencefilter.invoke(clientscopepersistencefilter.java:2 8)
@ coldfusion.filter.browserfilter.invoke(browserfilter.java:38)
@ coldfusion.filter.nocachefilter.invoke(nocachefilter.java:46)
@ coldfusion.filter.globalsfilter.invoke(globalsfilter.java:38)
@ coldfusion.filter.datasourcefilter.invoke(datasourcefilter.java:22)
@ coldfusion.cfmservlet.service(cfmservlet.java:175)
@ coldfusion.bootstrap.bootstrapservlet.service(bootstrapservlet.java:89)
@ jrun.servlet.filterchain.dofilter(filterchain.java:86)
@ coldfusion.monitor.event.monitoringservletfilter.dofilter(monitoringservletfilter.java:42 )
@ coldfusion.bootstrap.bootstrapfilter.dofilter(bootstrapfilter.java:46)
@ jrun.servlet.filterchain.dofilter(filterchain.java:94)
@ jrun.servlet.filterchain.service(filterchain.java:101)
@ jrun.servlet.servletinvoker.invoke(servletinvoker.java:106)
@ jrun.servlet.jruninvokerchain.invokenext(jruninvokerchain.java:42)
@ jrun.servlet.jrunrequestdispatcher.invoke(jrunrequestdispatcher.java:284)
@ jrun.servlet.servletengineservice.dispatch(servletengineservice.java:543)
@ jrun.servlet.jrpp.jrunproxyservice.invokerunnable(jrunproxyservice.java:203)
@ jrunx.scheduler.threadpool$downstreammetrics.invokerunnable(threadpool.java:320)
@ jrunx.scheduler.threadpool$threadthrottle.invokerunnable(threadpool.java:428)
@ jrunx.scheduler.threadpool$upstreammetrics.invokerunnable(threadpool.java:266)
@ jrunx.scheduler.workerthread.run(workerthread.java:66)

i have discovered site work when it's accessed outside using full url, www.acrga2.com/reporters/reporterlogin.cfm.

nonetheless, understanding of technology know why not access directly server. after all, whole thing developed working localhost on single pc. not able access server installed on, neither localhost nor full url, www.acrga2.com/reporters/reporterlogin.cfm.

or rather, more accurately, access site, not connect foxpro database via odbc within site.

i realize arcane issue - few people outside of old codgers me still program in foxpro - interesting know why occurs. ideas anyone?

anyway, worried. client not pleased. he's happy again. whew!

More discussions in Database Access

adobe