ADO Connectivity & View ASP Web Page

[gmag47]

Whenever I try to view my asp web page I keep getting this error message from microsoft i.e. referefncing my code:

<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="Connections/HCMAP.asp" -->
<%
Dim MeritPrinciple
Dim MeritPrinciple_numRows
Set MeritPrinciple=Server.CreateObject("ADODB.Recordset")
MeritPrinciple.ActiveConnection=MM_HCMAP_STRING
MeritPrinciple.Source="SELECT * FROM [Merit Principle Registration]"
MeritPrinciple.CursorType = 0
MeritPrinciple.CursorLocation = 2
MeritPrinciple.LockType = 1
MeritPrinciple.OPen()
MeritPrinciple_NumRows = 0
%>

<%
MeritPrinciple.Close()
Set MeritPrinciple = Nothing
%>

for some reason it keeps referring to this particular part of the code

MeritPrinciple.ActiveConnection=MM_HCMAP_STRING

Can someone help me please.

[Richard Conyard]

From the looks of it you're passing it the connection string rather than a connection object.

Dim objConn
set objConn = server.createObject("ADODB.Connection")
objConn.open( MM_HCMAP_STRING )

MeritPrinciple.ActiveConnection = objConn