pripojeni MS ACCESS databaze na localhostu

Dobry den, prosim o radu, vubec se mi nedari pripojit databazi MS ACCESS na localhostu. Pouzivam Apache2Triad 1.5.4 s verzi Apache/2.2.0 (Win32) a PHP/5.1.2. Databazi mam ulozenou v htdocs a skript odkud se pripojuji k ni taktez. pro pripojeni jsem zkousel mnoho zpusobu, napr.


$db = 'moje_databaze.mdb';
  $dbpath = realpath ($db);
  $cfg_dsn = "DRIVER=Microsoft Access Driver (*.mdb);
        DBQ=".$dbpath.";UserCommitSync=Yes;
        Threads=3;
        SafeTransactions=0;
        PageTimeout=5;
        MaxScanRows=8;
        MaxBufferSize=2048;
        DriverId=281;";
  $linkid = odbc_connect($cfg_dsn,"","") or die ("Připojení k databázi selhalo. Zkuste to prosím později.");

Ale nejde to, poradte prosim jak na to, dekuji

Odpovědi

Voláš

odbc_connect()

máš, ODBC driver pre Microsoft Access fungujúci pod Linuxom?

uz mi to funguje, spravne to bylo:


function odbc_connect_custom($db)
{

// $dbdir is the location of your databases.
// The main thing to watch out for is permissions.
// The process your web server is running under must
// have read / write permissions to this folder

    $dbdir = "C:\apache2triad\htdocs\mojedatabaze\\";
    
    $cfg_dsn = "DRIVER=Microsoft Access Driver (*.mdb);
        DBQ=".$dbdir.$db.".mdb;UserCommitSync=Yes;
        Threads=3;
        SafeTransactions=0;
        PageTimeout=5;
        MaxScanRows=8;
        MaxBufferSize=2048;
        DriverId=281;
        DefaultDir=C:/ProgramFiles/CommonFiles/ODBC/DataSources";

// The DefaultDir setting will probably be ok if you have gone for 
// a typical installation

    $cfg_dsn_login = "";
    $cfg_dsn_mdp = "";

    return odbc_connect($cfg_dsn,$cfg_dsn_login,$cfg_dsn_mdp);
}

Potreboval bych jeste vedet, zda je mozne databazi v MS ACCESS rozchodit i na hostingu napr. na webzdarma.cz, pripadne jestli nevite kam ji nahrat a co kde zmenit, nastavit?

Dotaz: pripojeni MS ACCESS databaze na localhostu

Odpovědi