Where to put MSAccess database for db_layer_access

QuestionsWhere to put MSAccess database for db_layer_access
C3media asked 7 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 7 years ago

Best,

Where to put file.mdb?

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

Abu Ghufran answered 7 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 7 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:password@hostname/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 7 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 7 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

1 + 17 =

Login with your Social Id:

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 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

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

Let us improve this post!

Tell us how we can improve this post?