Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Connection cannot see the updated structure
Message
De
05/01/2007 05:43:23
Alexandre Palma
Harms Software, Inc.
Alverca, Portugal
 
 
À
04/01/2007 23:46:58
Information générale
Forum:
ASP.NET
Catégorie:
Bases de données
Versions des environnements
Environment:
VB 8.0
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01182633
Message ID:
01182703
Vues:
17
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform