Connecting from SQL Server 2000 to FoxPro 2.6 tables

[davidy]

i'm trying to make a Stored Procedures that updates some foxpro tables. But i can't get the connection to work this is wath i tryed in the SQL Query Analyzer for test:

select * from openrowset('MSDASQL',
'Driver=Microsoft Visual FoxPro Driver;
SourceDB=k:\dev-test\1\order04.dbf\support\;
SourceType=DBF',
'select * from country.dbf')

And after 15 minutes of waiting still no result.
The message is that he is still "Executing query batch".
Its a table of 45 records i don't think that that should take solong.

Does anyone know whats wrong?

Thanx in advance

 

[JBaileys]

I would begin by suggesting dropping foxpro

Are you able to create ODBC connections to both databases using a DSN?
With odbc it should give you the ability to create your stored proc.