mysql- microsoft access

Ads
 

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){}

    }
}

Ads









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
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
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?": In the JAR selection window... run as option. If successful, you can now access Mysql through JDBC. You
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
MYSQL
MYSQL  How to create time and date based trigger in mysql   MySQL Time Trigger
mysql
mysql  how to open\import table in .dbf format in mysql
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
mysql
you need to download the mysql-connector jar file for connecting java program from mysql database.......   Hi friend, MySQL is open source database... is the link for the page from where you can understand how to Download and Install MySQL
mysql
mysql  want the code for mysql nested select query with single where condition.want to select data from more than one table
Video Tutorial: How to access MySQL database from JSP?
How to access MySQL database from JSP? In this tutorial,I will teach you how to access data from JSP page. We are using MySQL database and we have a table... to the MySQL database. Here is the video tutorial of "How to access MySQL
Access Specifier
Access Specifier  What's the usage of getter and setter in access specifier? Thank You
Access level
Access level  Which access level allows exclusive access to the attributes and methods that belong to a class or classes derived from that class? default protected public private
How to Access MS Access in jar.
How to Access MS Access in jar.  how do i access my Ms-Access file... to access it via Code or is their any alter-native?? Do i need any Driver to do this ... i m able to access a Ms-access via JDBC but cant find the file wen
ModuleNotFoundError: No module named 'coco-microsoft-bot-framework'
ModuleNotFoundError: No module named 'coco-microsoft-bot-framework'  ...: No module named 'coco-microsoft-bot-framework' How to remove the ModuleNotFoundError: No module named 'coco-microsoft-bot-framework' error
ModuleNotFoundError: No module named 'coco-microsoft-bot-framework'
ModuleNotFoundError: No module named 'coco-microsoft-bot-framework'  ...: No module named 'coco-microsoft-bot-framework' How to remove the ModuleNotFoundError: No module named 'coco-microsoft-bot-framework' error
ModuleNotFoundError: No module named 'devops-microsoft-client-etl'
ModuleNotFoundError: No module named 'devops-microsoft-client-etl'  ...: No module named 'devops-microsoft-client-etl' How to remove the ModuleNotFoundError: No module named 'devops-microsoft-client-etl' error? Thanks
ModuleNotFoundError: No module named 'devops-microsoft-mapping-sspo'
ModuleNotFoundError: No module named 'devops-microsoft-mapping-sspo'  ...: No module named 'devops-microsoft-mapping-sspo' How to remove the ModuleNotFoundError: No module named 'devops-microsoft-mapping-sspo' error
ModuleNotFoundError: No module named 'devops-microsoft-sspo-etl'
ModuleNotFoundError: No module named 'devops-microsoft-sspo-etl'  Hi...: No module named 'devops-microsoft-sspo-etl' How to remove the ModuleNotFoundError: No module named 'devops-microsoft-sspo-etl' error? Thanks  
ModuleNotFoundError: No module named 'django-microsoft-auth'
ModuleNotFoundError: No module named 'django-microsoft-auth'  Hi...: No module named 'django-microsoft-auth' How to remove the ModuleNotFoundError: No module named 'django-microsoft-auth' error? Thanks   Hi

Ads