>We don't use Remote Views and Connections. We use SQLCONNECT to assign the ODBC driver e.g.
>
>lnResult=SQLCONNECT(lcODBCConnection,lcUserID,lcPassword)
>
>lcODBCConnection is the name of the SystemDSN setup in the ODBC control panel. Is there a way to do what you've shown under this environment?
You should be able to use SQLSETPROP() instead of DBSETPROP(). Use 0 (zero) as the connection handle and set the parameters before you do the SQLCONNECT(). This set's parameters for the VFP environment - which will then apply to all new connections.
By the way, you can use a Connection without using Views.