face problem to read data from microsoft access

[chyeeqi]

i have the error of
problem connecting to jdbc:odbc:testdb

testdb is my database file name..how can i fix the error???

i face the probelm at here

String URL = "jdbc:odbc:testdb";//Change data source name.
        String username = "";
        String password = "";

[RamyaSivakanth]

Hi,
Have you mapped ur db with dsn like this below.

Goto Control panel and select Administrative Tools -> Data Sources(ODBC) -> you will get a window "ODBC DataSource Administrator".

In the above window select Add button then you will get "Create New Data Source" window.In that list you need to select "Driver do Microsoft Access(*.mdb)" option and the click "Finish" button. Then,you will get "ODBC Microsoft Access set up" window.

In the above window enter "Data Source Name" as any name which u have to use it in your program.Then click "Select" button.U have to map this name to db file by selecting the location.

So the above mapped DSN name only u need to give in ur code as jdbc:odbc:dsnName.

Do the above steps and let me know if u get problems.

[chyeeqi]

i alrady done that setting....but having the same problem....

[RamyaSivakanth]

Send the java execption by calling printStackTrace and also send the code.
Are u refering the datasource name properly?

[chyeeqi]

this is my code...help me where got problem

import java.sql.*;
import java.io.*;


public class Search {
    public static void main (String args[]) throws IOException{
	BufferedReader br=new BufferedReader (new InputStreamReader(System.in));
        String URL = "jdbc:odbc:testdb";//Change data source name.
        String username = "";
        String password = "";

        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        } catch (Exception e) {
            System.out.println("Failed to load JDBC/ODBC:dsnName.");
            return;
        }

        Statement stmt = null;
        Connection con=null;
        try {
            con = DriverManager.getConnection (
                URL,
                username,
                password);
            stmt = con.createStatement();
        } catch (Exception e) {
            System.err.println("problems connecting to "+URL);
        }

       String input;
       input=br.readLine();

        try {
            ResultSet result = stmt.executeQuery(
                "SELECT * FROM chee Where day='" + input + "'");//Select Query statement
            ResultSetMetaData meta = result.getMetaData();

			//============================================================================
			
			//get all records
			String programmer; 
			double price;
			while(result.next()) { 
			   programmer= result.getString("programmer");
			   price=result.getDouble("Price");
			   
			    
			   System.out.println(programmer + "\n");
			} 

			//============================================================================
            con.close();
        }
        catch (Exception e) {
          e.printStackTrace();
        }
    }
}

[RamyaSivakanth]

Hi,
U print the exception like

e.printStackTrace() so that u can find the exact problem inside the exception block .

Anyway you are not having userName and password know just use

DriverManager.getConnection("jdbc:odbc:testdb");

Crosscheck whether testdb is listed in userdsn and mapped to ur db file

[netrista]

Hello,

In addition to logging, as Ramya has suggested, I would add:

1. Determine what JDK/JRE resources are on your Windows client.

2. Ensure the local classpath SYSTEM and USER variables point to the correct JAVA resources.

3. Ensure java <driver class> returns the correct driver info.

4. Ensure the driver is compatible with your version of the JAVA resources.

5. Sanity test your JDBC-ODBC bridge with a standard JDBC demo app.

6. If the problem persists, perform parallel tests with 3rd-party ODBC drivers just to see if the problem is inherent to your current driver or generalized and probably indicative of some problem with your code or environment.

Best regards,
Netrista Khatam
Technical Services Manager
OpenLink Software

[chyeeqi]

i already fix it...thank u very much !!! XD