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

have you set up the DSN "Inventory" on the web server? Uploaded the DB etc,.?

Does your host allow DSN's ?

if not look into using the <b>Server.MapPath</b> method of finding the DB.

Regards,
Dave

[DWMX 2004]|[FlashMX 2004 Pro]|[Studio MX 2004]|[SQL]|[Access2000/2002]|[ASP/VBScript]|[XP-Pro]
If you like online gaming, please register @ www.nova-multigaming.com