Type 3 or Type 4 JDBC database drivers for MSSQL 2000 and MS ACcess

Posted on 2006-04-11
Last Modified: 2010-03-31
What is the different between Type 3 and Type 4 JDBC database drivers?

I need JDBC database drivers for MSSQL 2000 and MS Access,
can any one suggest a type 3 or type 4 drivers for both of them?
Question by:william007
    LVL 92

    Accepted Solution

    you can get one for SQL server from M$

    Not aware of (a free) one for Access
    LVL 8

    Assisted Solution

    LVL 30

    Expert Comment

    >> I need JDBC database drivers for MSSQL 2000 and MS Access

    I'd suggest you use the JDBC-ODBC bridge for MS Access (use the sun.jdbc.odbc.JdbcOdbcDriver)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    INTRODUCTION Working with files is a moderately common task in Java.  For most projects hard coding the file names, using parameters in configuration files, or using command-line arguments is sufficient.   However, when your application has vi…
    Introduction Java can be integrated with native programs using an interface called JNI(Java Native Interface). Native programs are programs which can directly run on the processor. JNI is simply a naming and calling convention so that the JVM (Java…
    Viewers will learn about the different types of variables in Java and how to declare them. Decide the type of variable desired: Put the keyword corresponding to the type of variable in front of the variable name: Use the equal sign to assign a v…
    This tutorial covers a practical example of lazy loading technique and early loading technique in a Singleton Design Pattern.

    761 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

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now