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?

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

    scottd

      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?

        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

          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?

            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

              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.

                hi!

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

                thanks!

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

                    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

                      Can't be done.

                      to my knowledge 🙂

                        5 months later
                        Write a Reply...