Ronan,
Check these:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q306269
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q174943
It's most likely an issue with how you have your DSN setup or how apache is
running.
Best regards,
Andrew Hill
Director of Technology Evangelism
http://www.openlinksw.com/virtuoso/whatis.htm
OpenLink Virtuoso Universal Server
-Original Message-
From: ronan cleary [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 6:42 AM
To: [EMAIL PROTECTED]
Subject: [PHP] PHP and MS Access
I am running PHP and Apache and have a problem connecting to an Ms Access
database
I cannot connect to my database. I am using an Apache Server with
PHP. Now
as far as I can see these work fine apart from some dll files in PHP.
I have also set up an ODBC connection to my database, but when I
try and run
the PHP code I get errors.
This is the PHP code I am using. The ODBC is called link1 and the
database
db1.
?php
$db = ODBC_Connect(link1, ,);
$res = ODBC_Exec($db, SELECT Employee.Name FROM Employee;);
while (ODBC_Fetch_Row($res)) {
echo TRTD.ODBC_Result($res, 'fieldname')./TD/TR;
}
ODBC_Free_Result($res);
?
These are the errors that it returns
X-Powered-By: PHP/4.0.6 Content-type: text/html
Warning: 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 o:\program files\apache
group\apache\htdocs\name1.php on line 2
Warning: Supplied argument is not a valid ODBC-Link resource in
o:\program
files\apache group\apache\htdocs\name1.php on line 3
Warning: Supplied argument is not a valid ODBC result resource in
o:\program
files\apache group\apache\htdocs\name1.php on line 4
Warning: Supplied argument is not a valid ODBC result resource in
o:\program
files\apache group\apache\htdocs\name1.php on line 7
Any help on where to go would be great.
Thanks a million
Ronan
_
Join the worlds largest e-mail service with MSN Hotmail.
http://www.hotmail.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[EMAIL PROTECTED] writes:
Anybody have a good tutorial on getting PHP to access a MS Access
Database with ODBC?
I cant even get a connection to succeed.
Check at php.weblogs.com/ADOdb
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

I guess I am gonna have to plead stupid here.
I've never used access, I don't like it, and I think there are much
better tools out
there to do what access does.
We agree...
Having said that, I work in an environment that is almost completely
VBA in either
access or excel.
May god have mercy on your soul...
I need to find a way to query an access database, and I wanted to do
it with a
auto_refresh web page.
But I cant, I cant connect to the database, I cant execute a query,
and maybe I return
the infamous empty yet infinite array.
maybe I should just do it in excel?
No
I think a way could be by trying the ODBC functions of PHP.
See www.php.net/odbc
If you give us more details we might be more of a help.
Sincerely,
Maxim Maletsky
Founder, Chief Developer
PHPBeginner.com (Where PHP Begins)
[EMAIL PROTECTED]
www.phpbeginner.com
If any of you have been able to get this to work, please tell me what
you did to get it
to work, and how you did it.
Thanks,
Rance Hall
308.238.2455
Internal Office Extensions: 2455 or 6655
PC Programmer, The Buckle, Inc.
[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

If you want,
I can give you an ODBC Db abstraction layer.. there are only a few things
not complete on it, it's at abuot 90%
- Original Message -
From: Maxim Maletsky [EMAIL PROTECTED]
To: 'Rance Hall' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, April 02, 2002 6:31 PM
Subject: RE: [PHP] PHP and MS Access
I guess I am gonna have to plead stupid here.
I've never used access, I don't like it, and I think there are much
better tools out
there to do what access does.
We agree...
Having said that, I work in an environment that is almost completely
VBA in either
access or excel.
May god have mercy on your soul...
I need to find a way to query an access database, and I wanted to do
it with a
auto_refresh web page.
But I cant, I cant connect to the database, I cant execute a query,
and maybe I return
the infamous empty yet infinite array.
maybe I should just do it in excel?
No
I think a way could be by trying the ODBC functions of PHP.
See www.php.net/odbc
If you give us more details we might be more of a help.
Sincerely,
Maxim Maletsky
Founder, Chief Developer
PHPBeginner.com (Where PHP Begins)
[EMAIL PROTECTED]
www.phpbeginner.com
If any of you have been able to get this to work, please tell me what
you did to get it
to work, and how you did it.
Thanks,
Rance Hall
308.238.2455
Internal Office Extensions: 2455 or 6655
PC Programmer, The Buckle, Inc.
[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.n=1 H
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php