5
Hello, i'm using windows, eclipse, Tomcat 5.5 and JSP file 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 no suitable driver
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://localhost: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);
}
%>
