<% 
dim connstr
dim conn2
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&server.mappath("mydb.mdb")&";Persist Security Info=False;"
'connstr="Provider=SQLOLEDB.1;User ID=sa;Password=123;Data Source=127.0.0.1;DataBase=xz_db_8002" 
set conn2=server.createobject("ADODB.CONNECTION")
conn2.open connstr
%>  






