my connection is not working

ok i just joined discountasp and i uploaded my site which was working 100% percent on my pc after i tested it on my localhost.
this is the error i got

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

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

/articles.asp, line 8

and this is the code until line 8 in page articles.asp

1 <%@LANGUAGE='VBSCRIPT' CODEPAGE='1252'%>
2 <!--#include file='Connections/connAlg.asp' -->
3 <%
4 Dim rsCategories
5 Dim rsCategories_numRows
6
7 Set rsCategories = Server.CreateObject('ADODB.Recordset')</font>
8 rsCategories.ActiveConnection = MM_connAlg_STRING </font>

i know its something stupid that i missed to do but please help

oh this is the include file (connAlg.asp) code
<%
' FileName='Connection_odbc_conn_dsn.htm'
' Type='ADO'
' DesigntimeType='ADO'
' HTTP='true'
' Catalog=''
' Schema=''
Dim MM_connAlg_STRING
MM_connAlg_STRING = 'dsn=alg;'
%>

 

it is my guess that you don't have DSN 'alg' setup. It is recommended you use DSN-less connections over DSN connections. We provide the DSN feature for backward compatibility with existing apps, but whenever you can always use a DSN-less connection.







Joel Thoms
DiscountASP.NET
http://www.DiscountASP.NET