| asp.net 1.1 and oracle 8.1.7 [message #77048] |
Thu, 22 July 2004 10:59  |
vannak
Messages: 2
Registered: July 2004
|
Junior Member |
|
|
I tried to connect to oracle database version 8.1.7 from ASP.Net 1.1 and get this error message:
ORA-12154 TNS:Could not resolve service name
I get this same message whether I use OLEDB Provider for Oracle or .Net data provider for Oracle etc..
I think it has something to do with permissions. I am able to connect to Oracle with PL/SQL Developer but not through ASP.Net. I granted permission to the Oracle Home to IUSR_.. and IWAM_..
Can anyone please help?
Thanks,
Vannak.Chhang@imerys.com
|
|
|
|
| Re: asp.net 1.1 and oracle 8.1.7 [message #77087 is a reply to message #77048] |
Tue, 24 August 2004 05:38  |
Mark Compton
Messages: 1
Registered: August 2004
|
Junior Member |
|
|
Finally bottomed this one using tools from sysinternals -
For some reason ASP uses the registry (rather than environment variables) to locate TNS_ADMIN - so you need to add a TNS_ADMIN key to the registry.
Under HKEY_LOCAL_MACHINESOFTWAREORACLE
Add a string value named TNS_ADMIN and set its value to the location of the TNSNAMES.ORA file (C:OracleInstantClient in my case).
You also need to ensure that ASPNET account has full priveleges on the directories where your oracle client files reside.
Hope this helps
Mark Compton
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
