I get the following error when trying to call a DB2 stored procedure on OS/390 with the JDBC Type 4 driver supplied with CFMX (RVSPSEC is the stored procedure):
----------------------------------- An error has occured while accessing the Application. Database Error Executing Database Query. [Macromedia][DB2 JDBC Driver][DB2]The Specified library "RVSPSEC" could not be loaded. ----------------------------------- Does this error mean anything to anyone? I've searched the CFMX references, the Macromedia site, and I've Googled, but I'm coming up empty . . . The application runs fine in CF5. I'm trying to migrate from CF5 to CFMX. The Code Analyzer gave me informational warnings about the dbvarname parameter in the cfprocparam tag saying that it is ignored (otherwise the app is 'clean'). However the reference documentation says dbvarname is 'required for named notation', so I have left it there. I have Updater2 installed and I'm running on Win2k Adv Server, IIS5. Here is the code that calls the stored procedure: ----------------------------------- <cftransaction> <cfstoredproc datasource="#datasource#" procedure="RVSPSEC"> <!--- cfprocparam tags - variables passed to security stored procedure ---> <cfprocparam type="IN" cfsqltype="CF_SQL_VARCHAR" value="#pin##applicationType##applicationSource##paddingSpaces#" dbvarname="@INPTST"> <!--- cfprocparam tags - variables passed from the security stored procedure ---> <cfprocparam type="OUT" cfsqltype="CF_SQL_VARCHAR" variable="code" dbvarname="@RTRNCD"> <cfprocparam type="OUT" cfsqltype="CF_SQL_VARCHAR" variable="message" dbvarname="@RTRNMSG"> <!--- result set tag ---> <cfprocresult name = RS1> <cfprocresult name = RS2 resultset="2"> <cfprocresult name = RS3 resultset="3"> </cfstoredproc> </cftransaction> ----------------------------------- cftransaction is there because in CF5 the call to the stored procedure would not work without it. I took it out to see if it stopped the error message but it didn't. Thanks! George [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4