HELP PLEASE!!: How to connect to SQL Sever 2000 from Solaris?

[db2sysc@gmail.com]

We want to run Unix Scripts on SunSolaris which Connected to MS SQL
Server 2000.

We would like to connect to SQL Server 2000 from Solaris. Is there any
way to connect to Sql Server 2000 natively (just like isql we use in
windows which has the client) with the help of third party ct library?
or any other drivers or tools???

TIA

[Mark D Powell]

Re: HELP PLEASE!!: How to connect to SQL Sever 2000 from Solaris?

MS SQL Server is ODBC compliant so if you purchase or write an ODBC
driver you should be able to use if to connect. Search the Internet to
see if someone offers such a driver.

HTH -- Mark D Powell --

[Robert Klemme]

Re: HELP PLEASE!!: How to connect to SQL Sever 2000 from Solaris?

Mark D Powell wrote:[color=blue]
> MS SQL Server is ODBC compliant so if you purchase or write an ODBC
> driver you should be able to use if to connect. Search the Internet
> to see if someone offers such a driver.[/color]

ODBC is just an interface spec. And it's mostly available in the Windows
world.

A low cost solution for the OP is to write a Java program that uses jTDS
JDBC driver to connect to an SQL Server DB. This will also work on
Solaris because the driver is pure Java (i.e. no native code). HTH

Kind regards

robert

[Simon Tobias]

Re: HELP PLEASE!!: How to connect to SQL Sever 2000 from Solaris?


"Mark D Powell" <Mark.Powell@ed s.com> wrote in message
news:1123768001 .088369.288060@ g43g2000cwa.goo glegroups.com.. .[color=blue]
> MS SQL Server is ODBC compliant so if you purchase or write an ODBC
> driver you should be able to use if to connect. Search the Internet to
> see if someone offers such a driver.[/color]

Under Ken North's ODBC portal, he has a table of ODBC driver providers at
http://www.sqlsummit.com/ODBCVend.HTM .

SimonT.

[Erland Sommarskog]

Re: HELP PLEASE!!: How to connect to SQL Sever 2000 from Solaris?

(db2sysc@gmail. com) writes:[color=blue]
> We want to run Unix Scripts on SunSolaris which Connected to MS SQL
> Server 2000.
>
> We would like to connect to SQL Server 2000 from Solaris. Is there any
> way to connect to Sql Server 2000 natively (just like isql we use in
> windows which has the client) with the help of third party ct library?
> or any other drivers or tools???[/color]

I have some alternatives listed on
http://www.sommarskog.se/mssqlperl/unix.html.

(Just updated with a link to the ODBC Portal suggested by Simon Tobin,
thanks Simon for that link!)


--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Mark D Powell]

Re: HELP PLEASE!!: How to connect to SQL Sever 2000 from Solaris?

Actually MS's ODBC standard is fairly well supported by Oracle and DB2.
I also believe that mySQL supports ODBC access.

www.datadirect.com is a good souce for ODBC drivers that connect UNIX
based databases to SQL Server.

HTH -- Mark D Powell --