It's not a secret anymore!
The moose likes JDBC and Relational Databases and the fly likes J2EE + MS SQL SERVER Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "J2EE + MS SQL SERVER" Watch "J2EE + MS SQL SERVER" New topic


Reeha Shah

Joined: May 18, 2001
Posts: 4
i have a problem using MS SQL SERVER with J2EE. i am using odbc bridge for database connection but getting an error "unable to load driver" i did it as:
private String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";
private String connectionURL = "jdbc dbc:jspDB";
public void makeConnection () {
try {
conn = DriverManager.getConnection (connectionURL);
}// END OF try
catch (Exception e) {
System.err.println("Unable to load driver");
}// END OF catch
}// END OF makeConnection()
is there any type 4 driver for MS SQL SERVER?? if there is then from where i can get it??

Raja Shekhar
Ranch Hand

Joined: Apr 02, 2001
Posts: 49
Hi Reeha
Just go throgh this site....
and just select the DB
hope this helps 4 u...
Reeha Shah

Joined: May 18, 2001
Posts: 4
thanks for ur reply Raj.
i have accessed the database successfully usnig the same piece of code on Tomcat server but getting problems on J2EE, might be i have to make changes in some J2EE files but don't know wht and where ?? i tried to change server.xml but of no use.......
i'm still clueless abt the solution, if u or anybody else has accessed the MS SQL database using jdbc : odbc bridge on J2EE then plz tell me.
I agree. Here's the link:
subject: J2EE + MS SQL SERVER
It's not a secret anymore!