Where to put MSAccess database for db_layer_access

QuestionsWhere to put MSAccess database for db_layer_access
C3media asked 2 years ago

Hello,

In db_layer for access there is it code:

$db_conf["server"] = "odbc:Driver={Microsoft Access Driver (*.mdb)};Dbq=".dirname(__FILE__)."/../../sampledb/northwind.MDB;Uid=;Pwd=;";

Then, where is this folder specifically?

Thank you

5 Answers
C3media answered 2 years ago

Best,

Where to put file.mdb?

There is option to use FTP connection, or by LAN?

Abu Ghufran answered 2 years ago

This path is relative to the jqgrid_dist.php folder location.
You can specify it relative like above or absolule too, like c:/test/test.mbd OR in linux /opt/test/test.mdb

C3media answered 2 years ago

Ok Abu,

Thank you by you explain, equally would be interesting to read file using FTP; so this is way i´m doing it:

<?php
$filename = 'ftp://username:[email protected]/files/path/and/name.txt&#039;;
$handle = fopen($filename, "r");
$contents = fread($handle, filesize($filename));
fclose($handle);
echo $contents;
?>

This is correct to integrate with grid?

Thank you!

Abu Ghufran answered 2 years ago

I don't understand your complete scenario, but you can download the file using ftp and give local path of database for php grid.

C3media answered 2 years ago

Thank you Abu, explain you…

My scenario is based in database from NVR server and database save rows using NVR software. Then my grid take it table rows for other operations.

Thank you!

Your Answer

8 + 5 =

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating / 5. Vote count:

As you found this post useful...

Follow us on social media!

We are sorry that this post was not useful for you!

Let us improve this post!