Go Back   Webmaster Malaysia Forum » Website Design & Development » Website Programming

Reply
 
LinkBack Thread Tools Search this Thread Rate Thread Display Modes
  #1 (permalink)  
Old 15-05-2007, 03:37 PM
New kid on the block
 
Join Date: May 2007
Location: KL
Posts: 7
Rep Power: 0
nurmaiza is on a distinguished road
Cool jdbc ms sql error;Unable to load class for JSP

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>
<!--This Page Obtains a Connection to MS SQL Database-->
<%
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 {
<!--jdbc:jtds:<server_type>://<server>[:<port>][/<database>][;<property>=<value>[;...]]-->

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);
}

%>
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply



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

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

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



All times are GMT +8. The time now is 05:35 PM. Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
LinkBacks Enabled by vBSEO 3.1.0 vBulletin skin by ForumMonkeys.com.


WebmasterMalaysia.com is Proudly Hosted by Exabytes Semi Dedicated Server.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60