Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 190
  • Last Modified:

how to make connection from jsp to ms access 97 using JDBC

i want to know how to make a connection from jsp files to ms access 97 using jdbc?? could any expert help me, thank you so much.
0
abdulmalick
Asked:
abdulmalick
1 Solution
 
cheekycjCommented:
Check out:
http://home-1.worldonline.nl/~bmc88/java/jdbc/
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=2691&lngWId=2 

pretty much you want to use the jdbc:odbc bridge for this
import java.sql.*;

try {
// load the JDBC-ODBC bridge by referencing it
  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  Connection con = DriverManager.getConnection(
        "jdbc:odbc:dsnname",
        "username",
        "password");
} catch (Exception e) {
   e.printStackTrace();
}

HTH,
CJ
0
 
girionisCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

- Points to cheekycj

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

girionis
EE Cleanup Volunteer
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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