Can SQL Server call be made from unix sh - The UNIX and Linux Forums

		The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
Can SQL Server call be made from unix sh

google unix.com

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

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Can we call JSP file from Unix.if so how.Please help me.Im newbie to Unix	mailsukumar	Shell Programming and Scripting	0	05-26-2008 09:12 AM
Call a UNIX shell with parameters from C	dustman	UNIX for Dummies Questions & Answers	1	03-14-2007 10:26 PM
How to call SQL procedure from UNIX Shellscript ?	varungupta	UNIX for Advanced & Expert Users	1	03-05-2007 11:12 AM
how to call to unix through cobol	naamas03	Shell Programming and Scripting	8	10-22-2006 08:08 AM
How to call pl/sql in unix script	YoYo	Shell Programming and Scripting	6	09-01-2005 05:59 PM


	Powered by

LinkBack

Thread Tools

Search this Thread

Rate Thread

Display Modes

#1 (permalink)

01-29-2008

sspreethi

Registered User

Join Date: Jan 2008

Posts: 1

Can SQL Server call be made from unix sh

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

Bookmarks

« ping hosts from config file | odd behaviour with quoted input strings »

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules

All times are GMT -4. The time now is 09:24 AM.