Connecting MS Access and PHP

Question

Connecting MS Access and PHP

Navigation

#1 by (1 votes)

0

I have a problem connecting to MS Access and PHP, this is giving an error that I do not know how to fix, could someone help me?

The code is this:

//Abre a conexão asdasda
$conn = new COM('ADODB.Connection') or die('ADO não iniciado');
//linha 30 

   $conn->Open('Provider=Microsoft.Jet.OLEDB.4.0; 
   Data Source='.realpath('..\db\dashboard.accdb').'; 
   Persist Security Info=False;');

//fim da linha 30

//Pronto para utilizar o banco de dados

// Fecha a conexão
$conn->Close();

and the error is this:

php ms-access

asked by anonymous 25.07.2017 / 13:38

1 answer

SQL comparison with values written in different ways Callback from reCaptcha when user is wrong

score 1 · Accepted Answer

One solution is to use PDO , an example:

// Add arquivo e a extensão 
$database_name = $_SERVER["DOCUMENT_ROOT"] . "C:\..\..\..\..\arquivo.accbd"; 
// Check if file exist.
if (!file_exists($database_name )) {
    die("Não foi possível encontrar o arquivo.");
}
// Conecta o banco com o seu projeto.
$db = new PDO("odbc:DRIVER={Microsoft Access Driver (*.mdb, *.accdb)}; DBNAME=$database_name ; username=; password=;");

try {
     $db = new PDO("odbc:DRIVER={Microsoft Access Driver (*.mdb, *.accbd)}; 
     DBNAME=$database_name ; username=; password=;");

     $db ->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
     echo "Sucesso"; 
}
catch(PDOException $e){
      echo "Falha na Conexão: " . $e->getMessage();
}