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. ______________________________________________________________________ Get Your Own Dedicated Windows 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=coldfusionb 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
