topic Re: How to connect to MS SQL Server from HP-UX? in Operating System - HP-UX

How to connect to MS SQL Server from HP-UX?

alberthsu — Thu, 29 Mar 2001 09:54:10 GMT

Hi,

Currently we are trying to customize NNM on an HP-UX box to retrieve some data stored on a MS SQL database on an NT machine. What will be the easiest way to do so?

Albert
HP Consulting

Re: How to connect to MS SQL Server from HP-UX?

Philip Chan_1 — Thu, 29 Mar 2001 10:04:36 GMT

Take a look at the MSSQL::DBlib module

http://www.algonet.se/~sommar/mssql/

with it you could manipulate SQL Server data from within Perl (nice effort by Michael Peppler & Christian Mallwitz).

The other method is feed your Transact-SQL script to the isql command, then parse the output using shell script (cut, sed, grep etc).

Hope this help.

Rgds,
Philip

Re: How to connect to MS SQL Server from HP-UX?

Tony Watts — Wed, 04 Apr 2001 00:07:31 GMT

Albert,
First, are you currently connected to the NT machine? if not, I would recommend using WRQ Reflection suite, its a highly customizable package and got me connected from my NT Server To my HP9000 server in about 45 minutes, from that point I could share data both ways including all db's drives and printers, or if you prefer there are quite a large variety of other packages that do similiar, but have tried them and then finding Reflections, I would definately recommend that.
Second, but if you are not currently connected, I cant offer too much more...Hope this was usefull...Tony