473,386 Members | 1,726 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 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 2993
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: duikboot | last post by:
Hi all, I'm trying to export a view tables from a Oracle database to a Mysql database. I create insert statements (they look alright), but it all goes wrong when I try to execute them in Mysql,...
1
by: Aliandro | last post by:
Hi I am really stuck and need some expertise help please. I have an XML file: <XML> <USER_INFO> <USERNAME>username</USERNAME> <PASSWORD>password%</PASSWORD> </USER_INFO> <SITE_INFO>...
1
by: LilleSkutt | last post by:
I am trying to create and instantiate a class into a created domain, so that I can unload the domain and replace the class (assembly .dll) while the main application is running, but I can't get it to...
14
by: TrvlOrm | last post by:
OK. After much playing around, I managed to get my frame page this far.. see code below. BUT...there are still errors with it, and what I would like to have happened is this: 1) On the Left...
23
by: Jason | last post by:
Hi, I was wondering if any could point me to an example or give me ideas on how to dynamically create a form based on a database table? So, I would have a table designed to tell my application...
1
by: Chua Wen Ching | last post by:
Hi there, I have some problems when reading XML file. 1. First this, is what i did, cause i can't seem to read "sub elements or tags" values, so i place those values into attributes like this....
2
by: Sivla | last post by:
i have a win 2000 pro machine with iis5 and VS 2003 enterprise when i try to create a web application VB dotnet tells me that i dont have the dotnet framework installed i have version v1.1.4322...
28
by: Tim_Mac | last post by:
hi, i'm new to .net 2.0, and am just starting to get to grips with the gridview. my page has autoEventWireUp set to true, which i gather is supposed to figure out which handlers to invoke when...
12
by: ThunderMusic | last post by:
hi, I have two classes in C#, one is the base, the other inherits from the base class... both are generics... Here is the definition of the second class : public class...
6
by: spider661 | last post by:
im trying to make a perl file that will take all the info from a spell_us.txt file and place it into an sql file i can import into my database but its not working can anyone help please? ...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

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.