Results 1 to 4 of 4

Thread: Connecting to MS Access with PHP

  1. #1
    Junior Member
    Join Date
    Jan 2008
    Answers
    5

    Connecting to MS Access with PHP

    Hi, I want to connect to an MS Access database without using an ODBC. Can someone help me? I have been researching this for a while now and haven't found anything that works. Maybe it's just me. Thanks.


  2. #2
    Shivanna
    Guest

    Re: Connecting to MS Access with PHP

    I dont think there is anything that works for connecting ms access without using odbc
    while there are options available to connect mysql, oracle and ms sql server dbs

    mysql - mysql_connect()
    oracle - ocilogon()
    ms sql server - mssql_connect()

    using format like for example
    $db = mysql_connect("localhost", "root", "password");
    mysql_select_db("mydb",$db);
    $result = mysql_query("select * from employees",$db);

    there dont seem to be one available to connect ms access
    however there is one product "php lens" which provides "adodb.inc.php"
    using this "adodb.inc.php" you can connect to ms access
    the format of which is

    include("adodb.inc.php");
    $db = newadoconnection('access');
    $db->connect("localhost", "root", "password", "my_access_db");

    regards
    shivanna

    Last edited by Shivanna; 01-23-2008 at 06:20 AM.

  3. #3
    Junior Member
    Join Date
    Jan 2008
    Answers
    5

    Re: Connecting to MS Access with PHP

    Thank you for your help do you know anything about the other connection you were talking about? I found one that seems to connect, but then I don't know the syntax or how to write the code to work with it.


  4. #4
    Shivanna
    Guest

    Re: Connecting to MS Access with PHP

    I have not used adodb.php.inc exactly
    You can find this at [[http:// adodb . sourceforge . net / # download]]
    Have a look, You should be able to use it


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact