Solved

JDBC for Access97 and SQL Server

Posted on 1998-09-17
4
198 Views
Last Modified: 2012-05-04
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
Comment
Question by:JohnO061798
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 

Expert Comment

by:pureDan
ID: 1224391
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
 

Author Comment

by:JohnO061798
ID: 1224392
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
 
LVL 1

Accepted Solution

by:
baresse earned 200 total points
ID: 1224393
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
 

Author Comment

by:JohnO061798
ID: 1224394
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

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
jsp login check 12 67
maven disable workspace resolution 1 79
java imports not found 4 71
Html split(text) 2 50
After being asked a question last year, I went into one of my moods where I did some research and code just for the fun and learning of it all.  Subsequently, from this journey, I put together this article on "Range Searching Using Visual Basic.NET …
Java contains several comparison operators (e.g., <, <=, >, >=, ==, !=) that allow you to compare primitive values. However, these operators cannot be used to compare the contents of objects. Interface Comparable is used to allow objects of a cl…
Viewers will learn about if statements in Java and their use The if statement: The condition required to create an if statement: Variations of if statements: An example using if statements:
This tutorial covers a practical example of lazy loading technique and early loading technique in a Singleton Design Pattern.
Suggested Courses

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question