odbc connection not working

plzz · #1 (**permalink**) 06-24-11, 16:34

I'm trying to access a .mdb database file, but I cannot open a connection.

I know that the path of the file is right, I don't receive the 'Database file does not exist' error I wrote (which was popping up earlier when the file was in the wrong place).

I have been looking online for the proper way to open an ODBC connection to a Microsoft Access database, but I still can't find what is wrong with my code.

PHP Code:


			
$dbq = "db/hsc.mdb";

    

if    (!file_exists($dbq)) 

    { 

        echo "Sorry!<br />Database file: <b>$dbq does not exist</b>"; 

    }



$db_conn = odbc_connect("Driver={Microsoft Access Driver (*.mdb)};Dbq=$dbq", $username, $password,'SQL_CUR_USE_ODBC');

        

$this->db_connection = $db_conn;

        

if($db_conn){echo "Yay! there is a connection!";}

else{echo "There is no connection :(";}

When the code runs, I get the error message "There is no connection :(" because $db_conn is 0. How do I fix this?

healdem · #2 (**permalink**) 06-25-11, 17:02

try an or die when you try to establish the connection
one of the problems of PHP is that it doesn't die automatically.
you need to establish why the connection is failing

plzz · #3 (**permalink**) 06-27-11, 09:14

adding an 'or die' did nothing except break my page. Nothing shows up now but white.

healdem · #4 (**permalink**) 06-27-11, 13:14

or die (echo "MYSQL crapped out with the following error message:-".mysql_errno()."; ".mysql_error()));

plzz · #5 (**permalink**) 07-06-11, 09:14

hmmm. so now my line of code reads:

PHP Code:


			
$db_conn = odbc_connect("Driver={Microsoft Access Driver (*.mdb)};Dbq=$dbq, $username, $password,'SQL_CUR_USE_ODBC'" 

        or die (echo "MYSQL error message:-".mysql_errno()."; ".mysql_error()));

and nothing happens except a blank page. My error message doesn't come up, but the script dies and refuses to go on to the HTML that describes the page, I think. I'm not sure what's happening?

healdem · #6 (**permalink**) 07-06-11, 09:43

sorry my bad
there is no point repeating the MySQL error & description as these are specific to MySQL and you are using ODBC to a Microsoft JET db.
so look up what the equivalent error number and messages are in ODBC / JET

you may also need to turn on full error reporting, which IIRC is going to be soemthing like
error_reporting(E_ALL);

plzz · #7 (**permalink**) 07-06-11, 11:15

no, I mean I don't get any message at all. I don't even get the "MYSQL error message:-" which is just text I asked it to print. Even if I ask it to just print a bland "This page is broken, sorry" or something, it's not showing up. I think it's dying before it gets to printing?

healdem · #8 (**permalink**) 07-06-11, 13:16

so turn on the full error reporting
whether you need E_ALL or E_ALL || E_NOTICE or whatever is up to you

Internet Services

Web Development

Digital Marketing

Consumer Tech