I know this is not a help forum and I know this should not be posted there but this msg will be closed in a couple of hours.

I have a site using asp created in Dreamweaver Ultradev 4. It works locally using pws but whenever I upload, I get this error msg:

Code:
Microsoft OLE DB Provider for ODBC Drivers error '80004005' 

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified 

/valhalla/html/default.asp, line 102

heres the code from default.asp (starting with line 101)

set val = Server.CreateObject("ADODB.Recordset")
val.ActiveConnection = MM_comp_STRING
val.Source = "SELECT * FROM Contestant"
val.CursorType = 0
val.CursorLocation = 2
val.LockType = 3
val.Open()
val_numRows = 0
%>


anyone who can help me fix this in the next few hours receives a season pass to blackpool pleasure beach (home of one of the largest roller coasters in the world).

Bruce

(if mg33 is reading this I am very sorry!!!)