connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("\hotel system\App_Data\hotel_Date.MDF") & ""
conn = New Data.OleDb.OleDbConnection(connstr)
conn.Open() 提示文件找不到 可明明放在App_Data文件中 全名为hotel_Date.MDF 这是什么回事
conn = New Data.OleDb.OleDbConnection(connstr)
conn.Open() 提示文件找不到 可明明放在App_Data文件中 全名为hotel_Date.MDF 这是什么回事
LZ想通过Office的东西,打开数据库文件?
str="driver={sql server};server=YOURSQLSERVERNAME;uid=sa;pwd=youpassword;database=hotel"
conn.open(str)
adoconn.Open"Driver={Microsoft Access Driver(*.mdb)};DBQ="& _
Server.MapPath("数据库所在路径") 2.Access OLE DB连接方法: set adocon=Server.Createobject("adodb.connection")
adocon.open"Provider=Microsoft.Jet.OLEDB.4.0;"& _
"Data Source=" & Server.MapPath("数据库所在路径") 3.SQL server连接方法: set adocon=server.createobject("adodb.recordset")
adocon.Open"Driver={SQL Server};Server=(Local);UID=***;PWD=***;"& _
"database=数据库名;" 4.SQL server OLE DB连接方法: set adocon=Server.Createobject("adodb.connection")
adocon.open"provider=SQLOLEDB.1;Data Source=RITANT4;"& _
"user ID=***;Password=***;"& _
"inital Catalog=数据库名"
search.init()
Dim connstr As String
Dim sql As String
Dim mycommand As Data.OleDb.OleDbCommand
Dim conn As Data.OleDb.OleDbConnection
Dim ds As Data.DataSet
Dim da As Data.OleDb.OleDbDataAdapter
connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("\hotel system\App_Data\hotell") & ""
conn = New Data.OleDb.OleDbConnection(connstr)
conn.Open()
sql = "select top 30 * from log "
我的用的是SQL server2000 能不能说个具体点的 楼上都试了还是不行