By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
460,023 Members | 1,235 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 460,023 IT Pros & Developers. It's quick & easy.

How to connect to MSSQL server from HP-UX environment

P: n/a
Hi,

Please confirm.. is it possible to connect to MSSQL server by executing
a shell script on HP-UX (UNIX) platform.

Regards,
Uncle Sam

Oct 9 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a


On Oct 9, 7:30 am, "Uncle Sam" <mainisund...@hotmail.comwrote:
Hi,

Please confirm.. is it possible to connect to MSSQL server by executing
a shell script on HP-UX (UNIX) platform.

Regards,
Uncle Sam
Well, certainly, but the shell script is irrelevant. A shell on
HP won't have any native capability to connect to MS SQL.
It will simply be able to run anything on your box that has
a commandline interface. So your question is whether there
is anything existing or creatable that will have a commandline
interface and can connect to MS SQL.
Yes. What do you want this connection to do? For instance,
you can write something (or find something) in Java that uses
MS's all-java JDBC driver for MS SQL. Such a Java program
could connect to MS SQL from anywhere on the net that can
see your DBMS machine. All you would need is Java. That
could be on HP or Sun, or a PDA.
Joe Weinstein at BEA Systems.

Oct 9 '06 #2

P: n/a
Thanks Joe,

for your response... also.. could you please provide in the JDBC
connection string in UNIX environment......... for establishing
connection to MSSQL on WINDOWS platform

Rgds,
Uncle Sam
jo*******@BEA.com wrote:
On Oct 9, 7:30 am, "Uncle Sam" <mainisund...@hotmail.comwrote:
Hi,

Please confirm.. is it possible to connect to MSSQL server by executing
a shell script on HP-UX (UNIX) platform.

Regards,
Uncle Sam

Well, certainly, but the shell script is irrelevant. A shell on
HP won't have any native capability to connect to MS SQL.
It will simply be able to run anything on your box that has
a commandline interface. So your question is whether there
is anything existing or creatable that will have a commandline
interface and can connect to MS SQL.
Yes. What do you want this connection to do? For instance,
you can write something (or find something) in Java that uses
MS's all-java JDBC driver for MS SQL. Such a Java program
could connect to MS SQL from anywhere on the net that can
see your DBMS machine. All you would need is Java. That
could be on HP or Sun, or a PDA.
Joe Weinstein at BEA Systems.
Oct 10 '06 #3

P: n/a


On Oct 10, 12:27 am, "Uncle Sam" <mainisund...@hotmail.comwrote:
Thanks Joe,

for your response... also.. could you please provide in the JDBC
connection string in UNIX environment......... for establishing
connection to MSSQL on WINDOWS platform

Rgds,
Uncle Sam
Just read the documentation for the driver. All you need
is the name of the machine running SQLServer, and to
make the setup of the DBMS allow mixed-mode (TCP)
connection requests.

Oct 10 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.