hava a look at the usual web sites at www.javasoft.com

typically , if you want to connected to Access you have to set up a DSN with the ODBC 
bridge, on win2k you can find this:

control panels->administrative tools->datasources (ODBC)
from here you can set up a new reference to your database , go to SystemDsn tab and 
click on 'add'. The wizard should start up and the rest should be easy.

simple code to connect to your database is usually something like:

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
                        connection_ = 
DriverManager.getConnection("Jdbc:Odbc:"+databasename,user,password);

where 'databasename' is the name of the database you specify in the DSN

'user' is the admin user name specified again in the dsn (this is typically "sa")

and 'password' is the passoword for the 'user' (also specified in the dsn bridge)



-----Original Message-----
From: Mick Sullivan [mailto:[EMAIL PROTECTED]]
Sent: 08 March 2001 10:28
To: [EMAIL PROTECTED]
Subject: CONNECTING TO MS ACCESS DB?


Hi all,
Does anyone know where i could find code (or documentation) that would 
enable my JSP pages to connect to a MS ACCESS Database?
I have all the JSP pages (with beans) submitting and requesting information 
via response pages, now i just need to set the project up with a database.
Any Help at al would be greatly appreciated.
Thanks in advance, Mick
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]

Reply via email to