Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ASP.NET locks files
Message
From
13/05/2006 09:48:44
 
 
To
13/05/2006 01:26:54
General information
Forum:
ASP.NET
Category:
Databases
Environment versions
Environment:
VB 8.0
Miscellaneous
Thread ID:
01121566
Message ID:
01121640
Views:
13
>The data adapter object goes out of scope on each request. So, this should not be a factor.<

But does the connection object go out of scope too?

~~Bonnie


>>I haven't used DBF tables in our .NET app, so this may or may not have anything to do with it ... but I'm wondering if your app is keeping the connections open? You should only be connected to your database as briefly as possible. IOW, open the connection, grab the data, close the connection and then do stuff with your data. When you're ready to update the database, open the connection, update the database, close the connection. Are you doing it this way?
>
Bonnie Berent DeWitt
NET/C# MVP since 2003

http://geek-goddess-bonnie.blogspot.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform