asked on

ODBC Connection to Access database with PHP

I followed the steps here:
http://www.devasp.com/samples/dsn_access.asp

and created a DSN, which went OK.

Then I tried to use this code to access it, but it keeps failing. $conn is empty.

<?php
	$conn=odbc_connect('MCDB','phpadmin','********!');
	if (!$conn)
	{
		exit("Connection Failed: " . $conn);
	}
	else
	{
		echo "Connection Established";
	}
	odbc_close($conn);
?>

Open in new window

What am I doing wrong?

Lukasz Chmielewski

Do you need an odbc ?
http://www.actionscript.org/forums/showthread.php3?t=21969

Lukasz Chmielewski

If so... Seems ok but double check:
DSN name ? Is it the same ?
Are you providing good password ?

DrDamnit

ASKER

Since this is a Windows 2k8 box, there is no user and password because I have used a system DSN.

In that same vein, I have manually added some user / passwords to the DSN, and I have also tried authenticating with the system administrator credentials (with and without the DOMAIN\User format). All to no avail.

ODBC is already installed on a Windows SBS 2008 box, so I don't think I need to install anything else. I did, however have to install the access drives, but that went ok.

Lukasz Chmielewski

Does this work without providing ANYTHING ?
$conn=odbc_connect('MCDB','','');

DrDamnit

ASKER

No joy.

I have set the file permissions to this as Everyone = Full Access (for the folder that contains this file). Still didn't work.

Thoughts?

DrDamnit

ASKER

This is how I set it up...