• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 224
  • Last Modified:

JDBC for Access97 and SQL Server

Does anyone know how to connect a MsAccess97 or MsSQLServer database to a Java applet? Is it possible deploy this functionality without distributing files to the client?

(DevPlat: Winnt J++6.0b, DeployPlat: WinntServer(IIS))

Many thanks.
0
JohnO061798
Asked:
JohnO061798
  • 2
1 Solution
 
pureDanCommented:
It's possible to access a database from an applet thru JDBC...my in my previous experience a only achieved a connection to a database from an application...not from an applet thru JDBC-ODBC driver.
how? in Control Panel / 32 bit ODBC/User DSN  do the following:
1. Add the driver U need
2. in the Datasource Name TextField type your database name (without the extension)
3. then Select the path to your database.
4. You 've got also some Advanced features like seting a password or smthng. for your database.

------------
Once U've done this U can access thru code your database.

Hope this helps U.

0
 
JohnO061798Author Commented:
This is asked in a client-server context ie. applet connects to *remote* MS database. I know it can be done with JDBC-ODBC bridge BUT I am interested in a PURE java solution where a JDBC driver does the work of connecting to and querying the DB. Is there such a driver around or does anyone know a work-around. (MS seem keen to promote their ADO technology which is NOT pure Java)
0
 
baresseCommented:
You can go here for JDBC availabe Driver :

  http://java.sun.com/products/jdbc/jdbc.drivers.html

you can found :  IDS Software
                 Intersolv
                 NetAway
                 etc...
for type 3 Driver  -> to use with 3-tiers (middleware) architecture.

WebLogic for a type 4 Driver for MsSQLServer.

I don't know if theses drivers are free...

I've developped exaclty what you want but with a ORACLE database
and so a free ORACLE Driver. A client-server context where applet connects to *remote* ORACLE database through a firewall by
using either RMI, either CORBA and for both JDBC. (I've made 2 versions)



0
 
JohnO061798Author Commented:
Thanks for that. The WebLogic driver does cost around $500 dollars though! I have since found www.synsoft.com whose JDBLite driver does the job with a small footprint although I'm not sure how scalable it is.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now