Two Laptop Bag*
The moose likes JDBC and the fly likes How can I connect to a SQL Server 2000 from linux machine? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How can I connect to a SQL Server 2000 from linux machine?" Watch "How can I connect to a SQL Server 2000 from linux machine?" New topic
Author

How can I connect to a SQL Server 2000 from linux machine?

ico chen
Greenhorn

Joined: Jan 18, 2004
Posts: 6
I am developing a project by using Struts, JSP and Servlet. I prefer to work under linux. However, the database is SQL Server 2000. And the project database is set up in a laptop already. How can I run tomcat on my home machine - desktop, and use eclipse, to connect the database in the laptop running SQL Server 2000?
Thanks a lot.


Flying!
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 60794
    
  65

"ico",
We're really glad that you've joined us here at the Ranch, and there aren't many rules you'll have to worry about, but one is that proper names are required. Please take a look at the JavaRanch Naming Policy and change your display name to match it.
In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.
Thanks!
bear
JSP Forum Bartender


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 60794
    
  65

Also, since this is more about the database than it is about JSP, I'm moving this to the JDBC forum.
ico chen
Greenhorn

Joined: Jan 18, 2004
Posts: 6
sorry, hopefully this is all right.
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30130
    
150

Ico,
Assuming that your desktop and laptop are networked together, you use the IP address (or machine name) of the laptop when using JDBC to connect to the remote database.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How can I connect to a SQL Server 2000 from linux machine?
 
Similar Threads
Connecting to SQL Server 2000
JDBC to ODBC to ODBC?
Error using JTDS Driver
Accessing Remote Databases
Use MS SQL Server 2000 JDBC driver with WSAD 4.0