• Post Reply Bookmark Topic Watch Topic
  • New Topic

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

 
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Author and ninkuma
Marshal
Posts: 66345
155
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"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
 
Bear Bibeault
Author and ninkuma
Marshal
Posts: 66345
155
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Also, since this is more about the database than it is about JSP, I'm moving this to the JDBC forum.
 
ico chen
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
sorry, hopefully this is all right.
 
author & internet detective
Marshal
Posts: 37693
575
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!