Re: Using JDBC-ODBC bridge with Oracle 8

hi

You should create a DSN (control panel->odbc32) and to specify Oracle as ODBC Driver Type. Creating an Oracle DSN you can insert the service name.

bye
joe

Matthew Jones wrote:

> Hello,
>
> I'm sure this question has been asked before, but I can't get Java 1.2
> to connect to an Oracle 8 database via the JDBC-ODBC bridge.
>
> I suspect this is because I have not specified the Oracle "Service" name
> in the Java code. How do you do this?
>
> My code currently reads:-
>
> String URL = "jdbc:odbc:OracleUGAdmODBC";
> String username = "ug_adm";
> String password = "fred";
> .
> .
> con = DriverManager.getConnection (
> URL,
> username,
> password);
>
> Where do I put the Service information? The ODBC connection works fine
> with other software, so I know that is OK.
>
> Many thanks,
>
> Matthew
Received on Wed Dec 01 1999 - 01:34:31 CST