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