Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

configuring dsn connection automatically

 
Devu Shah
Ranch Hand
Posts: 50
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I would like to configure my dsn connection automatically instead of doing it manually through control panel , Could any one suggest me an software which would do this for me on start of my application or is there any standard java program available to do it plaese do reply
thanku
 
surya kumar mp
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
HI
You can create DSN on fly to Any database in the following fashion
String url = "jdbc dbc river={Microsoft Access Driver (*.mdb)};DBQ=f:\\Screen\\surya.mdb";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con =DriverManager.getConnection(url);
Surya.MP
--------------------------------------------------
Originally posted by Devu Shah:
I would like to configure my dsn connection automatically instead of doing it manually through control panel , Could any one suggest me an software which would do this for me on start of my application or is there any standard java program available to do it plaese do reply
thanku

 
surya kumar mp
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
HI
You can create DSN on fly to Any database in the following fashion
String url = jdbc dbc river={Microsoft Access Driver (*.mdb)};DBQ=f:\\Screen\\surya.mdb;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con =DriverManager.getConnection(url);
Surya.MP
--------------------------------------------------
Originally posted by Devu Shah:
I would like to configure my dsn connection automatically instead of doing it manually through control panel , Could any one suggest me an software which would do this for me on start of my application or is there any standard java program available to do it plaese do reply
thanku

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic