inline command db connection fails

System

Hello,

I'm using the inline command to pull some records from a database and using substitution to populate options in a select element for a DCR element. Initially, I did the db connect, querying and return using cgi-callouts, but I thought having inline command and skipping the extra button click would be better.

My problem is that my perl script (.ipl) for the cgi-callouts connects to my oracle database, and performs great. I'm using the DBI and DBDracle modules. and my code is something like this.
use DBI;
$dbh= DBI->connect("$db", $username, $auth)
|| die 'Database connection not made: $DBI->errstr';
....
However, when I use the same code for my inline command, the db connect fails. The error on the server side is that "the dynamoci link library oci.dll could not be found in the specified path d:\Program files\interwoven\teamsite\iw-perl\site.;c:\winnt\system32;c:\winnt\system;c:\winnt;."
And the error displayed on the template window is:
Templating Error Page
A MessageException was thrown: com.interwoven.clientutils100.TMessageException: Error building the requirements for java.io.ByteArrayInputStream@6489f0: install_driver(Oracle) failed: Can't load 'd:\PROGRA~1\INTERW~1\Teamsite\iw-perl\site\lib/MSWin32-x86/auto/DBD/Oracle/Oracle.dll' for module DBD:racle: load_file:The specified module could not be found at d:\PROGRA~1\INTERW~1\Teamsite\iw-perl\lib/MSWin32-x86/DynaLoader.pm line 169. at (eval 1) line 3 Perhaps a required shared library or dll isn't installed where expected at d:/PROGRA~1/INTERW~1/Teamsite/httpd/iw-bin/inline_datacapture_callout.ipl line 30

Are there some differences in how to implement these db connections that I'm not aware of. I would appreciate any insight and information.

Thank you very much.

jbyork

Sounds like you are trying to connect to Oracle 8i. Your DBI/DBD modules probably need to be updated (not an easy task if you've never compiled libraries and drivers before).

The DBI/DBD shipped with TeamSite only supports Oracle 7 & 8.

We've been working on resolving the same problem you're experiencing for over a week now. See the following KB articles (and good luck!!!):

https://support.interwoven.com/kb/kb_show_article2.asp?ArticleID=1675
https://support.interwoven.com/kb/kb_show_article2.asp?ArticleID=2141
https://support.interwoven.com/kb/kb_show_article2.asp?ArticleID=2444

You need Microsoft Visual C++ to compile the new DBI/DBD Oracle modules. We found out (the hard way) that there are problems with spaces in directory names in earlier versions of Perl. So, if you have your C++ compiler installed under c:\Program Files... it won't work. When you start the process, the DBI/DBD instructions are wrong and running the install scripts will probably fail. Check all your paths, environment variable settings, etc. I wish I could give you the magic answer, but first of all, we haven't been succesful yet, and second, all environments are usually completely different. The following site has perl discussions about DBI/DBD. http://aspn.activestate.com/ASPN/Mail/Message/perl-win32-users/263624

FYI - We are trying to upgrade to:
DBI-Oracle-1.201
DBD-Oracle-1.12

Good luck...