Re: odbc problem

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"" <landavia81@gmail.com> wrote in message news:018401c76462$2524cd90$670b1e0a@mis01... > > ----- Original Message ----- > From: "gunawan" <wibisonog@ramsayhealth.co.id> > 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; >> ?> >> >> ------------------- >>