jdbc ms sql error;Unable to load class for JSP

nurmaiza · #1 (**permalink**) 15-05-2007, 03:37 PM

Hello, i'm trying to connect jdbc ms sql using jdts driver.
i've download the driver and assigned the path at en.variable..but it give me an error HTTP STATUS 500 and unable to load class for jsp

anyone ve idea on what the setting shud i set?i've no idea after followed some instruction on web site still it give me the same error.

this is my code

<title>Obtain connection</title>
</head>
<body>

<%
Connection conn = null;
ResultSet result = null;
Statement stmt = null;

try {
Class c = Class.forName("net.sourceforge.jtds.jdbc.Driver");
}
catch (Exception e) {
System.out.println("Error occurred at line 18");
}
try {


String url="jdbc:jdts:sqlserver://10.120.0.90:1433/JIT;tds=8.0;lastupdatecount=true";
conn = DriverManager.getConnection(url,"jitUser","123abc" );
}
catch (SQLException e) {
System.out.println("Error occurred "e);
}
try {
stmt = conn.createStatement();
result = stmt.executeQuery("SELECT * FROM dbo.attcourse");
}
catch (SQLException e) {
System.out.println("Error occurred "e);
}

%>

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Unable to position the button	marukochan	Webmaster Tools	8	31-10-2006 10:45 PM
Internal Server Error - ASP error	ladyheart2612	Website Programming	0	21-07-2005 09:22 AM
Class	nurulmajdi	Website Programming	10	15-04-2004 12:03 AM
unable to edit user profile	MENJ	FeedBack & Suggestion	0	05-04-2004 09:18 AM
#define class error dlm java prog	ymhy_80	Website Programming	6	14-02-2004 12:01 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)