Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connection Handle on a DBC
Message
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00538771
Message ID:
00538804
Views:
9
>Hi all,
>
>I have a DBC with a Named connection to an Oracle Database 'myconnection'. I want to be able to use a SQLEXEC to pull data for a small lookup. Is there a way to determine the connection handle of the Named connection in the DBC so that I don't have to establish another connection using SQLCONNECT?

Matt,
The Connection in the stored in the DBC doesn't have a connection to the back end database. It merely has the information stored with it so that you can use it to establish a connection. If you have already used the Connection to connect to Oracle using something like a remote view then you cans use CursorGetProp() and retrieve the ConectionHandle for it.

HTH.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Reply
Map
View

Click here to load this message in the networking platform