The Artima Developer Community
Sponsored Link

Legacy Java Answers Forum
December 2001

Advertisement

Advertisement

This page contains an archived post to the Java Answers Forum made prior to February 25, 2002. If you wish to participate in discussions, please visit the new Artima Forums.

Message:

local applet with remote database

Posted by Chin Loong on December 05, 2001 at 11:03 PM

hmm, nobody's been saying thanks to me lately.. is it that all my answers are wrong and unhelpful? getting a little demotivated :p

anyway, binod, if i'm not mistaken, your local applet (which is downloaded n resides in the individual machine) is trying to resolve your access's data source locally. when it tries to execute the DriverManager.getConnection("jdbc:odbc:[data source name here]"), it tries to look for the data source *locally*, and not remotely. one way of solving the problem is to individually create a data source that links with the remote database in each machine that's going to access the remote server.

don't get cheated by the "url" of DriverManager.getConnection(String url) ;) it doesn't mean the complete url, it means "url - a database url of the form jdbc:subprotocol:subname".

anybody else got any other solutions?




Replies:
  • :) Jay December 08, 2001 at 2:19 PM (6)
    • stranger? Chin Loong December 08, 2001 at 9:13 PM (0)
    • printing Chin Loong December 08, 2001 at 9:11 PM (4)

Sponsored Links



Google
  Web Artima.com   
Copyright © 1996-2009 Artima, Inc. All Rights Reserved. - Privacy Policy - Terms of Use - Advertise with Us