We are querying foxpro 2.6 tables o

[dracos2]

We are querying foxpro 2.6 tables on a netware 5.0 server from a SQL 7.0 server this did work. Because this is a monthly job so it is hard to say why this quit working. We can access the files from the SQL server from the explorer. To the best of our knowledge all users that are in use for the process have the necessary rights


query that is being run++++++++

select * from openrowset('MSDASQL','Driver=Microsoft Visual FoxPro Driver;SourceDB=\\fs1\v2\database;SourceType=DBF',
'select * from bbImport where Status=0')

++++++output message++++++

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [Microsoft][ODBC Visual FoxPro Driver]File 'bbimport.dbf' does not exist.]

TIA
Todd Jones

 

[jhall156]

Is there a .CDX file associated with the table? I have seen it happen that when an index or table header gets damaged foxpro will tell you that it's not a table.

Have you considered making it a Linked Server? I started out with nothing, and I still have most of it.

 

[1Husker]

I have a similiar problem. I have successfully linked FoxPro tables however whenver I run the following select...

select *
from Fox_link.h:\Data.NULL.table

When I run this I get the following error

Incorrect syntax near 'h:'.