国产一级a片免费看高清,亚洲熟女中文字幕在线视频,黄三级高清在线播放,免费黄色视频在线看

Dreamweaver連接數(shù)據(jù)庫教程（ASP類）

注意，后臺(tái)語言不同的話連接數(shù)據(jù)庫的方法也不相同，

下面的這些方法都是在Dreamweaver中ASP連接數(shù)據(jù)庫的方法

ASP連接 Access 數(shù)據(jù)庫方法：


這是用相對(duì)路徑的： <% Set Conn=Server.CreateObject("ADODB.Connection") ConnStr="provider=Microsoft.jet.oledb.4.0;data Source="&Server.MapPath("database/data.mdb") Conn.Open ConnStr %>

下面的幾種是其它常用數(shù)據(jù)庫的連接方法,有需要的話可以看看

DSN
Conn.Open "DSN=AdvWorks;"&_
"Uid=Admin;"&_
"Pwd=;"
DSN文件
Conn.Open "FILEDSN=c:\somepath\mydb.dsn;" & _
"Uid=Admin;" & _
"Pwd=;"

ACCESS
Conn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=c:\somepath\mydb.mdb;" & _
"Uid=Admin;" & _
"Pwd=;"

Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\somepath\myDb.mdb;" & _
"User Id=admin;" & _
"Password=;"
VF

Conn.Open "Driver={Microsoft Visual FoxPro Driver};" & _
"SourceType=DBF;" & _
"SourceDB=c:\somepath\mySourceDbFolder;" & _
"Exclusive=No;"

Excel
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\somepath\myExcelSpreadsheet.xls;" & _
"Extended Properties=""Excel 8.0;HDR=Yes;"";"

sql
Conn.Open "Provider=MSDASQL;" & _
"Driver={SQL Server};" & _
"Server=myServerName;" & _
"Database=myDatabaseName;" & _
"Uid=myUsername;" & _
"Pwd=myPassword;"

Oracle
Conn.Open "Provider=OraOLEDB.Oracle;" & _
"Data Source=MyOracleDB;" & _
"User Id=myUsername;" & _
"Password=myPassword;"