Can SQL Server call be made from unix sh

[sspreethi]

Hi,
I need to make SQL Server procedure call (exec <proc name>)from unix shell script. First of all I would like to know if it is possible. I know we can do it from Oracle but not sure about SQL Server.
Version:
SunOS 5.8
SQL 8.0

I have made the below entry in the interface file.
NSXNA267
query tcp ether NSXNA267.ibt.ibtco.com 1433
master tcp ether NSXNA267.ibt.ibtco.com 1433

When I give ->
isql -U <userid> -P <password> -S NSXNA267
I get the below error.
DB-LIBRARY error:
Unknown network type found in interface file.

isql -U <userid> -P <password> -S NSXNA267.ibt.ibtco.com
DB-LIBRARY error:
Server name not found in interface file.

Thanks,
Preethi

 

[dstxaix]

Are you referring to Sybase SQL Server or Microsoft SQL Server?

 

[SamBones]

Have you tried just this...

isql -U <userid> -P <password> -S NSXNA267

 

[sspreethi]

It is Microsoft Sql server.
Sam - Yes i tried the code I mentioned in my above post.

Please let me know other ways.

 

[rzs0502]

I use the FreeTDS libraries

http://www.freetds.org/

(for Sybase and MS SQLServer)
Then I install the TDS DB API for Python (or you could use the shell)


&quot;If you always do what you've always done, you will always be where you've always been.&quot;