General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Hi all
>
>I just want to know which is better, if that is the case, Connection in a DBC or directly the ODBC DSN?
>
>Please advise.
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).
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only