ASP连接Access是怎样连接的呀？是怎样的的呀？？？快帮我呀！

[great388]

ASP连接Access是怎样连接的呀？
是怎样的的呀？？？
快帮我呀！

[liuyann]

我程序中一段
ACCESS数据库于相同目录下,名字为IFWU_IT_KPI.mdb

connstring = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("IFWU_IT_KPI.mdb")

set conn = server.createObject("ADODB.Connection")
conn.open connstring

[OracleRoob]

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source= c:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb;"

[rzysl]

'连接并打开rzxsk.mdb数据库,连接数据库的路径最好不要用绝对路径
set conn=server.CreateObject("adodb.connection")
cs="Provider=Microsoft.jet.OLEDB.4.0;Data Source="
conn.ConnectionString=cs&Server.MapPath("rzxsk.mdb")
conn.open

'打开数据库中的xscjk表格
sSQL="select * from xscjk
set rs=server.CreateObject("adodb.recordset")
rs.open sSQL,conn

[changechange]

关于此主题请参考：
关于jet db的连接字串，以及加密后的字串《ADO/DAO》
http://access911.net/index.asp?u1=a&u2=72FABF1E10DC

[li_hui_hui]

我用asp.net 和access 进行连接下面是我的原码：不知道asp.net和asp像不像

%%%连接数据库%%%%%
string strConnection ="Provider = Microsoft.Jet.OleDb.4.0;";
strConnection +=@"Data Source = C:\Visual Studio Projects\database\citydab.mdb";

myConnection = new System.Data.OleDb.OleDbConnection(strConnection);
myConnection.Open();
%%%%读入表格数据存入dataset%%%%%%%%
myDataSet = new System.Data.DataSet();
myDataSet.CaseSensitive = true;

myCommand = new System.Data.OleDb.OleDbCommand();
myCommand.Connection = myConnection;
myCommand.CommandText = "Select * from city";

DataAdapter = new System.Data.OleDb.OleDbDataAdapter();
DataAdapter.SelectCommand = myCommand;
DataAdapter.TableMappings.Add("Table","city");
DataAdapter.Fill(myDataSet);