Test new DSN connection to sql server Post: 302720723

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Database Connection test in unix Script

i have a unix script that gives me the sysdate from the database EDNAMID.WORLD.What i want my script to do the following 1) Establish a database connection 2) if database connection is successfull then echo the message "Connected" 3) put the o/p of the Sql query in a spool file 4) then...

2. Shell Programming and Scripting

Connection Test Script

I am writing a script to do some conditional logic based on the results of a connection test. I need to capture the output of netcat, the 3 expected conditions are as follows. I need to capture the output of this command. I could write this to a file, but I would like to do it clearer if possible....

3. Shell Programming and Scripting

bash script to test network connection - please help

I want to test if my host can connect to any of the following 10 hosts (192.168.1.0 to 192.168.1.9) I didnt know which command i should use, so i chose ping. (i wonder if i should use tracepath or sth else) my code is the following: #!/bin/bash clear firstPart="192.168.1" maxNum="9" ...

4. Shell Programming and Scripting

Connection to Microsoft SQL Server

Hi, I am using "ksh" and trying to connect to the Microsoft SQL Server but it gives an error that is: DB-LIBRARY error: Unexpected EOF from SQL Server. Can any one please help me to resolve this issue. And i am using Putty to connect to the Unix server. Thanks

5. Shell Programming and Scripting

Help with SQL*Plus Connection

I "inherited" these scripts which are used to access an Oracle DB on a test envoiroment. Originaly someone from our security team would add an system user and password to the otherwise finished script and encrypt the whole thing. The encrypted file (script.x) would then be scheduled with Control-M....

6. Shell Programming and Scripting

Execute multiple SQL scripts from single SQL Plus connection

Hi! I would like to do a single connection to sqlplus and execute some querys. Actually I do for every query one connection to database i.e echo 'select STATUS from v$instance; exit' > $SQL_FILE sqlplus user/pass@sid @$SQL_FILE > $SELECT_RESULT echo 'select VERSION from v$instance;...

7. UNIX for Dummies Questions & Answers

Test Connection to hosts

i have about 3500 hosts/devices which i monitor. i monitor them from one host. we'll call this one host HOSTA. HOSTA has connectivity to all 3500 hosts/devices. now, i have to create a backup for HOSTA. and the back up is in another state. how do i get a list of all open ports on HOSTA so...

8. UNIX for Dummies Questions & Answers

Shell Script to test telnet connection using port

Hello, I need to test telnet connections using port number for few hosts. Could you please help me? Thanks !!

9. UNIX for Dummies Questions & Answers

UNIX string connection to sql server db

Hi, i have to perform a connection from unix to sql server database, using TCP protocol. I have all connection parameters (user,pwd,server_name,port,db_name). How can i perform this connection, by unix console ? is it available a command similar to this one (for oracle): sqlplus...

10. HP-UX

How can I test ldap connection to DC?

Hi all, Recently, I configured LDAP loadbalancing. So I need to test it from HPUX servers. But I don't know how to to it. I know many ldap connection tools such as ldap browser etc. But it's HPUX 11.31, so please share your practices. Thanks

LEARN ABOUT OSX

netrc

NETRC(5)						      BSD File Formats Manual							  NETRC(5)

NAME

     netrc -- user configuration for ftp

SYNOPSIS

     ~/.netrc

DESCRIPTION

     This file contains configuration and autologin information for the File Transfer Protocol client ftp(1).

     The .netrc file contains login and initialization information used by the auto-login process.  It resides in the user's home directory.  The
     following tokens are recognized; they may be separated by spaces, tabs, or new-lines:

     machine name
	       Identify a remote machine name.	The auto-login process searches the .netrc file for a machine token that matches the remote
	       machine specified on the ftp command line or as an open command argument.  Once a match is made, the subsequent .netrc tokens are
	       processed, stopping when the end of file is reached or another machine or a default token is encountered.

     default   This is the same as machine name except that default matches any name.  There can be only one default token, and it must be after
	       all machine tokens.  This is normally used as:

		     default login anonymous password user@site

	       thereby giving the user automatic anonymous ftp login to machines not specified in .netrc.  This can be overridden by using the -n
	       flag to disable auto-login.

     login name
	       Identify a user on the remote machine.  If this token is present, the auto-login process will initiate a login using the specified
	       name.

     password string
	       Supply a password.  If this token is present, the auto-login process will supply the specified string if the remote server requires
	       a password as part of the login process.  Note that if this token is present in the .netrc file for any user other than anonymous,
	       ftp will abort the auto-login process if the .netrc is readable by anyone besides the user.

     account string
	       Supply an additional account password.  If this token is present, the auto-login process will supply the specified string if the
	       remote server requires an additional account password, or the auto-login process will initiate an ACCT command if it does not.

     macdef name
	       Define a macro.	This token functions like the ftp macdef command functions.  A macro is defined with the specified name; its con-
	       tents begin with the next .netrc line and continue until a null line (consecutive new-line characters) is encountered.  If a macro
	       named init is defined, it is automatically executed as the last step in the auto-login process.

SEE ALSO

     ftp(1), ftpd(8)

Linux NetKit (0.17)						September 23, 1997					       Linux NetKit (0.17)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Database Connection test in unix Script

Discussion started by: ali560045

2. Shell Programming and Scripting

Connection Test Script

Discussion started by: princeboot

3. Shell Programming and Scripting

bash script to test network connection - please help

Discussion started by: shadow_boi

4. Shell Programming and Scripting

Connection to Microsoft SQL Server

Discussion started by: anupdas