473,796 Members | 2,625 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 3009
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*********@ed s.com> wrote in message
news:11******** **************@ g43g2000cwa.goo glegroups.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****@sommarsk og.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
3497
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, because the dates must have quotes on each side. I just don't know how make the dates right. Well I'll just show you the code and some insert statements it generates. Could anyone please help me?
1
5477
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> <SITE_NO>18856</SITE_NO> </SITE_INFO>
1
406
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 work for some reason. Here is the code: ' Create an appdomain Try Dim setup As AppDomainSetup = New AppDomainSetup setup.ApplicationBase = "C:\test" setup.PrivateBinPath = AppDomain.CurrentDomain.BaseDirectory setup.ApplicationName =...
14
2171
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 Frame (File LeftEx8_2.html) a series of buttons, which when clicked prompt the user to enter information for background color, text color, link color, title and some text.
23
3290
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 to create certain textboxes, labels, and combo boxes? Any ideas would be appreciated. Thanks
1
3445
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. Before: ----------
2
903
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 installed this is the most current version. could someone please tell me how to make my iis5 run asp dotnet thanks.
28
10280
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 appropriate based on your method names . the GridView has OnRowCommand="GridView1_RowCommand" in the aspx. my problem is that the RowCommand event is firing twice (95% of the time) on the page. the other 5% it only fires once. there's no
12
1632
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 CNetworkServer<PlayerInfos: CNetworkClient<PlayerInfoswhere PlayerInfos : CPlayerInfos, new() { }
6
1504
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? #!/usr/bin/perl -w # # Imports spells from spell_us.txt to spell table, as described in the config below $spellfile="spells_us.txt"; $sqlspellfile="allspells.sql"; $tbspells = "spells";
0
9685
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9533
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10461
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10190
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9057
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7555
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5579
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4122
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3736
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.