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 DEBIAN

osql

osql(1) 							 FreeTDS Utilities							   osql(1)

NAME

       osql - utility to test FreeTDS connections and queries

SYNOPSIS

       osql  -S dsn -U username -P password [-I ini_dir]

DESCRIPTION

       osql  is a diagnostic tool provided as part of FreeTDS. It is a Bourne shell script that checks and reports on your configuration files. If
       everything checks out OK, it invokes isql.

       osql works only with the isql that comes with unixODBC.

OPTIONS

       -S dsn the Data Source Name to which to connect, as known to odbc.ini.

       -U username
	      database login name.

       -P password
	      database password.

       -I ini_dir
	      override odbc.ini file location.

EXAMPLE

       If you have an odbc.ini with a section like this:

	       [myDSN]
		       servername = myserver
		       TDS_Version = 5.0

       You would invoke osql as:

	       osql -S myDSN [...]

NOTES

       If you can connect with "osql -S servername -U user -P passwd", your FreeTDS ODBC installation is working.

       osql guesses where unixODBC might look for its odbc.ini by examining the binary. This is not always an effective approach.  If  it  doesn't
       work, you'll receive a report of candidate strings. Kindly pass along the output to help improve the guessing.

       If  osql  cannot intuit your odbc.ini directory, you can force the issue with the -I option. However, you're instructing osql what to test,
       not where unixODBC will eventually look. Your override is therefore only as good as you are. Look carefully  at	the  error  output  before
       overriding.

       If you have suggestions for ways to make osql more useful as a diagnostic tool, please post them to the FreeTDS mailing list.

HISTORY

       osql first appeared in FreeTDS 0.65.

AUTHORS

       The osql utility was written by James K. Lowden

doc								 13 November 2011							   osql(1)