inline connecting to SQLServer

Teamsite 6.7
Sqlserver

(Files are attached)
When I callled the folowing inline function from the prompt on the CMS server:
"iwperl GetShowcaseID_inline.ipl showcaseID"
Everything execute properly, meaning that the DB get query and return the following results.
24
Which is what I want.

When I'm opening a new form(DCT)as an inline it complains see Error messages.

What's missing? My DSN is setup properly.

============================== Error message=====================================
Root cause:
DBI connect('km2','iw_user',...) failed: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation. (SQL-08001) [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()). (SQL-01000)(DBD: db_login/SQLConnect err=-1) at d:\iw-home\httpd\iw-bin\canadaPost\GetShowcaseID_inline.ipl line 31 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation. (SQL-08001) [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()). (SQL-01000)(DBD: db_login/SQLConnect err=-1) From Mik at d:\iw-home\httpd\iw-bin\canadaPost\GetShowcaseID_inline.ipl line 31.

Details...

com.interwoven.ui.datacapture.core.dct.InlineCallout$InlineCalloutException: DBI connect('km2','iw_user',...) failed: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation. (SQL-08001)
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()). (SQL-01000)(DBD: db_login/SQLConnect err=-1) at d:\iw-home\httpd\iw-bin\canadaPost\GetShowcaseID_inline.ipl line 31
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation. (SQL-08001)
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()). (SQL-01000)(DBD: db_login/SQLConnect err=-1) From Mik at d:\iw-home\httpd\iw-bin\canadaPost\GetShowcaseID_inline.ipl line 31.

at com.interwoven.ui.datacapture.core.dct.InlineCallout.execute(InlineCallout.java:181)
at com.interwoven.ui.datacapture.external.InlineCalloutProcessor.executeInline(InlineCalloutProcessor.java:197)
at com.interwoven.ui.datacapture.external.InlineCalloutProcessor.evaluateInlineCallouts(InlineCalloutProcessor.java:130)
at com.interwoven.ui.formspub.datacapture.DCRPredicate.buildDCRDocument(DCRPredicate.java:200)

Find more posts tagged with

Comments

ISCBorisB

When I'm opening a new form(DCT)as an inline it complains see Error messages

Suffering from amnesia? [thread=22261]Inline Problem[/thread]

Digger

it must me amnesia... :-) Thx for re-routing me.

Just to answer my own Question: just by adding this to my inline script it took care of the problem.

BEGIN
{
$ENV{SystemRoot}="C:\\WINDOWS";
};

Thx for your help.

Regards,

MIchel