10-25-2012
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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... (3 Replies)
Discussion started by: ali560045
3 Replies
2. Shell Programming and Scripting
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.... (1 Reply)
Discussion started by: princeboot
1 Replies
3. Shell Programming and Scripting
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"
... (2 Replies)
Discussion started by: shadow_boi
2 Replies
4. Shell Programming and Scripting
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 (3 Replies)
Discussion started by: anupdas
3 Replies
5. Shell Programming and Scripting
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.... (7 Replies)
Discussion started by: dani_nonato
7 Replies
6. Shell Programming and Scripting
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;... (6 Replies)
Discussion started by: guif
6 Replies
7. UNIX for Dummies Questions & Answers
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... (1 Reply)
Discussion started by: SkySmart
1 Replies
8. UNIX for Dummies Questions & Answers
Hello,
I need to test telnet connections using port number for few hosts.
Could you please help me?
Thanks !! (1 Reply)
Discussion started by: skhichi
1 Replies
9. UNIX for Dummies Questions & Answers
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... (1 Reply)
Discussion started by: nash83
1 Replies
10. HP-UX
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 (1 Reply)
Discussion started by: sembii
1 Replies
LEARN ABOUT DEBIAN
odbcinst
odbcinst(1) UnixODBC Reference odbcinst(1)
NAME
odbcinst - command line tool for batch ODBC configuration
SYNOPSIS
odbcinst action object options
action is one of
-i install a driver or data source
-u uninstall a driver or data source
-q query a list of drivers or data sources present on the system
--version
shows the version number of the program
object is one of
-d an ODBC driver in /etc/odbcinst.ini
-s an ODBC Data Source Name (DSN) in an odbc.ini file.
options are zero or more of
-f template file
Used with -i, this option specifies a template file containing the driver or DSN to be installed.
-r Read the template from standard input.
-n Driver/Data Source Name
Used with -u to specify a driver or DSN to remove.
-v Contrary to standard practice, this turns off verbose output; there is no output, even for errors.
-l The specified Data Source object is a System DSN, in /etc/odbc.ini.
-h The specified Data Source object is a User DSN, in the current user's $HOME/.odbc.ini. This is the default with -s.
DESCRIPTION
odbcinst updates the configuration files that control ODBC access to database servers on the current host. It also maintains in
/etc/odbcinst.ini a count of the number of references to a particular driver, which can be used to determine whether it should be removed
from the file (only when the reference count drops to 0).
Installing
Drivers and DSNs are installed using the -i option.
If the object to be installed is a driver (-d), the specified driver is added to /etc/odbcinst.ini or its reference count is incremented if
it is already there.
If the object is a data source (-s), the data source is added either to /etc/odbc.ini (if -l is used) or to $HOME/.odbc.ini (the default,
which can also be specified with -h).
Uninstalling
Uninstalling a driver is done with the command odbcinst -u -d -n driver name. Uninstalling a DSN is done with the command odbcinst -u -s
-n data source name. Uninstalling causes the reference count on the object to be decremented. If nothing else has requested this driver
or DSN (i.e., the reference count drops to zero), it is removed from the config file.
The options -l and -h are used with -s to specify which odbc.ini file to configure.
Queries
The command odbcinst -q -d returns a list of all drivers present in /etc/odbcinst.ini. The command odbcinst -q -s returns a list of all
system and user DSNs available.
EXIT STATUS
0 Success
non-zero
Failure
TEMPLATE FILES
A typical driver template looks like this:
[MySQL]
Description = MySQL driver
Driver = /usr/lib/odbc/libmyodbc.so
Setup = /usr/lib/odbc/libodbcmyS.so
A DSN template looks like this:
[Sample DSN]
Description = Test MySQL connection
Driver = MySQL
Trace = Yes
TraceFile = /tmp/odbc.log
Database = junk
Server = localhost
Port = 3306
Socket =
The Description and Driver fields should be present in all DSN configurations. Other options are driver-specific; consult your ODBC
driver's documentation for a list of allowed options, or see ODBCConfig(1) for a graphical tool that can be used to interactively set up a
DSN or driver the first time.
FILES
/etc/odbcinst.ini, /etc/odbc.ini, $HOME/.odbc.ini
AUTHOR
This manual page was written by Oliver Elphick <olly@lfix.co.uk> and Steve Langasek <vorlon@debian.org> for the Debian package of unixODBC.
SEE ALSO
ODBCConfig(1), gODBCConfig(1)
UnixODBC 2nd Mar 2002 odbcinst(1)