How to connect to MSSQL server from HP-UX environment

Hi,

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

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

Quote:

Originally Posted by

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.|||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
joeNOSPAM@.BEA.com wrote:

Quote:

Originally Posted by

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

Quote:

Originally Posted by

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.

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

Quote:

Originally Posted by

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.

How to configure MSDTC in a 2003 OS cluster environment running Sql Server 2005?

Dear fellows,

We're installing Sql Server 2005 in Active-Active way.

As far as I know seems that at first MSDTC must be installed before Sql. But how?

Does anyone ever faced this kind of requirement?

Any document related with this issue would be very useful

TIA

Hi Eric,

I don't know if your problem is solved, but here is the info you require:

Http://support.microsoft.com/?id=301600

Hope this helps

How to configure MSDTC in a 2003 OS cluster environment running Sql Server 2005?

Dear fellows,

We're installing Sql Server 2005 in Active-Active way.

As far as I know seems that at first MSDTC must be installed before Sql. But how?

Does anyone ever faced this kind of requirement?

Any document related with this issue would be very useful

TIA

Hi Eric,

I don't know if your problem is solved, but here is the info you require:

Http://support.microsoft.com/?id=301600

Hope this helps

How to configure bidirectional replication

In a MSCS SQL 2000 SP3 cluster environment I plan on implementing
transactional replication. Distributor and publisher are on the same server
(quad processor machine). I Intent to publish a relatively small db (@. 60
articles) to a subscriber in a remote SQL Server cluster and would like to
have updates made to subscribers also replicated back to publisher. I
understand bidirectional replication is not supported by the replication
wizard in enterprise manager. How can that be achieved?
For starters, this article may help:
http://support.microsoft.com/default...75&Product=sql
There's also an article on this subject in SQL Server Magazine
(www.sqlmag.com) by Bren Newman, ArticleID 42858.
"Cesar" wrote:

> In a MSCS SQL 2000 SP3 cluster environment I plan on implementing
> transactional replication. Distributor and publisher are on the same server
> (quad processor machine). I Intent to publish a relatively small db (@. 60
> articles) to a subscriber in a remote SQL Server cluster and would like to
> have updates made to subscribers also replicated back to publisher. I
> understand bidirectional replication is not supported by the replication
> wizard in enterprise manager. How can that be achieved?
>
>