连接数据库

[poemGao]

sub openDB()
set conn=server.createobject("ADODB.Connection")
conn.open "DRIVER={&_
SQL Server};SERVER=127.0.0.1;DATABASE=learnasp;UID=sa;PWD="
set rs=server.createobject("ADODB.Recordset")
end sub
sub openDB()
set conn=server.createobject("ADODB.Connection")
conn.provider="microsoft.jet.oledb.4.0"
conn.open server.mappath("learnasp.mdf")
set rs=server.createobject("ADODB.Recordset")
end sub
sub opendb()
set conn=server.createobject("ADODB.Connection")
strprovider="driver={SQL Server};dbq="&server.mappath("\")_&"\learnasp.mdf;uid=sa;pwd=;"
conn.open strprovider
set rs=server.createobject("ADODB.Recordset")
以上三种方法均连接不上数据库
数据库在c:\asp\data\learnasp 登陆窗口在c:\asp\char03\login.htm

[pdsnet]

不是.net的

[wujinjian2008n]

能直接打开数据库吗

[wuyq11]

路径不正确
server.mappath("../../data/learnasp.mdf")

[wuyq11]

那是SQL SERVER数据库，要配置连接字符串
Str="driver={SQL server};server="&StrServer&";uid="&StrUid&";pwd="&StrSaPwd&";database="&StrDbName
set Conn = Server.CreateObject("ADODB.Connection")
set Rs=Server.CreateObject("ADODB.RecordSet")

[itcrazyman]

[Quote=引用 4 楼 wuyq11 的回复:]
那是SQL SERVER数据库，要配置连接字符串
Str="driver={SQL server};server="&StrServer&";uid="&StrUid&";pwd="&StrSaPwd&";database="&StrDbName
set Conn = Server.CreateObject("ADODB.Connection")
set Rs=Server.CreateObject("ADODB.RecordSet")
[/Quote]\
顶