March 31, 2009 at 10:26 am
Intermittent error running SQL 2005 and have a linked server to Foxpro DBF files on a different physical serve.
The ODBC was set up to use the Free Tables option.
I read the data from an older Foxpro application as views in SQL. Everything works fine. Except intermittently the view say that the .net SqlClient data Provider cannot execute the select statement.
If I run …
EXEC master.dbo.sp_serveroption @server=N'Foxpro_QUA', @optname=N'query timeout', @optvalue=N'1000'
to reset the delay back to itself it works again.
The time between failures appears to be random.
March 31, 2009 at 10:33 am
Just a shot in the dark, but I wonder if the DBF is locked by another session. This might explain the intermittent nature of the problem.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 31, 2009 at 11:25 am
I thought about that. But if thats the case when the lock must encompass multiple tables and once it is released I should be able to access the data again.
However, once I get the error the only way to see any of the tables is to run the sp_serveroption statement again.
The error message is 7320
It says the Foxpro dbf file does not exist. It does exist and as soon as I run the sp_serveroption it shows up again.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply