PHP and ms Access

[dschroeder]

OK, you convinced me that I had to use PHP to do a server side export and save of a chart.  Where is the dbconn.php for an Access database?

[Guest Basundhara Ghosal]

Hi,

Please refer to the Includes folder FusionCharts for the same.

Ref.- FusionCharts_Evaluation > Code > PHP > Includes > DBConn.php

Hope this helps.

[srividya_sharma]

Hi

You could easily modify the DBConn.php to connect to the MS Access database.

Here is a simple piece of code to connect to the database:

$db = 'C:Program FilesMicrosoft OfficeOffice10SamplesNorthwind.mdb';

$conn = new COM('ADODB.Connection') or exit('Cannot start ADO.');

// Connect
$conn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=$db") or exit('Cannot open with driver.');

Hope this helps.

Srividya

[dschroeder]

That one is for mySQL - is there no difference?

[dschroeder]

Thanks, the modified code included in the post will help. 

[Guest Basundhara Ghosal]

Hi,

We are happy to help you.