aspose file tools*
The moose likes JDBC 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
Bookmark "J2EE + MS SQL SERVER" Watch "J2EE + MS SQL SERVER" New topic
Author

J2EE + MS SQL SERVER

Reeha Shah
Greenhorn

Joined: May 18, 2001
Posts: 4
hi,
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 {
Class.forName(driverName);
conn = DriverManager.getConnection (connectionURL);
}// END OF try
catch (Exception e) {
System.err.println("Unable to load driver");
e.printStackTrace();
}// 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??
Reeha.

Raja Shekhar
Ranch Hand

Joined: Apr 02, 2001
Posts: 49
Hi Reeha
Just go throgh this site....
try http://industry.java.sun.com/products/jdbc/drivers
and just select the DB
hope this helps 4 u...
Raj
Reeha Shah
Greenhorn

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.
Reeha.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: J2EE + MS SQL SERVER