Although apparently depreciated, I've found using the SQL Server "text" data type works perfectly well. I've never managed to make the nvarchar(MAX) data type work using ADODB.