asp连接access,sqlserver2000和sqlserver2005

作者:admin 日期:2008-04-11

字体大小: 小中大

    select case dbtype
    case "access"
        db="/database/database.mdb"      '数据库文件的位置
        connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(db)
    case "sql2000"
        connstr= "driver={SQL Server};server=127.0.0.1;uid=sa;pwd=;database=law"
    case "sql2005"
        connstr  = "Provider=SQLNCLI;Server=127.0.0.1;Database=law;Uid=sa;Pwd=;"
    end select
    conn.Open connstr