Re: informix functions and asp

Posted in 2004

Sheshnarayan Agrawal — Fri, 13 Feb 2004 16:26:01 -0600 — source: Usenet: comp.databases.informix

--0__=08BBE4AADFE966258f9e8a93df938690918c08BBE4AADFE96625 Content-type: multipart/alternative; Boundary="1__=08BBE4AADFE966258f9e8a93df938690918c08BBE4AADFE96625" --1__=08BBE4AADFE966258f9e8a93df938690918c08BBE4AADFE96625 Content-type: text/plain; charset=US-ASCII I would say there is not enough information available to comment further ....ODBC trace would help .... Which version of IBM Informix ODBC Driver are you using? From the application it looks 3.34(CSDK 2.60)? I would suggest to use the latest 3.82.TC3 ( CSDK 2.81.XC3 ). Thanks & Regards -Shesh c.davies@geos.com (Carl) To: informix-list@iiug.org Sent by: cc: owner-informix-li Subject: informix functions and asp st@iiug.org 02/13/2004 11:15 AM Please respond to c.davies I am trying to retrieve the results from an informix function in an asp page, my dsn is fine because i can return a simple sql query. Each time i try to execute a function, i simply get a 'trappable error' occurring.. any ideas? Thanks Carl. <HTML> hello again <% Set oConnection = CreateObject("ADODB.Connection") oConnection.ConnectionString = "DSN=CEDAR;DRIVER={INFORMIX 3.34 32 BIT}" oConnection.Open Set oCommand = CreateObject("ADODB.Command") Set oCommand.ActiveConnection = oConnection oCommand.CommandText = "select calibration_id from calibration" oCommand.CommandType = 1 'oCommand.CommandText = "Execute FUNCTION fggeoscontract(33);" Set oResult = oCommand.Execute() Do While Not oResult.EOF response.write oResult(0) oResult.MoveNext Loop %> </HTML> --1__=08BBE4AADFE966258f9e8a93df938690918c08BBE4AADFE96625 Content-type: text/html; charset=US-ASCII Content-Disposition: inline <html><body> I would say there is not enough information available to comment further ....ODBC trace would help .... Which version of IBM Informix ODBC Driver are you using? From the application it looks 3.34(CSDK 2.60)? I would suggest to use the latest 3.82.TC3 ( CSDK 2.81.XC3 ). Thanks & Regards -Shesh <img src="cid:10__=08BBE4AADFE966258f9e8a93df938@us.ibm.com" width="16" height="16" alt="Inactive hide details for c.davies@geos.com (Carl)">c.davies@geos.com (Carl) <table V5DOTBL=true width="100%" border="0" cellspacing="0" cellpadding="0"> <tr valign="top"><td width="1%"><img src="cid:20__=08BBE4AADFE966258f9e8a93df938@us.ibm.com" border="0" height="1" width="72" alt=""> </td><td style="background-image:url(cid:30__=08BBE4AADFE966258f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " width="1%"><img src="cid:20__=08BBE4AADFE966258f9e8a93df938@us.ibm.com" border="0" height="1" width="225" alt=""> <ul> <ul> <ul> <ul>c.davies@geos.com (Carl) Sent by: owner-informix-list@iiug.org 02/13/2004 11:15 AM Please respond to c.davies</ul> </ul> </ul> </ul> </td><td width="100%"><img src="cid:20__=08BBE4AADFE966258f9e8a93df938@us.ibm.com" border="0" height="1" width="1" alt=""> To: informix-list@iiug.org cc: Subject: informix functions and asp</td></tr> </table> I am trying to retrieve the results from an informix function in an asp page, my dsn is fine because i can return a simple sql query. Each time i try to execute a function, i simply get a 'trappable error' occurring.. any ideas? Thanks Carl. <HTML> hello again <% Set oConnection = CreateObject("ADODB.Connection") oConnection.ConnectionString = "DSN=CEDAR;DRIVER={INFORMIX 3.34 32 BIT}" oConnection.Open Set oCommand = CreateObject("ADODB.Command") Set oCommand.ActiveConnection = oConnection oCommand.CommandText = "select calibration_id from calibration" oCommand.CommandType = 1 'oCommand.CommandText = "Execute FUNCTION fggeoscontract(33);" Set oResult = oCommand.Execute() Do While Not oResult.EOF response.write oResult(0) oResult.MoveNext Loop %> </HTML> </body></html> --1__=08BBE4AADFE966258f9e8a93df938690918c08BBE4AADFE96625-- --0__=08BBE4AADFE966258f9e8a93df938690918c08BBE4AADFE96625 Content-type: image/gif; name="graycol.gif" Content-Disposition: inline; filename="graycol.gif" Content-ID: <10__=08BBE4AADFE966258f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhEAAQAKECAMzMzAAAAP///wAAACH5BAEAAAIALAAAAAAQABAAAAIXlI+py+0PopwxUbpu ZRfKZ2zgSJbmSRYAIf4fT3B0aW1pemVkIGJ5IFVsZWFkIFNtYXJ0U2F2ZXIhAAA7 --0__=08BBE4AADFE966258f9e8a93df938690918c08BBE4AADFE96625 Content-type: image/gif; name="ecblank.gif" Content-Disposition: inline; filename="ecblank.gif" Content-ID: <20__=08BBE4AADFE966258f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhEAABAIAAAAAAAP///yH5BAEAAAEALAAAAAAQAAEAAAIEjI8ZBQA7 --0__=08BBE4AADFE966258f9e8a93df938690918c08BBE4AADFE96625 Content-type: image/gif; name="pic14482.gif" Content-Disposition: inline; filename="pic14482.gif" Content-ID: <30__=08BBE4AADFE966258f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhWABDALP/AAAAAK04Qf79/o+Gm7WuwlNObwoJFCsoSMDAwGFsmIuezf///wAAAAAAAAAA AAAAACH5BAEAAAgALAAAAABYAEMAQAT/EMlJq704682770RiFMRinqggEUNSHIchG0BCfHhOjAuh EDeUqTASLCbBhQrhG7xis2j0lssNDopE4jfIJhDaggI8YB1sZeZgLVA9YVCpnGagVjV171aRVrYR RghXcAGFhoUETwYxcXNyADJ3GlcSKGAwLwllVC1vjIUHBWsFilKQdI8GA5IcpApeJQt8L09lmgkH LZikoU5wjqcyAMMFrJIDPAKvCFletKSev1HBw8KrxtjZ2tvc3d5VyKtCKW3jfz4uMKmq3xu4N0nK BVoJQmx2LGVOmrqNjjJf2hHAQo/eDwJGTKhQMcgQEEAnEjFS98+RnW3smGkZU6ncCWav/4wYOnAI TihRL/4FEwbp28BXMMcoscQCVxlepL4IGDSCyJyVQOu0o7CjmLN50OZlqWmyFy5/6yBBuji0AxFR M00oQAqNIstqI6qKHUsWRAEAvagsmfUEAImyxgbmUpJk3IklNUtJOUAVLoUr1+wqDGTE4zk+T6FG uQb3SizBCwatiiUgCBN8vrz+zFjVyQ8FWkOlg4NQiZMB5QS8QO3mpOaKnL0Z2EKvNMSILEThKhCg zMKPVxYJh23qm9KNW7pArPynMqZDiErsTMqI+LRi3QAgkFUbXpuFKhSYZALd0O5RKa2z9EYKBbpb qxIKsjUPRgD7I2XYV6wyrOw92ykExP8NW4URhknC5dKGE4v4NENQj2jXjmfNgOZDaXb5glRmXQ33 YEWQYNcZFnrYcIQLNzyTFDQNkXIff