I'm trying to grab data from the database, and prepopulate a select field in a data capture template. First I tried the following approach in the DCT:
<iw_sql_open
data_source = "dbi
racle:database dsn
ort:instance"
username = "username"
password = "password">
<iw_sql_query
stmt = 'select * from SPECIALTY'
result_set = 'specialty'/>
<iw_sql_iterate
result_set = 'specialty'
var = 'row'>
<iw_value name="$row->{specialty_type}"/>
</iw_sql_iterate>
</item>
</iw_sql_open>
That didn't work, and I couldn't see any error messages (Is there anyway to get an error message to view?)
So then I tried to write a perl script to make the connection:
use DBI
......;
$dbh = DBI->connect($db, $username, $password) or die "Couldn't connect to database:" . DBI->errstr;
......
When I run this perl, I get the following error:
Can't connect(DBI::datbase_info_here username password), no database driver specified and DBI_DSN env var not set at test_jm.ipl line 23
Interwoven Documentation that I have says "TeamSite ships with a full Perl DBI module for ...Oracle ...". So there shouldn't be any other set up to do.
What am I missing? What else can I try?
Thanks in advance.
