Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Best Practice- Use Connections in DBC or ODBC
Message
 
À
24/11/2004 06:34:44
Dorin Vasilescu
ALL Trans Romania
Arad, Roumanie
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 6 SP5
Database:
Visual FoxPro
Divers
Thread ID:
00964163
Message ID:
00964235
Vues:
6
Hi Dorin

>I prefer ODBC DSN because you can:
>SQLCONNECT('{ODBC_DSN}',oApp.cUserId, oApp.cPassword)
>or
>SQLSTRINGCONNECT('DSN={ODBC_DSN};'+other connection clauses)
>
>and saving password in DBC or registry is not needed.
>
>But you will need a connection in DBC if you are using remote views (I don't know if VFP6 has CONNSTRING clause in USE command).

Actually I too don't use connection in the views DBC and define the Views using the DSN, but it somehow does store a record internally though I guess.

Thanks, I just wanted to clear the doubt.
Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
___________________________________________
venussoftop@gmail.com
___________________________________________
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform