Connecting to MS SQL database from bash (using unixODBC)

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. 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 ...

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...

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...

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...

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

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...

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...

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...

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

LEARN ABOUT DEBIAN

grass-odbc

grass-odbc(1grass)						Grass User's Manual						grass-odbc(1grass)

NAME

       grass-odbc - ODBC driver

       ODBC driver ODBC driver in GRASS Communication between GRASS and ODBC database for attribute management:
       | GRASS module | | ODBC Interface | | RDBMS
       | GRASS | DBMI driver | unixODBC | ODBC driver | PostgreSQL
       | Oracle
       | ...

Supported SQL commands
       All SQL commands supported by ODBC.

Operators available in conditions
       All SQL operators supported by ODBC.

EXAMPLE

       In  this  example  we  copy  the  dbf file of a SHAPE map into ODBC, then connect GRASS to the ODBC DBMS. Usually the table will be already
       present in the DBMS.

		     Configure ODBC driver for selected database (manually or with 'ODBCConfig').  ODBC drivers are defined in	/etc/odbcinst.ini.
		     Here is example:
		      [PostgreSQL]
		      Description     = ODBC for PostgreSQL
		      Driver	      = /usr/lib/libodbcpsql.so
		      Setup	      = /usr/lib/libodbcpsqlS.so
		     FileUsage	     = 1

		      Create  DSN  (data  source  name).  The  DSN  is	used  as  database  name  in  db.*   modules.  Then DSN must be defined in
		     $HOME/.odbc.ini (for this user only) or in /etc/odbc.ini for (for all users) [watch out for the database name  which  appears
		     twice and also for the PostgreSQL protocol version]. Omit blanks at the beginning of lines:
		      [grass6test]
		      Description	      = PostgreSQL
		      Driver		      = PostgreSQL
		      Trace		      = No
		      TraceFile 	      =
		      Database		      = grass6test
		      Servername	      = localhost
		      UserName		      = neteler
		      Password		      =
		      Port		      = 5432
		      Protocol		      = 8.0
		      ReadOnly		      = No
		      RowVersioning	      = No
		      ShowSystemTables	      = No
		      ShowOidColumn	      = No
		      FakeOidIndex	      = No
		     ConnSettings	      =  Configuration	of  an	DSN without GUI is described on http://www.unixodbc.org/odbcinst.html, but
		     odbc.ini and .odbc.ini may be created by the 'ODBCConfig' tool. You can easily view your DSN structure by 'DataManager'. Con-
		     figuration with GUI is described on http://www.unixodbc.org/doc/UserManual/

	      To find out about your PostgreSQL protocol, run:

	      psql -V

		     Now create a new database if not yet existing:
		     db.createdb driver=odbc database=grass6test

		     Now store the table 'mytable.dbf' (here: in current directory) into PostgreSQL through ODBC:
		     db.connect driver=odbc database=grass6test
		     db.copy from_driver=dbf from_database=./ from_table=mytable 
			     to_driver=odbc to_database=grass6test to_table=mytable

		      Next link map to attribute table (now the ODBC table is used, not the dbf file):
		     v.db.connect map=mytable.shp table=mytable key=ID 
				  database=grass6test driver=odbc
		     v.db.connect -p

		     Finally a test: Here we should see the table columns (if the ODBC connection works):
		     db.tables -p
		     db.columns table=mytable
		      Now the table name 'mytable' should appear.
		     Doesn't work? Check with 'isql ' if the ODBC-PostgreSQL connection is really established.
       Note  that  you	can  also connect mySQL, Oracle etc. through ODBC to GRASS.  You can also check the vector map itself concerning a current
       link to a table:
       v.db.connect -p mytable.shp
	which should print the database connection through ODBC to the defined RDBMS.

SEE ALSO

	db.connect, v.db.connect, unixODBC web site, SQL support in GRASS GIS

       Last changed: $Date: 2011-02-07 18:59:50 +0100 (Mon, 07 Feb 2011) $
       Help Index

GRASS 6.4.2															grass-odbc(1grass)

Shell Programming and Scripting