mysql- microsoft access

mysql- microsoft access

hello,

In all your tutorials, you have used Mysql. If instead of mysql i use microsoft access so how will it differ and wat will be the connection steps?

View Answers

May 31, 2011 at 2:00 PM

Follow these steps:

1)Go to the start<<Control Panel<<Administrative Tools<< data sources.

2)Click Add button and select the driver Microsoft Access Driver(*.mdb).

3)After selecting the driver, click finish button.

4)Then give Data Source Name and click ok button.

5)Your DSN will get created.

6) Restart your command prompt and compile your program:

import java.sql.*;
import javax.swing.*;
class  Retrieve{
public static void main(String[] args){
    try{
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
           Connection con = DriverManager.getConnection("jdbc:odbc:student");
           Statement st=con.createStatement();
           ResultSet rs=st.executeQuery("select * from data");
           String name="",address="";
           while(rs.next()){
              System.out.println(rs.getString("name")+rs.getString("address"));

           }
    }
    catch(Exception e){}

    }
}









Related Tutorials/Questions & Answers:
mysql- microsoft access
mysql- microsoft access  hello, In all your tutorials, you have used Mysql. If instead of mysql i use microsoft access so how will it differ and wat will be the connection steps
JSF CONNECTION WITH MICROSOFT ACCESS
JSF CONNECTION WITH MICROSOFT ACCESS  HI CAN U PLEASE HELP ME WITH A PROGRAM WHICH SHOWS HOW TO RETRIEVE DATAS FROM MICROSOFT ACCESS.I HAD TO CREATE AN USER INTERFACE USING JSF BY CONNECTING TO MS ACCESS THANKS DEEPAK
Advertisements
Use JDBC to connect Microsoft Access
Use JDBC to connect Microsoft Access  How to use JDBC to connect Microsoft Access
The JDBC API to access a desktop database like Microsoft Access over the network.
The JDBC API to access a desktop database like Microsoft Access over the network.  How can I use the JDBC API to access a desktop database like Microsoft Access over the network
retreiving data from microsoft access database
retreiving data from microsoft access database  How can i retrieve data from microsoft access when i have select the vaules in combo box and text box. When i select these values... i want to retrieve the corresponding columns
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.  String sql = "UPDATE emp_details SET empEname = ?, emailId = ?, guid =?, proximityCard =?, managerEmailId = ?, reviewerEmailId
Migrating from mysql to MS Access
Migrating from mysql to MS Access  Hi I am hoping for some help I need to write a conversion program (SQL statements) to import existing data in a MYSQL database to a MS Access database. any suggestions would be appreciated
why it is very slow when I am using the backend as microsoft access file for running the java webapplication - SQL
why it is very slow when I am using the backend as microsoft access file for running the java webapplication  I am using the backend as microsoft access file for running the java webapplication.it is very slow when twoor mor
how to close the connection object,statement object,resultssetobject when using the microsoft access a database - SQL
how to close the connection object,statement object,resultssetobject when using the microsoft access a database   Hi Friend, I am developing the webapplication using the jsp(business logice-jsp).backend is microsoft access
How to access (MySQL)database from J2ME?
How to access (MySQL)database from J2ME?  I am new to J2ME. I am using NetBeans. Can anyone help me? How to access (MySQL)database from J2ME? ( I search a lot I found that there is need to access database through servlet
access image from ajax store in mysql using jsp
access image from ajax store in mysql using jsp  access image from ajax store in mysql using jsp (code to access image captured by camera and store in mysql
MySQL Access Control
MySQL Access Control       MySQL Security Access Control Most users concentrate on MySQL's databases... or malicious mischief. With that in mind, this chapter examines the MySQL access
access data from mysql through struts
access data from mysql through struts  I am Pradeep Kundu. I am making a program in struts in which i want to access data from MySQL through struts. I am using Strut 1.3.8 , Netbean 6.7.1 and MySQL 5.5. In this program ,I want
Access data from mysql through struts-hibernate integration
Access data from mysql through struts-hibernate integration  Hi friends, I am making a program in which I want to access data from mysql... delete and insert command gives output correctly but they don't update mysql
MicroSoft word
MicroSoft word  sir i want to develop an swing application like the microsoft word Document.can you help me pls
access
access   This is Nitha Sriram i am having a problem that, i am having a combo box in the JSP page when i select an item from that i am calling the onchange function. In javascript i am getting the value now i want to pass
Video Tutorial: How to access MySQL through JDBC?
How to access MySQL through JDBC? The interface that is used to access... of "How to Access MySQL through JDBC?":ADS_TO_REPLACE_1 In the JAR... click and select run as option. If successful, you can now access Mysql
Access Specifiers and Access Modifiers
Access Specifiers and Access Modifiers  What are Access Specifiers and Access Modifiers
Microsoft ajax library
Microsoft ajax library  Hi, I am .NET developer. Give me the url of microsoft ajax library
ModuleNotFoundError: No module named 'microsoft'
ModuleNotFoundError: No module named 'microsoft'  Hi, My Python... 'microsoft' How to remove the ModuleNotFoundError: No module named 'microsoft' error? Thanks   Hi, In your python environment you
implement microsoft office
implement microsoft office   how implement microsoft office in my java swing project ,or when microsoft office is not install then file open in defualt text editar.please send me source code
MS ACCESS - JDBC
MS ACCESS  java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'origin='src' destination='dest''. THAT MY PROBLEM
access specifiers and access modifiers
access specifiers and access modifiers  I want a powerpoint presentation for access specifiers and access modifiers. Please send me the same and soon
MS-Access
MS-Access  I am trying to upload a image to ms-acess using jsp,and my problem is that it shows some error int the browser that "java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect ".I think i set
Microsoft Visual Fox Pro - SQL
Microsoft Visual Fox Pro  how can create a query using sql on microsoft visual fox pro 6.0
microsoft data science
microsoft data science  Hi, I am beginner in Data Science and machine learning field. I am searching for the tutorials to learn: microsoft data... the topic "microsoft data science". Also tell me which is the good
microsoft data science certification
microsoft data science certification  Hi, I am beginner in Data...: microsoft data science certification Try to provide me good examples or tutorials links so that I can learn the topic "microsoft data science
edx microsoft data science
edx microsoft data science  Hi, I am beginner in Data Science... microsoft data science Try to provide me good examples or tutorials links so that I can learn the topic "edx microsoft data science". Also tell me which
microsoft academy data science
microsoft academy data science  Hi, I am beginner in Data Science...: microsoft academy data science Try to provide me good examples or tutorials links so that I can learn the topic "microsoft academy data science". Also tell
microsoft certified data scientist
microsoft certified data scientist  Hi, I am beginner in Data...: microsoft certified data scientist Try to provide me good examples or tutorials links so that I can learn the topic "microsoft certified data scientist"
microsoft edx data science
microsoft edx data science  Hi, I am beginner in Data Science and machine learning field. I am searching for the tutorials to learn: microsoft... learn the topic "microsoft edx data science". Also tell me which
microsoft azure data science
microsoft azure data science  Hi, I am beginner in Data Science and machine learning field. I am searching for the tutorials to learn: microsoft... can learn the topic "microsoft azure data science". Also tell me
edx microsoft professional program
edx microsoft professional program  Hi, I am beginner in Data... microsoft professional program Try to provide me good examples or tutorials links so that I can learn the topic "edx microsoft professional program"
data science microsoft edx
data science microsoft edx  Hi, I am beginner in Data Science... microsoft edx Try to provide me good examples or tutorials links so that I can learn the topic "data science microsoft edx". Also tell me which
microsoft data analytics certificate
microsoft data analytics certificate  Hi, I am beginner in Data...: microsoft data analytics certificate Try to provide me good examples or tutorials links so that I can learn the topic "microsoft data analytics
microsoft ai course
microsoft ai course  Hi, I am beginner in Data Science and machine learning field. I am searching for the tutorials to learn: microsoft ai course... the topic "microsoft ai course". Also tell me which is the good training
microsoft artificial intelligence certification
microsoft artificial intelligence certification  Hi, I am beginner... to learn: microsoft artificial intelligence certification Try to provide me good examples or tutorials links so that I can learn the topic "microsoft
edx microsoft ai
edx microsoft ai  Hi, I am beginner in Data Science and machine learning field. I am searching for the tutorials to learn: edx microsoft ai Try... "edx microsoft ai". Also tell me which is the good training courses
ai microsoft course
ai microsoft course  Hi, I am beginner in Data Science and machine learning field. I am searching for the tutorials to learn: ai microsoft course... the topic "ai microsoft course". Also tell me which is the good training
microsoft free ai course
microsoft free ai course  Hi, I am beginner in Data Science and machine learning field. I am searching for the tutorials to learn: microsoft free... learn the topic "microsoft free ai course". Also tell me which
microsoft ai edx
microsoft ai edx  Hi, I am beginner in Data Science and machine learning field. I am searching for the tutorials to learn: microsoft ai edx Try... "microsoft ai edx". Also tell me which is the good training courses
microsoft artificial intelligence certificate
microsoft artificial intelligence certificate  Hi, I am beginner... to learn: microsoft artificial intelligence certificate Try to provide me good examples or tutorials links so that I can learn the topic "microsoft
microsoft ai course edx
microsoft ai course edx  Hi, I am beginner in Data Science and machine learning field. I am searching for the tutorials to learn: microsoft ai... the topic "microsoft ai course edx". Also tell me which is the good
microsoft ai course free
microsoft ai course free  Hi, I am beginner in Data Science and machine learning field. I am searching for the tutorials to learn: microsoft ai... learn the topic "microsoft ai course free". Also tell me which
microsoft ai certification
microsoft ai certification  Hi, I am beginner in Data Science and machine learning field. I am searching for the tutorials to learn: microsoft ai... learn the topic "microsoft ai certification". Also tell me which
microsoft ai training
microsoft ai training  Hi, I am beginner in Data Science and machine learning field. I am searching for the tutorials to learn: microsoft ai... the topic "microsoft ai training". Also tell me which is the good
microsoft azure ai certification
microsoft azure ai certification  Hi, I am beginner in Data Science...: microsoft azure ai certification Try to provide me good examples or tutorials links so that I can learn the topic "microsoft azure ai certification"
microsoft ai certificate
microsoft ai certificate  Hi, I am beginner in Data Science and machine learning field. I am searching for the tutorials to learn: microsoft ai... learn the topic "microsoft ai certificate". Also tell me which
microsoft data & ai certification
microsoft data & ai certification  Hi, I am beginner in Data Science...: microsoft data & ai certification Try to provide me good examples or tutorials links so that I can learn the topic "microsoft data & ai certification"
microsoft data and ai certification
microsoft data and ai certification  Hi, I am beginner in Data...: microsoft data and ai certification Try to provide me good examples or tutorials links so that I can learn the topic "microsoft data and ai

Ads