----- Original Message -----
From: "gunawan" <[EMAIL PROTECTED]>
To: <php-db@lists.php.net>
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

Reply via email to