Nadia,
Contact your vendor/supplier showing you on how to connect to databases
or where are the documents showing you how to do it.
Ask for the instructions. If the ducementation are good enough or proof
read I am sure you
can follow them with out any help what so ever.
Best Regards,
Zahid
-----Original Message-----
From: nadia [mailto:[EMAIL PROTECTED]]
Sent: 19 September 2001 12:48
To: [EMAIL PROTECTED]
Subject: Re: Pls Help-Jsp connection to database
I have no choice..
The place where I work wants resin...
What can I do...
----- Original Message -----
From: sachin <mailto:[EMAIL PROTECTED]> walia
To: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
Sent: Wednesday, September 19, 2001 1:13 PM
Subject: Re: Pls Help-Jsp connection to database
if u r using a jsp in resin my guess is about gettnig the classpath..
plz ensure that ur resin's classpath conatins all the necessary jar file
which r in jdk/lib as well as jre/lib directory of jdk..
that shud work..
anyway i suggest u to go for tomcat4.0 why u r using resin..
sachin..
----- Original Message -----
From: nadia <mailto:[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
Sent: Wednesday, September 19, 2001 3:56 PM
Subject: Pls Help-Jsp connection to database
Hi all.
I am still struggling to connect my jsp page to a access database.
I keep getting the error.
[2001/09/19 11:17:01] [Microsoft][ODBC Driver Manager] Data source name not
found and no default driver specified
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not
found and no default driver specified
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6031)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6188)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:2458)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:320)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:163)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at _jsp._test._test6._response__jsp._jspService(_response__jsp.java:33)
at com.caucho.jsp.JavaPage.service(JavaPage.java:89)
at com.caucho.jsp.JavaPage.subservice(JavaPage.java:83)
at com.caucho.jsp.Page.service(Page.java:280)
at com.caucho.jsp.QServlet.service(QServlet.java:161)
at com.caucho.server.http.AbstractRequest.service(AbstractRequest.java:454)
at com.caucho.server.http.AbstractRequest.service(AbstractRequest.java:397)
at com.caucho.server.http.PageCache$Entry.service(PageCache.java:256)
at com.caucho.server.http.PageCache.service(PageCache.java:105)
at com.caucho.server.http.VirtualHost.service(VirtualHost.java:424)
at com.caucho.server.http.Request.dispatch(Request.java:213)
at
com.caucho.server.http.RunnerRequest.handleRequest(RunnerRequest.java:313)
at
com.caucho.server.http.RunnerRequest.handleConnection(RunnerRequest.java:260
)
at com.caucho.server.TcpConnection.run(TcpConnection.java:142)
at java.lang.Thread.run(Thread.java:484)
It seems as it doesnot see my data source that I have made in the Control
Panel(I have made both a user dsn and a system dsn (but both doesn't work))
I am using resin 1.1.6 with iis as a webserver
my jsp page looks like this
<%@page import="java.sql.*"%>
<%Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");%>
<% String data="jdbc:odbc:JSP";
Connection connection=DriverManager.getConnection(data," "," ");
Statement statement =connection.createStatement();
ResultSet results=statement.executeQuery("Select * from Names");
%>
<html>
<body>
<P> The results are:
</P>
<UL>
<% while (results.next()) { %>
<LI><%= results.getString(1)%></LI>
<% } %>>
</UL>
</html>
</body>
It looks as if it has a problem with the getConnection part..
Ihave made an odbc data source..
Please Please help...
Thanking you all in advance..
Nadia
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
