Foxpro access in Coldfusion 7

[mike42780]

With Coldfusion 5-6.1 we were accessing are old Foxpro 2.6 databases through
ODBC using the Visual Foxpro Drivers. There wasn't any major problems. After
upgrading to CF7 there have been some problems. I get the following error
trying to access a table:

[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Visual FoxPro
Driver]File '*.dbf' does not exist.

The weird thing is, in the CF administrator I can still verify the foxpro DSN
just fine and is says "OK" with no error messages at all.

To get access to the foxpro tables we had to change the CF services to log on
as a domain admin. I made sure the CF 7 services were logging in as the same
domain admin.

Has anyone else had similar issues or know of any fixes? Thanks.

[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Visual FoxPro
Driver]File '*.dbf' does not exist.

[mike42780]

I tried linking the foxpro tables in access and then creating a Access DSN in
Coldfusion. I can see the linked tables when i'm in access just fine, but when
i try to call the table in Coldfusion I get a similar error.

It says "Could not execute query; could not find linked table."

Can anyone help? This problem is only happening in CF 7. In CF 6.1 I am able
to access the tables without a problem.

[mike42780]

anyone?

[HenryA1]

Mike, I do not have an answer, but just to let you know you are not alone. Same thing here. Oh well, back to mx 6.

[mike42780]

Thanks Henry. We have Coldfusion 6 on production and 7 on development. Until this is resolved we'll be staying on 6 as well. Or hopefully someday we'll get rid of the Foxpro databases!

[mike42780]

I have figured out that if my foxpro tables are stored locally, it actually
does work. Our foxpro files are located on a network share though and that
still doesn't work at all. Does anyone know what permissions to set on the
share to get it to work? I'm assuming it's a permissions issue, but i can't
say for sure.

[Mike40]

Mike,

Have you discovered the solution to the FoxPro issue? We're having big time problems with the same error you are getting and are making no progress.

Thanks,
Mike L

[mike42780]

Mike L,

Sorry, nothing to report yet. I have tried a lot of different things, but
nothing is helping. I'll be sure to post a solution if i ever find one. If
you ever find a solution, please post it as well. I'd be very interested in
knowing what is wrong.

Mike