php-windows Digest 26 Nov 2004 22:30:50 -0000 Issue 2484
Topics (messages 25046 through 25048):
Re: Permission deny on connecting MS Access database
25046 by: Luis Moreira
[maybe minor ot] cache probs.
25047 by: Bobo Wieland
HI! can u help me?
25048 by: Kurlic
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
--- Begin Message ---
This is not a PHP error, it's a DB error, and the message is very clear.
Either the database is opened allready, and exclusively, or you have to
give a username/password with sufficient rights, which you are not
doing, with that command.
Luis
Emperor Kang Xi wrote:
Hi all,
I need help to solve my problem, I use ADO to connect MS Access
database; the data is store in another server computer; I have try two
different way to access the data, and below is the code:
-----------------------------------------
//$dbName = "\\SERVER\mdb\mydata.mdb";
$dbName = "X:/mdb/mydata.mdb";
$conn = new COM('ADODB.Connection');
$conn->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=$dbName;Persist Security Info=False");
output:
------------------------------------------
*Warning*: (null)(): Invoke() failed: Exception occurred. *Source*:
Microsoft JET Database Engine *Description*: The Microsoft Jet
database engine cannot open the file 'X:\mdb\mydata.mdb'. It is
already opened exclusively by another user, or you need permission to
view its data.
Thanks
------------------------------------------------------------------------
åç
------------------------------------------------------------------------
Walla! Mail - get your free 1G mail today <http://www.walla.com>
--- End Message ---
--- Begin Message ---
i'm sorry _if_ this is ot...
i use php to communicate between flash and mysql...
in internet explorer (not in opera or fire fox, where eveything works ok)
something goes wrong and flash recives old data that doesn't exist
anymore...
the php page that loads the flash movie displays the correct updated info,
but the php function (in another file) that gets called from flash displayes
old info that doesn't exist anymore...
this is the php function that returns the wrong info:
<code>
function fetchImgUrl() {
global $link_id;
$question = "SELECT path, filename FROM img_tmp WHERE id = 'sortment'";
$result = mysql_query($question, $link_id);
if ($result) {
$img = mysql_fetch_object($result);
if (file_exists("./../img/sort/".$img->filename)) { $rtnVal =
"&error=0&path=".$img->path."&file=".$img->filename; }
else { $rtnVal = "&error=3&arg=".htmlentities("The file
".$img->path.$img->filename." does not exist"); }
} else { $rtnVal = "&error=2"; }
return $rtnVal;
}
</code>
explaination of the code: the mysql table "img_tmp" never holds more than
one row... this row allways have the id "sortment" (this is because if i
decide to expand the functionality in the future).
if (file_exists("./../img/sort/".$img->filename)) { $rtnVal =
"&error=0&path=".$img->path."&file=".$img->filename; }
Now this is really strange... flash recives this info:
"&error=0&path=./../img/sort/path&file=<old file name that doesn't exist
anymore>" this filename points to a file that doesn't exist on the server so
why does the if-statement evaluate to true?!?
any ideas?
_bobo wieland _ [EMAIL PROTECTED] _
winamp >> jeans team feat. mc lan | keine melodien
--- End Message ---
--- Begin Message ---
Hi all!
Can i ask u a question?
Using PHP:
How can i count the files in a folder and obtain their
names?
(i want to produce a script that count the images in a folder and make a
list of them...)
please help me... ^_^
Thank you by Kurlic
--------------------
[EMAIL PROTECTED]
--------------------
--- End Message ---
