Unable to get connection, DataSource invalid: "java.sql.SQLException: No su
Hi all,
I use :
1)PC with win2000
2) NetBeans IDE 5.0 with Sun Java System Application Server
3)JAVA version 1.4.2_11
4) SQL Server 2000 which is on another server
5) Microsoft SQL Server 2005 JDBC Driver
(http://msdn2.microsoft.com/en-us/library/ms378526.aspx)
My CLASSPATH on My PC is : C:\Exercises\NetBeans\AppAskiseis\build\web\WEB-INF\lib;C:\j2sdk1.4.2_11\jre
I have create a new web project named "AppAskiseis"
I put "sqljdbc.jar" (Microsoft SQL Server 2005 JDBC Driver) in AppAskiseis\build\web\WEB-INF\lib
In the Netbeans I managed to create (in Runtime window)
1)a Connection Pool (name :connectionPool_1)
2)a JDBC Resource (name: dikimou)
3) a database connection to my database (name : infoshop) on SQL Server 2000. I managed to see tha tables
I wrote a simple JSP:
<%@ taglib uri="http://java.sun.com/jstl/core" prefix="c" %>
<%@ taglib uri="http://java.sun.com/jstl/sql" prefix="sql" %>
<sql:setDataSource
var = "dikimou"
driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="jdbc:sqlserver://192.168.2.221;DatabaseName=infoshop"
user="sa"
password="test"
/>
<sql:query var="test" dataSource="dikimou">
SELECT Code FROM Material
</sql:query>
<html>
<head>
<title>SQL Tag Out Examples</title>
</head>
<body>
kostas ole
</body>
</html>
When I run it i get
javax.servlet.ServletException: Unable to get connection, DataSource invalid: "java.sql.SQLException: No suitable driver"...
Please HELP ME !!!
