Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Connecting to MS SQL database from bash (using unixODBC)

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Connecting to MS SQL database from bash (using unixODBC)
# 1  
Old 06-12-2009
Connecting to MS SQL database from bash (using unixODBC)
I've installed unixODBC and I would like to connect to a MS SQL (2005) database from a bash script. Can you post a code example?

Thank you! Smilie

J.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Solaris

Connecting to Oracle database

Hi guys, long time no typing :D I have problems when I try to connect to Oracle database from SQL Developer which is located on my Windows box. Server is running Solaris 11/11 and Oracle 11 enterprise. I can log in locally with sys account to database, start it up and shut it down but when I... (2 Replies)
Discussion started by: solaris_user
2 Replies

2. Shell Programming and Scripting

script for connecting database in loops

Hi experts. I have different database and schema and their passwords in one file. In Unix : I want to create the script that connect the sqlplus and execute the select query one by one schema with different database. Ex: password File Format databse schemaname password DB1 name1 ... (1 Reply)
Discussion started by: abhigrkist
1 Replies

3. Shell Programming and Scripting

Connecting database

Hi all, In my concern they gave a task to me do cran job like To write a shell script for To connect a database it should execute a query it should save the output of the query after getting the output it should send a mail to you inbox for every one hour I can able to... (8 Replies)
Discussion started by: thelakbe
8 Replies

4. Shell Programming and Scripting

Connecting to oracle database

Hai i want to connect to oracle database from user input and create a view. ${ECHO} "Debut Creating View" ${ECHO} "Please Enter the User Name:" read user_name ${ECHO} "Please Enter the Connection String:" read con_string ${ECHO} "Please Enter the Password:" read pwd... (3 Replies)
Discussion started by: shenthil76
3 Replies

5. Shell Programming and Scripting

connecting to different database in sqr

Hi, My requirement is to generate a single text output which fetches data from two different databases. I have two different sqrs to generate text file1(data from db1) and file2(data from db2). can I execute both the sqrs from a single shell script? If yes, pls let me know how to connect to db2... (1 Reply)
Discussion started by: vimalr
1 Replies

6. Shell Programming and Scripting

Connecting to Database

Hi, I want to write a shell script which connects to a Database, executes a set of SQLs and displays a message for every SQL that was run whether any records have been returned or not? Can anyone help me in this regard? Appreciate your help and concern. Thanks, Dave (1 Reply)
Discussion started by: yoursdavinder
1 Replies

7. Windows & DOS: Issues & Discussions

Client is not connecting to the Database

Hi, Am running my client in Windows and the database (IBM DB2) is in AIX machine. if I open my client its not connecting to the database at first time and failing in a particular SQL Query. But if I close the client and open again then its connecting and the query is also working fine. Don't... (0 Replies)
Discussion started by: mvictorvijayan
0 Replies

8. Shell Programming and Scripting

Connecting to Oracle Database

if; sql="select username from dba_users where username = '$FromUser';" check_FromUser=`ExecSql "$sql"` I want to connect to Oracle database & check the users in the database, store the value in check_FromUser. First how to connect to Oracle database from the shell script ? Appreciate your... (4 Replies)
Discussion started by: dreams5617
4 Replies

9. Shell Programming and Scripting

error connecting database from perl

Hi, While i am trying to connect to Oracle database from Perl using DBI module,am getting the error as follows : Can't load '/usr/local/fuseperl-modules/lib/i586-linux-thread-multi/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libwtc9.so: cannot open shared object file: No such file... (4 Replies)
Discussion started by: DILEEP410
4 Replies

10. UNIX for Advanced & Expert Users

Connecting to a database via UNIX

hello - Is it possible to connect to a database at the command line to an Oracle instance whilst logged in on the unix box i.e. not using a script Cheers (Running Solaris) Also if anyone has any info on how a Citirix ICA client might be helpful here that would be appreciated Cheers (1 Reply)
Discussion started by: penfold
1 Replies
Login or Register to Ask a Question

LEARN ABOUT CENTOS

odbcinst

odbcinst(1)						       unixODBC manual pages						       odbcinst(1)

NAME

       odbcinst - An unixODBC tool for manipulating configuration files

SYNOPSIS

       odbcinst ACTION OBJECT OPTIONS

DESCRIPTION

       odbcinst  is  a	command line tool which has been created for allowing people who are developing the install scripts/RPMs for Drivers to be
       able to easily create/remove entries in odbc.ini and odbcinst.ini. This command line tool is a complement to the shared library of the same
       name (libodbcinst.so). This tool is a part of the odbcinst component of unixODBC.

OPTIONS

   ACTIONS
       -i     Install (add section to config file) new OBJECT.

       -u     Uninstall (remove section from config file) existing OBJECT.

       -q     Query the config files and print the options for specified OBJECT.

       -j     Prints current configuration of unixODBC, listing (among others) the paths to the configuration files.

       -c     Calls SQLCreateDataSource

       -m     Calls SQLManageDataSources

       --version
	      Prints program version and exits.

   OBJECTS
       -d     The ACTION affect drivers (and thus the odbcinst.ini configuration file).

       -s     The ACTION affect data sources (and thus the user or system odbc.ini configuration file).

   OPTIONS
       -f FILE
	      The FILE is template file, describing the configuration of installed OBJECT (only valid for the -i ACTION).

       -r     Same as the -f OPTION, only take the standard input as the template file.

       -n NAME
	      Specifies the NAME of the OBJECT.

       -v     Turn off verbose mode. This turns off all information, warning and error messages.

       -l     The specified data source is system-wide. Has any effect only with the -s OBJECT.

       -h     The specified data source is user-specific. Has any effect only with the -s OBJECT.

RETURN VALUES

       This command returns zero on success and non-zero value on failure.

FILES

       /etc/odbinst.ini
	      Configuration file containing all the database drivers specifications. See odbcinst.ini(5) for more details.

       /etc/odbc.ini
	      System-wide data sources specifications. See odbc.ini(5) for more details.

       $HOME/.odbc.ini
	      User-specific data sources specifications. See odbc.ini(5) for more details.

SEE ALSO

       odbcinst.ini(5), 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							  Wed 26 Jun 2013						       odbcinst(1)