DB Connection Error

Hi,

Teamsite 6.5 SP2
Win 2003 Enterprise Edition
Oracle 9i

We are using a tpl, which connects to DB, to generate and html. When previewing the DCR we are getting a connection error.

Error: [12154] [] "[Microsoft][ODBC driver for Oracle][Oracle]ORA-12154: TNS:could not resolve service name"

We have checked the tnsnames.ora file. It looks Ok.

We are able to connect to the database, when running the tpl from command prompt usign iwpt_compile.ipl

We are also able to connect through cgi scripts.

We are using Microsoft ODBC for DB Connection.

TPL attached.

Could anyone help resolve this issue.

Regards,
Pratheesh.

Find more posts tagged with

Comments

Adam Stoller

Hi,

Teamsite 6.5 SP2
Win 2003 Enterprise Edition
Oracle 9i

We are using a tpl, which connects to DB, to generate and html. When previewing the DCR we are getting a connection error.

Error: [12154] [] "[Microsoft][ODBC driver for Oracle][Oracle]ORA-12154: TNS:could not resolve service name"

We have checked the tnsnames.ora file. It looks Ok.

We are able to connect to the database, when running the tpl from command prompt usign iwpt_compile.ipl

We are also able to connect through cgi scripts.

We are using Microsoft ODBC for DB Connection.

TPL attached.

Could anyone help resolve this issue.

Regards,
Pratheesh.

The environment within the PT is distinctly different than the environment from your command prompt shell window. Please search the forums - you should be able to find at least a dozen posts of this nature all of which contain basically the same advice.

Pratheesh

Thanks fish,

I understand that there are difference when running a script from command prompt and through pt. But I was able to connect through a cgi script placed under iw-home/httpd/iw-bin folder, when accessed through the browser. I thought if a cgi is working, then tpl should also work. Is there a difference between calling a tpl and cgi.

I have searched the forum. Most of them advice to set the path variable and oracle home variable. I have set these environment correctly.

Regards,
Pratheesh.

Adam Stoller

Thanks fish,

I understand that there are difference when running a script from command prompt and through pt. But I was able to connect through a cgi script placed under iw-home/httpd/iw-bin folder, when accessed through the browser. I thought if a cgi is working, then tpl should also work. Is there a difference between calling a tpl and cgi.

I have searched the forum. Most of them advice to set the path variable and oracle home variable. I have set these environment correctly.

Regards,
Pratheesh.

Yes - there is a difference between a CGI and a PT - and you seem to indicate that you've taken care of setting the environment information correctly - but as we haven't seen the code you're using - we cannot comment on whether or not you've done it correctly.

Pratheesh

Hi,

The problem was solved. It was a very strange solution.

What we did was:
1) We unchecked the Read and Execute permission for "Authenticated Users" for Oracle home directory.
2) Applied the changes to all the subdirectores.
3) Again checked the Read and Execute permission for "Authenticated Users" for the Oracle home directory.
4) Applied the changes to all the subdirectories.

Then it worked correctly. We didn't make any changes to Code or environment variables.

regards,
Pratheesh