Data source not found?!

[jarv]

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

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

/paddycampbell.www.co.uk/www/office/categoryproductorder/updateorder.asp, line 16


<%
Dim rsUpdate, ID, DisplayOrder

CategoryID = Request.Form("CategoryID")
ID = Request.Form("ID")
DisplayOrder = Request.Form("DisplayOrder")

response.write(CategoryID)
response.write(DisplayOrder)
response.write(ID)


sql = "UPDATE tblProductCategories SET ProductOrder= '" & DisplayOrder & "' WHERE ProductID= '"&ID&"'"
Set conn = Server.CreateObject("ADODB.Connection")
conn.ConnectionString = MM_CON_Database_STRING
conn.open
conn.Execute sql
Set conn = Nothing

%>

Line 16: conn.open

[Old Pedant]

Can't guess.

You don't show us what is in your MM_CON_Database_STRING variable.

If you don't know, then RESPONSE.WRITE it to find out.