Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

OpenRowSet maintains connection after query complete

Status
Not open for further replies.
redlam

redlam

MIS
Jun 28, 2000
218
US
Hi.
I am using OpenRowSet to query a Foxpro database from SQL. The query works fine, however, SQL maintains a connection to the file long after the query completes and the query window is closed. The only way to release the connection is to stop the SQL Service. This is a problem because other users need to be able to copy, move and delete these Foxpro tables after the query is complete. Has anyone seen this before? If so, is there a better solution to release the connection other than stopping the service?
Thanks for your help.
 
Sort by date Sort by votes
Have you tried turning off the connection pooling setting in ODBC for FoxPro??

Just an idea, I have never seen this before...
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question
Error in Select query
Replies
14
Views
280
Andrzejek
Andrzejek
WomanPro
  • Locked
  • Question
Insert into query adds records to unreadable format, how do I change that? 1
Replies
5
Views
231
Chris Miller
Chris Miller
Auguy
  • Locked
  • Question
Connection String in .NET program Config File 2
Replies
10
Views
258
Auguy
Auguy
ahmedsa2018
  • Locked
  • Question
How to enhance query to run faster ?
Replies
0
Views
98
ahmedsa2018
ahmedsa2018
ahmedsa19051985
  • Locked
  • Question
After adding Feature Name and Feature Value query takes more than 5 minutes
Replies
4
Views
117
TamarGranor
TamarGranor

Part and Inventory Search

Sponsor

Back
Top