SQL & how different databases implement it

Some vaguely structured thoughts on the differences that you see between SQL as implemented by one DBMS and that of another.

28 January 2011

 

OraOLEDB (0x80004005)

Error Type:
OraOLEDB (0x80004005)
?B8
/nar/nvCreateaccount.asp, line 105

This error was caused by assigning a null value to a stored procedure input variable.


OraOLEDB error '80004005'
$?

This error was caused by setting a procedure output parameter as Variant - should be VarChar, for example:
objCommand.parameters.append objCommand.createparameter( "p_device_id", adVarChar, adParamOutput, 24)

Links

Archives

September 2005   October 2005   December 2005   January 2006   March 2006   May 2006   June 2006   September 2006   May 2007   June 2007   November 2007   December 2007   March 2008   April 2008   December 2008   January 2011  

This page is powered by Blogger. Isn't yours?

Subscribe to Posts [Atom]