connecting a ms access database using php

Question

5.00/5 (1 vote)

See more:

hi i have been taring to connect a MS access database using php in wamp server i used i a ready code from the internet but i still have an error that i couldn't fix

PHP

<?php
try{
    $dbh = new PDO("odbc:Driver={MS Access Database (*.mdb, *.accdb)};Dbq=C:\wamp\www\Database1.accdb");
}catch(PDOException $e){
    echo $e->getMessage();
}

and the message i get is

SQLSTATE[IM002] SQLDriverConnect: 0 [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

help please ^_^

Posted 25-Apr-13 5:03am

marwa_e

Add a Solution

Comments

Prasad Khandekar 25-Apr-13 11:10am

Checkout this tutorial (http://phpmaster.com/using-an-access-database-with-php/)

marwa_e 25-Apr-13 11:20am

i uncommented the line extension=php_pdo_odbc.dll in php.ini
but i dont get this line in the code
$dbName = $_SERVER["DOCUMENT_ROOT"] . "products\\products.mdb";
i am a beginner in php ^^

Prasad Khandekar 25-Apr-13 12:40pm

The $dbName = $_SERVER["DOCUMENT_ROOT"] . "products\\products.mdb"; line creates the full path of the data file.

marwa_e 25-Apr-13 15:32pm

ok then in my case i will write :-
The $dbName = $_SERVER["DOCUMENT_ROOT"] . "\\Database1.accdb";
right?
when i do this :( i get a new error :-
PDOException: SQLSTATE[IM002] SQLDriverConnect: 0 [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified in C:\wamp\www\odbc_test.php on line 6

my code in the odbc_test.php file :-

Prasad Khandekar 26-Apr-13 1:56am

Have you tried the connection string as odbc:DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=C:\\wamp\\www\\Database1.accdb; Uid=; Pwd=;.
Assuming that your database file name is Database1.accdb and is located in C:\wamp\www\ folder.

marwa_e 26-Apr-13 6:52am

yes i did but i still have the same error :(

Prasad Khandekar 26-Apr-13 7:08am

I think you don;t have the proper driver installed.

IM0002 means "(DM) The data source name specified in the connection string (InConnectionString) was not found in the system information, and there was no default driver specification. (DM) ODBC data source and default driver information could not be found in the system information."

Try re/installing the MS-ACCESS ODBC Driver. (http://www.microsoft.com/en-us/download/details.aspx?id=13255)

marwa_e 26-Apr-13 9:24am

thank you for your help i just found the problem is about a conflation about 64-bit and 32-bit :)
it looks like it only work on 32-bit wamp server (php) and i was using a 64-bit :)

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

marwa_e · Accepted Answer · 2013-04-26T03:34:00

Solution 1

the problem is about a conflation about 64-bit and 32-bit :)
it looks like it only work on 32-bit wamp server (php) and i was using a 64-bit :)

Posted 26-Apr-13 3:34am

marwa_e