Dotaz: pripojeni MS ACCESS databaze na localhostu

[tom]

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

[rastos]

Voláš

odbc_connect()

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

[tom]

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?