Home Answers Viewqa JDBC mysql- microsoft access

 
 


Shruti Bansal
mysql- microsoft access
1 Answer(s)      2 years ago
Posted in : JDBC

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 Pages:
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
Use JDBC to connect Microsoft Access
Use JDBC to connect Microsoft Access  How to use JDBC to connect Microsoft Access
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
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
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
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
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
Microsoft Open source
Microsoft Open source Microsoft open to open source Microsoft Corp... to the open-source community, and it wants to continue the practice, a Microsoft... of that on the way," said Microsoft's Stephen Walli, who oversaw the process of releasing
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
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 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
MS ACCESS
-> data sources. 2)Click Add button and select the driver Microsoft Access... = DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Access Driver (*.mdb... CONNECTION (MA ACCESS) LET ME KNOW IN MY PROGRAM WHERE I AM GOIN WRONG PLEASE
MS ACCESS
-> data sources. 2)Click Add button and select the driver Microsoft Access... = DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb... CONNECTION (MA ACCESS) LET ME KNOW IN MY PROGRAM WHERE I AM GOIN WRONG PLEASE
MS ACCESS
-> data sources. 2)Click Add button and select the driver Microsoft Access... = DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Access Driver (*.mdb... CONNECTION (MA ACCESS) LET ME KNOW IN MY PROGRAM WHERE I AM GOIN WRONG PLEASE
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
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
MicroSoft word
MicroSoft word  sir i want to develop an swing application like the microsoft word Document.can you help me pls
MySQL Tools
Oracle, Microsoft SQL Server, Microsoft Access and other databases  *Reduce... MySQL Tools       MySQL Migration Toolkit The MySQL Migration Toolkit is a powerful framework
MySQL For Window
.   MySQL Database Server and Microsoft Windows The Windows version... the millions of .NET developers worldwide. MySQL and Microsoft are now collaborating... MySQL For Window       MySQL
Servlet and Access - JDBC
. And how to save image in access database cause i am using Microsoft access 2003 so how to save the image file in access Database. please do reply
MySQL Books
of MySQL and Perl. Author Paul DuBois shows you how to use Perl's DBI database access... MySQL Books       List of many MySQL books. MySQL Books Hundreds of books and publications related to MySQL
Windows 8, the New Operating System from Microsoft
. With a single sign in Microsoft account you can access all your computer..., the wait for the Windows 8, the new operating system from Microsoft... system it has again shaped the quintessentially Microsoft experience
how to access the MS ACCESS database with java
; data sources. 2)Click Add button and select the driver Microsoft Access Driver...how to access the MS ACCESS database with java   how to access the MS ACCESS database with java how can we insert,delete,update,search records
jsp to access query
jsp to access query  How to insert the values from jsp to access ?   Here is a jsp code that insert the values to MS access database... Tools>> data sources. 2)Click Add button and select the driver Microsoft
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
connecting to access database
connecting to access database  print("code sample");Hi I Write java... Tool->Data Sources(ODBC) Open User DSN tab Add a user DSN Select Microsoft Access Driver(*.mdb) Select database name and Create the DSN name (e.g access
Microsoft ajax library
Microsoft ajax library  Hi, I am .NET developer. Give me the url of microsoft ajax library
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
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
PDO MySQL
PDO MySQL: MySQL is one of the most popular open source database, in this current tutorial we will come to know how to connect MySQL with PHP using PDO. Most of the web developers use MySQL with PHP, and most of the examples in our
Connections with MicroSoft SQL - JDBC
Connections with MicroSoft SQL  How to Connect Java and MS SQL?? Actually i used below code i got SQLException and class not found... import...:microsoft:sqlserver://localhost:3042/"; String db = "MyDataBase
problem in jsp using ms-access
and select the driver Microsoft Access Driver(*.mdb). 3)After selecting... the driver Microsoft Access Driver(*.mdb). 3)After selecting the driver, click
Servlet Example To Delete Mysql Blob Data
Servlet Example To Delete Mysql Blob Data  ... clips, JPEG/GIF pictures, and Microsoft word documents. getBlob() and setBlob... Statement can be used to access an SQL BLOB value. The Blob interface
mysql query
mysql query  how do transfer into the excel data to my sql  ...; data sources. 2)Click Add button and select the Drive do Microsoft Excel(*.xls... the mysql connection in your php and store the list values inside the mysql
Data Access Object
Creating Data Access Object (DAO) Design Pattern The Data Access Object is a design pattern, which consists java classes and methods to access the data. It provides a technique to separate the object persistence and data access logic
Microsoft Visual Fox Pro - SQL
Microsoft Visual Fox Pro  how can create a query using sql on microsoft visual fox pro 6.0
Servlet Example To Display Mysql Blob Data
Servlet Example To Display Mysql Blob Data    ..., video clips, JPEG/GIF pictures, and Microsoft word documents. A BLOB..., CallableStatemene and PreparedStatement can be used to access an SQL BLOB value. The Blob
Windows Web Hosting
on the Microsoft Windows Operating Systems. IIS server is used to serve the web... and Microsoft SQL Server. But it depends on the web hosting providers to providers. Many web hosting server providers also support MySQL on the web hosting servers
MySQL Tutorials
This section introduces you with the MySQL Database server. What is MySQL? In this section you will learn about the MySQL database server. You will see the features of MySQL database and why it is used in most of the websites
MySQL Training
MySQL Training     MySQL... great power and reliability in compare to many others like MS Access and price... and SQL Server. This MySQL training course provides everything like installing
java to MS Access conectivity - Swing AWT
(ODBC) 2. Open User DSN tab 3. Add a user DSN 4. Select Microsoft Access Driver...java to MS Access conectivity  give me source code to stored... database on the ACCESS.  Hi Friend, Follow these steps: 1. Open
jfreechart display from access database data.
button and select the driver Microsoft Access Driver(*.mdb). 3)After selecting...jfreechart display from access database data.  I have made a database... to retrieve the data from the access database using prepared statement and then display
how to connect to MS access database in JSP?
and select the driver Microsoft Access Driver(*.mdb). 3)After selecting the driver...how to connect to MS access database in JSP?  how to connect to MS access database in JSP? Any seetings/drivers need to be set or installed before
MySQL Database
access programs.  * MySQL Classic is the standard storage engine without... in Dreamweaver     Using MyODBC to Access your MySQL Database... including Microsoft Access and SQL Server, Oracle, dBase and Visual Fox Pro
Access Specifiers and Access Modifiers
Access Specifiers and Access Modifiers  What are Access Specifiers and Access Modifiers
saving the changes in Microsoft sql sever - SQL
saving the changes in Microsoft sql sever  How do we commit the changes in Microsoft sql server
Creating Data Access Object (DAO) Design Pattern
Creating Data Access Object (DAO) Design Pattern Data Access Object... to separating the object persistence and data access logic. All the basic data access code contains in  DAO and it provides a simple interface to access the data

Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.