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.
>
>  $db = ODBC_Connect("link1", "","");
>   $res = ODBC_Exec($db, "SELECT Employee.Name FROM Employee;");
> while (ODBC_Fetch_Row($res)) {
> echo "".ODBC_Result($res, 'fieldname')."";
> }
> 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

[PHP] PHP and MS Access

2002-04-05 Thread ronan cleary 

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.

".ODBC_Result($res, 'fieldname')."";
}
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

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 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

[PHP] PHP and MS Access

2002-04-02 Thread Rance Hall 

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.

Having said that, I work in an environment that is almost completely VBA in either 
access or excel.

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?

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

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 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

[PHP] PHP and MS access

2002-04-02 Thread Rance Hall 

Anybody have a good tutorial on getting PHP to access a MS Access Database with ODBC?

I cant even get a connection to succeed.

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