Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DSN-Less Connection in DBC
Message
From
16/11/1998 12:49:51
 
 
To
16/11/1998 10:40:21
Robert Byrd
National Association of Homebuilders
Washington, District of Columbia, United States
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00157835
Message ID:
00157886
Views:
22
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform