httpd-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Huang Xingang" <mpe...@nus.edu.sg>
Subject RE: [users@httpd] Database problem
Date Sat, 05 Apr 2003 01:24:28 GMT
Congratulation!

*********** REPLY SEPARATOR  ***********

On 2003-4-4 at 17:53 Dolo wrote:

>I finally found the solution! The problem was about privileges not given
>to
>Apache (I have it as a Windows Service). I was trying to access network
>resources (database) without the respective privilege. If someone is
>interested, here is the documentation:
>http://httpd.apache.org/docs-2.0/platform/windows.html#winsvc
>
>
>
>-----Original Message-----
>From: Dolo [mailto:dologij@yahoo.es]
>Sent: Friday, 04 April, 2003 15:14
>To: users@httpd.apache.org
>Subject: RE: [users@httpd] Database problem
>
>
>No problem in showing you the JSP code, but it works with IIS & Tomcat
>(that´s why I think the problem is with Apache):
>
><%@ page info="User Login"
>	errorPage ="errorLogin.jsp"
>%>
><%! String urldb = "jdbc:odbc:DSNUserData";
>    /*    More code here    */
>%>
><html>
><head>
><TITLE>User Login</TITLE>
><jsp:useBean id="BeanDB" class="sun.jdbc.rowset.CachedRowSet"
>scope="session">
><%
>  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
>  // initialize our CachedRowSet bean
>  BeanDB.setUsername("");
>  BeanDB.setPassword("");
>  BeanDB.setUrl(urldb);
>  // some drivers require this
>  //  BeanDB.setTableName("user");
>%>
></jsp:useBean>
>
></head>
>
><body>
><%
>    userID = request.getParameter("userID");
>    psw = request.getParameter("psw");
>    if ( (userID != null) && (psw != null) && (!userID.equals("")) &&
>(!psw.equals("")) ) {
>
>	String strSql = "SELECT NAME, PASSWORD FROM USER WHERE USERCODE LIKE '"
+
>userID +"'";
>        BeanDB.setCommand(strSql);
>        BeanDB.execute();
>        BeanDB.beforeFirst();
>        if(BeanDB.next()){
>        	userName = BeanDB.getString("NAME");
>        	dbPsw = BeanDB.getString("PASSWORD");
>        }else{
>        	throw new Exception("Invalid User");
>        }
>
>    /*    More code here    */
>
>%>
></body>
></html>
>
>
>
>
>-----Original Message-----
>From: Huang Xingang [mailto:mpehxg@nus.edu.sg]
>Sent: Friday, 04 April, 2003 13:56
>To: users@httpd.apache.org
>Subject: Re: [users@httpd] Database problem
>
>
>It's nothing to do with your Apache.
>Can I see your jsp code to access the database?
>
>*********** REPLY SEPARATOR  ***********
>
>On 2003-4-4 at 11:13 Dolo wrote:
>
>>Hi!
>>I have Apache 2.0 and Tomcat 4.1.24 installed on Windows 2000 Server. And
>I
>>have a Web Application running on Tomcat (HTML and JSP files are placed
in
>>Tomcat respective folder). JSP files have to retrieve data from a MS
>Access
>>2000 database (it's on a different machine), but an error message is
shown
>>when trying to get the data:
>>
>>"[Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid
>path.
>>Make sure that the path name is spelled correctly and that you are
>>connected
>>to the server on which the file resides."
>>
>>This application works perfectly when running on IIS & Tomcat, so I think
>>it
>>might be an Apache problem. Everything remains the same, except that I
>>moved
>>from IIS to Apache. I´m using the same System DSN to access the
>database.
>>Any idea of why database can't be reached?
>>
>>Thanks,
>>Dolores
>>
>>
>>---------------------------------------------------------------------
>>The official User-To-User support forum of the Apache HTTP Server
Project.
>>See <URL:http://httpd.apache.org/userslist.html> for more info.
>>To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
>>   "   from the digest: users-digest-unsubscribe@httpd.apache.org
>>For additional commands, e-mail: users-help@httpd.apache.org
>
>
>******************************************
>Dr. Huang Xingang
>******************************************
>Laboratory for Concurrent Engineering & Logistics
>Department of Mechanical Engineering
>National University of Singapore
>10 Kent Ridge Crescent
>Singapore 119260
>******************************************
>Tel: (65) 6874-4857
>Fax: (65) 6779-5922
>Email: mpehxg@nus.edu.sg
>******************************************
>
>
>---------------------------------------------------------------------
>The official User-To-User support forum of the Apache HTTP Server Project.
>See <URL:http://httpd.apache.org/userslist.html> for more info.
>To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
>   "   from the digest: users-digest-unsubscribe@httpd.apache.org
>For additional commands, e-mail: users-help@httpd.apache.org
>
>
>---------------------------------------------------------------------
>The official User-To-User support forum of the Apache HTTP Server Project.
>See <URL:http://httpd.apache.org/userslist.html> for more info.
>To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
>   "   from the digest: users-digest-unsubscribe@httpd.apache.org
>For additional commands, e-mail: users-help@httpd.apache.org
>
>
>---------------------------------------------------------------------
>The official User-To-User support forum of the Apache HTTP Server Project.
>See <URL:http://httpd.apache.org/userslist.html> for more info.
>To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
>   "   from the digest: users-digest-unsubscribe@httpd.apache.org
>For additional commands, e-mail: users-help@httpd.apache.org


******************************************
Dr. Huang Xingang
******************************************
Laboratory for Concurrent Engineering & Logistics
Department of Mechanical Engineering
National University of Singapore
10 Kent Ridge Crescent
Singapore 119260
******************************************
Tel: (65) 6874-4857
Fax: (65) 6779-5922
Email: mpehxg@nus.edu.sg
******************************************


---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
   "   from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org


Mime
View raw message