var cndb = new ActiveXObject("adodb.connection");
cndb.Open("Provider=SQLOLEDB;Data Source=myserversip\\myserversinstance;User
ID=myusername;Password=mypass");
cndb.Open("Provider=SQLOLEDB;Data Source=myserversip\\myserversinstance;User
ID=myusername;Password=mypass");
<HTML>
<BODY>
<TITLE>ASP+JSCRIPT</TITLE>
<SCRIPT LANGUAGE="JSCRIPT" RUNAT="Server">
Response.write('<TABLE border="1" cellspacing="0" cellpadding="0">');
var sSQL = 'SELECT * FROM authors';
var oConn= new ActiveXObject("ADODB.Connection");
oConn.Open('Provider=SQLOLEDB;Server=(local);Database=pubs;UID=sa;PWD=;');
var rs = oConn.Execute(sSQL);
var i;
Response.write('<tr>');
for (i = 0; i < rs.Fields.Count - 1; i++)
{
Response.write('<td>' + rs(i).Name + '</td>');
}
Response.write('</tr>'); while (!rs.EOF)
{
Response.write('<tr>');
for (i = 0; i < rs.Fields.Count - 1; i++)
{
Response.write('<td>' + rs(i).Value + '</td>');
}
Response.write('</tr>');
rs.MoveNext();
}
rs.Close();
oConn.Close();
rs=null;
oConn = null;
Response.write('</TABLE>');
</SCRIPT>
</BODY>
</HTML>
<%@ language=javascript %>
<%
var oConn= new ActiveXObject("ADODB.Connection");
oConn.Open('Provider=SQLOLEDB;Server=(local);Database=test;UID=sa;PWD=XXX;');
var sSQL = 'SELECT * FROM authors';
var rs = oConn.Execute(sSQL);
%>
我用的是本地服务器..数据库为:test 可是用上面用这种方法我查不到数据库中的记录啊.??