By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,369 Members | 1,131 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,369 IT Pros & Developers. It's quick & easy.

MS Access Applets JDBC

P: n/a
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!!!

Jul 18 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
jd********@yahoo.ie wrote:
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!!!


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

--
XML is the programmer's duct tape.
Jul 18 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.