RE: all operation not work (insert delete update) / maybepermissionproblem

You are getting a -206 error as shown in your attachment. Informix -206: -206 The specified table <table-name> is not in the database. The database server cannot find a table or view specified in the statement. The table or view might have been renamed or dropped from the database. You might also get this message if you omit the keyword "TYPE" when you are trying to grant USAGE privileges on a user-defined type. For example, the following GRANT statement is correct: GRANT USAGE ON TYPE person_row_type TO usr2; The following GRANT statement, however, generates error -206: GRANT USAGE ON person_row_type TO usr2; Check the names of tables and views in the statement or check for omission of the keyword "TYPE" in a GRANT statement. If the names are spelled as you intended and "TYPE" is not missing, check that you are using the database you want. To find the names of all tables in the database, query the systables table. To find the names of all views, query the sysviews table. ________________________________ From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Muthana.AL-Temimi@tu-harburg.hamburg.de Sent: Thursday, September 21, 2006 9:46 AM To: informix-list@iiug.org Subject: AW: all operation not work (insert delete update) / maybepermissionproblem Hello Superboer, I got the following can you help to fix my problem, please! I sent you a copy from fehler.txt which is difficult to understand anything from it. Regards Muthana PS.: Sorry Superboer I sent a mail to your account again. Sorry again and thanks for tips. ------------------------------------------ Muthana AL-Temimi Tel.: 040 42 878 2338 EMail: m.al@tu-harburg.de Rechenzentrum RZ53.4 Technische Universität Hamburg Harburg ________________________________ Von: superboer7@t-online.de [mailto:superboer7@t-online.de] Gesendet: Donnerstag, 21. September 2006 16:15 An: AL-Temimi, Muthana Betreff: Re: all operation not work (insert delete update) / maybe permissionproblem hello Muthana, well in that case: assume c:\\tmp exist. set SQLIDEBUG=2:c\\tmp\\sqlilog set this env var in your windows globally so if you start a cmd line and to set |more SQLIDEBUG is there. Then run msaccess stuff. Then check if there are files present in c:\\tmp called sqlilog_<something> do your insert/update etc. then open a cmd box do unset SQLIDEBUG cd c:\\tmp sqliprint sqlilog_<something> > somefile.txt (sqliprint comes free with the clientsdk for windowze.) in somefile.txt you will see all the sql sent to the database including error messages; this should tell you what is wrong. -->> do youserlf a favour; i am not always looking into this account youre better off sending it to the newsgroup; someone else may give you an answer. See you Superboer. -----Original Message----- Date: Thu, 21 Sep 2006 15:36:28 +0200 Subject: AW: all operation not work (insert delete update) / maybe permissionproblem From: <Muthana.AL-Temimi@tu-harburg.hamburg.de> To: <superboer7@t-online.de> Hello Superboer, I tried the following: 1. to use grant dba to public but the result still the same I haven't permission to do anything just read from db. 2. I enabled the logging of ODBC and nothings are reporting there 3. I called this command just you are told me: onstat -g sql and I got the following: xakt@tuhhsrvzul:~> onstat -g sql IBM Informix Dynamic Server Version 10.00.UC3R1 -- On-Line -- Up 5 days 06:11:57 -- 106192 Kbytes Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers Explain 266 - regin CR Not Wait 0 0 9.03 Off 246 - sospos CR Not Wait 0 0 9.03 Off 193 - sospos CR Not Wait 0 0 9.03 Off 192 - sospos CR Wait 0 0 9.03 Off 191 - sospos CR Not Wait 0 0 9.03 Off 190 - sospos CR Not Wait 0 0 9.03 Off 4 - sysmaster RR Wait 300 0 0 9.03 Off Regards, Muthana ------------------------------------------ Muthana AL-Temimi Tel.: 040 42 878 2338 EMail: m.al@tu-harburg.de Rechenzentrum RZ53.4 Technische Universität Hamburg Harburg -----Ursprüngliche Nachricht----- Von: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] Im Auftrag von Superboer Gesendet: Mittwoch, 20. September 2006 20:16 An: informix-list@iiug.org Betreff: Re: all operation not work (insert delete update) / maybe permissionproblem If you suspect it to be a permission problem, you could do a a quick test to grant dba to public.... YIKES... revoke it later!!!!!!!!!!!!! if you do an op what does onstat -g sql tell you, it should show sql errors.. you can also enable odbc logging.... Superboer. Muthana.AL-Temimi@tu-harburg.hamburg.de schreef: > Hello there, > > > > I import a new database into Informix 10 from the old system. The owner for this DB is the same from old system and part of the Informix group (under etc/group) > > Than I successfully assignment all tables within MS-Access by using ODBC. > > > > Now becomes my problem when I tried to delete, insert, and update a record from MS-Access side leads that I cannot do all those operation. > > > > I have already checked the "online.log" and there is nothing helping me to avoid and solve this problem. > > > > Any help will be grateful > > > > Regards > > Muthana > > ------------------------------------------ > > Muthana AL-Temimi > > Tel.: 040 42 878 2338 > > EMail: m.al@tu-harburg.de > > Rechenzentrum RZ53.4 > > Technische Universität Hamburg Harburg > > > > > ------_=_NextPart_001_01C6DCC7.CFE9CBD2 > Content-Type: text/html; charset=iso-8859-1 > Content-Transfer-Encoding: quoted-printable > X-Google-AttachSize: 4577 > > <html> > > <head> > <meta http-equiv=Content-Type content="text/html; charset=iso-8859-1"> > <meta name=Generator content="Microsoft Word 11 (filtered)"> > > <style> > <!-- > /* Font Definitions */ > @font-face > {font-family:Verdana; > panose-1:2 11 6 4 3 5 4 4 2 4;} > /* Style Definitions */ > p.MsoNormal, li.MsoNormal, div.MsoNormal > {margin:0cm; > margin-bottom:.0001pt; > font

yep: SQ_PREPARE # values: 0 CMD.....: "SELECT Config, nValue FROM MSysConf" [35] SQ_NDESCRIBE SQ_WANTDONE SQ_EOT S->C (20) Time: 2006-09-21 16:23:18.19800 SQ_ERR SQL error..........: -206 ISAM/RSAM error....: -111 Offset in statement: 35 Error message......: "msysconf" [8] SQ_EOT so msysconf is missing. can you check if this is one of the tables you should have in your app. thin ice: could be an informix table????? new in V10????????? DONO check your old system for this table. Superboer. Sebastian, Norma J. schreef: > You are getting a -206 error as shown in your attachment. > > Informix -206: > > > > > > -206 The specified table <table-name> is not in the database. > > > > The database server cannot find a table or view specified in the statement. > > The table or view might have been renamed or dropped from the database. > > > > You might also get this message if you omit the keyword "TYPE" when you are > > trying to grant USAGE privileges on a user-defined type. For example, the > > following GRANT statement is correct: > > > > GRANT USAGE ON TYPE person_row_type TO usr2;> > > > The following GRANT statement, however, generates error -206: > > > > GRANT USAGE ON person_row_type TO usr2;> > > > Check the names of tables and views in the statement or check for omission > > of the keyword "TYPE" in a GRANT statement. If the names are spelled as you > > intended and "TYPE" is not missing, check that you are using the database > > you want. To find the names of all tables in the database, query the > > systables table. To find the names of all views, query the sysviews table. > > > > > > > > > > > > ________________________________ > > From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Muthana.AL-Temimi@tu-harburg.hamburg.de > Sent: Thursday, September 21, 2006 9:46 AM > To: informix-list@iiug.org > Subject: AW: all operation not work (insert delete update) / maybepermissionproblem > > > > Hello Superboer, > > > > I got the following can you help to fix my problem, please! > > > > I sent you a copy from fehler.txt which is difficult to understand anything from it. > > > > Regards > > Muthana > > PS.: Sorry Superboer I sent a mail to your account again. Sorry again and thanks for tips. > > ------------------------------------------ > > Muthana AL-Temimi > > Tel.: 040 42 878 2338 > > EMail: m.al@tu-harburg.de > > Rechenzentrum RZ53.4 > > Technische Universität Hamburg Harburg > > > > ________________________________ > > Von: superboer7@t-online.de [mailto:superboer7@t-online.de] > Gesendet: Donnerstag, 21. September 2006 16:15 > An: AL-Temimi, Muthana > Betreff: Re: all operation not work (insert delete update) / maybe permissionproblem > > > > hello Muthana, > > > > well in that case: > > > > assume c:\\tmp exist. > > > > set SQLIDEBUG=2:c\\tmp\\sqlilog > > > > set this env var in your windows globally so > > if you start a cmd line and to set |more > > SQLIDEBUG is there. > > > > Then run msaccess stuff. > > > > Then check if there are files present in c:\\tmp called sqlilog_<something> > > do your insert/update etc. > > > > then open a cmd box > > do unset SQLIDEBUG > > cd c:\\tmp > > > > sqliprint sqlilog_<something> > somefile.txt > > (sqliprint comes free with the clientsdk for windowze.) > > > > in somefile.txt you will see all the sql sent to the database including error > > messages; this should tell you what is wrong. > > > > -->> do youserlf a favour; i am not always looking into this account > > youre better off sending it to the newsgroup; > > someone else may give you an answer. > > > > See you > > > > Superboer. > > > > > -----Original Message----- > Date: Thu, 21 Sep 2006 15:36:28 +0200 > Subject: AW: all operation not work (insert delete update) / maybe permissionproblem > From: <Muthana.AL-Temimi@tu-harburg.hamburg.de> > To: <superboer7@t-online.de> > > Hello Superboer, > > I tried the following: > > 1. to use grant dba to public but the result still the same I haven't permission to do anything just read from db. > > 2. I enabled the logging of ODBC and nothings are reporting there > 3. I called this command just you are told me: onstat -g sql and I got the following: > > > xakt@tuhhsrvzul:~> onstat -g sql > > IBM Informix Dynamic Server Version 10.00.UC3R1 -- On-Line -- Up 5 days 06:11:57 -- 106192 Kbytes> > Sess SQL Current Iso Lock SQL ISAM F.E. > Id Stmt type Database Lvl Mode ERR ERR Vers Explain > 266 - regin CR Not Wait 0 0 9.03 Off > 246 - sospos CR Not Wait 0 0 9.03 Off > 193 - sospos CR Not Wait 0 0 9.03 Off > 192 - sospos CR Wait 0 0 9.03 Off > 191 - sospos CR Not Wait 0 0 9.03 Off > 190 - sospos CR Not Wait 0 0 9.03 Off > 4 - sysmaster RR Wait 300 0 0 9.03 Off > > Regards, > Muthana > ------------------------------------------ > Muthana AL-Temimi > Tel.: 040 42 878 2338 > EMail: m.al@tu-harburg.de > Rechenzentrum RZ53.4 > Technische Universität Hamburg Harburg > > > -----Ursprüngliche Nachricht----- > Von: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] Im Auftrag von Superboer > Gesendet: Mittwoch, 20. September 2006 20:16 > An: informix-list@iiug.org > Betreff: Re: all operation not work (insert delete update) / maybe permissionproblem > > If you suspect it to be a permission problem, > you could do a a quick test to grant dba to public.... YIKES... > revoke it later!!!!!!!!!!!!! > > > if you do an op what does onstat -g sql tell you, > it should show sql errors.. > you can also enable odbc logging.... > > Superboer. > > Muthana.AL-Temimi@tu-harburg.hamburg.de schreef: > > > Hello there, > > > > > > > > I import a new database into Informix 10 from the old system. The owner for this DB is the same from old system and part of the Informix group (under etc/group) > > > > Than I successfully assignment all tables within MS-Access by using ODBC. > > > > > > > > Now becomes my problem when I tried to delete, insert, and update a record from MS-Access side leads that I cannot do all those operation. > > > > > > > > I have already checked the "online.log" and there is nothing helping me to avoid an