I recently changed the DB connection in our website from ODBC to OLEDB. But now the default value as set in SQL Server are not being used.<BR><BR>I use rs.addnew, then rs.update to add the records. While using the ODBC connection the default values in SQL were used but now are not with the direct OLEDB connection.<BR><BR>Any thoughts??