Re^3: Error running CGI on tomcat

Does

my $dsn = "DBI:$driver:oradev";
my $dbh = DBI->connect($dsn,$user,$password);
[download]

make any difference?

The code you currently have bypasses the tns alias, the code above uses the alias.

rdfield

Comment on Re^3: Error running CGI on tomcat Download Code
Re^4: Error running CGI on tomcat by sdeshpan (Initiate) on Sep 12, 2007 at 19:10 UTC
Hi, I tried this format of the connection string, but it now gives this error: Error ORA-12560: TNS:protocol adapter error (DBD ERROR: OCIServerAttach) connecting to DBI:Oracle:ORADEV Any ideas? I am banging my head, wondering what environment variables etc might be missing!!!	[reply]
Re^5: Error running CGI on tomcat by rdfield (Priest) on Sep 13, 2007 at 11:23 UTC
There should be an error stack in your sqlnet.log file, the error above is a generic error, and more detailed infomation should be recorded in the log file. rdfield	[reply]
Re^6: Error running CGI on tomcat by sdeshpan (Initiate) on Sep 13, 2007 at 17:50 UTC
Can you please help me locate the sqlnet.log file? Is it the one under the deafult C:\Documents and Settings\<user> folder? Also, I just found out that the Oracle DB connectivity code works fine as a PL file from the command line using perl.exe. It is only through a CGI script (web) that it is failing. I am not sure, but may be the code cannot read ORACLE_HOME in the CGI, running on tomcat! Any ideas on how I can make the Windows Environment Variables visible to the CGI script?	[reply]
Re^7: Error running CGI on tomcat by rdfield (Priest) on Sep 14, 2007 at 08:21 UTC


laziness, impatience, and hubris
	PerlMonks