469,087 Members | 1,267 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,087 developers. It's quick & easy.

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

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

Aug 11 '05 #1
5 2851
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 --

Aug 11 '05 #2
Mark D Powell wrote:
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.


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

Aug 11 '05 #3

"Mark D Powell" <Ma*********@eds.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...
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.


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

SimonT.
Aug 11 '05 #4
(db*****@gmail.com) writes:
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???


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, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Aug 11 '05 #5
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 --

Aug 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by duikboot | last post: by
1 post views Thread by LilleSkutt | last post: by
23 posts views Thread by Jason | last post: by
1 post views Thread by Chua Wen Ching | last post: by
2 posts views Thread by Sivla | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.