471,601 Members | 982 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,601 software developers and data experts.

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 2917
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
1 post views Thread by XIAOLAOHU | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.