I was getting errors with making recordsets too, especially
when creating a variable in advanced mode. The new interface
includes a dropdown for a variable type and does not let you choose
to NOT specify a data type. Even if you do, Dreamweaver puts the
data in the wrong place and the variable doesn't work. I downgraded
back to 8.0 and have been fine since.
I submitted a bug report to Macro-dobe, but no word