----- Original Message -----
From: "gunawan" <wibisonog@xxxxxxxxxxxxxxxxxx>
To: <php-db@xxxxxxxxxxxxx>
Sent: Monday, March 12, 2007 11:46 AM
Subject: odbc problem
> i have this warning.. i don't know what the meaning
> ----------------------------------------
> Using odbc_num_fields
>
> Warning: odbc_exec() [function.odbc-exec]: SQL error: [Caché ODBC][State :
> S1000][Native Code 400] [C:\ProgramFiles\xampp\apache\bin\apache.exe]
> General server error, SQL state S1000 in SQLExecDirect in
> C:\dokumen_php\tes\odbc\c-6.php on line 12
> ---------------------------------------------
>
> this is my script.. i know this is simple..
> ----------------
> <h1>Using odbc_num_fields</h1> <?
>
> //include "c-config.php";
> $DBname = 'medtrak2'; //'MSAccessDriver'
> $DBuser = "_system";
> $DBpass = "sys";
>
> $con = odbc_connect($DBname, $DBuser, $DBPass);
> if ($con)
> {
> $txt.= "odbc connected
> ";
> $sql = "select * from PA_Adm";
> //this function will execute the sql satametn in
> //correspondance to the table in the db
> $exec = odbc_exec($con, $sql);
> //int odbc_num_fields ( resource result_id )
> $n= odbc_num_fields($exec); //$Query_ID);
>
> $txt.="<br>\ntotal column=".$n;
> }
>
> //$txt.= readThisFile($filename);
>
> print $txt;
> ?>
>
> -------------------
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
