MS Access Applets JDBC

Thread view:

jdavis999x@yahoo.ie - 20 Mar 2005 13:51 GMT

I have spent a good deal of time looking for how to connect an applet
to a remote database (MS Access) using JDBC, as yet I have found no
solid solution!!

According to some books I have read the url takes the format of
"jdbc:odbc://ipaddress:port/MS_Access/DBName"

I am working with jbuilder and this does not work

I am able to connect when i use "jdbc:odbc:DBNAME"

Are their any websites on how to soleve this problem!!

I really need a solid example of how to over come this problem.

When I run the applet within a browser using "jdbc:odbc:DBNAME"
which worked in JBuilder, it fails to create the connection. This is
because of security. What is the solution around this problem??

Their seems to be a good few topics posted on this subject, but I have
seen no workable solutions!!!

Reply to this Message

Raymond DeCampo - 20 Mar 2005 14:39 GMT

> I have spent a good deal of time looking for how to connect an applet
> to a remote database (MS Access) using JDBC, as yet I have found no
[quoted text clipped - 17 lines]
> Their seems to be a good few topics posted on this subject, but I have
> seen no workable solutions!!!

First, the URL connection string is a function of the JDBC driver. So
look at the documentation for the JDBC driver.

Second, get your program working as an application first. That way you
can eliminate any applet security issues from the equation.

Next, start worrying about applet security issues. For starters, the
applet can only talk to the server that hosts the applet. So the
database needs to run on the same server (or you need to employ some
trickery). Second, I would be concerned about using the JDBC-ODBC
bridge in an applet. I would imagine that it uses resources that are
applet no-nos. But I am not certain of this.

If you can't get around the applet security, look into signing your applet.

HTH,
Ray

Signature

XML is the programmer's duct tape.

Reply to this Message

MS Access Applets JDBC

Free Magazines