0
I have a problem making a connection with MS Access and PHP, giving an error that I do not know how to fix, someone could 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 mistake is this:
Line 30 is the part of the entire $Conn->Open?
– Bruno Folle
If yes try to change the part of realpath('.. db Dashboard.accdb') to a variable and concatenate the variable in the string to see what the result is here
– Bruno Folle
I already managed to connect to the bank, not directly to it, I linked Access to a msql database and I took the data through this database, I needed the data urgently and I ended up doing this way, but I will test by the way you spoke and put the result here as soon as you give a time, vlw ai :)
– Emmanuel S.
managed to connect, but changing the code, I’ll put it here because if someone also is having difficulty in this already gives a help
– Emmanuel S.
For accdb, if I’m not mistaken, you should install version 12 of MS JET. I’ve had a problem with PHP.
– GilCarvalhoDev