Login failure

chand012 · Post by **chand012** » Tue Apr 30, 2002 9:51 am

When I issue the command below, I get a login failure:

bash-2.03$ texis -u _SYSTEM -p '********' "select * from SYSCOLUMNS"
Texis Web Script (Vortex) Copyright (c) 1996-2000 Thunderstone - EPI, Inc.
Commercial Version 3.01.959738425 of May 30, 2000 (sparc-sun-solaris2.5.1)

000 Login failure in the function permstexis
000 Could not connect to . in the function openntexis

However, when I run the same command without -u -p OR the same command with -d, it works (so it's not a bad password). What could be wrong?

Thanks,
David

Post by **mark** » Tue Apr 30, 2002 10:29 am

texis requires you use tell it what database with -d if you don't want it to use the database, if any, in the current directory (.). Notice the error "Could not connect to .".

chand012 · Post by **chand012** » Tue Apr 30, 2002 10:54 am

But, notice I said that the command works without -u -p -- i.e., texis "select * from SYSCOLUMNS". Anyway, I wonder whether some weirdness was caused by the presence of a "$" in the _SYSTEM password. I changed the password and it seems to work fine now. Or--perhaps--I lost track of my current dir before.

David

Post by **Kai** » Wed May 01, 2002 10:34 am

The "Could not connect to ." means it couldn't connect to the database in the *current directory*, which is what texis and tsql default to if no database is given with -d. You probably weren't in a database directory at the time of the command, so texis couldn't connect to the database, and therefore the login failed (regardless of user/password).