>I have tried the following, but get "Invalid Subscript Reference"
>
>

>lnConId = SQLSTRINGCONNECT("myconstring",.T.)
>use <rv> CONNSTRING SQLGETPROP(lnConId,"ODBChdbc")
>

Hi Aaron,

If you want to share ODBC connection between multiple views then, for each additional remote view, you need to obtain new connection handle by calling SQLCONNECT.

lnConId1 = SQLSTRINGCONNECT("myconstring",.T.)
use <rv1> CONNSTRING lnConId1
lnConId2 = SQLCONNECT(lnConId1)
use <rv2> CONNSTRING lnConId2

Thanks,
Aleksey.