Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Connection string to conn to SQL from shell script

Author  Topic 

thayaparani
Starting Member

3 Posts

Posted - 2007-12-27 : 13:36:27
I have a unix shell script. I need to establish connection to the MS SQL server to execute packages and jobs. Could you please help me out on how to establish this connection as I am new to SQL server. I am using SQL Server 2000.

Thanks,
T.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-27 : 22:05:02
You need sql odbc driver for unix.
Go to Top of Page

thayaparani
Starting Member

3 Posts

Posted - 2007-12-27 : 22:39:20
How will I verify that sql odbc driver is available or not??
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-27 : 22:58:28
Ask your unix admin if installed on the machine.
Go to Top of Page

thayaparani
Starting Member

3 Posts

Posted - 2008-01-02 : 11:04:04
For which dll we should make it is available.
Go to Top of Page

KenW
Constraint Violating Yak Guru

391 Posts

Posted - 2008-01-02 : 15:37:58
thayaparani,

Which library you need for SQL ODBC on a Unix machine (which type of Unix you haven't mentioned) is not a SQL Server question, but a Unix administration question. Try asking it on a Unix forum.
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-01-03 : 23:16:20
Sql odbc is not standard unix feature, have to buy it from third party.
Go to Top of Page
   

- Advertisement -