Click here to Skip to main content
15,921,697 members
Home / Discussions / Web Development
   

Web Development

 
GeneralRe: Disable BACK button? Pin
devvvy22-May-05 5:42
devvvy22-May-05 5:42 
GeneralRe: Disable BACK button? Pin
Vasudevan Deepak Kumar24-May-05 4:23
Vasudevan Deepak Kumar24-May-05 4:23 
Generalsending data to different pages Pin
tonydevlin20-May-05 9:35
tonydevlin20-May-05 9:35 
GeneralRe: sending data to different pages Pin
Anonymous27-May-05 17:11
Anonymous27-May-05 17:11 
QuestionHow do I find the version number of my PHPBB? Pin
Anonymous20-May-05 8:29
Anonymous20-May-05 8:29 
GeneralJavaScript Error : Unspecified Error Pin
Mighty Booshed20-May-05 3:56
Mighty Booshed20-May-05 3:56 
General"Getting Error while publishing on uddi server programatically" Pin
Member 197389619-May-05 20:36
Member 197389619-May-05 20:36 
QuestionPHP + Access DB = please help? Pin
Member 196994119-May-05 10:36
Member 196994119-May-05 10:36 
I'm trying to set up a PHP page to get a few things from an access database that i've got like 2 things in. Could some one please help me? PHP tutorials are not working? lol i get:


<?php
$conn=odbc_connect('fin','','');

?>
Gives me:
Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data., SQL state S1000 in SQLConnect in c:\Inetpub\wwwroot\index.php on line 10

and

<?
$conn = new COM("ADODB.Connection") or die("Cannot start ADO");

// Microsoft Access connection string.
;$conn->Open("DRIVER={Microsoft Access Driver (*.mdb)};
;DBQ=C:\\inetpub\\wwwroot\\php\\mydb.mdb");

$conn->Open("DRIVER={Microsoft Access Driver (*.mdb)};
DBQ=C:\\inetpub\\wwwroot\\db1.mdb");

// SQL statement to build recordset.
$rs = $conn->Execute("SELECT myfield FROM mytable");
echo "<p>Below is a list of values in the MYDB.MDB database, MYABLE table, MYFIELD field.</p>";

// Display all the values in the records set
while (!$rs->EOF) {
$fv = $rs->Fields("myfield");
echo "Value: ".$fv->value."<br>\n";
$rs->MoveNext();
}
$rs->Close();
?>

Gives me :

Fatal error: Uncaught exception 'com_exception' with message 'Source: Microsoft OLE DB Provider for ODBC Drivers
Description: [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x564 Thread 0x72c DBC 0xb63404 Jet'.' in c:\Inetpub\wwwroot\index.php:13 Stack trace: #0 c:\Inetpub\wwwroot\index.php(13): com->Open('DRIVER={Microso...') #1 {main} thrown in c:\Inetpub\wwwroot\index.php on line 13



i don't know what to do...
AnswerRe: PHP + Access DB = please help? Pin
Vasudevan Deepak Kumar21-May-05 3:06
Vasudevan Deepak Kumar21-May-05 3:06 
GeneralDownloading, editing and uploading files on the fly Pin
Julio Aragao19-May-05 10:05
Julio Aragao19-May-05 10:05 
GeneralRe: Downloading, editing and uploading files on the fly Pin
niansah19-May-05 21:30
niansah19-May-05 21:30 
GeneralRe: Downloading, editing and uploading files on the fly Pin
Julio Aragao20-May-05 2:26
Julio Aragao20-May-05 2:26 
GeneralRe: Downloading, editing and uploading files on the fly Pin
Anonymous27-May-05 17:14
Anonymous27-May-05 17:14 
GeneralProblems redirecting to a frame Pin
brian5519-May-05 7:43
brian5519-May-05 7:43 
GeneralRe: Problems redirecting to a frame Pin
Alsvha22-May-05 23:40
Alsvha22-May-05 23:40 
GeneralEmpty HttpWebResponse length for some urls Pin
Jason Manfield18-May-05 18:11
Jason Manfield18-May-05 18:11 
GeneralRe: Empty HttpWebResponse length for some urls Pin
minhpc_bk19-May-05 19:52
minhpc_bk19-May-05 19:52 
GeneralRe: Empty HttpWebResponse length for some urls Pin
Jason Manfield20-May-05 9:18
Jason Manfield20-May-05 9:18 
GeneralLinefeed in normal text Pin
Brendan Vogt18-May-05 4:42
Brendan Vogt18-May-05 4:42 
GeneralRe: Linefeed in normal text Pin
Ted Ferenc18-May-05 5:30
Ted Ferenc18-May-05 5:30 
GeneralRe: Linefeed in normal text Pin
JKroschel18-May-05 10:49
JKroschel18-May-05 10:49 
GeneralRe: Linefeed in normal text Pin
niansah19-May-05 2:08
niansah19-May-05 2:08 
GeneralRe: Linefeed in normal text Pin
Brendan Vogt19-May-05 2:13
Brendan Vogt19-May-05 2:13 
GeneralRe: Linefeed in normal text Pin
niansah19-May-05 2:22
niansah19-May-05 2:22 
GeneralRe: Linefeed in normal text Pin
d_vaibhav23-May-05 2:57
d_vaibhav23-May-05 2:57 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.