RE: [PHP] PHP and MS Access

2002-04-05 Thread Andrew Hill

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




Re: [PHP] PHP and MS access

2002-04-02 Thread pong-TC

[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

2002-04-02 Thread Daniel Negron/KBE


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

2002-04-02 Thread Maxim Maletsky

 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

2002-04-02 Thread eric.coleman

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




Re: [PHP] PHP with MS Access?

2001-07-08 Thread Henrik Hansen

Jeff Lewis [EMAIL PROTECTED] wrote:

  1.  (*) text/plain  
  
  Anyone have a tutorial or site dealing with PHP and MS Access databases?
  

if you dont have a dns:
http://www.alt-php-faq.org/#id46

if you do:
php.net/odbc

-- 
Henrik Hansen


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]