Hi Tek-tip Experts:
I've been tring to update a memo field (or long text field) with an SQL statement. Due to the nature of the data, the statement is very long. It goes something like this,
UPDATE tblname SET fld = "255 characters" + "255 characters" + "255 characters" etc. It works fine when I run it at the command prompt of backgound DB, but when I try to do cnnSomeADODBconnection.execute (sqlCmd) it crashes my IIS 5.0 and gives me an vbscript error saying "An exception has occurred: 'Execute'". I had to restart my IIS and the nightmare starts all over again. What is the problem? is there a limitation on the commandText given to an ADODB.execute method? Please help!
I've been tring to update a memo field (or long text field) with an SQL statement. Due to the nature of the data, the statement is very long. It goes something like this,
UPDATE tblname SET fld = "255 characters" + "255 characters" + "255 characters" etc. It works fine when I run it at the command prompt of backgound DB, but when I try to do cnnSomeADODBconnection.execute (sqlCmd) it crashes my IIS 5.0 and gives me an vbscript error saying "An exception has occurred: 'Execute'". I had to restart my IIS and the nightmare starts all over again. What is the problem? is there a limitation on the commandText given to an ADODB.execute method? Please help!