Question

急！DW做的网站本地测试成功，传到虚拟服务器上链接不到数据库！

代码是：
<%@LANGUAGE="JAVASCRIPT"%>
<!--#include file="Connections/sdy.asp" -->
<%
var jiuyexinxi = Server.CreateObject("ADODB.Recordset");
jiuyexinxi.ActiveConnection = MM_sdy_STRING;
jiuyexinxi.Source = "SELECT * FROM zhaopinxinxi ORDER BY ID DESC";
jiuyexinxi.CursorType = 0;
jiuyexinxi.CursorLocation = 2;
jiuyexinxi.LockType = 1;
jiuyexinxi.Open();
var jiuyexinxi_numRows = 0;
%>

file="Connections/sdy.asp"的代码是：
<%
// FileName="Connection_odbc_conn_dsn.htm"
// Type="ADO"
// DesigntimeType="ADO"
// HTTP="false"
// Catalog=""
// Schema=""
var MM_sdy_STRING = "dsn=sdy;"
%>

Answer 1

你用的是不是先在本加添加数据源，再用DW里的“数据源名称”来连接数据库的？那样的话就会出问题。要用自定义连接字符串的，代码如下：
Quotation
Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;

Answer 2

检查数据库连接路径