odbc problem
in [Databases]
|
From: "IMRAN" on 12 Mar 2007 02:03 Is odbc_num_fields return any value ? You can disable the warnings in php.ini file. Please let me know if that helps... ----- Original Message ----- From: ""bedul"" <landavia81(a)gmail.com> Newsgroups: php.db To: <php-db(a)lists.php.net> Sent: Monday, March 12, 2007 10:21 AM Subject: Fw: odbc problem > > ----- Original Message ----- > From: "gunawan" <wibisonog(a)ramsayhealth.co.id> > To: <php-db(a)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; > > ?> > > > > ------------------- > >
From: "bedul" on 12 Mar 2007 02:45 ----- Original Message ----- From: "IMRAN" <imran(a)perfecture.com> To: ""bedul"" <landavia81(a)gmail.com> Cc: "php.db" <php-db(a)lists.php.net> Sent: Monday, March 12, 2007 1:03 PM Subject: Re: odbc problem > Is odbc_num_fields return any value ? > You can disable the warnings in php.ini file. > > Please let me know if that helps... nope.. no value has been return.. but it kind strange Using odbc_field_len No rows found odbc connected total column=268 it return the column but not the value inside?? strange?? the more strange was it should return 300++?? i'm curious about this warning line ==================================== Warning: odbc_exec() [function.odbc-exec]: SQL error: [Cach� ODBC][State : S1000][Native Code 400] [D:\Aplikasi\xampp\apache\bin\apache.exe] General server error, SQL state S1000 in SQLExecDirect in D:\Aplikasi\xampp\htdocs\tes\odbc\c-4.php on line 11 =========================================== "General server error, SQL " any clue anyone.. i believe this the problem begin.. fyi.. i already close after open the database. but nothing good happen. thx to anyone reply.. > ----- Original Message ----- > From: ""bedul"" <landavia81(a)gmail.com> > Newsgroups: php.db > To: <php-db(a)lists.php.net> > Sent: Monday, March 12, 2007 10:21 AM > Subject: Fw: odbc problem > > > > > > ----- Original Message ----- > > From: "gunawan" <wibisonog(a)ramsayhealth.co.id> > > To: <php-db(a)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; > > > ?> > > > > > > ------------------- > > > > >
From: "Haydar Tuna" on 12 Mar 2007 03:53 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(a)gmail.com> wrote in message news:018401c76462$2524cd90$670b1e0a(a)mis01... > > ----- Original Message ----- > From: "gunawan" <wibisonog(a)ramsayhealth.co.id> > To: <php-db(a)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; >> ?> >> >> ------------------- >>
From: "bedul" on 12 Mar 2007 04:08 allright.. i don't blame anyone.. i just wanna say "thanks to everyone for helping me.." perhaps u right.. more rows make the script return ERROR.. ----- Original Message ----- From: "Haydar Tuna" <haydartuna(a)yahoo.com> To: <php-db(a)lists.php.net> Sent: Monday, March 12, 2007 2:53 PM Subject: [PHP-DB] 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(a)gmail.com> wrote in message > news:018401c76462$2524cd90$670b1e0a(a)mis01... > > > > ----- Original Message ----- > > From: "gunawan" <wibisonog(a)ramsayhealth.co.id> > > To: <php-db(a)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 >
From: "IMRAN" on 12 Mar 2007 09:04 Send me your code, I'll fix it for you... ----- Original Message ----- From: "bedul" <landavia81(a)gmail.com> To: "IMRAN" <imran(a)perfecture.com> Cc: "php.db" <php-db(a)lists.php.net> Sent: Monday, March 12, 2007 12:15 PM Subject: Re: odbc problem ----- Original Message ----- From: "IMRAN" <imran(a)perfecture.com> To: ""bedul"" <landavia81(a)gmail.com> Cc: "php.db" <php-db(a)lists.php.net> Sent: Monday, March 12, 2007 1:03 PM Subject: Re: odbc problem > Is odbc_num_fields return any value ? > You can disable the warnings in php.ini file. > > Please let me know if that helps... nope.. no value has been return.. but it kind strange Using odbc_field_len No rows found odbc connected total column=268 it return the column but not the value inside?? strange?? the more strange was it should return 300++?? i'm curious about this warning line ==================================== Warning: odbc_exec() [function.odbc-exec]: SQL error: [Cach� ODBC][State : S1000][Native Code 400] [D:\Aplikasi\xampp\apache\bin\apache.exe] General server error, SQL state S1000 in SQLExecDirect in D:\Aplikasi\xampp\htdocs\tes\odbc\c-4.php on line 11 =========================================== "General server error, SQL " any clue anyone.. i believe this the problem begin.. fyi.. i already close after open the database. but nothing good happen. thx to anyone reply.. > ----- Original Message ----- > From: ""bedul"" <landavia81(a)gmail.com> > Newsgroups: php.db > To: <php-db(a)lists.php.net> > Sent: Monday, March 12, 2007 10:21 AM > Subject: Fw: odbc problem > > > > > > ----- Original Message ----- > > From: "gunawan" <wibisonog(a)ramsayhealth.co.id> > > To: <php-db(a)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; > > > ?> > > > > > > ------------------- > > > > >
|
Next
|
Last
Pages: 1 2 Prev: array field type Next: PHP + PostgreSQL: invalid byte sequence for encoding"UTF8" |