[分享]用數據源(用數據源(ODBC)創建數據庫連接DSN設置)創建數據庫連接DSN設置
Asp連接數據庫推薦用ACCESS+MSSQL / ASP+ACCESS Conn.open=”provider=microsoft.jet.oledb.4.0;data source=”&server.mappath(“數據庫路徑”) ASP+MSSQL Conn.open=”provider=sqloledb;server=127.0.0.1;uid=sa;pwd=admin;database=wm” ASP+MYSQL conn.open="driver={MYSQLODBC 3.51 DRIVER};uid=root;pwd=;database=HR_MOVE;server=127.0.0.1" ASP+SQLITE A conn.open="DSN=SQL_WM;DRIVER={SQLite3 ODBC Driver}" B conn.open="DRIVER={SQLite3 ODBC Driver};DATABASE=D:\SQLITE\WWWW" ASP+PostgreSQL conn.open="DRIVER={PostgreSQL ANSI};server=127.0.0.1;uid=itnows;pwd=000000;database=test1" php連接數據庫推薦用PHP+MYSQL PHP+ACCESS $conn = new com("ADODB.Connection"); $connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("workermove.mdb"); $conn->Open($connstr); $rs = new com("ADODB.RecordSet"); $rs->Open(SQL語句,$conn,1,1); PHP+MSSQL $connstr = "DRIVER={SQL SERVER};SERVER=127.0.0.1\GSQL;UID=SA;PWD=ADMIN;DATABASE=WORKMOVE"; $conn->Open($connstr); ?> PHP+MYSQL PHP+SQLITE $db = @sqlite_open("sqlite.db"); 也可調用odbc方式連接sqlite 詳見PHP手冊 PHP+PostgreSQL $conn_string =@pg_connect("host=127.0.0.1 port=5432 dbname=test1 user=itnows password=000000") 關于MYSQL與SQLITE共同提取5151筆資料時間比較 次數 MYSQL SQLITE (單位，毫秒) 1 467.59 325.57 69.6% 2 509.15 333.10 65.4% 3 487.99 326.93 66.9% 4 511.35 352.47 68.9% 5 500.42 328.93 65.7% 補充： SQLite數據庫在ASP下使用，先要裝ODBC的驅動。才能set conn=server.createobject("adodb.connection")。 到這邊下載sqlite的odbc驅動程序安裝下就可以使用了
connstr="driver={sqlite3 odbc driver};database="&server.MapPath("data.db3")
|
|||
| >> 相關文章 | |||
|
|||
浙公網安備 33048302000166號
