Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Verify a connection programmatically
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00577460
Message ID:
00602848
Vues:
31
You can check the connection object for state > 0

>Vicky,
>
>Would ADBOBJECTS(laConNames, "CONNECTION") be helpful??? See ya at Tommy's after the game...
>
>-Justin
>
>
>>Here's the situation:
>>
>>I created a DSN to connect to a VFP Database through ODBC. I left the database field empty because I'm gonna use it in a connection string to make a connection in a VFP Database. (ya, ya... sounds strange to make a connection to connect to a VFP Database - due to circumstances beyond our control it has to be this way - it's a whole different topic in itself.)
>>
>>The problem that I'm having is that when I run GenDBC to create the database everything runs perfect. The tables are created. Keys are generated. Even the connection is created using the connection string... However, when it comes time to make the Remote Views I get an error 1526 (connectivity error). When we step through the code and verify the connection the remote view are created successfully and everyone is happy.
>>
>>The solution is that we have to verify the connection but we can't have any interface while doing this. Verification has to be done programmatically.
>>
>>Does anyone know how to do this??? Any help would be appreciated.
Imagination is more important than knowledge
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform