Hi Madhu, the difference is the environment setting. You have to set the PATH variables for the oracle db like oracle_home oracle_lib etc. in the startup of the web server under which teamsite runs, or it has to be set for the user, that starts the web server. I have done this only for Solaris so I can't tell you the details for Windows.
Kind regards Robert -----Original Message----- From: madhu maddipatla [mailto:madhumaddipatla@;yahoo.com] Sent: Wednesday, November 06, 2002 1:24 PM To: [EMAIL PROTECTED] Subject: [cms-list] Calling perl script from TeamSite TPL Hi, I am using Interwoven's, TeamSite 5.5.2. I have written a perl script that makes use of DBD::ODBC to fire some queries to database. I am using System DSN to specify the connection string. The problem i am encountering is, when i run the script from a TPL. The script stops at create connection step. In the DBI trace file i can see the following error: db_login/SQLConnect error -1 recorded: [Oracle][ODBC][Ora]ORA-12545: Connect failed because target host or object does not exist When i execute the tpl via iwpt_compile.ipl it works fine. I guess this has something to do with the environment in which a TPL runs. Any pointers on this will be appreciated. Madhu __________________________________________________ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ -- http://cms-list.org/ trim your replies for good karma. -- http://cms-list.org/ trim your replies for good karma.
