Login or Register to Ask a Question and Join Our Community


Red Hat

Isql doesn't work when logged in remotely.

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Operating Systems Linux Red Hat Isql doesn't work when logged in remotely.
# 1  
Old 07-17-2009
Isql doesn't work when logged in remotely.
Our database is housed on a Red Hat Enterprise Linux ES release 4 (Nahant Update 8). My version of isql is "unixODBC 2.2.11".

Issue:
If I log in to this box on the internal network, or over the VPN i can
type:
Code:
isql -Usa

And it will prompt for the password and connect.

Today I logged into our one of our public facing web servers ( Mac Xserve /w Leopard ) ...then logged into the same RHEL box from there ( ssh ) via internal network. So I'm still basically connecting from the same host yet when I type the same command it just gives me the help/syntax crap.

Is there some security setting I'm missing? Here's another thing ...I can
connect if:
I ssh into my workstation from the xServe then use SQSH.

My colleague can type the same command on the same box ( RHEL ) and have it work while on the VPN.

Any ideas?

Bub

---------- Post updated at 01:28 PM ---------- Previous update was at 12:54 PM ----------

It's Sybase by the way.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Red Hat

Can C program put message to IBM MQ remotely, if local server doesn't have MQ library?

Can somebody know if it is possible to connect to remote IBM MQ, if local server using C, but don't have MQ library? Thanks for contribution (0 Replies)
Discussion started by: digioleg54
0 Replies

2. Shell Programming and Scripting

Timeout doesn't work, please help me

#!/bin/sh trap "cleanup" TERM timeout=5 mainpid=$$ cleanup() { echo "at $i interupt" kill -9 0 } watchdog() { sleep $1 } (watchdog $timeout && kill -TERM $mainpid) & run_test() (10 Replies)
Discussion started by: yanglei_fage
10 Replies

3. Shell Programming and Scripting

-ne 0 doesn't work -le does

Hi, I am using korn shell. until ] do echo "\$# = " $# echo "$1" shift done To the above script, I passed 2 parameters and the program control doesn't enter inside "until" loop. If I change it to until ] then it does work. Why numeric comparison is not working with -ne and works... (3 Replies)
Discussion started by: ab_2010
3 Replies

4. UNIX for Dummies Questions & Answers

Why doesn't this work?

find . -name "05_scripts" -type d -exec mv -f {}/'*.aep\ Logs' {}/.LogFiles \; Returns this failure: mv: rename ./019_0120_WS_WH_gate_insideTEST/05_scripts/*.aep\ Logs to ./019_0120_WS_WH_gate_insideTEST/05_scripts/.LogFiles/*.aep\ Logs: No such file or directory I don't know why it's trying... (4 Replies)
Discussion started by: scribling
4 Replies

5. Solaris

There is gcc but doesn't work !!

gcc packages are installed as is seen. # pkginfo | grep -i gcc system SUNWgcc gcc - The GNU C compiler system SUNWgccruntime GCC Runtime libraries # There is gcc in /usr/sfw/bin but It doesn't work. # gcc bash: gcc: command not found... (7 Replies)
Discussion started by: getrue
7 Replies

6. HP-UX

How can i get My parent user name while i am on remotely logged on other server.

Hi please suggest .. how can i get my original user from which logged in to another server. my main current login is $whoami nitin ssh nit01@n01 i m going (redirected)to log in below path.. nit01@n01:/home/n01 -> pwd /home/n01 nit01@n01:/home/n01 -> on this server i want get... (1 Reply)
Discussion started by: nitindreamz
1 Replies

7. UNIX for Dummies Questions & Answers

my make doesn't work

hi I wrote the following makefile, I have just one problem, when i type make clean I get the message make 'clean' is up to date and any obj file is removed from my folder, what's wrong? Thank you CC = cc all: es.o elaboration.o $(CC) -o es es.o elaboration.o elaboration.o:... (0 Replies)
Discussion started by: Puntino
0 Replies

8. UNIX for Dummies Questions & Answers

Script doesn't work, but commands inside work

Howdie everyone... I have a shell script RemoveFiles.sh Inside this file, it only has two commands as below: rm -f ../../reportToday/temp/* rm -f ../../report/* My problem is that when i execute this script, nothing happened. Files remained unremoved. I don't see any error message as it... (2 Replies)
Discussion started by: cheongww
2 Replies

9. UNIX for Dummies Questions & Answers

my ctrl+c doesn't work

it seams that my ctrl+c and my ctrl+d don't work. if I type a bunch of jiberish on a line and ctrl+c I expect the command to be cancelled and to be given a fresh prompt, but instead it just putts ^C at the end of the line. Also, ctrl+d should close the session, but instead mine just puts ^D at... (3 Replies)
Discussion started by: yankee428
3 Replies

10. Shell Programming and Scripting

Why doesn't this work?

cat .servers | while read LINE; do ssh jason@$LINE $1 done exit 1 ./command.ksh "ls -l ~jason" Why does this ONLY iterate on the first server in the list? It's not doing the command on all the servers in the list, what am I missing? Thanks! JP (2 Replies)
Discussion started by: jpeery
2 Replies
Login or Register to Ask a Question

LEARN ABOUT CENTOS

iusql

isql(1) 						       UnixODBC manual pages							   isql(1)

NAME

       isql, iusql - unixODBC command-line interactive SQL tool

SYNOPSIS

       isql DSN [USER [PASSWORD]] [options]

DESCRIPTION

       isql  is  a  command  line  tool which allows the user to execute SQL in batch or interactively. It has some interesting options such as an
       option to generate output wrapped in an HTML table.

       iusql is the same tool with built-in Unicode support.

ARGUMENTS

       DSN    The Data Source Name, which should be used to make connection to the database.  The data source is looked for in	the  /etc/odbc.ini
	      and $HOME/.odbc.ini files in that order, with the latter overwriting the former.

       USER   Specifies the database user/role under which the connection should be made.

       PASSWORD
	      Password for the specified USER.

OPTIONS

       -b     Run isql in non-interactive batch mode. In this mode, the isql processes its standard input, expecting one SQL command per line.

       -dDELIMITER
	      Delimits columns with delimiter.

       -xHEX  Delimits	columns with HEX, which is a hexadecimal code of the delimiting character in the format 0xNN - i.e. 0x09 for the TAB char-
	      acter.

       -w     Format the result as HTML table.

       -c     Output the names of the columns on the first row. Has any effect only with the -d or -x options.

       -mNUM  Limit the column display width to NUM characters.

       -lLOCALE
	      Sets locale to LOCALE.

       -q     Wrap the character fields in double quotes.

       -3     Use the ODBC 3 calls.

       -n     Use the newline processing.

       -e     Use the SQLExecDirect instead of Prepare.

       -k     Use SQLDriverConnect.

       -v     Turn on the verbose mode, where the errors are fully described. Useful for debugging.

       --version
	      Prints the program version and exits.

COMMANDS

       This section briefly describes some isql runtime commands.

       help
	      List all tables in the database.

       help table
	      List all columns in the table.

       help help
	      List all help options.

EXAMPLES

       $ isql WebDB MyID MyPWD -w -b < My.sql

       Connects to the WebDB as user MyID with password MyPWD, then execute the commands in the My.sql file and returns  the  results  wrapped	in
       HTML table.  Each line in My.sql must contain exactly 1 SQL command, except for the last line, which must be blank (unless the -n option is
       specified).

FILES

       /etc/odbc.ini
	      System-wide DSN definitions. See odbc.ini(5) for details.

       $HOME/.odbc.ini
	      User-specific DSN definitions. See odbc.ini(5) for details.

SEE ALSO

       odbcinst(1), odbc.ini(5)

AUTHORS

       The authors of unixODBC are Peter Harvey <pharvey@codebydesign.com> and Nick Gorham <nick@easysoft.com>. For the full list of  contributors
       see the AUTHORS file.

COPYRIGHT

       unixODBC is licensed under the GNU Lesser General Public License. For details about the license, see the COPYING file.

version 2.3.1							  Tue 25 Jun 2013							   isql(1)