SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-19-2008, 08:23 PM
| ||||
| ||||
 Re: informix functions and asp --0__=08BBE4AADFE966258f9e8a93df938690918c08BBE4AADF E96625 Content-type: multipart/alternative; Boundary="1__=08BBE4AADFE966258f9e8a93df938690918c 08BBE4AADFE96625" --1__=08BBE4AADFE966258f9e8a93df938690918c08BBE4AADF E96625 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__=08BBE4AADFE966258f9e8a93df938690918c08BBE4AADF E96625 Content-type: text/html; charset=US-ASCII Content-Disposition: inline <html><body> <p>I would say there is not enough information available to comment further ....ODBC trace would help ....<br> Which version of IBM Informix ODBC Driver are you using? From the application it looks 3.34(CSDK 2.60)? I would<br> suggest to use the latest 3.82.TC3 ( CSDK 2.81.XC3 ).<br> <br> Thanks & Regards<br> -Shesh<br> <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)<br> <br> <br> <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=""><br> </td><td style="background-image:url(cid:30__=08BBE4AADFE966258f9e8a93df938@u s.ibm.com); background-repeat: no-repeat; " width="1%"><img src="cid:20__=08BBE4AADFE966258f9e8a93df938@us.ibm .com" border="0" height="1" width="225" alt=""><br> <ul> <ul> <ul> <ul><b><font size="2">c.davies@geos.com (Carl)</font></b><br> <font size="2">Sent by: owner-informix-list@iiug.org</font> <p><font size="2">02/13/2004 11:15 AM</font><br> <font size="2">Please respond to c.davies</font></ul> </ul> </ul> </ul> </td><td width="100%"><img src="cid:20__=08BBE4AADFE966258f9e8a93df938@us.ibm .com" border="0" height="1" width="1" alt=""><br> <font size="1" face="Arial"> </font><br> <font size="2"> To: </font><font size="2">informix-list@iiug.org</font><br> <font size="2"> cc: </font><br> <font size="2"> Subject: </font><font size="2">informix functions and asp</font></td></tr> </table> <br> <br> <font face="Courier New">I am trying to retrieve the results from an informix function in an<br> asp page, my dsn is fine because i can return a simple sql query. <br> Each time i try to execute a function, i simply get a 'trappable<br> error' occurring..<br> any ideas?<br> <br> Thanks<br> <br> Carl.<br> <br> <HTML><br> <br> hello again<br> <br> <%<br> Set oConnection = CreateObject("ADODB.Connection"  <br>oConnection.ConnectionString = "DSN=CEDAR;DRIVER={INFORMIX 3.34 32<br> BIT}"<br> oConnection.Open<br> <br> Set oCommand = CreateObject("ADODB.Command" <br>Set oCommand.ActiveConnection = oConnection<br> oCommand.CommandText = "select calibration_id from calibration"<br> oCommand.CommandType = 1<br> <br> 'oCommand.CommandText = "Execute FUNCTION fggeoscontract(33);"<br> Set oResult = oCommand.Execute()<br> <br> Do While Not oResult.EOF<br> response.write oResult(0)<br> oResult.MoveNext<br> Loop<br> %><br> <br> </HTML><br> </font> </body></html> --1__=08BBE4AADFE966258f9e8a93df938690918c08BBE4AADF E96625-- --0__=08BBE4AADFE966258f9e8a93df938690918c08BBE4AADF E96625 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 ZRfKZ2zgSJbmSRYAIf4fT3B0aW1pemVkIGJ5IFVsZWFkIFNtYX J0U2F2ZXIhAAA7 --0__=08BBE4AADFE966258f9e8a93df938690918c08BBE4AADF E96625 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__=08BBE4AADFE966258f9e8a93df938690918c08BBE4AADF E96625 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 EDeUqTASLCbBhQrhG7xis2j0lssNDopE4jfIJhDaggI8YB1sZe ZgLVA9YVCpnGagVjV171aRVrYR RghXcAGFhoUETwYxcXNyADJ3GlcSKGAwLwllVC1vjIUHBWsFil KQdI8GA5IcpApeJQt8L09lmgkH LZikoU5wjqcyAMMFrJIDPAKvCFletKSev1HBw8KrxtjZ2tvc3d 5VyKtCKW3jfz4uMKmq3xu4N0nK BVoJQmx2LGVOmrqNjjJf2hHAQo/eDwJGTKhQMcgQEEAnEjFS98+RnW3smGkZU6ncCWav/4wYOnAI TihRL/4FEwbp28BXMMcoscQCVxlepL4IGDSCyJyVQOu0o7CjmLN50OZl qWmyFy5/6yBBuji0AxFR M00oQAqNIstqI6qKHUsWRAEAvagsmfUEAImyxgbmUpJk3IklNU tJOUAVLoUr1+wqDGTE4zk+T6FG uQb3SizBCwatiiUgCBN8vrz+zFjVyQ8FWkOlg4NQiZMB5QS8QO 3mpOaKnL0Z2EKvNMSILEThKhCg zMKPVxYJh23qm9KNW7pArPynMqZDiErsTMqI+LRi3QAgkFUbXp uFKhSYZALd0O5RKa2z9EYKBbpb qxIKsjUPRgD7I2XYV6wyrOw92ykExP8NW4URhknC5dKGE4v4NE NQj2jXjmfNgOZDaXb5glRmXQ33 YEWQYNcZFnrYcIQLNzyTFDQNkXIff0ExVlY4srziQk43inZgL4 rwxxINMvpFFAz1KOODHiu+4aEw NEjFl5B3JIKWKF3k6I9bfUGp5ZZcdunll5IA4cuHvQQJ5gcsoC WOOUwgltIwAKRxJgbIkJAQZEq0 2YliZnpZZ4BH3CnYOXldOUOfQoYDqF1LFHbXCrO8xmRsfoXDXJ 6ChjCAH3QlhJcT6VWE6FCkfCco CgrMFsROrIEX3o2whVjWDjoJccN3LdggSGXLCdLEgHr1lyU3O3 QxhgohNKXJCWv8JQr/PDdaqd6w 2rj1inLiGeiCJoDspAoQlYE6QWLSECehcWIYxIQES6zhbn1iIm THEQyqJ4eIxJJoUBc+3CbBuwZE V5cJPPkIjFDdeEabQbd6WgICTxiiz0f5dBKquXF6k4senwEhYG nKEFJeGrxUZy8dB8gmAXI/sPvH ESfCwVt5hTgYiqQqtdRNHQIU1PJ33ZqmzgE90OwLaoJcnMop1W iMmgkPHQRIrwgFuNV90A3doNKT mrKIN07AnGcI9BQjhCBN4RfA1qIZnMqorJCogKfGQnxSCDilTV IA0yl5ciTovgLuBDKFUDE9aQcw 9SA+rjSNf9/M1gxrj6VwDTS0IUSElMzBfsj0NFXR2kwsV1A5IF1grLgLL/r1R40BZEnuBWgmQEyb jqRwSAt6bqMCOFkvKFN2GPPkUzIm/SCF8z8pVzpbjVnMsy0vOr1hw3SaSRUhpY09v0z0J1FnwzPl fmh+xl4WtR0zGu24I4KbMQm3lnVu2oNWxI9W/lcyzA+mCKF4DBikxb/+UWtOGRiFP8qEwAayIgIA Ow== --0__=08BBE4AADFE966258f9e8a93df938690918c08BBE4AADF E96625-- sending to informix-list      |
Linear Mode
