Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Best Practice- Use Connections in DBC or ODBC
Message
 
To
24/11/2004 06:34:44
Dorin Vasilescu
ALL Trans Romania
Arad, Romania
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6 SP5
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00964163
Message ID:
00964235
Views:
7
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
___________________________________________
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform