<?
$db = 'C:\\yourLocalDir\\YourDB.mdb';$conn = new COM('ADODB.Connection');// Connect to DB with Password.
$conn->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=$db; Jet OLEDB:Database Password=yourPassword");
// Connect to DB without Password.
//$conn->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=$db");// Your SQL query
$sql = 'Select field1,LastName from table26 where field2=0 order by field1';
$res = $conn->Execute($sql);?>
$db = 'C:\\yourLocalDir\\YourDB.mdb';$conn = new COM('ADODB.Connection');// Connect to DB with Password.
$conn->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=$db; Jet OLEDB:Database Password=yourPassword");
// Connect to DB without Password.
//$conn->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=$db");// Your SQL query
$sql = 'Select field1,LastName from table26 where field2=0 order by field1';
$res = $conn->Execute($sql);?>
以后还上.
下一个问题是:
win98下php操作access中文的问题,从数据库里面搜索出来的是乱码怎么办?
我的解决方法是删了重新添加中文就是中文而不是乱码,如果在2000下输入,而在98下显示就是乱码,啊¬¬¬ 如果这样的话....如何解决这个问题呢?