Yes, Forrest, it's working now. I went in to my client's office this afternoon and fixed the typo I mentioned, which was the only thing still standing in the way. However the question remains why it did not work from the server itself. After all, the whole thing was developed working as localhost on a single PC.
When I'm back in the client's place again (some time next week - maybe Tuesday, maybe Thursday), I'll try Steven's solution (He wrote: 'Could be an issue with you using host headers... if you have host headers on you should edit your hosts file to point to localhost...'). But, Steven, what's the hosts file, and how do I edit it? For what it's worth, note that accessing the site from the server, I got the error BOTH when accessing it as localhost AND when accessing it with the full url www.acrga2.com/Reporters/ReporterLogin.cfm. -----Original Message----- >From: "Forrest C. Gilmore" <[EMAIL PROTECTED]> >Sent: Mar 8, 2008 3:38 PM >To: [email protected] >Subject: Re: [ACFUG Discuss] Strange Error > >When I went to this site, it seemed to work fine! Even followed a >"Details" link, whick also worked. > >Come to think of it: you can even go there and see the error for yourself. Go >to www.acrga2.com/Reporters/ReporterLogin.cfm, and enter 'mmm' as user id, and >'1598' as password. > >Forrest C. Gilmore >====================== >Peyton Todd wrote: >> Hello all. I have just attempted to install what I'm calling the beta >> version of my new website on my client's server, and when it tries to do an >> SQL select on a FoxPro data file, CF reports that the file does not exist, >> when in fact it does exist. The full error message can be found below the >> double lines later in this e-mail, after I provide a detailed explanation of >> the context. >> >> A complicating factor down the road, which should not matter yet as far as I >> can see, is that the same FoxPro tables will be accessed by an ASP website >> on the same server. This ASP site has been running for a couple of years >> now, and has been accessing the FoxPro data successfully the whole time. My >> own website that I just wrote has no problem accessing clones of the same >> FoxPro tables, both on my desktop PC at home, and on my laptop. In the >> future these two websites could step on each other's toes, and if that >> happens I plan to program FoxPro to write records to separate tables that >> only my site will access each time one of the two tables of interest is >> updated. For now, though, the presence of the other website SHOULD not be a >> problem as far as I understand it because: >> >> I get the same error message even when the other site is stopped, by which I >> mean that the COM object it utilizes to get the FoxPro data has not been >> loaded into memory: my testing this morning occurred after a cold boot, with >> that COM object not loaded at all. Furthermore, I put clones of the two >> FoxPro tables of interest in a separate directory, right on the C drive >> where the websites reside, and I pointed my DSN in ODBC to that location, >> specifying the Visual FoxPro driver (the data are in FoxPro for DOS, but the >> Visual FoxPro Driver is the one to use - in fact, the only one available). >> This DSN is distinct from the one used by the ASP site, and I made sure that >> my cfqueries mention this DSN and not the one used by the other site. I also >> made this DSN known to the ColdFusion Administrator, clicked the Verify All >> Connections button, and received an OK in response for all DSNs in the >> system. >> >> The only other DSN used by my site is one to SQL Server, where in fact most >> of the data used by my site reside, including the user login table. My login >> page, Login.cfm, comes up fine in the browser. It rejects bad passwords, and >> accepts good ones, which it could not do without accessing the SQL Server >> data correctly. With a good password, it moves on to the next page where it >> must list jobs from FoxPro (this is a court reporting company), and that's >> where it bombs. >> >> The only other connection to the ASP site is that both sites will be >> accessed by the same root url until such time as the owner of the company >> decides to get a separate domain name for mine, if he does. To be concrete, >> the ASP site is in the 'Inetpub\wwwroot\acrc' directory while mine is in >> 'Inetpub\wwwroot\Reporters'. Both are subdirectories of the Default web site >> in IIS, which is Inetpub\wwwroot, accessible by the domain name >> 'acrga2.com'. (It is my understanding that things should work even if the >> ASP dnd CFM pages were were intermixed in the same directory.) >> >> Come to think of it: you can even go there and see the error for yourself. >> Go to www.acrga2.com/Reporters/ReporterLogin.cfm, and enter 'mmm' as user >> id, and '1598' as password. >> >> Another point: FoxPro itself is installed on the same directory as the one >> accessed via ODBC by the ASP site, but that should not matter. Allegedly, >> all you need is the ODBC driver. Come to think of it, FoxPro is also on a >> different directory from the FoxPro tables on my PC at home and on my >> laptop, and as I said, those are working fine. >> >> Any suggestions? >> >> =================== FULL ERROR MESSAGE BELOW ================ >> >> Error Executing Database Query. >> [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Visual >> FoxPro Driver]File 'joblog.dbf' does 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 : from joblog where reporter_='#Ucase(Session.UserName)#' and >> Year(bill_date) < 2000 and Year(date_chg) < 2000 >> 7 : </cfquery> >> 8 : >> >> SQLSTATE 42S02 >> SQL select job_no, job_date, job_time, am_pm, caller_ from joblog where >> reporter_='MMM' and Year(bill_date) < 2000 and Year(date_chg) < 2000 >> VENDORERRORCODE 173 >> DATASOURCE ACRDB >> Resources: >> >> * 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.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) >> at >> 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' does not >> exist. >> 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.execDirect(Unknown Source) >> at macromedia.jdbc.sequelink.SequeLinkImplStatement.execute(Unknown Source) >> at macromedia.jdbc.slbase.BaseStatement.commonExecute(Unknown Source) >> at macromedia.jdbc.slbase.BaseStatement.executeInternal(Unknown Source) >> at macromedia.jdbc.slbase.BaseStatement.execute(Unknown Source) >> at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:254) >> at coldfusion.sql.Executive.executeQuery(Executive.java:1196) >> at coldfusion.sql.Executive.executeQuery(Executive.java:1008) >> at coldfusion.sql.Executive.executeQuery(Executive.java:939) >> at coldfusion.sql.SqlImpl.execute(SqlImpl.java:325) >> at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831) >> at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521) >> at >> cfListJobs2ecfm1841761115.runPage(C:\Inetpub\wwwroot\Reporters\ListJobs.cfm:6) >> at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192) >> at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366) >> at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) >> at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279) >> at >> coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) >> at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) >> at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) >> at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) >> at >> coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) >> at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) >> at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) >> at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) >> at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) >> at coldfusion.CfmServlet.service(CfmServlet.java:175) >> at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) >> at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) >> at >> coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) >> at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) >> at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) >> at jrun.servlet.FilterChain.service(FilterChain.java:101) >> at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) >> at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) >> at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:284) >> at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) >> at >> jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) >> at >> jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) >> at >> jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) >> at >> jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) >> at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) >> >> >> >> >> ------------------------------------------------------------- >> Annual Sponsor FigLeaf Software - http://www.figleaf.com >> >> To unsubscribe from this list, manage your profile @ >> http://www.acfug.org?fa=login.edituserform >> >> For more info, see http://www.acfug.org/mailinglists >> Archive @ http://www.mail-archive.com/discussion%40acfug.org/ >> List hosted by http://www.fusionlink.com >> ------------------------------------------------------------- >> >> >> >> >> >> > > > > > >------------------------------------------------------------- >Annual Sponsor FigLeaf Software - http://www.figleaf.com > >To unsubscribe from this list, manage your profile @ >http://www.acfug.org?fa=login.edituserform > >For more info, see http://www.acfug.org/mailinglists >Archive @ http://www.mail-archive.com/discussion%40acfug.org/ >List hosted by http://www.fusionlink.com >------------------------------------------------------------- > > > ------------------------------------------------------------- Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
