|
|
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
Navigation:
[Reply to this message]
|