Windows 2003 Web Edition - Oracle 9 Client

[GaryMurray]

I have published a new website that uses an Oracle 9 client to connect to an Oracle 9 database on another server.

The page launches and gives me the login (as it should) at this point it should login into the database but I get the following error:

Invalid credentials please re-enter...ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor

The tnsnames.ora file is correct and I can use SQL+ on the web server and connect to the database with it.

I have setup tracing but nothing gets written it is as if the webpage can not see the network folder within Oracle, because if it did not have access to Oracle then it would say: Oracle network components need installing.......

Has anyone else had this problem and got around it?
It works fine on win2k and Win2003 std

Thanks
Gary

 

[Titleist]

Gary,

Check the permissions on the C:\Oracle folder. We ran into this before and had to grant "Everyone" modify access to it.

John