Change your connection string, in config.asp, to an OLEDB one (one of those with the SQLOLEDB provider). That will fix it.
hmmmm...I just went to change it and noticed it WAS already set to use the OLEDB connection string ?? Any other suggestions? (And thnak you for replying
Make sure your server has the latest MDAC installed (contact your host if you need to). The method needs MDAC 2.5, at least. Latest MDAC can be found at http://microsoft.com/data