Posted by google on 07/05/07 21:13

On Jul 5, 4:00 pm, "Richard" <root@localhost> wrote:
> Do you get any error messages?
> Can you trim your script down to only the failing part?

As stated in the original, I'm getting what appears to be a general
'can't find tables' error:

PHP Warning: odbc_exec(): SQL error: [SmartWare Software][SmartWare
ODBC Driver][ISAM]Table access error, SQL state S0000 in SQLExecDirect
in D:\path\CustView\sw265test.php on line 52
PHP Warning: odbc_fetch_row(): supplied argument is not a valid ODBC
result resource in D:\path\sw265test.php on line 57

The ODBC driver is for an ANGOSS Smartware database, SWODBC32.DLL
V4.60.00.2127

The script code is pretty simple:

44 $conn = odbc_connect($dbhost, $dbuser, $dbpw);
45 $result = odbc_tables($conn);
46 odbc_result_all( $result );

//This returns No Results, but no error, either
// commented out lines here

51 $sql = "SELECT * FROM $dbname";
52 $result2 = odbc_exec( $conn, $sql );

// commented out lines here

57 while (odbc_fetch_row($result2)) {
echo odbc_result_all( $result2 );
}


-JPB

[Back to original message]