[ACFUG Discuss] Strange Error
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 : 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 : 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][Mi
[ACFUG Discuss] Erratum
Re-reading what I just sent, I notice that I called my login page Login.cfm. Sorry. It's name is ReporterLogin.cfm. What confused me is that the other site's login page in Login.asp. Doesn't matter, but just for the record so to speak. - 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 -
[ACFUG Discuss] Wierder still...
I just tried the site from home, where I am now, and it got past where it was bombing. It hit another bomb - due to a typo I'm about to go in to work to fix - but why should it work over the web from outside the office when it doesn't work from the server itself (both localhost and keying in the full acrga2.com/Reporters/ReporterLogin.cfm url)? - 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 -
Re: [ACFUG Discuss] Wierder still...
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... On Sat, Mar 8, 2008 at 12:20 PM, Peyton Todd <[EMAIL PROTECTED]> wrote: > I just tried the site from home, where I am now, and it got past where it > was bombing. It hit another bomb - due to a typo I'm about to go in to work > to fix - but why should it work over the web from outside the office when it > doesn't work from the server itself (both localhost and keying in the full > acrga2.com/Reporters/ReporterLogin.cfm url)? > > > - > 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 > - > > > > -- Steven Ross web application & interface developer http://blog.stevensross.com [mobile] 404-488-4364 [fax] 267-482-4364 [ AIM / Yahoo! : zeriumsteven ] [googleTalk : nowhiding ] - 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 -
Re: [ACFUG Discuss] Strange Error
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. Can you verify the Foxpro datasource from the ColdFusion Administrator interface? One of the buttons out to the left of the datasource name verifies the datasource. -- Howard Fore, [EMAIL PROTECTED] - 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 -
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 : 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 : 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 R
Re: [ACFUG Discuss] Strange Error
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: discussion@acfug.org >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