Oninit cdi / Archive
Talk to an expert →

dbaccess connect to (201). Strange problem?

Posted in 2006

Topics: Error Codes & Troubleshooting, Server Administration, Security, Permissions & Auditing

Denis.Zhuravlov@gmail.com — — source: Usenet: comp.databases.informix

> echo "connect to 'a' USER test; insert into t1 values (100);"|dbaccess sysmaster Database selected. 201: A syntax error has occurred. Error in line 1Near character position 24 206: The specified table (t1) is not in the database. 111: ISAM error: no record found. Error in line 1Near character position 42 Database closed. -------------------------------------------------------------------------------------------------------- > echo "connect to 'a' USER test fsdfsgdgfgh; insert into t1 values (100);"|dbaccess sysmaster Database selected. ENTER PASSWORD: Disconnected. Connected. 1 row(s) inserted. Disconnected. fsdfsgdgfgh -- any string. 10.00.UC3 Linux.

↪ replying to Denis.Zhuravlov@gmail.com
vomaringo@yahoo.com — — source: Usenet: comp.databases.informix

> -------------------------------------------------------------------------------------------------------- > > echo "connect to 'a' USER test; insert into t1 values (100);"|dbaccess sysmaster same with ids10uc5 linux. for me it work's with : echo "connect to 'a' USER test insert into t1 values (100);"|dbaccess sysmaster

↪ replying to Denis.Zhuravlov@gmail.com
=?ISO-8859-1?Q?J=F6rg_R=FCschenschmidt?= — — source: Usenet: comp.databases.informix

Denis.Zhuravlov@gmail.com schrieb: >>echo "connect to 'a' USER test; insert into t1 values (100);"|dbaccess sysmaster > > Database selected. > > 201: A syntax error has occurred. > Error in line 1> Near character position 24 > > 206: The specified table (t1) is not in the database. > 111: ISAM error: no record found. > Error in line 1> Near character position 42 > > Database closed. > > -------------------------------------------------------------------------------------------------------- > >>echo "connect to 'a' USER test fsdfsgdgfgh; insert into t1 values (100);"|dbaccess sysmaster > > Database selected. > ENTER PASSWORD: > Disconnected. > Connected. > 1 row(s) inserted. > Disconnected. > > > fsdfsgdgfgh -- any string. > 10.00.UC3 Linux. > Try connect to 'a' USER 'test'; insert into t1 values (100); Regards ... Joerg

↪ replying to =?ISO-8859-1?Q?J=F6rg_R=FCschenschmidt?=
Denis.Zhuravlov@gmail.com — — source: Usenet: comp.databases.informix

>echo "connect to 'a' USER test insert into t1 values (100);"|dbaccess > connect to 'a' USER 'test'; insert into t1 values (100); both work's, second looks pretty, tnks.

Glossary