December 28, 2003 at 9:33 pm
I have a JSP application that connects through the iPlanet Web Server (Sun One Web Server v6.1) using ODBC.
When I test the DSN (System DSN), it is OK but through the application I am unable to connect. It does not return any error, but it returns no rows. I am able to connect to the SQL Server through the Enterprise Manager or Query Analyzer.
What could be the problem(s)? Where should I start with?
Any help will be highly appreciated.
December 29, 2003 at 6:58 am
Start up a Profiler trace on the SQL Server. Test throup your JSP application. See (1) if the connection is being made and if it is (2) if the query you expect to be executed is in fact the one being executed.
K. Brian Kelley, GSEC
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
K. Brian Kelley
@kbriankelley
December 29, 2003 at 9:37 am
Are you sending the password through? Pwds are not stored in the DSN.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 29, 2003 at 8:46 pm
The application is able to connect to another SQL Server, but not the SQL Server in question. Where should I start with?
Rest everything is fine..DSN..username/passwords etc.
December 29, 2003 at 8:49 pm
Do a profiler trace and try to to access the web pages in question through the web app. Make sure you add Audit Login Failure to the events you're trapping for in the profiler trace. That should tell you if the app is attempting the connection, whether the login is successful, and if so, what queries are being run.
K. Brian Kelley, GSEC
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
K. Brian Kelley
@kbriankelley
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy