Re: JDBC Applets - MS Access

david.murphy_at_jnetdirect.com
Date: 03/21/05 

Date: 21 Mar 2005 09:58:25 -0800

jdavis999x@yahoo.ie wrote:
> 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.

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.

Relevant Pages

  • Re: Thread info
    ... > I have an applet which automatically connects to my application server ... > as the applet closes it kills the connection with the application ... Or are you trying to reuse the server's thread so that it ...
    (comp.lang.java.programmer)
  • Re: VPN with WXP Laptop
    ... I'm aware that connect to the server only allows a maximum of 2 connections. ... connection, and I have not found a way to use it with an established cable ... Syncing with an access database is what I think you are trying to achieve, ...
    (microsoft.public.windows.server.sbs)
  • Re: Problem with JDBC MSSQL
    ... >>the server they were downloaded from. ... >>can sign the applet thus relaxing security restrictions. ... The wrong IP/Port was used in the connection String or, ... The SQL Server does not accept TCP/IP connections because it is not ...
    (comp.lang.java.databases)
  • Re: Unable to Update Database Records
    ... The server has been performing adds, updates, deletes without any ... > 2) Changed the Connection from the internal FrontPage database connection ... > 4) I restored from a known-working Access database backup from 4 weeks ... Thx, Chad. ...
    (microsoft.public.frontpage.programming)
  • Re: Unable to establish a socket connection
    ... int port) class on the applet side to establish a connection ... >> with the Server and the ServerSocketclass on the server ... When I run both the Server and Applet on the same workstation, ... I am unable to establish a connection with that Server. ...
    (comp.lang.java.programmer)