OBDC DSN- less 方式 Access

Set conn = Server.CreateObject("ADODB.Connection") conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq="&Server.MapPath("/fpdb/UniversalDB.mdb")

OBDC DSN-less 方式 SQL

Set conn = Server.CreateObject("ADODB.Connection") conn.Open "driver={SQL Server};Server=(Local);UID=XXXX;PWD=YYYY;database="&Server.MapPath("/fpdb/UniversalDB.mdb")&";" Server.MapPath("/fpdb/UniversalDB.mdb")

OLE DB 方式 Access

Set conn = Server.CreateObject("ADODB.Connection") conn.Open "driver={Microsoft.Jet.OLEDB.4.0; Data Source="&Server.MapPath("/fpdb/UniversalDB.mdb")

OLE DB 方式 SQL

Set conn = Server.CreateObject("ADODB.Connection") conn.Open "driver={SQL Server};Server=(Local);UID=XXXX;PWD=YYYY;database="&Server.MapPath("/fpdb/UniversalDB.mdb")&";" Server.MapPath("/fpdb/UniversalDB.mdb")

實際有連到的範例 <% Set conn_Kwell = Server.CreateObject("ADODB.connection") conn_Kwell.open "Provider=SQLOLEDB.1;Data Source=test-server;User ID=SEN;Password=8621030;Initial Catalog=trdata" %> 　 <% Set conn_UniversalDB = Server.CreateObject("ADODB.connection") DBpath = "Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\tristar\fpdb\UniversalDB.mdb" conn_UniversalDB.open DBpath %>

　

　

Set MemberRS = Server.CreateObject("ADODB.Recordset")

MemberSQL = "SELECT ChineseName, Skill FROM members WHERE UserID = '" &Service& "'"

MemberRS.Open MemberSQL, conn2, 1,1