Connect to SQl Server from Unix

• itskanchanhere

  SSC Eights!

  Points: 802

  More actions

  April 4, 2012 at 2:26 am

  #254265

  Is there a microsoft recommended way of connecting to SQL Server from a Unix box? If YES then please guide me to related pages. If NO then which would be the cleanest and most efficient way of doing this??

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  April 4, 2012 at 3:04 am

  #1468682

  This page should help you.

  -- Gianluca Sartori

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  April 4, 2012 at 3:05 am

  #1468683

  This is the downlaod page for MSSQL ODBC driver for Linux.

  -- Gianluca Sartori

• itskanchanhere

  SSC Eights!

  Points: 802

  More actions

  April 4, 2012 at 4:54 am

  #1468723

  I am trying to do this connection through script and not through any application.. Can anyone point me in right direction..

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  April 4, 2012 at 5:06 am

  #1468735

  itskanchanhere (4/4/2012)

  ---

  I am trying to do this connection through script and not through any application.. Can anyone point me in right direction..

  So, I guess I should not consider a script an application...

  Which scripting language? KSH? BSH? PERL? ...?

  -- Gianluca Sartori

• itskanchanhere

  SSC Eights!

  Points: 802

  More actions

  April 4, 2012 at 6:34 am

  #1468784

  I will be using Shell scripting..

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  April 4, 2012 at 6:48 am

  #1468791

  So, you need a command line tool to query the database.

  Here are some options:

  http://blog.nguyenvq.com/2010/04/15/accessing-ms-sql-server-from-command-line-in-mac-os-x-and-linuxunix/

  http://stackoverflow.com/questions/149395/what-are-some-ways-of-accessing-microsoft-sql-server-from-linux

  Hope this helps

  Gianluca

  -- Gianluca Sartori