This week's book giveaway is in the Agile and other Processes forum.
We're giving away four copies of The Mikado Method and have Ola Ellnestam and Daniel Brolund on-line!
See this thread for details.
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
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply 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: 56192
    
  13

"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


[Smart Questions] [JSP FAQ] [Books by Bear] [Bear's FrontMan] [About Bear]
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 56192
    
  13

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: 26192
    
  66

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://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: How can I connect to a SQL Server 2000 from linux machine?
 
Similar Threads
Error using JTDS Driver
Accessing Remote Databases
Use MS SQL Server 2000 JDBC driver with WSAD 4.0
Connecting to SQL Server 2000
JDBC to ODBC to ODBC?