ODBC error

[Anon]

I have finished setting up all the require steps for PHP to run in IIS but when i write a simple PHP linking with MS access using ODBC code... it gives me these errors..
Warning: SQL error: , SQL state 00000 in SQLConnect in e:\Inetpub\wwwroot\hr\admin_check.php on line 12

Warning: Supplied argument is not a valid ODBC-Link resource in e:\Inetpub\wwwroot\hr\admin_check.php on line 14

Warning: Supplied argument is not a valid ODBC result resource in e:\Inetpub\wwwroot\hr\admin_check.php on line 17

ahh....... what's wrong with it??

[kparker]

The connection itself is not succeeding: perhaps a problem with permissions, dsn name, etc.

By the way, the fact that you get this cascade of error messages means that you aren't checking the return values from your odbc functions to see if there is a problem. I.e. don't just do this:

$conn = odbc_connect(...);
$result = odbc_exec( $conn, ...);
while (odbc_fetch( $result, ...) )
...

Instead, test the values of $conn and $result to make sure the respective function calls didn't fail. And if they do fail, call odbc_errormsg() or look at $php_errormsg to find out why.

[Anon]

How to you test the values of $conn and $result ??
Do i just echo the values only?

Dave

[soulreaver]

Make your life a bit easier and take a trip to http://php.weblogs.com and get ADODB 1.01

read the files and connect to access nice and easily.

Neil

[kparker]

I mean test as in the programmatic sense, e.g. with an if-statement. These functions all return false (numeric zero) if they fail; this:

if (! ($conn = odbc_connect(...)))
  {
  echo "Couldn't connect: $php_errormsg";
  }
else
  {
  if (! ($result = odbc_exec( $conn, ... )))
    {
    echo "Query error: $php_errormsg";
    }
  else
    {
    // get the result rows...
    }
  }