JDBC Applets - MS Access

Thread view:

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

I am working on a Applet at the moment which must be able to access an
MS Access Database.

I need to be able to setup a jdbc connection to an Access database.

Does any body know of any webpages on how to do this?

Is it even possible?

Are signed Applets required / extra security policy permissions?

any help, or links to web pages about this problem would be great.

Another problem is that I wish to connect to a remote database,
according to some books I have read: the URL connection string has the
format of:

"jdbc:odbc://ipaddress:port/ODBC_Engine/Datasource"

When I try this it is unable to create the connection.

I have a database connection setup on my machine called
DBTEST

calling
"jdbc:odbc://DBTEST"

will work from JBuilder, but not when it is run as a standalone applet
in a webpage!!

when I try
"jdbc:odbc://localhost/DBTEST"

I also am unable to connect - any Ideas?

I have looked for answers at java.sun.com, and have spent a good deal
of time on google but as yet have not come across a useable solution.

Reply to this Message

Lee Fesperman - 21 Mar 2005 02:17 GMT

> I am working on a Applet at the moment which must be able to access an
> MS Access Database.
[quoted text clipped - 6 lines]
>
> Are signed Applets required / extra security policy permissions?

Yes, it must be signed because both the ODBC driver and the Access database must be on
the client machine. If you need the database to be on the server machine, I think you'll
be out of luck. For that you'll need a Type 4 JDBC driver, and there isn't one for
Access.

> any help, or links to web pages about this problem would be great.
>
[quoted text clipped - 5 lines]
>
> When I try this it is unable to create the connection.

AFAIK, you can't use this form with a datasource. You can use a variant of it with a
DRIVER= form instead. Normally, you would just define the ipaddress and port in the
datasource setup. However, this won't work for Access anyway because it doesn't support
connecting from another machine.

You really need to choose another database backend.

Signature

Lee Fesperman, FFE Software, Inc. (http://www.firstsql.com)
==============================================================
* The Ultimate DBMS is here!
* FirstSQL/J Object/Relational DBMS (http://www.firstsql.com)

Reply to this Message

david.murphy@jnetdirect.com - 21 Mar 2005 18:55 GMT

> I am working on a Applet at the moment which must be able to access an
> MS Access Database.
[quoted text clipped - 33 lines]
> I have looked for answers at java.sun.com, and have spent a good deal
> of time on google but as yet have not come across a useable solution.

Hi - another solution is to look at a product such as JDataConnect (at
our site www.jnetdirect.com). This provides a Sun certified JDBC 2.0 to
MS Access. The client side of the architecture is all Java so you dont
need any ODBC or bridges installed on the client machine. Using
JDataConnect you simply include the single JDBC JAR file in the web
server root.

JDataConnect also uses a server side JDBC server. If that server is
deployed on the same machine as the web server there is no need to sign
the applet since its connecting only to the web server machine. There's
a 30 day trial download on the site and some examples using JDBC
connectivity to MS Access included.

If you need more info getting setup please post to our tech support or
forums sections from the web site.

Reply to this Message

JDBC Applets - MS Access

Free Magazines