asp連接Access數據庫(ODBC)
?set conn=server.createobject("adodb.connection")
?dbPath="config/bloo.mdb"
?connStr="Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath(DBpath)
?conn.open connStr
asp連接Access數據庫(OleDb)
?set conn=server.createobject("adodb.connection")
?dbPath="config/bloo.mdb"
?connStr="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath(DBpath)
?conn.open connStr
asp連接SQL Server數據庫(ODBC)
?set conn=server.createobject("adodb.connection")
?connStr="Driver={SQL Server};Server=(Local);UID=sa;PWD=sa;database=system;"
?conn.open connStr
asp連接SQL Server數據庫(OleDb)
?set conn=server.createobject("adodb.connection")
?connStr="Provider=SQLOLEDB.1;User ID=sa;Password=sa;Data Source=(local);Initial Catalog=system;"
?conn.open connStr
asp連接DM數據庫(ODBC)
?set conn=server.createobject("adodb.connection")
?connStr="DSN=***;DRIVER={DM ODBC DRIVER};DATABASE=SYSTEM;UID=SYSDBA;PWD=SYSDBA;"
?conn.open connStr
asp.net連接DM數據庫(ODBC)
?Driver={DM ODBC Driver}; Server=localhost; Database=SYSTEM; UID=SYSDBA; PWD=SYSDBA;
asp.net連接DM數據庫(OleDb)
?Provider=DMOLEDB.1; Data Source=localhost; Initial Catalog=SYSTEM; User Id=SYSDBA; Password=SYSDBA; Port=1433
?或
?Provider=DMOLEDB.1; Data Source=localhost; Initial Catalog=SYSTEM; User Id=SYSDBA; Password=SYSDBA;
轉貼
posted on 2006-08-08 16:03
fly 閱讀(277)
評論(0) 編輯 收藏 所屬分類:
ASP學習