Hi Tony,
For reading TNSNames.ora, I do not know of any tools that would do that, you
would have to read it in and parse it yourself.
For connecting to oracle, you need a connection string. Here's an example:
DBCONSTR = "DRIVER=Microsoft ODBC for
Oracle;PASSWORD=[password];UID=[username];SERVER=[server];"
Get the login information from the user, then complete this string. You
should then be able to use it to connect to oracle.
Steve
"Tony Teoh" <teohcl@cari.net.my> wrote in message
news:u83ZWB3iDHA.2516@TK2MSFTNGP09.phx.gbl...[color=blue]
> All,
>
> Current Im develop a program that using web page to connect to Oracle.
> My difficulties was:
>
> 1) How to retrieve the information in tnsnames.ora and put into all
> connection string into a option list to let user choose accordingly ?
> 2) After using had choosen the connection then a username and passowrd
> page will appear to let user key in the username and password, if verify
> is ok then proceed to do other stuffs else put back to login page to let
> user retry.
>
> I had tried and tried but still cannot, can someone please help me.
> Thanks in advance
>
>
>
> *** Sent via Developersdex
http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it![/color]
Need help using asp 
