Microsoft OLE DB Provider for Oracle (0x80004005) ORA-12154: TNS:could not
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 authenticated users have read and execute permission (have done the uncheck/check exercise)
Can anyone help me fix this issue?
Thanks and Regards
Amit Trivedi