java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found a

[bhanu08]

I am get this error

java.sql.SQLExc eption: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

my code for connection is

{   
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:MyDataSource1");
ps=con.prepareStatement("Select * from Reservation where TravelDate=? and FlightNo=?");
ps.setString(1,t1.getText());
ps.setString(2,t2.getText());
rs=ps.executeQuery();
rs.next();
t3.setText(Integer.toString(rs.getInt(3)));
t4.setText(Integer.toString(rs.getInt(4)));
t5.setText(Integer.toString(rs.getInt(5)));
con.close();
}

[r035198x]

hi,
iam get this error

java.sql.SQLExc eption: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

my code for connection is

{ 
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:MyDataSource1");
ps=con.prepareStatement("Select * from Reservation where TravelDate=? and FlightNo=?");
ps.setString(1,t1.getText());
ps.setString(2,t2.getText());
rs=ps.executeQuery();
rs.next();
t3.setText(Integer.toString(rs.getInt(3)));
t4.setText(Integer.toString(rs.getInt(4)));
t5.setText(Integer.toString(rs.getInt(5)));
con.close();
}

Just like the error said. You did not create the datasource. What paltform are you using and which database are you trying to connect to?

[bhanu08]

Just like the error said. You did not create the datasource. What paltform are you using and which database are you trying to connect to?

iam working on windows XP and iam using MS acess
I tried to creat a DSN but having a doubt weather i have to creat USER DSNor SYSTEM DSN

[r035198x]

iam working on windows XP and iam using MS acess
I tried to creat a DSN but having a doubt weather i have to creat USER DSNor SYSTEM DSN

Create a user DSN

[bhanu08]

Create a user DSN

still getting same error

[r035198x]

still getting same error

Did you complete all the required steps for creating the datasource?
Tell us how you did it.

[bhanu08]

i clicked ODBC Data Source Adminstrator
then
clicked User DSN
then
clicked Add
then selected
Driver Do Microsoft Access
then
clicked select and then browsed the .mdb file and clicked ok
this is the thing i did

[r035198x]

i clicked ODBC Data Source Adminstrator
then
clicked User DSN
then
clicked Add
then selected
Driver Do Microsoft Access
then
clicked select and then browsed the .mdb file and clicked ok
this is the thing i did

After add, select

Microsoft Acces Driver (*.mdb)

[bhanu08]

After add, select

Microsoft Acces Driver (*.mdb)

created but getting the same error

[bhanu08]

created but getting the same error

IS there any 1 to help me

[r035198x]

created but getting the same error

How did you create the datasource after selecting *mdb?

[chisepo]

When selecting the database name to put in the data source, make sure you don't put the access extention '.mdb' as this will make it lose the data sorce. the data source name should only have the database name with no extentiojn and the spelling should be 100% the same. Goog day man

[Avijit Kar]

what is the solution of this problem???"java .sql.SQLExcepti on: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"