|
|
Posted by Jerry Stuckle on 07/05/07 22:24
google@thefifthimperium.com wrote:
> 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
>
Maybe a stupid question - but does your web host have authority to open
the database files?
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|