>I have a DBC that I inherited with many views. Currently the DBC has a connection CONN01 that is bound to a DSN.
>
>I would like to change the connection to a Connection String type where I can define the connection string as a global variable (g_cConnString). The global vairable will be set from a login form.
>
>I have not been able to make this work. Is it feasible? If so, what does the connection string value look like?
>
>Thanks, Bob
You can define a connection in the dbc and then use
DBGETPROP('MyConnection','Connection','ConnectString')
to see what the connection string looks like.
you can then use a string of similar construct with SQLSTRINGCONNECT()
Erik Moore
Clientelligence