• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 212
  • Last Modified:

system odbc settings

hi guys.....i have a program code as follows

import java.sql.*;



public class testDataBase {
     
               
     
     
     public static void main(String [] args){
     try {
         
          System.out.println("ahbh");
          ;
        Class.forName("oracle.odbc.driver.OracleDriver");
                  // open connection to database
                  System.out.println("starlet");
           Connection connection = DriverManager.getConnection("odbc:oracle:thin:@url:port:dsn", "user", "passwrod");
           
               System.out.println("YARK");
            connection.close () ;

        }
        catch (Exception e) {
            System.err.println (e) ;
           
           
        }
    }
     
     }


i want to add the dsn to the system settings....iam on win 2000...tell me which driver to select in the userDSN in the administrativetools/odbc settings.................plz hurry
0
Mooooodz
Asked:
Mooooodz
  • 2
1 Solution
 
TimYatesCommented:
errr...don't think you need dsn...

you are using the "thin" driver...
0
 
TimYatesCommented:
oh hang on...

I'm talking rubbish :-(

The DSN is your schema name

you set it up when you create your database using the Oracle Admin tools...
0
 
CleanupPingCommented:
Mooooodz:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0
 
jimmackCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

Accept TimYates' comment as answer.

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

jimmack
EE Cleanup Volunteer
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now