>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).