RE: [PHP] PHP and MS Access
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 worlds 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
Re: [PHP] PHP and MS access
[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
Re: [PHP] PHP and MS access
you can try http://www.accessmysql.com also. Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com |+ || pong-TC | || [EMAIL PROTECTED]| || | ||| || 04/02/02 12:23| || PM| ||| |+ -| | | | To: [EMAIL PROTECTED] | | cc: [EMAIL PROTECTED] | | Subject: Re: [PHP] PHP and MS access | -| [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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP and MS Access
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
