java: How to connect data base without dsn

[softkans]

Hai Guys...
I just want to know about how to connect the java application to MS-ACCESS or oracle without using the DSN (Data Source Name) name.Is there any drivers we need to install otherwise give the code for this.i will expecting for ur correct answers.

[ComputerJy]

http://www.vbforums.com/showpost.php...20&postcount=4

[softkans]

http://www.vbforums.com/showpost.php...20&postcount=4

thanks for your reply..

in your program

cn=DriverManager.getConnection("jdbcdbc:test","","");

test is the dsn name

i want to connect database without dsn name. please give me correct code..

[ComputerJy]

Sorry...
This code is created by JBuilder, it uses some pre-compiled borland classes

public class DataModule1 implements DataModule
{
  /**
   * Data module reference.
   */
  private static DataModule1 myDM ;
  private Database database1 = new Database() ;
  private QueryDataSet addresses = new QueryDataSet() ;
  private QueryDataSet country = new QueryDataSet() ;

  /**
   * DataModule constructor.
   */
  public DataModule1 () {
    try {
      jbInit() ;
    }
    catch (Exception exception) {
      exception.printStackTrace() ;
    }
  }

  /**
   * Initialize.
   *
   * @throws java.lang.Exception
   */
  private void jbInit () throws Exception {
    database1.setConnection(new ConnectionDescriptor("jdbc:borland:dslocal:D:\\Borland\\JBuilder2006\\samples\\JDataStore\\datastores\\employee.jds",
        "Sample", "", false, "com.borland.datastore.jdbc.DataStoreDriver")) ;
    addresses.setQuery(new QueryDescriptor(database1,
                                           "SELECT ADDRESSES.FIRST_NAME,ADDRESSES.LAST_NAME,ADDRESSES.ADDRESS,ADDRESSES.CITY,ADDRESSES.STATE,ADDR" + "ESSES.ZIP FROM ADDRESSES", null, true,
                                           Load.ALL)) ;
    country.setQuery(new QueryDescriptor(database1,
        "SELECT COUNTRY.COUNTRY,COUNTRY.CURRENCY FROM COUNTRY", null, true,
                                         Load.ALL)) ;
  }

  /**
   * Get data module reference.
   *
   * @return DataModule reference
   */
  public static DataModule1 getDataModule () {
    if (myDM == null) {
      myDM = new DataModule1() ;
    }
    return myDM ;
  }

  public Database getDatabase1 () {
    return database1 ;
  }

  public QueryDataSet getAddresses () {
    return addresses ;
  }

  public QueryDataSet getCountry () {
    return country ;
  }
}

[CornedBee]

Uh, why?

No, it's not possible to connect to anything using JDBC without a DSN. (Unless you use a preconfigured data source, but then the configuration of that source probably used a DSN.) Why would you want to do such a thing?