Hi all, We're running UniData 6.0 on Sun Solaris and UniData ODBC 3.1.3 on a Windos 2003 server. The Windows server also has Cold Fusion MX, and we're using CF to connect with UniData
I've had no luck in being able to run a stored procedure. If we run a SQL query from Cold Fusion using the cfquery tag we are able to get data back; however, stored procedures don't seem to run at all. We've had this working for a long time using Cold Fusion and UniData ODBC on a NT box with Cold Fusion 5. All of our config settings are identical between the two Cold Fusion boxes and we're using the same stored proc on the UniData side, so it's a bit of a mystery why it isn't working. Anyone have any suggestions where I might look for a solution? It looks like as far as I can tell the stored procedure doesn't execute at all. Thanks, Andy Here's some debug info from Cold Fusion for what little it's probably worth.: There was an error in procedure A26_DARS_STU_INFO Returned code is '' Stored Procedures A26_DARS_STU_INFO (Datasource=dars_uni_sys, Time=2406ms) in D:\wwwroot\dars\dars_load_stu_data.cfm @ 14:11:37.037 Table with 2 columns and 2 rows Nested Table with 5 columns and 6 rows, nesting level 1 parameters type CFSQLType value variable dbVarName OUT CF_SQL_VARCHAR returned_code = returned_code IN CF_SQL_VARCHAR 2104120814113401 IN CF_SQL_VARCHAR DARS IN CF_SQL_VARCHAR 0218485 table end resultsets name resultset table end | Andy Squires -- Systems Analyst | | E-Administration? -- American University | | (202) 885-2785 | ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/