I copied one of the tables that i needed to query to the local cf server and this time the CF server was able to read the table.
Thanks for your help. Andres -----Original Message----- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 12:20 PM To: CF-Talk Subject: RE: Accessing FoxPro database IIRC you can't access a datasource on another drive. Perhaps you could try copying the file to a local location with CFFile and then try querying it. I know that for some of the Excel stuff I've worked on in the past we had a "placeholder" spreadsheet that the DSN pointed to. When we did a data import we would rename the placeholder, copy the file into the proper location with the right name so the DSN would see it and then once things were done, delete the file and rename the placeholder back to the right name. Lot of effort but it worked. Hatton > -----Original Message----- > From: Andres [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 19, 2002 12:15 PM > To: CF-Talk > Subject: Accessing FoxPro database > > > Hello All, > I am trying to access a foxpro database. This database is stored in > server A, while the Cold Fusion and web server is located in server B. > Server B has all the odbc connections set to read and access the foxpro > files in server A. > > When i try to run the following query i get an error: > > <cfquery datasource="foxprodsn" name="getsodata" debug> > SELECT custno FROM S:\pro50\ARDATA\arcust10.dbf > </cfquery> > > This is the error i get: > > ODBC Error Code = S0002 (Base table not found) > [Microsoft][ODBC Visual FoxPro Driver]File 'arcust10.dbf' does not > exist. > > The error occurred while processing an element with a general identifier > of (CFQUERY), occupying document position (9:1) to (9:56). > > I've also tried these other ways: > SELECT custno FROM 'S:\pro50\ARDATA\arcust10.dbf' > and... > SELECT custno FROM arcust10.dbf > and... > SELECT custno FROM 'arcust10.dbf' > and... > SELECT custno FROM arcust10 > and... > SELECT custno FROM 'arcust10' > > I've also made sure the table DOES EXIST... and that i have access to > this mapped drive (s drive). I have also ensured that the odbc settings > point to the right location. > > Any ideas will be most appreciated. > > ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
