Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
redlam
Starting Member
7 Posts |
 Posted - 2003-08-06 : 19:49:00
|
| Hi there.I am using an OpenRowSet query to access Foxpro tables from SQL Server. The problem is once the query has completed and the query window is closed, the lock from the OpenRowSet connection is not released. The only way to release it is to stop and restart the SQL Service. Has anyone else experienced this before? Is there a better way to release the locks on these files after the query has completed?Thanks for the help. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-06 : 19:55:58
|
| That sounds like a bug. Which version of SQL Server are you using and what service pack has been installed? Do you have the correct driver installed for Foxpro? Maybe you should run a COMMIT after your query. Just an idea.Tara |
 |
|
|
redlam
Starting Member
7 Posts |
Posted - 2003-08-06 : 20:05:45
|
| Hi Tara.I am using SQL Server 2000 SP3 and I believe the Foxpro driver is correct. I'll test your theory on committing...Thanks. |
|
|
|
|
|
|
OpenRowSet query holds lock on Foxpro tables