p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

beginning_php thread: Using Access 2000 in PHP without ODBC driver


Message #1 by =?iso-8859-1?q?tan=20chek=20seng?= <tcs_mmu@y...> on Tue, 15 Jan 2002 06:05:38 +0000 (GMT)
hello, can i access *.mdb file without ODBC driver coz

my uni do not allow me to do so.I need a solution urgent!!



__________________________________________________

Do You Yahoo!?

Everything you'll ever need on one web page

from News and Sport to Email and Music Charts

http://uk.my.yahoo.com

Message #2 by "Nikolai Devereaux" <yomama@u...> on Tue, 15 Jan 2002 00:28:01 -0800

A couple of questions:



What's the server setup?  Where is access running?  Why do you need an

access file, of all things?  Why not save your access file in a text file

(xml, comma separated values, whatever) and write a PHP class to parse it?



nik





-----Original Message-----

From: tan chek seng [mailto:tcs_mmu@y...]

Sent: Monday, January 14, 2002 10:06 PM

To: beginning php

Subject: [beginning_php] Using Access 2000 in PHP without ODBC driver





hello, can i access *.mdb file without ODBC driver coz

my uni do not allow me to do so.I need a solution urgent!!



__________________________________________________

Do You Yahoo!?

Everything you'll ever need on one web page

from News and Sport to Email and Music Charts

http://uk.my.yahoo.com






$subst('Email.Unsub').



Message #3 by =?iso-8859-1?q?tan=20chek=20seng?= <tcs_mmu@y...> on Wed, 16 Jan 2002 05:47:48 +0000 (GMT)
server is IIS5 built-in win2000 not sure about ACL and

reson is my lecturer only allow us to used access. 

--- Nikolai Devereaux <yomama@u...> wrote: > 

> A couple of questions:

> 

> What's the server setup?  Where is access running? 

> Why do you need an

> access file, of all things?  Why not save your

> access file in a text file

> (xml, comma separated values, whatever) and write a

> PHP class to parse it?

> 

> nik

> 

> 

> -----Original Message-----

> From: tan chek seng [mailto:tcs_mmu@y...]

> Sent: Monday, January 14, 2002 10:06 PM

> To: beginning php

> Subject: [beginning_php] Using Access 2000 in PHP

> without ODBC driver

> 

> 

> hello, can i access *.mdb file without ODBC driver

> coz

> my uni do not allow me to do so.I need a solution

> urgent!!

> 

> __________________________________________________

> Do You Yahoo!?

> Everything you'll ever need on one web page

> from News and Sport to Email and Music Charts

> http://uk.my.yahoo.com

> 





> $subst('Email.Unsub').

> 

> 





$subst('Email.Unsub'). 



__________________________________________________

Do You Yahoo!?

Everything you'll ever need on one web page

from News and Sport to Email and Music Charts

http://uk.my.yahoo.com

Message #4 by "Nikolai Devereaux" <yomama@u...> on Wed, 16 Jan 2002 11:40:20 -0800

Okay, so what exactly do you want to do?  It's still not clear what you

mean.  Humor me -- be descriptive. =)





> -----Original Message-----

> From: tan chek seng [mailto:tcs_mmu@y...]

> Sent: Tuesday, January 15, 2002 9:48 PM

> To: beginning php

> Subject: [beginning_php] RE: Using Access 2000 in PHP without ODBC

> driver

>

>

> server is IIS5 built-in win2000 not sure about ACL and

> reson is my lecturer only allow us to used access.

> --- Nikolai Devereaux <yomama@u...> wrote: >

> > A couple of questions:

> >

> > What's the server setup?  Where is access running?

> > Why do you need an

> > access file, of all things?  Why not save your

> > access file in a text file

> > (xml, comma separated values, whatever) and write a

> > PHP class to parse it?

> >

> > nik

> >

> >

> > -----Original Message-----

> > From: tan chek seng [mailto:tcs_mmu@y...]

> > Sent: Monday, January 14, 2002 10:06 PM

> > To: beginning php

> > Subject: [beginning_php] Using Access 2000 in PHP

> > without ODBC driver

> >

> >

> > hello, can i access *.mdb file without ODBC driver

> > coz

> > my uni do not allow me to do so.I need a solution

> > urgent!!

> >

> > __________________________________________________

> > Do You Yahoo!?

> > Everything you'll ever need on one web page

> > from News and Sport to Email and Music Charts

> > http://uk.my.yahoo.com

> >





> > $subst('Email.Unsub').

> >

> >





> $subst('Email.Unsub').

>

> __________________________________________________

> Do You Yahoo!?

> Everything you'll ever need on one web page

> from News and Sport to Email and Music Charts

> http://uk.my.yahoo.com

>




> $subst('Email.Unsub').



Message #5 by =?iso-8859-1?q?tan=20chek=20seng?= <tcs_mmu@y...> on Thu, 17 Jan 2002 02:21:20 +0000 (GMT)
i got a database file a;ready called (watis.mdb).and i

want to be able to query for my php script. 



--- Nikolai Devereaux <yomama@u...> wrote: > 

> Okay, so what exactly do you want to do?  It's still

> not clear what you

> mean.  Humor me -- be descriptive. =)

> 

> 

> > -----Original Message-----

> > From: tan chek seng [mailto:tcs_mmu@y...]

> > Sent: Tuesday, January 15, 2002 9:48 PM

> > To: beginning php

> > Subject: [beginning_php] RE: Using Access 2000 in

> PHP without ODBC

> > driver

> >

> >

> > server is IIS5 built-in win2000 not sure about ACL

> and

> > reson is my lecturer only allow us to used access.

> > --- Nikolai Devereaux <yomama@u...> wrote: >

> > > A couple of questions:

> > >

> > > What's the server setup?  Where is access

> running?

> > > Why do you need an

> > > access file, of all things?  Why not save your

> > > access file in a text file

> > > (xml, comma separated values, whatever) and

> write a

> > > PHP class to parse it?

> > >

> > > nik

> > >

> > >

> > > -----Original Message-----

> > > From: tan chek seng [mailto:tcs_mmu@y...]

> > > Sent: Monday, January 14, 2002 10:06 PM

> > > To: beginning php

> > > Subject: [beginning_php] Using Access 2000 in

> PHP

> > > without ODBC driver

> > >

> > >

> > > hello, can i access *.mdb file without ODBC

> driver

> > > coz

> > > my uni do not allow me to do so.I need a

> solution

> > > urgent!!

> > >

> > >

> __________________________________________________

> > > Do You Yahoo!?

> > > Everything you'll ever need on one web page

> > > from News and Sport to Email and Music Charts

> > > http://uk.my.yahoo.com

> > >





> > > $subst('Email.Unsub').

> > >

> > >





> > $subst('Email.Unsub').

> >

> > __________________________________________________

> > Do You Yahoo!?

> > Everything you'll ever need on one web page

> > from News and Sport to Email and Music Charts

> > http://uk.my.yahoo.com

> >





> > $subst('Email.Unsub').

> 

> 





$subst('Email.Unsub'). 



__________________________________________________

Do You Yahoo!?

Everything you'll ever need on one web page

from News and Sport to Email and Music Charts

http://uk.my.yahoo.com

Message #6 by "Nikolai Devereaux" <yomama@u...> on Thu, 17 Jan 2002 11:22:35 -0800

Okay... maybe I should be more specific, too. =)



First of all, I would guess that you can't access an Access database file

without using Access.  In PHP, this means either a COM approach or an ODBC

approach.



Though I don't think it will change things, what I was hoping you'd answer

the first time were the following:



1.   Where is Access running?  On your computer, or the school's?

2.   Where is the webserver running?  On your computer, or the school's?

3.   Why can't you save your access file in a format that PHP can parse

(tab-delimited or comma separated) before you use it?

4.   What is it exactly you're trying to do?  Telling me the NAME of the

access file doesn't really make anything more specific than your original

post.



nik





> -----Original Message-----

> From: tan chek seng [mailto:tcs_mmu@y...]

> Sent: Wednesday, January 16, 2002 6:21 PM

> To: beginning php

> Subject: [beginning_php] RE: Using Access 2000 in PHP without ODBC

> driver

>

>

> i got a database file a;ready called (watis.mdb).and i

> want to be able to query for my php script.

>

> --- Nikolai Devereaux <yomama@u...> wrote: >

> > Okay, so what exactly do you want to do?  It's still

> > not clear what you

> > mean.  Humor me -- be descriptive. =)

> >

> >

> > > -----Original Message-----

> > > From: tan chek seng [mailto:tcs_mmu@y...]

> > > Sent: Tuesday, January 15, 2002 9:48 PM

> > > To: beginning php

> > > Subject: [beginning_php] RE: Using Access 2000 in

> > PHP without ODBC

> > > driver

> > >

> > >

> > > server is IIS5 built-in win2000 not sure about ACL

> > and

> > > reson is my lecturer only allow us to used access.

> > > --- Nikolai Devereaux <yomama@u...> wrote: >

> > > > A couple of questions:

> > > >

> > > > What's the server setup?  Where is access

> > running?

> > > > Why do you need an

> > > > access file, of all things?  Why not save your

> > > > access file in a text file

> > > > (xml, comma separated values, whatever) and

> > write a

> > > > PHP class to parse it?

> > > >

> > > > nik

> > > >

> > > >

> > > > -----Original Message-----

> > > > From: tan chek seng [mailto:tcs_mmu@y...]

> > > > Sent: Monday, January 14, 2002 10:06 PM

> > > > To: beginning php

> > > > Subject: [beginning_php] Using Access 2000 in

> > PHP

> > > > without ODBC driver

> > > >

> > > >

> > > > hello, can i access *.mdb file without ODBC

> > driver

> > > > coz

> > > > my uni do not allow me to do so.I need a

> > solution

> > > > urgent!!

> > > >

> > > >

> > __________________________________________________

> > > > Do You Yahoo!?

> > > > Everything you'll ever need on one web page

> > > > from News and Sport to Email and Music Charts

> > > > http://uk.my.yahoo.com

> > > >





> > > > $subst('Email.Unsub').

> > > >

> > > >





> > > $subst('Email.Unsub').

> > >

> > > __________________________________________________

> > > Do You Yahoo!?

> > > Everything you'll ever need on one web page

> > > from News and Sport to Email and Music Charts

> > > http://uk.my.yahoo.com

> > >





> > > $subst('Email.Unsub').

> >

> >





> $subst('Email.Unsub').

>

> __________________________________________________

> Do You Yahoo!?

> Everything you'll ever need on one web page

> from News and Sport to Email and Music Charts

> http://uk.my.yahoo.com

>




> $subst('Email.Unsub').



Message #7 by David Cameron <dcameron@i...> on Fri, 18 Jan 2002 09:48:51 +1100
This message is in MIME format. Since your mail reader does not understand

this format, some or all of this message may not be legible.



------_=_NextPart_001_01C19FA9.25DE979E

Content-Type: text/plain;

	charset="iso-8859-1"



You can use ADO from php. ADO is typically the way things are done in ASP,

so you might as well use that. Besides you might get extra marks for being

clever.



http://www.php.net/manual/en/ref.com.php





regards

David Cameron

nOw.b2b

dcameron@i...



-----Original Message-----

From: Nikolai Devereaux [mailto:yomama@u...]

Sent: Friday, 18 January 2002 5:23 AM

To: beginning php

Subject: [beginning_php] RE: Using Access 2000 in PHP without ODBC

driver







Okay... maybe I should be more specific, too. =)



First of all, I would guess that you can't access an Access database file

without using Access.  In PHP, this means either a COM approach or an ODBC

approach.



Though I don't think it will change things, what I was hoping you'd answer

the first time were the following:



1.   Where is Access running?  On your computer, or the school's?

2.   Where is the webserver running?  On your computer, or the school's?

3.   Why can't you save your access file in a format that PHP can parse

(tab-delimited or comma separated) before you use it?

4.   What is it exactly you're trying to do?  Telling me the NAME of the

access file doesn't really make anything more specific than your original

post.



nik





> -----Original Message-----

> From: tan chek seng [mailto:tcs_mmu@y...]

> Sent: Wednesday, January 16, 2002 6:21 PM

> To: beginning php

> Subject: [beginning_php] RE: Using Access 2000 in PHP without ODBC

> driver

>

>

> i got a database file a;ready called (watis.mdb).and i

> want to be able to query for my php script.

>

> --- Nikolai Devereaux <yomama@u...> wrote: >

> > Okay, so what exactly do you want to do?  It's still

> > not clear what you

> > mean.  Humor me -- be descriptive. =)

> >

> >

> > > -----Original Message-----

> > > From: tan chek seng [mailto:tcs_mmu@y...]

> > > Sent: Tuesday, January 15, 2002 9:48 PM

> > > To: beginning php

> > > Subject: [beginning_php] RE: Using Access 2000 in

> > PHP without ODBC

> > > driver

> > >

> > >

> > > server is IIS5 built-in win2000 not sure about ACL

> > and

> > > reson is my lecturer only allow us to used access.

> > > --- Nikolai Devereaux <yomama@u...> wrote: >

> > > > A couple of questions:

> > > >

> > > > What's the server setup?  Where is access

> > running?

> > > > Why do you need an

> > > > access file, of all things?  Why not save your

> > > > access file in a text file

> > > > (xml, comma separated values, whatever) and

> > write a

> > > > PHP class to parse it?

> > > >

> > > > nik

> > > >

> > > >

> > > > -----Original Message-----

> > > > From: tan chek seng [mailto:tcs_mmu@y...]

> > > > Sent: Monday, January 14, 2002 10:06 PM

> > > > To: beginning php

> > > > Subject: [beginning_php] Using Access 2000 in

> > PHP

> > > > without ODBC driver

> > > >

> > > >

> > > > hello, can i access *.mdb file without ODBC

> > driver

> > > > coz

> > > > my uni do not allow me to do so.I need a

> > solution

> > > > urgent!!

> > > >

> > > >

> > __________________________________________________

> > > > Do You Yahoo!?

> > > > Everything you'll ever need on one web page

> > > > from News and Sport to Email and Music Charts

> > > > http://uk.my.yahoo.com

> > > >





> > > > $subst('Email.Unsub').

> > > >

> > > >





> > > $subst('Email.Unsub').

> > >

> > > __________________________________________________

> > > Do You Yahoo!?

> > > Everything you'll ever need on one web page

> > > from News and Sport to Email and Music Charts

> > > http://uk.my.yahoo.com

> > >





> > > $subst('Email.Unsub').

> >

> >





> $subst('Email.Unsub').

>

> __________________________________________________

> Do You Yahoo!?

> Everything you'll ever need on one web page

> from News and Sport to Email and Music Charts

> http://uk.my.yahoo.com

>




> $subst('Email.Unsub').








$subst('Email.Unsub').




Message #8 by =?iso-8859-1?q?tan=20chek=20seng?= <tcs_mmu@y...> on Fri, 18 Jan 2002 09:06:12 +0000 (GMT)
 



--- Nikolai Devereaux <yomama@u...> wrote: > 

> Okay... maybe I should be more specific, too. =)

> 

> First of all, I would guess that you can't access an

> Access database file

> without using Access.  In PHP, this means either a

> COM approach or an ODBC

> approach.

> 

  Answer:actually this is my internet computing

subject's project.my lecturer doesnt want to setup DSN

for every group,he said we will mess up the

database,and he assume we all using asp coz he is

teaching that,but few of us plan to use php.as we know

that we can access access databse with DSN-less.so

there is not problems for other groups.but so far i

dunno whether there is such solution for php.i am

trying ADOdb from php.weblogs.com,still not sure can

function well or not.



> Though I don't think it will change things, what I

> was hoping you'd answer

> the first time were the following:

> 

> 1.   Where is Access running?  On your computer, or

> the school's?



  answer:is in my uni's server.



> 2.   Where is the webserver running?  On your

> computer, or the school's?

  answer:together with access.



> 3.   Why can't you save your access file in a format

> that PHP can parse

> (tab-delimited or comma separated) before you use

> it?

  answer:my lecturer doesnt want us to do so.



> 4.   What is it exactly you're trying to do? 

> Telling me the NAME of the

> access file doesn't really make anything more

> specific than your original

> post.

  answer:i am doing a admin control panel which can

add/edit/delete product from database and also to

query statistic about web site from database.



Do i explain detail enough?

> 



__________________________________________________

Do You Yahoo!?

Everything you'll ever need on one web page

from News and Sport to Email and Music Charts

http://uk.my.yahoo.com

Message #9 by "Nikolai Devereaux" <yomama@u...> on Fri, 18 Jan 2002 01:34:55 -0800

Yeah, that's much more detailed, thanks!  =)



Now for the bad news --  I don't think you can do it without an ODBC or a

COM approach.



Since you said that ODBC is out, use COM and ADO.



There's some sample code at http://www.php.net/COM.



I don't know offhand what the connection string is for access, but a quick

google search came up with enough examples for me to throw this together:



Driver={Microsoft Access Driver (*.mdb)};

Dbq=<full path and filename of .mdb file>;

DefaultDir=<path to web script, i guess>;

Uid=<username>;Pwd=;





Good luck,



nik



-----Original Message-----

From: tan chek seng [mailto:tcs_mmu@y...]

Sent: Friday, January 18, 2002 1:06 AM

To: beginning php

Subject: [beginning_php] RE: Using Access 2000 in PHP without ODBC

driver





--- Nikolai Devereaux <yomama@u...> wrote: >

> Okay... maybe I should be more specific, too. =)

>

> First of all, I would guess that you can't access an

> Access database file

> without using Access.  In PHP, this means either a

> COM approach or an ODBC

> approach.

>

  Answer:actually this is my internet computing

subject's project.my lecturer doesnt want to setup DSN

for every group,he said we will mess up the

database,and he assume we all using asp coz he is

teaching that,but few of us plan to use php.as we know

that we can access access databse with DSN-less.so

there is not problems for other groups.but so far i

dunno whether there is such solution for php.i am

trying ADOdb from php.weblogs.com,still not sure can

function well or not.



> Though I don't think it will change things, what I

> was hoping you'd answer

> the first time were the following:

>

> 1.   Where is Access running?  On your computer, or

> the school's?



  answer:is in my uni's server.



> 2.   Where is the webserver running?  On your

> computer, or the school's?

  answer:together with access.



> 3.   Why can't you save your access file in a format

> that PHP can parse

> (tab-delimited or comma separated) before you use

> it?

  answer:my lecturer doesnt want us to do so.



> 4.   What is it exactly you're trying to do?

> Telling me the NAME of the

> access file doesn't really make anything more

> specific than your original

> post.

  answer:i am doing a admin control panel which can

add/edit/delete product from database and also to

query statistic about web site from database.



Do i explain detail enough?



Message #10 by =?iso-8859-1?q?tan=20chek=20seng?= <tcs_mmu@y...> on Fri, 18 Jan 2002 13:01:32 +0000 (GMT)
thanks for yr patience:P 



--- David Cameron <dcameron@i...> wrote: > You

can use ADO from php. ADO is typically the way

> things are done in ASP,

> so you might as well use that. Besides you might get

> extra marks for being

> clever.

> 

> http://www.php.net/manual/en/ref.com.php

> 

> 

> regards

> David Cameron

> nOw.b2b

> dcameron@i...

> 

> -----Original Message-----

> From: Nikolai Devereaux [mailto:yomama@u...]

> Sent: Friday, 18 January 2002 5:23 AM

> To: beginning php

> Subject: [beginning_php] RE: Using Access 2000 in

> PHP without ODBC

> driver

> 

> 

> 

> Okay... maybe I should be more specific, too. =)

> 

> First of all, I would guess that you can't access an

> Access database file

> without using Access.  In PHP, this means either a

> COM approach or an ODBC

> approach.

> 

> Though I don't think it will change things, what I

> was hoping you'd answer

> the first time were the following:

> 

> 1.   Where is Access running?  On your computer, or

> the school's?

> 2.   Where is the webserver running?  On your

> computer, or the school's?

> 3.   Why can't you save your access file in a format

> that PHP can parse

> (tab-delimited or comma separated) before you use

> it?

> 4.   What is it exactly you're trying to do? 

> Telling me the NAME of the

> access file doesn't really make anything more

> specific than your original

> post.

> 

> nik

> 

> 

> > -----Original Message-----

> > From: tan chek seng [mailto:tcs_mmu@y...]

> > Sent: Wednesday, January 16, 2002 6:21 PM

> > To: beginning php

> > Subject: [beginning_php] RE: Using Access 2000 in

> PHP without ODBC

> > driver

> >

> >

> > i got a database file a;ready called

> (watis.mdb).and i

> > want to be able to query for my php script.

> >

> > --- Nikolai Devereaux <yomama@u...> wrote: >

> > > Okay, so what exactly do you want to do?  It's

> still

> > > not clear what you

> > > mean.  Humor me -- be descriptive. =)

> > >

> > >

> > > > -----Original Message-----

> > > > From: tan chek seng [mailto:tcs_mmu@y...]

> > > > Sent: Tuesday, January 15, 2002 9:48 PM

> > > > To: beginning php

> > > > Subject: [beginning_php] RE: Using Access 2000

> in

> > > PHP without ODBC

> > > > driver

> > > >

> > > >

> > > > server is IIS5 built-in win2000 not sure about

> ACL

> > > and

> > > > reson is my lecturer only allow us to used

> access.

> > > > --- Nikolai Devereaux <yomama@u...> wrote:

> >

> > > > > A couple of questions:

> > > > >

> > > > > What's the server setup?  Where is access

> > > running?

> > > > > Why do you need an

> > > > > access file, of all things?  Why not save

> your

> > > > > access file in a text file

> > > > > (xml, comma separated values, whatever) and

> > > write a

> > > > > PHP class to parse it?

> > > > >

> > > > > nik

> > > > >

> > > > >

> > > > > -----Original Message-----

> > > > > From: tan chek seng

> [mailto:tcs_mmu@y...]

> > > > > Sent: Monday, January 14, 2002 10:06 PM

> > > > > To: beginning php

> > > > > Subject: [beginning_php] Using Access 2000

> in

> > > PHP

> > > > > without ODBC driver

> > > > >

> > > > >

> > > > > hello, can i access *.mdb file without ODBC

> > > driver

> > > > > coz

> > > > > my uni do not allow me to do so.I need a

> > > solution

> > > > > urgent!!

> > > > >

> > > > >

> > >

> __________________________________________________

> > > > > Do You Yahoo!?

> > > > > Everything you'll ever need on one web page

> > > > > from News and Sport to Email and Music

> Charts

> > > > > http://uk.my.yahoo.com

> > > > >





> > > > > $subst('Email.Unsub').

> > > > >

> > > > >





> > > > $subst('Email.Unsub').

> > > >

> > > >

> __________________________________________________

> > > > Do You Yahoo!?

> > > > Everything you'll ever need on one web page

> > > > from News and Sport to Email and Music Charts

> > > > http://uk.my.yahoo.com

> > > >





> > > > $subst('Email.Unsub').

> > >

> > >





> > $subst('Email.Unsub').

> >

> > __________________________________________________

> > Do You Yahoo!?

> > Everything you'll ever need on one web page

> > from News and Sport to Email and Music Charts

> > http://uk.my.yahoo.com

> >





> > $subst('Email.Unsub').

> 

> 





> $subst('Email.Unsub').

> 

> 





> $subst('Email.Unsub').

>  



__________________________________________________

Do You Yahoo!?

Everything you'll ever need on one web page

from News and Sport to Email and Music Charts

http://uk.my.yahoo.com

Message #11 by =?iso-8859-1?q?tan=20chek=20seng?= <tcs_mmu@y...> on Sat, 19 Jan 2002 10:05:53 +0000 (GMT)
i tot i can do it without ADOdb??any have idea?i

really dunno how to solve it.give me more idea or

resources,ok?



--- Nikolai Devereaux <yomama@u...> wrote: > 

> Yeah, that's much more detailed, thanks!  =)

> 

> Now for the bad news --  I don't think you can do it

> without an ODBC or a

> COM approach.

> 

> Since you said that ODBC is out, use COM and ADO.

> 

> There's some sample code at http://www.php.net/COM.

> 

> I don't know offhand what the connection string is

> for access, but a quick

> google search came up with enough examples for me to

> throw this together:

> 

> Driver={Microsoft Access Driver (*.mdb)};

> Dbq=<full path and filename of .mdb file>;

> DefaultDir=<path to web script, i guess>;

> Uid=<username>;Pwd=;

> 

> 

> Good luck,

> 

> nik

> 

> -----Original Message-----

> From: tan chek seng [mailto:tcs_mmu@y...]

> Sent: Friday, January 18, 2002 1:06 AM

> To: beginning php

> Subject: [beginning_php] RE: Using Access 2000 in

> PHP without ODBC

> driver

> 

> 

> --- Nikolai Devereaux <yomama@u...> wrote: >

> > Okay... maybe I should be more specific, too. =)

> >

> > First of all, I would guess that you can't access

> an

> > Access database file

> > without using Access.  In PHP, this means either a

> > COM approach or an ODBC

> > approach.

> >

>   Answer:actually this is my internet computing

> subject's project.my lecturer doesnt want to setup

> DSN

> for every group,he said we will mess up the

> database,and he assume we all using asp coz he is

> teaching that,but few of us plan to use php.as we

> know

> that we can access access databse with DSN-less.so

> there is not problems for other groups.but so far i

> dunno whether there is such solution for php.i am

> trying ADOdb from php.weblogs.com,still not sure can

> function well or not.

> 

> > Though I don't think it will change things, what I

> > was hoping you'd answer

> > the first time were the following:

> >

> > 1.   Where is Access running?  On your computer,

> or

> > the school's?

> 

>   answer:is in my uni's server.

> 

> > 2.   Where is the webserver running?  On your

> > computer, or the school's?

>   answer:together with access.

> 

> > 3.   Why can't you save your access file in a

> format

> > that PHP can parse

> > (tab-delimited or comma separated) before you use

> > it?

>   answer:my lecturer doesnt want us to do so.

> 

> > 4.   What is it exactly you're trying to do?

> > Telling me the NAME of the

> > access file doesn't really make anything more

> > specific than your original

> > post.

>   answer:i am doing a admin control panel which can

> add/edit/delete product from database and also to

> query statistic about web site from database.

> 

> Do i explain detail enough?

> 

> 





$subst('Email.Unsub'). 



__________________________________________________

Do You Yahoo!?

Everything you'll ever need on one web page

from News and Sport to Email and Music Charts

http://uk.my.yahoo.com

Message #12 by "Nikolai Devereaux" <yomama@u...> on Sat, 19 Jan 2002 14:46:40 -0800

Sorry, there's really nothing else I can give you...



First of all, it's your assignment, not mine. =)



Second, you're trying to access a database file withOUT using the tools that

you're given specifically for that purpose!  If you aren't allowed to use

either ODBC or COM/ADO, then I don't know what to tell you.



Lastly, I really don't see the educational value in this.  Why are you so

dead set on using PHP when you're not allowed to use the extensions

required?



nik





-----Original Message-----

From: tan chek seng [mailto:tcs_mmu@y...]

Sent: Saturday, January 19, 2002 2:06 AM

To: beginning php

Subject: [beginning_php] RE: Using Access 2000 in PHP without ODBC

driver





i tot i can do it without ADOdb??any have idea?i

really dunno how to solve it.give me more idea or

resources,ok?




  Return to Index