Problem with DSN name!!! Urgent

Sorry im new to java,

i am using JSP ,and MS Access Database,

my code is as shown below

Connection conn=null;

Statement st=null;

ResultSet rs=null;

try

{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

}

catch (ClassNotFoundException e)

{

System.out.println("JdbcOdbc Bridge Driver not found");

}

try

{

conn = DriverManager.getConnection("jdbc:odbc:DBName","","");

String s="SELECT * from Table_Name '";

st = conn.createStatement();

rs=st.executeQuery(s);

while(rs.next())

{

ss=rs.getString(1);

}

I want to modify this code such that it should work at site even though ODBC DSN name chage occurs....

Thanks!

java_fundooa at 2007-7-9 6:12:37 >