How To: Access .mdb database with PHP?
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2

Thread: How To: Access .mdb database with PHP?

  1. #1
    Join Date
    Aug 2002
    Location
    Brazil
    Posts
    730

    How To: Access .mdb database with PHP?

    I would like to know how can I use Access .mdb databases with PHP.
    I would apreciate very much a small snipet.
    Also, what are the dependencies for such database to work in php? (dlls, mdac, etc...)

    Thanks your for your atention!
    All consequences are eternal in some way.

  2. #2
    Join Date
    May 2001
    Location
    Oslo, Norway
    Posts
    610

    Re: How To: Access .mdb database with PHP?

    Man thats a no-brainer in Windows if you have access to the server. If not you have to ask your host provider or use some sort of interface to create a DSN (this is what you use in odbc_connect PHP function to connect to a data source) which will be mapped to an Access Database. I will not explain you how to do it, because all ISPs have their own way of doing this.

    If you host PHP on a Windows machine and you can access the Administrato desktop:

    1. Go to Control Panel->Administrative Tools->Data Sources (ODBC). You can make a new data source name there.

    2. Use this name in odbc_connect.

    Dont forget to create an Access database with your tables !

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Windows Mobile Development Center


Click Here to Expand Forum to Full Width

This is a CodeGuru survey question.


Featured


HTML5 Development Center