PHP: <?php//create an instance of the ADO connection object$conn = new COM ("ADODB.Connection") or die("Cannot start ADO");//define connection string, specify database driver$connStr = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source= C:\\wamp\\www\\test1\\database\\directorydb.mdb"; $conn->open($connStr); //Open the connection to the database//declare the SQL statement that will query the database$query = "SELECT Category FROM tblCategories";//execute the SQL statement and return records$rs = $conn->execute($query);$num_columns = $rs->Fields->Count();echo $num_columns . "<br>";for ($i=0; $i < $num_columns; $i++) { $fld[$i] = $rs->Fields($i);}echo "<table>";while (!$rs->EOF) //carry on looping through while there are records{ echo "<tr>"; for ($i=0; $i < $num_columns; $i++) { echo "<td>" . $fld[$i]->value . "</td>"; } echo "</tr>"; $rs->MoveNext(); //move on to the next record}echo "</table>";//close the connection and recordset objects freeing up resources$rs->Close();$conn->Close();$rs = null;$conn = null;?>
I have Create DSN Less Connection. Data Source= C:\\wamp\\www\\test1\\database\\directorydb.mdb"; I have give the full path data base. When the uplode appliction on server. what changes the path Thanaks