<%@language="JSCRIPT"%>
<%
var dbConn =new ActiveXObject("adodb.connection");
dbConn.Open("Provider=SQLOLEDB; User ID=test; Password=test; Initial Catalog=test; Data Source=(local);");
%>
<%
var dbConn =new ActiveXObject("adodb.connection");
dbConn.Open("Provider=SQLOLEDB; User ID=test; Password=test; Initial Catalog=test; Data Source=(local);");
%>
还要保证数据库服务器是运行的,用户名密码是正确的,IP地址是正确的……楼主还是把失败原因贴出来吧
<%
set conn = Server.CreateObject("ADODB.Connection")
conn.Open("PROVIDER=SQLOLEDB;DATA SOURCE=(local);UID=sa;PWD=you;DATABASE=2007bysj")%>
是没有问题可以连接的 证明sql正常 现在是改为 js的话就不行
<%
try
{
var dbConn =new ActiveXObject("adodb.connection");
dbConn.Open("Provider=SQLOLEDB; User ID=test; Password=test; Initial Catalog=test; Data Source=(local);");}
catch (e)
{
Response.Write(e.description)
}
%>
ACCESS:
OLEDB:
var conn= "Provider=Microsoft.Jet.OLEDB.4.0;persist security info=false;Data source="+
Server.MapPath("data/shawlqiu.mdb");
MSSQL:
OLEDB:
var conn="provider=sqloledb;data source=shawl;user id=unstr; password=pwdstr;persist security info=false;initial catalog=shawl"
Vbscript:
ACCESS:
OLEDB:
dim conn
conn = "Provider=Microsoft.Jet.OLEDB.4.0;Data source="&Server.MapPath("/Data/data.mdb")
MSSQL:
OLEDB:
dim conn
conn="provider=sqloledb;data source=shawl;user id=unstr; password=pwsstr;persist security info=false;initial catalog=shawl"
c# .net
public static string Conn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+
@HttpContext.Current.Server.MapPath("/data/#data.mdb");