JDBC compilation error too weird

[cgk_js]

I am trying to execute the below simple java program
but i am getting the below error..
import java.sql.*;

class SqlConnection {
public static void main(String[] args) {
Connection con = null;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:Driver={Mic rosoft Acess Driver (*.accdb)}; DBQ=C:\\Users\\gopc\\odbc_sql.accdb","","");
Statement statement = con.createStatement();
statement.execute("select * from log_entry");
ResultSet rs = statement.getResultSet();
if (rs != null)
{
while (rs.next())
{
System.out.println(rs.getString("date"));
}
}
} catch (Exception e) {
System.out.println("Error: " + e);
}
}
}

getting the below compilation error, seems to be too weired.

C:\Documents and Settings\gopc\workspace\JDBC_Connection\src>javac SqlConnection
.java
SqlConnection.java:9: error: incompatible types
con = DriverManager.getConnection("jdbc:odbc:Driver={Mic
rosoft Acess Driver (*.accdb)}; DBQ=C:\\Users\\gopc\\odbc_sql.accdb","","");
^
required: Connection
found: java.sql.Connection
SqlConnection.java:10: error: cannot find symbol
Statement statement = con.createStatement();
^
symbol: method createStatement()
location: variable con of type Connection
2 errors

C:\Documents and Settings\gopc\workspace\JDBC_Connection\src>

[Toll]

Seems to me there's a second Connection class wreaking havoc somewhere. Try changing it to java.sql.Connection con = null; and see if that makes any difference.

[DarrylBurke]

Guide For New Members
BB Code List - Java Programming Forum

db

[cgk_js]

this problem has been resolved..


basically the issues was the i need to download the JDK for 32 bit for windows 7 and also basically i need to configure the C:\Windows\SysWOW64 to configure
in the control panel's for configuring the odbc data sources..