Connect SQL server from UNIX | Unix Linux Forums | Shell Programming and Scripting

  Go Back    


Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here.

Connect SQL server from UNIX

Shell Programming and Scripting


Closed Thread    
 
Thread Tools Search this Thread Display Modes
    #1  
Old 07-10-2013
help_scr_seeker help_scr_seeker is offline
Registered User
 
Join Date: Jun 2011
Last Activity: 11 July 2013, 2:47 AM EDT
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Connect SQL server from UNIX

We want to connect to SQL server from unix (AIX 6.1 version)

HTML Code:
MS SQL Server 2008 R2
and below are the details of SQL server

HTML Code:
Microsoft SQL Server Management Studio 10.50.1600.1
Microsoft Analysis Services Client Tools 10.50.1600.1
Microsoft Data Access Components (MDAC) 3.85.1132
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0 
Microsoft Internet Explorer 8.0.6001.18702
Microsoft .NET Framework 2.0.50727.3643
Operating System 5.1.2600
We have installed Data direct Technologies's ODBC driver

HTML Code:
[DataDirect 5.1 SQL Server Wire Protocol]
Driver=/usr/opt/ibm/WSII/odbc/lib/FRmsss21.so
Description=DataDirect 5.1 SQL Server Wire Protocol
there is no utility or client tool, to connect directly to SQL server.

I assume isql may help? If that is correct, can you please let me know from where we can download it?

If this Data direct does not suits, please let me know some other tool.

Thanks for the needful.
Sponsored Links
    #2  
Old 07-10-2013
Just Ice's Avatar
Just Ice Just Ice is offline Forum Advisor  
Lights on, brain off.
 
Join Date: Mar 2005
Last Activity: 20 September 2013, 10:59 AM EDT
Location: Philadelphia metro
Posts: 958
Thanks: 3
Thanked 67 Times in 60 Posts
sql server is on windows server and you want to connect to it from an aix box ...

you may want to specify exactly what is the purpose for connecting to sql server so you could better answers ...
Sponsored Links
    #3  
Old 07-11-2013
help_scr_seeker help_scr_seeker is offline
Registered User
 
Join Date: Jun 2011
Last Activity: 11 July 2013, 2:47 AM EDT
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
we are moving from db2 to sql server. thats the purpose.
Sponsored Links
Closed Thread

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Connect to SQL server from Linux cvsanthosh SuSE 1 01-01-2013 10:11 PM
how to Connect from ksh script to SQL server santoshhegde Shell Programming and Scripting 2 10-25-2012 09:37 AM
How to connect Unix and Sql Server 2005? parthmittal2007 Emergency UNIX and Linux Support 14 01-19-2012 01:54 AM
connect to SQL server from shell script amitbhelave Solaris 0 12-15-2010 08:18 AM
Connect From VB to SQL Server Than Chanroeun Solaris 0 08-04-2006 11:48 AM



All times are GMT -4. The time now is 04:38 PM.