Need help using asp

[Tony Teoh]

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!

[Steve Lutz]

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" <te****@cari.net.my> wrote in message
news:u8**************@TK2MSFTNGP09.phx.gbl...

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!

[Tony Teoh]

Steve,

Thanks for your help.

But I believe that it can be done by stored it into array and retrieve
it when user selected to connection.

Im new to the programming in asp and I do not know how to do it. Do you
have any ideal ?

Regards
Tony


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!