database Connectivity

[arjun_duddu]

hiii

please help me out i am not able to connect to Data Base: i get an Exception like:
ORA-12514:TNS:listner could not resolve SERVICE_NAME given in connect desriptor

DataSourceName: Oracle
Platform:Windows XP

my code:
public static void main(String[] args) {

String driver="sun.jdbc.odbc.JdbcOdbcDriver";
String cs="jdbc:odbc:Oracle";
String user = "scott";
String pwd = "tiger";
String sqlstmt="INSERT INTO STUDENT VALUES(2,'Steve',50)";
Connection con = null;
Statement st = null;
try
{
Class.forName(driver);
}
catch(Exception e)
{
System.out.println(e);
}
System.out.println("Driver loaded");
try
{
con=DriverManager.getConnection(cs,user,pwd);
System.out.println("Connected to the Oracle Database");
st = con.createStatement();//creates a Statement object for sending SQL statements to the database.
int updatecount=st.executeUpdate(sqlstmt);//return either the row count for INSERT, UPDATE or DELETE statements, or 0 for SQL statements that return nothing
System.out.println(updatecount+" row inserted");
}
catch(Exception e)
{
System.out.println(e);
}
try
{
st.close();
con.close();
}
catch(Exception e)
{
System.out.println(e);
}
}//main()
}//class()

[wsaryada]

Hi,

What version of Oracle database that you are using? And why are you using a JDBC ODBC bridge instead of Oracle JDBC driver?

[Eranga]

And why are you using a JDBC ODBC bridge instead of Oracle JDBC driver?

Yes it is, why didn't you do that?

And also find the tnsnames.ora file in your installation file and check the settings.