1. 用Asp链接access数据库
使用ODBC: "dsn=baogao;uid=用户名;pwd=密码;"
使用OLE DB: "Driver={Microsoft Access Driver(*.mdb)};Dbq=/somepath/mydb.mdb;Uid=Admin;Pwd=password;"
2. 用Asp链接Sql Server 数据库
"Driver={SQL Server};Server=ServerName;Uid=xxxx;Pwd=xxxx;DataBase=DataBaseName"
3. 用php链接access数据库<? $dbc=new com("adodb.connection"); $dbc->open("driver=microsoft access driver (*.mdb);dbq=/path/db.mdb;Uid=Admin;Pwd=password;"); $rs=$dbc->execute("select * from tablename"); $i=0; while (!$rs->eof){ $i+=1 $fld0=$rs->fields["UserName"]; $fld0=$rs->fields["Password"]; .... echo "$fld0->value $fld1->value ...."; $rs->movenext(); } $rs->close(); ?>
