Thunderstone Support Forums

Attempting to add a user in a db created with gw. No users have ever been added.

/tsql "select * from SYSUSERS";
Texis Version 03.01.962147411(20000627) Copyright (c) 1988-2000 Thunderstone EPI

U_NAME U_UID U_GID U_PASSWD
------------+------------+------------+------------+
_SYSTEM 0 0
PUBLIC 9999 9999


Texis manual on tsql says

the _SYSTEM password (empty string by default).


Entering an empty string for password produced the following error:



/tsql -a A nuts
Texis Version 03.01.962147411(20000627) Copyright (c) 1988-2000 Thunderstone EPI

_SYSTEM Password:
000 Could not open SYSTABLES in the function ddopen
002 Could not open database . in the function administer
nuts:/export/usr/rr>/tsql "select * from SYSUSERS";
Texis Version 03.01.962147411(20000627) Copyright (c) 1988-2000 Thunderstone EPI

000 Could not open SYSTABLES in the function ddopen
000 Couldn't connect to . in the function SQLConnect


Is this a bad password or a bad statement?

Since your first and last tsql SQL statements are the same and the first worked and the last didn't I must surmise that you were not in the correct directory except the first time. Make sure you are in the database directory or supply the -d option with the path to the database.

Thanks, it worked -- I thought I was in the correct directory the first time but I guess not.

Is there a list of tsql commands or a specific tutorial? Or, which sql program is most similar?

For example, "show" and "describe" (mysql) do not seem to work.