I have been racking my brains trying to get an ASP page to work on a server once I upload the entire site.
It works perfectly on my local testing server but will not display properly on the uploaded server i get an error page:
I am including the errror and my source coded pages for anyone to review and help me.

ERROR:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/MENSSPORTSRESULTS.asp, line 7

Sample of ASP Connection that DW created:
<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_apparel_STRING
MM_apparel_STRING = "dsn=Inventory;"
%>

Sample of top code from actual ASP page I'm trying to get to work:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!--#include file="Connections/apparel.asp" -->
<%
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset"
Recordset1.ActiveConnection = MM_apparel_STRING
Recordset1.Source = "SELECT * FROM EMBROIDERY_DATABASE WHERE Cat=10 and des=10"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()
Recordset1_numRows = 0
%>



If there is anyone out there that can help or lead me in the right direction, I would greatly appreciate it.
I used dreamweaver because I thought it would be easier due to the uplaod feature.

PLEASE HELP ME OUT.
TINO

its seems to indicate that dsn=Inventory does not exist on the server.

you may have to contact your host about setting this up.

John Auzheal Clement
(www.digitm.com)