>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.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao