MS Access DSN for PEAR DB::connet

[bjoon]

Hi,

does anyone know what DSN I must use to get connected to my MS Access database?

BUSINESS is my OBDC connection on Windows 2000 to my database.

As PHP database type I use 'odbc'.

Please find the enclosed code snipet:

<?php require_once('DB.php');

$dsn = "odbc:///BUSINESS";

// Establish the connection

$db = DB::connect($dsn);

if (DB::isError($db)) {
die ($db->getMessage());
}
?>

When running it, I receive an DB Error: connect failed.

Unfortunately with same result, I tried the following DSN:

$dsn = "odbc:///BUSINESS";
$dsn = "odbc://localhost/BUSINESS";
$dsn = "odbc://administrator@localhost/BUSINESS";
$dsn = "odbc://user@localhost/BUSINESS";
$dsn = "odbc://user:password@localhost/BUSINESS";

Any hints from you are very welcome,

regards,
bjoon

require_once('DB.php');$dsn = "odbc:///BUSINESS";$db = DB::connect($dsn);if (DB::isError($db)) {die ($db->getMessage());}

[bjoon]

Isn't there anyone out in this world who can answer me this question?

Or am I the only one who like to use PEAR with a Microsoft Access database?

Please let me know if you know more.

regards,
bjoon

[bjoon]

Problem is solved for those who run into same problem.

Review the DSN!

Don't use:

$dsn = "odbc://test:test@localhost/BUSINESS";

Use instead w/o 'localhost':

$dsn = "odbc://test:test@BUSINESS";