資料庫連線字串

張貼日期:Mar 10, 2010 3:49:6 PM

'資料庫連線字串Access模式

Dim myConnString

myConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("/db/dbname.mdb") & ";Jet OLEDB:Database Password=jackson_design"

'MSSQL模式

myConnString = "Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=dbname;User ID=sa;Password=1234;"