Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connection cannot see the updated structure
Message
From
05/01/2007 05:43:23
Alexandre Palma
Harms Software, Inc.
Alverca, Portugal
 
 
To
04/01/2007 23:46:58
General information
Forum:
ASP.NET
Category:
Databases
Environment versions
Environment:
VB 8.0
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01182633
Message ID:
01182703
Views:
16
Michel are you closing all the tables at the end of your request?
That looks like a caching issue since now you keep ur connection always open the resources never gets released is jut like if you had the application always running, My 1st tought was that you may have access the tale with a select statment and never closed, but if that was the case then you should not be able to modify the structure of the table.

>Here is an interesting situation with the VFPOleDB data provider. Now, I am using it in a global mode, which means that I create the connection at startup and use that connection for any SQL request. This works well and it also provides an increase of performance. If I go in VFP and update the structure of one of the table in the directory and issue another request to the Web site, the application cannot see the updated structure. I had to IISRESET /RESTART in order for the application to see the update. Is this normal?
Alexandre Palma
Senior Application Architect
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform