Install the ODBC driver from Oracle Client,
DO NOT use the Microsoft Windows default driver, it simply NOT work
if for any reason you need direct access to the ODBC registry keys:
HKEY_CURRENT_USER\Software\ODBC\ODBC.INI
Test it from Java:
package myOracle.jdbcOdbcTest;
import java.sql.Connection;
import java.sql.DriverManager;
public class LaunchJdbcOdbcTest {
public static void main(String[] args) throws Exception {
args.getClass();
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:odbcal12";
Connection dbConnection = DriverManager.getConnection(url,"aldo","pwd");
}
}
|