aspose file tools
The moose likes JDBC and the fly likes Specified SQL server not found Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "Specified SQL server not found" Watch "Specified SQL server not found" New topic
Author

Specified SQL server not found

surendra majji
Greenhorn

Joined: Dec 29, 2012
Posts: 2
posted private message
0
Quote
hi sir this my error i run apache tomcat/5.5.28 HTTP Status 500 -

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found.
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:460)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:355)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

root cause

javax.servlet.ServletException: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found.
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:841)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:774)
org.apache.jsp.loginresponse_jsp._jspService(loginresponse_jsp.java:126)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

root cause

java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found.
sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
org.apache.jsp.loginresponse_jsp._jspService(loginresponse_jsp.java:57)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

root cause

java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()).
sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
org.apache.jsp.loginresponse_jsp._jspService(loginresponse_jsp.java:57)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
Nam Ha Minh
Ranch Hand

Joined: Oct 31, 2011
Posts: 346

I like...
Eclipse IDE Firefox Browser Windows
posted private message
0
Quote
Looks like you specified wrong name of your SQL server instance. Could you post your database URL here?

Job Offer: Online working Java technical writing
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 16483
    
    2

I like...
MySQL Database
posted private message
0
Quote
surendra majji wrote:[ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found.


Notice that the message is about (or from) the ODBC driver. Probably it isn't configured correctly. Remember that you have to configure the ODBC driver on the machine where Tomcat is running.
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19216

I like...
Android Eclipse IDE Opera
posted private message
1
Quote
Or even better, stop using ODBC completely and use a direct connection to the SQL Server.

SCJP 1.4 - SCJP 6 - SCWCD 5
How To Ask Questions How To Answer Questions
 
I agree. Here's the link: http://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: Specified SQL server not found
 
Similar Threads
JDBC connection on SQL Server 2005
Axis2 - WSDL to code
unable to set the value of Internal attribute using <c:set>
ERROR with using JDBC to connect to DB2 Express C
problem in running a servlet