MS Access and PHP

phpmla

Hi!

PHP with mySQL works realy fine!

But i have a problem with my provider! he has PHP and a Windows NT Webserver. but he dont has MySQL.

Now, my question is, is it possible to copy a MS Access *.MDB file on a Webserver and access it with PHP? (write and read)

Have anyone Sources or Links about this?

What's about Security?

scottd

I take it you are not able to use odbc to do this? Are you wanting a DSNless connection?

scottd

phpmla

I only now, that odbc mybe is a Microsoft Product for access databases.
I think, if PHP works fine with odbc, why not!

But, what do you meen with DSNless connection?

scottd

odbc is a way of coonnecting to various different database types, and the only way you can connect to MS Acess using php.

To connect to it you will need to have the server admin create a DSN for the database...you can't simply have php read and write to the database without one of these. Once you have the DSN set up you cannot move the database.

ASP lets you connect to a MS access DB without a DSN otherwise known as a DSNless connection...juts like reading a file, but if you are using php then you cannot do this an dare stuck with the DSN way.

Have aread of the odbc features in the php manual.

scottd

phpmla

hey, thanks a lot for your informations!

So, that meen, i've to talk with my ISP, to say them he must install a DSN, because only ODBC to access Access Files with PHP don't work.

Maybe you now other ways to create a DB, if the webserver only have Windows NT and PHP?

scottd

no other way around it unless you read from a flat file which ain't too great. If your ISP isn't easy to get hold of then just use ASP and connect to the access db without a dsn.

Scottd

ame12

Not sure if this is an option, but check out:

http://badblue.com/helpmdb.htm

The BadBlue PHP web server will transcode Access MDB data into HTML automatically (along with Excel and Word). You can use fopen (HTTP address) calls to get to the data. You could even run your main app using IIS which could to fopen/HTTP calls to the transcoding engine to retrieve Access data.

phpmla

hi!

this is a good idea, i will check it out this weekend!

thanks!

phpmla

this is a other way, but i think it isn't the best way, because i dont like to take ASP and PHP ond the same Website!

But maybe i've to change the ISP.... 🙂

Anon

I'm also very much Intersted in getiing to learn that " How can I call access mdb file with a DSN Less connection with PHP "

Ajay Chadha

Anon

Can't be done.

to my knowledge 🙂

Anon

ive been looking around and ive read that it CAN be done, just that im having problems replicating their procedure for ms access. veiw these sites and tell me if you can get it to work for access please.

http://php.weblogs.com/odbc
http://faqchest.dynhost.com/prgm/dbi-l/dbi-01/dbi-0112/dbi-011201/dbi01120502_06024.html

you may have to download that set of adodb files to be used as includes.

id really like to get this working...