uploaded my mssql database to the hosting server but when I try to test it I get the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

It all works fine on my local computer.

Sounds like you need to check the path you're using to connect.
If you're using a DSN you'll need to get your host to set that up (though some will have a control panel interface that'll allow you to do it)
Or if you're using a DSN-less connection then consider using MapPath...?
Useful help at Macromedia www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19065

Live the life you love
Love the life you live

Simon

[DWMX 2004]|[SQL]|[ASP/VBScript]|[XP-Pro]