Does PHP5 support querying an MS Access MDE file?

Hello,

I have PHP Version 5.2.6-1+lenny3

I have been having difficulty using odbc_connect with an MS Access MDE
database. I do have php5-mysql and php5-odbc installed on this server.

Due to the rather poor search results regarding the topic of querying MDE
files with PHP, I am becoming increasingly concerned that this file type
is not supported.

Is it possible to query an MDE file via PHP5 or should I try different
approach to querying the database from our linux server? I am interested
in your thoughts.

Thanks for your help.

Tim Legg


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Does PHP5 support querying an MS Access MDE file?

2009/11/2 Timothy Legg :
> Hello,
>
> I have PHP Version 5.2.6-1+lenny3
>
> I have been having difficulty using odbc_connect with an MS Access MDE
> database.  I do have php5-mysql and php5-odbc installed on this serv=
er.
>
> Due to the rather poor search results regarding the topic of querying MDE
> files with PHP, I am becoming increasingly concerned that this file type
> is not supported.
>
> Is it possible to query an MDE file via PHP5 or should I try different
> approach to querying the database from our linux server?  I am inter=
ested
> in your thoughts.
>
> Thanks for your help.
>
> Tim Legg
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

If you have the MS Access ODBC driver installed, then have you tried
accessing the MDE as an MDB?



--=20
-----
Richard Quadling
"Standing on the shoulders of some very clever giants!"
EE : http://www.experts-exchange.com/M_248814.html
Zend Certified Engineer : http://zend.com/zce.php?c=3DZEND002498&r=3D213474=
731
ZOPA : http://uk.zopa.com/member/RQuadling

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Does PHP5 support querying an MS Access MDE file?

> 2009/11/2 Timothy Legg :
>> Hello,
>>
>> I have PHP Version 5.2.6-1+lenny3
>>
>> I have been having difficulty using odbc_connect with an MS Access MDE
>> database. Â I do have php5-mysql and php5-odbc installed on this server.
>>
>> Due to the rather poor search results regarding the topic of querying
>> MDE
>> files with PHP, I am becoming increasingly concerned that this file type
>> is not supported.
>>
>> Is it possible to query an MDE file via PHP5 or should I try different
>> approach to querying the database from our linux server? Â I am
>> interested
>> in your thoughts.
>>
>> Thanks for your help.
>>
>> Tim Legg
>>
>
> If you have the MS Access ODBC driver installed, then have you tried
> accessing the MDE as an MDB?
>

Yes, I have. The username and password are arbitrarily set since the
management hasn't provided that data for me yet. But I am not far enough
along to have run into a user rights issue. I get a warning and also an
error upon interpreting the page. I have checked the path to the database
file, and it is correct. I also checked file ownership and readability
permissions, too. So maybe the name of the driver is wrong; it does look
a little verbose to me, but it did come straight from the php.net online
documentation.

Error messages and source is below. Sorry, I modified the domain name in
the path for privacy.

Warning: odbc_connect() [function.odbc-connect]: SQL error:
[unixODBC][Driver Manager]Data source name not found, and no default
driver specified, SQL state IM002 in SQLConnect in
/var/www/www.example.com/ht-secure/database_entry/test.php on line 9


$mdbFilename = "/root/tims_db.mde";
$user = "root";
$password = "1248163264";

$connection = odbc_connect("Driver={Microsoft Access Driver
(*.mdb)};Dbq=$mdbFilename", $user, $password);

?>

Thanks for looking this over,

Tim Legg

>
>
> --
> -----
> Richard Quadling
> "Standing on the shoulders of some very clever giants!"
> EE : http://www.experts-exchange.com/M_248814.html
> Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731
> ZOPA : http://uk.zopa.com/member/RQuadling
>



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Does PHP5 support querying an MS Access MDE file?

2009/11/3 Timothy Legg :
>> 2009/11/2 Timothy Legg :
>>> Hello,
>>>
>>> I have PHP Version 5.2.6-1+lenny3
>>>
>>> I have been having difficulty using odbc_connect with an MS Access MDE
>>> database. Â I do have php5-mysql and php5-odbc installed on this s=
erver.
>>>
>>> Due to the rather poor search results regarding the topic of querying
>>> MDE
>>> files with PHP, I am becoming increasingly concerned that this file typ=
e
>>> is not supported.
>>>
>>> Is it possible to query an MDE file via PHP5 or should I try different
>>> approach to querying the database from our linux server? Â I am
>>> interested
>>> in your thoughts.
>>>
>>> Thanks for your help.
>>>
>>> Tim Legg
>>>
>>
>> If you have the MS Access ODBC driver installed, then have you tried
>> accessing the MDE as an MDB?
>>
>
> Yes, I have.  The username and password are arbitrarily set since th=
e
> management hasn't provided that data for me yet.  But I am not far e=
nough
> along to have run into a user rights issue.  I get a warning and als=
o an
> error upon interpreting the page.  I have checked the path to the da=
tabase
> file, and it is correct.  I also checked file ownership and readabil=
ity
> permissions, too.  So maybe the name of the driver is wrong; it does=
look
> a little verbose to me, but it did come straight from the php.net online
> documentation.
>
> Error messages and source is below.  Sorry, I modified the domain na=
me in
> the path for privacy.
>
> Warning: odbc_connect() [function.odbc-connect]: SQL error:
> [unixODBC][Driver Manager]Data source name not found, and no default
> driver specified, SQL state IM002 in SQLConnect in
> /var/www/www.example.com/ht-secure/database_entry/test.php on line 9
>
>
> > $mdbFilename =3D "/root/tims_db.mde";
> $user =3D "root";
> $password =3D "1248163264";
>
> $connection =3D odbc_connect("Driver=3D{Microsoft Access Driver
> (*.mdb)};Dbq=3D$mdbFilename", $user, $password);
>
> ?>
>
> Thanks for looking this over,
>
> Tim Legg
>
>>
>>
>> --
>> -----
>> Richard Quadling
>> "Standing on the shoulders of some very clever giants!"
>> EE : http://www.experts-exchange.com/M_248814.html
>> Zend Certified Engineer : http://zend.com/zce.php?c=3DZEND002498&r=3D213=
474731
>> ZOPA : http://uk.zopa.com/member/RQuadling
>>
>
>
>

You've got odbc, but probably not a driver for MS Access.

You need both.

I can't seem to find a unix driver for MSAccess.

Converting to a different DB would help (mysql, sqlite).

--=20
-----
Richard Quadling
"Standing on the shoulders of some very clever giants!"
EE : http://www.experts-exchange.com/M_248814.html
Zend Certified Engineer : http://zend.com/zce.php?c=3DZEND002498&r=3D213474=
731
ZOPA : http://uk.zopa.com/member/RQuadling

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Does PHP5 support querying an MS Access MDE file?

> 2009/11/3 Timothy Legg :
> >> 2009/11/2 Timothy Legg :
> >>> Hello,
> >>>
> >>> I have PHP Version 5.2.6-1+lenny3
> >>>
> >>> I have been having difficulty using odbc_connect with an MS Access MD=
E
> >>> database. =C2 I do have php5-mysql and php5-odbc installed on this se=
rver.
> >>>
> >>> Due to the rather poor search results regarding the topic of querying
> >>> MDE
> >>> files with PHP, I am becoming increasingly concerned that this file t=
ype
> >>> is not supported.
> >>>
> >>> Is it possible to query an MDE file via PHP5 or should I try differen=
t
> >>> approach to querying the database from our linux server? =C2 I am
> >>> interested
> >>> in your thoughts.
> >>>
> >>> Thanks for your help.
> >>>
> >>> Tim Legg
> >>>
> >>
> >> If you have the MS Access ODBC driver installed, then have you tried
> >> accessing the MDE as an MDB?
> >>
> >
> > Yes, I have. =A0The username and password are arbitrarily set since the
> > management hasn't provided that data for me yet. =A0But I am not far en=
ough
> > along to have run into a user rights issue. =A0I get a warning and also=
an
> > error upon interpreting the page. =A0I have checked the path to the dat=
abase
> > file, and it is correct. =A0I also checked file ownership and readabili=
ty
> > permissions, too. =A0So maybe the name of the driver is wrong; it does =
look
> > a little verbose to me, but it did come straight from the php.net onlin=
e
> > documentation.
> >
> > Error messages and source is below. =A0Sorry, I modified the domain nam=
e in
> > the path for privacy.
> >
> > Warning: odbc_connect() [function.odbc-connect]: SQL error:
> > [unixODBC][Driver Manager]Data source name not found, and no default
> > driver specified, SQL state IM002 in SQLConnect in
> > /var/www/www.example.com/ht-secure/database_entry/test.php on line 9
> >
> >
> > > > $mdbFilename =3D "/root/tims_db.mde";
> > $user =3D "root";
> > $password =3D "1248163264";
> >
> > $connection =3D odbc_connect("Driver=3D{Microsoft Access Driver
> > (*.mdb)};Dbq=3D$mdbFilename", $user, $password);
> >
> > ?>
> >
> > Thanks for looking this over,
> >
> > Tim Legg
> >
> >>
> >>
> >> --
> >> -----
> >> Richard Quadling
> >> "Standing on the shoulders of some very clever giants!"
> >> EE : http://www.experts-exchange.com/M_248814.html
> >> Zend Certified Engineer : http://zend.com/zce.php?c=3DZEND002498&r=3D2=
13474731
> >> ZOPA : http://uk.zopa.com/member/RQuadling
> >>
> >
> >
> >
>=20
> You've got odbc, but probably not a driver for MS Access.
>=20
> You need both.
>=20
> I can't seem to find a unix driver for MSAccess.
>=20
> Converting to a different DB would help (mysql, sqlite).

I had a similar problem. I had to access (pardon the pun) a very old MS
Access db. Being on x64 windows ODBC is not an option, so in the end I
used OpenOffice.org with a java driver to open it and copy data to MySQL.

> --=20
> -----
> Richard Quadling
> "Standing on the shoulders of some very clever giants!"
> EE : http://www.experts-exchange.com/M_248814.html
> Zend Certified Engineer : http://zend.com/zce.php?c=3DZEND002498&r=3D2134=
74731
> ZOPA : http://uk.zopa.com/member/RQuadling
>=20
> --=20
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>=20

--
Niel Archer
niel.archer (at) blueyonder.co.uk



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Does PHP5 support querying an MS Access MDE file?

On Wed, Nov 4, 2009 at 3:44 AM, Niel Archer wrote:
>> 2009/11/3 Timothy Legg :
>> >> 2009/11/2 Timothy Legg :
>> >>> Hello,
>> >>>
>> >>> I have PHP Version 5.2.6-1+lenny3
>> >>>
>> >>> I have been having difficulty using odbc_connect with an MS Access M=
DE
>> >>> database. =C2 I do have php5-mysql and php5-odbc installed on this s=
erver.
>> >>>
>> >>> Due to the rather poor search results regarding the topic of queryin=
g
>> >>> MDE
>> >>> files with PHP, I am becoming increasingly concerned that this file =
type
>> >>> is not supported.
>> >>>
>> >>> Is it possible to query an MDE file via PHP5 or should I try differe=
nt
>> >>> approach to querying the database from our linux server? =C2 I am
>> >>> interested
>> >>> in your thoughts.
>> >>>
>> >>> Thanks for your help.
>> >>>
>> >>> Tim Legg
>> >>>
>> >>
>> >> If you have the MS Access ODBC driver installed, then have you tried
>> >> accessing the MDE as an MDB?
>> >>
>> >
>> > Yes, I have. =A0The username and password are arbitrarily set since th=
e
>> > management hasn't provided that data for me yet. =A0But I am not far e=
nough
>> > along to have run into a user rights issue. =A0I get a warning and als=
o an
>> > error upon interpreting the page. =A0I have checked the path to the da=
tabase
>> > file, and it is correct. =A0I also checked file ownership and readabil=
ity
>> > permissions, too. =A0So maybe the name of the driver is wrong; it does=
look
>> > a little verbose to me, but it did come straight from the php.net onli=
ne
>> > documentation.
>> >
>> > Error messages and source is below. =A0Sorry, I modified the domain na=
me in
>> > the path for privacy.
>> >
>> > Warning: odbc_connect() [function.odbc-connect]: SQL error:
>> > [unixODBC][Driver Manager]Data source name not found, and no default
>> > driver specified, SQL state IM002 in SQLConnect in
>> > /var/www/www.example.com/ht-secure/database_entry/test.php on line 9
>> >
>> >
>> > >> > $mdbFilename =3D "/root/tims_db.mde";
>> > $user =3D "root";
>> > $password =3D "1248163264";
>> >
>> > $connection =3D odbc_connect("Driver=3D{Microsoft Access Driver
>> > (*.mdb)};Dbq=3D$mdbFilename", $user, $password);
>> >
>> > ?>
>> >
>> > Thanks for looking this over,
>> >
>> > Tim Legg
>> >
>> >>
>> >>
>> >> --
>> >> -----
>> >> Richard Quadling
>> >> "Standing on the shoulders of some very clever giants!"
>> >> EE : http://www.experts-exchange.com/M_248814.html
>> >> Zend Certified Engineer : http://zend.com/zce.php?c=3DZEND002498&r=3D=
213474731
>> >> ZOPA : http://uk.zopa.com/member/RQuadling
>> >>
>> >
>> >
>> >
>>
>> You've got odbc, but probably not a driver for MS Access.
>>
>> You need both.
>>
>> I can't seem to find a unix driver for MSAccess.
>>
>> Converting to a different DB would help (mysql, sqlite).
>
> I had a similar problem. I had to access (pardon the pun) a very old MS
> Access db. Being on x64 windows ODBC is not an option, so in the end I
> used OpenOffice.org with a java driver to open it and copy data to MySQL.
>
>> --
>> -----
>> Richard Quadling
>> "Standing on the shoulders of some very clever giants!"
>> EE : http://www.experts-exchange.com/M_248814.html
>> Zend Certified Engineer : http://zend.com/zce.php?c=3DZEND002498&r=3D213=
474731
>> ZOPA : http://uk.zopa.com/member/RQuadling
>>
>> --
>> PHP Database Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>
> --
> Niel Archer
> niel.archer (at) blueyonder.co.uk
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>

NICE IDE,,,
i think for convert it to xml, and extract the array varaible from
tabel and field to destination place. Better than export this to JAVA,
i feel client will depressed face (imagine: moment at stomach seek,,
heheheh :)) Just kiding ), coz the work procedure is so long,,,

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php