http://snippets.dzone.com/posts Sun, 12 Oct 2008 17:42:27 GMT DZone Snippets: BDD code http://snippets.dzone.com/posts/show/4345 Conectar con Access / Connect with Access. <br />Código fuente / Source code : <br /> <br /><code> <br />$pathDB = str_replace("/", "\\", $_SERVER["DOCUMENT_ROOT"]) . "\\directory1\\directory2\\bdd.mdb"; <br /> <br />if(!file_exists($pathDB)) <br />{ <br />echo "!!! Base de datos no encontrada ".$pathDB; <br />exit; <br />} <br /> <br />$conexion = odbc_connect("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=".$pathDB, "ADODB.Connection", "", "SQL_CUR_USE_ODBC"); <br />$sql="select * from tabla where 1"; <br />$resultado=odbc_exec($conexion,$sql); <br />if($resultado) <br />{ <br /> while($fila=odbc_fetch_array($resultado)) <br /> { <br /> echo $fila['campo1']."<br />"; <br /> echo $fila['campo2']."<br />"; <br /> } <br />odbc_close_all(); <br />} <br /></code> Mon, 23 Jul 2007 10:55:33 GMT http://snippets.dzone.com/posts/show/4345 Ricardo (Ricardo m. García)