SQL Error

[Anon]

Hey You,
I get the following error when accessing an Access database through ODCB using PHP 4 on Win 2K.

Warning: SQL error: , SQL state 00000 in SQLConnect in f:\apache\odbcausg.php on line 9

Warning: Supplied argument is not a valid ODBC-Link resource in f:\apache\odbcausg.php on line 10

Warning: Supplied argument is not a valid ODBC result resource in f:\apache\odbcausg.php on line 11
Fehler!

My Script is:
<?
$Quelle = odbc_connect("Artikel", "peter", "geheim");
$Ergebnis = odbc_exec($Quelle, "SELECT * FROM Artikel");
if (odbc_fetch_row($Ergebnis, 1)) {
echo odbc_result($Ergebnis, "ArtikelNr");
}
else {
echo "Fehler!";
}
?>

Does anybody know the solution?
Do I have to make any changes at the database?

[ace21]

There are two possible problems $Quelle is not getting to the database try this

$Quelle = odbc_connect("Artikel", "peter", "geheim") or die("failed to connect");
meaning no database named Artikel or password username are wrong

or the database name is wrong in your select statement try this
if(!$Ergebnis = odbc_result($Ergebnis, "ArtikelNr"))
echo "select statement error";

Hope this helps.
Ace21

[jhonrputra]

Hi,

I agree with Ace21. The first error is in your database connection. Please check your database name, user or password in your ODBC.

Hope helpful.