Results 1 to 3 of 3
  1. #1
    mahasarathi is offline Member
    Join Date
    Feb 2009
    Posts
    1
    Rep Power
    0

    Default connecting to remote SQL server

    How to connect to a remote database server(SQL server 2005) using JSP?

    I know this connectivity for local host, but don't know how to do this for a remote database server.
    I don't know how to check that the server is configured for outside access.
    Is JTDS a solution for this problem? If so how to place the jar file in the classpath?


    Thanks in advance.

  2. #2
    masijade is offline Senior Member
    Join Date
    Jun 2008
    Posts
    2,571
    Rep Power
    9

    Default

    Quote Originally Posted by mahasarathi View Post
    How to connect to a remote database server(SQL server 2005) using JSP?
    I know this connectivity for local host, but don't know how to do this for a remote database server.
    Change "localhost" in the URL to the server ip address/hostname, maybe? Have you even tried?
    I don't know how to check that the server is configured for outside access.
    Speak with the administrators of the servers (and network because of possible firewall/proxy issues), or if they are yours, find correspondings forums, as those issues are system issues, and not Java issues.
    Is JTDS a solution for this problem? If so how to place the jar file in the classpath?


    Thanks in advance.
    Seeing as how that is a JDBC Driver for MS SQL Server (If I remember right), yes. Check the documentation for your app server / web container.
    Last edited by masijade; 02-23-2009 at 11:37 AM.

  3. #3
    satkk is offline Member
    Join Date
    Apr 2009
    Posts
    8
    Rep Power
    0

    Default re:

    You can do it in DSN settings, go through it carefully, select the name of other machine on network(if on network, u can see), instead of localhost or '.', most people do, when i changed it worked for me.

Similar Threads

  1. Connecting to SQL Server 2008 DB
    By Lyle in forum Eclipse
    Replies: 1
    Last Post: 02-22-2009, 04:26 PM
  2. Applet connecting to server
    By zenMarko in forum Java Applets
    Replies: 1
    Last Post: 11-15-2008, 04:32 PM
  3. Connecting To SQL Server
    By rmaadil in forum JDBC
    Replies: 7
    Last Post: 08-20-2008, 05:53 PM
  4. Connecting to a Web server
    By Java Tip in forum java.net
    Replies: 0
    Last Post: 04-07-2008, 07:57 PM
  5. Java connecting to sql server 2005
    By pelegk2 in forum JDBC
    Replies: 0
    Last Post: 04-05-2008, 09:17 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •