Hi,

I am new to ASP and MS technologies.

I have one application in ASP with backend as Oracle.

I am able to login to application and when i am clicking on a link to expand it, i am getting this error

"Microsoft OLE DB Provider for Oracle (0x80004005) ORA-12154: TNS:could not resolve service name "

Earlier for the same operation i was getting error

" Error Type:
Active Server Pages, ASP 0113 (0x80004005)
The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools."

To overcome this i increase the script execution time.

After this step i am getting this TNS error.

I know nothing is wrong from Oracle Side as I can access DB using TOAD, SQL*Plus etc and also i have checked at authenticated users have read and execute permission.

Can anyone help me fix this issue?

Thanks and Regards
Amit Trivedi