Hello,
      I faced same problems. My table had many rows but I couldn't run 
odbc_num_fields. It return -1 result. I looked PHP help file. But I get rows 
with odbc_fetch_row() function. My operating system was Windows 2003. I 
think, there is a bug odbc_num_fields function in Windows 2003 operating 
systems becuase in Windows 2003 , when I run PHP with IIS I faced many 
problems. :)


-- 
Haydar TUNA
Republic Of Turkey - Ministry of National Education
Education Technology Department Ankara / TURKEY
Web: http://www.haydartuna.net


""bedul"" <[EMAIL PROTECTED]> wrote in message 
news:[EMAIL PROTECTED]
>
> ----- 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