Re: Oracle & VB

"Frank Weber" <frank_at_frankweber.com> wrote in message news:dtunr9$7dd$1_at_online.de...
> "News" <Contact_404_at_hotmail.com> schrieb im Newsbeitrag
> news:1140714275.036407.116600_at_e56g2000cwe.googlegroups.com...
> > Anyone have sample VB code that returns set of connection strings
> > defined in local tnsnames.ora ? thx in advance
> >
>
> If you have Oracle 9 or 10 fully installed, there are some VB examples
> coming with. You just have to find them.
>

These files can be found on the Oracle Client Distribution disk.

Also, I am not sure why the OP needs to do this, as the whole point of a tnsnames.ora is to provide a connection and attributes for that connection based on the name? Various Oracle client utilities use the 'name' provided to refer back to information supplied by the tnsname entry. Mucking about with custom connection strings behind their back is a sure way to introduce interesting behavior.

-ralph Received on Mon Feb 27 2006 - 09:13:42 CST