since you mentioned variables i went snooping and found this error
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver]Invalid use of default parameter
/my/adveditor/variable.asp, line 499
i found it by clicking on the variables tab, then clicking on New Variable. While on that page i didnt fill anything in. i then clicked on the other tabs at the top under the Mystuff tab. (the links in the white area). wow thats difficult to understand. sorry, let me know if i can clear that up.
nate