Oninit cdi / Archive
Talk to an expert →

dbaccess connect to (201). Strange problem?

Posted in 2006

Summary

Denis Zhuravlov found that piping connect to 'a' USER test insert into t1 values (100) into dbaccess gave error 201 and a password prompt problem on 10.00.UC3 Linux. vomaringo saw the same on 10.00.UC5. Joerg Rueschenschmidt suggested quoting the user and adding a semicolon: connect to 'a' USER 'test'; insert ... Denis confirmed both forms work and the second is neater. Solved.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

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