fox pro DSN not working with CF 7

[dwd1]

I am trying to access a foxpro 5 database in order to migrate its data into sql
server 2000 usign coldfusion.

i created a system DSN on the CF server pointing to the folder containing all
the dbf files and then created a CF DSN (ODBC) using the system DSN. the CF
DSN verifies and seems ok.

but then i created a template with the followign query:
<cfquery name="foxlogs" datasource="foxLogs_inpat">
select *
FROM zipcode.DBF
</cfquery>

and when i run it i get the followign error:
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Visual FoxPro
Driver]File 'zipcode.dbf' does not exist.

but i know that zipcode.dbf DEFINITELY does exist.

what can i do to make this work?

[philh]

Why don't you just write a DTS package in SQL 2K? Using CF for this adds an
unnecessary layer of complexity.

That said, is your system DSN free-table? I believe the VFP driver defaults
to DBC-style.

[dwd1]

hey thanks for the reply. yeah i thought of DTS shortly after i posted this
and have since been workign on using DTS. but there will still be a need in
the future to access foxpro dbf files directly. my system DSN is set to free
table.

[BretHobbs]

If your DSN is truly pointing to a free table directory.
Then ensure that the ZipCode.dbf is included in the directory.

The cfquery should look like:

<cfquery name="foxlogs" datasource="foxlogs_inpat" dbtype="ODBC">
select * from zipcode
</cfquery>

Let me know if adding the ODBC and removing the .dbf does the trick.

[MickBW]

I am having a similar problem when trying to view a page with a query to a
FoxPro Database (in this case it is a VFP8 DB.

I changed my query to your suggested format:
<cfquery name="ViewError" datasource="Foxy" dbtype="ODBC">
Select * from apps
</cfquery>
The table apps is definitely there and viewable but not currently in use.

The ColdFusion Connection updates without a problem though it requires a
username to be passed.

I receive the same message:
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Visual FoxPro
Driver]Not a table.

Other information from the debug is:
SQL Select * from apps
DATASOURCE Foxy
VENDORERRORCODE 123
SQLSTATE 42S02

[mike42780]

Was anyone able to figure out a fix for this? I'm having the same problem with
Foxpro 2.6. I tried the dbtype="ODBC", but didn't help. I'm using free table
directory to access the tables. The same code works fine in Coldfusion 6.

Info from error:
VENDORERRORCODE 173
SQLSTATE 42S02