在MX中怎样建立与SQL SERVER 7.0数据库的连接。我做的连接提示第8行(Recordset1.ActiveConnection = MM_test_STRING)错误。请问是什么原因,怎样该?
如下为文件代码:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_test_STRING
Recordset1.Source = "SELECT * FROM dbo.TABLE1"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()
Recordset1_numRows = 0
%>
Untitled Document
<%=(Recordset1.Fields.Item("name").value)%> |
<%=(Recordset1.Fields.Item("pass").value)%> |
|
|
|
|
|
|
|
<%
Recordset1.Close()
Set Recordset1 = Nothing
%>
Connections/test.asp代码:
<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_test_STRING
MM_test_STRING = "dsn=test;"
%>
在MX中建立与SQL数据库的连接的步骤请说一下。谢谢!