problem in sql connectivity

[Bharati]

public void ToDatabase(){
//Retrieve info from the textfields in the dialog
String Name=Name1.getText();
String SName=DomainName.getText();
String Address=IPAddress.getText();
String dbuser="";
String dbpasswd="";
String DriverPrefix="jdbc:odbc";
String DataSource="UserInfo";

//The SQL String

String SQLString="INSERT INTO Users(username,domainname,ipaddress)VALUES('"+Name +'",'"+SName+"','"+Address+'")";

//Loads JDBC/ODBC driver

try{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(Exception e){
JOptionPane.showMessageDialog(null,""+e.getMessage (),"JDBC Driver Error ",JOptionPane.WARNING_MESSAGE);
return;
}

Statement stmt=null;
Connection con=null;

//Creates connection to the database
try{
con=DriverManager.getConnection(DriverPrefix+DataS ource,dbuser,dbpasswd);
stmt=con.createStatement();
}
catch(Exception e)
{

JOptionPane.showMessageDialog(null,""+e.getMessage (),"Connection Error ",JOptionPane.WARNING_MESSAGE);
}
}

Which SQL version we need to run this code as we are using jdk1.6.0_01 since their are some compatibility issues. Plz tell what settings do we need to configure in Control Panel.
D

[masijade]

A Depends on the "DB". Ask the DB vendor what the settings are for the ODBC DataSource.

[Bharati]

Ok, But if i remove the constraint for jdk version then what will be your answer. Plz tell me the general procedure for database setting in Control Panel.:confused:

[masijade]

Like I said, ask the DB vendor. It is not a Java related question.