RE: JDBC Error, cannot establish socket - Tomcat 4.0.6/SQL Server 2000

[Sexton, George]

Change

jdbc:inetdae7:10.10.0.84:1433?database=TibcoClearHouse

to

jdbc:microsoft:sqlserver://10.10.0.84:1433;DatabaseName=TibcoClearHouse


George Sexton
MH Software, Inc.
Home of Connect Daily Web Calendar Software
http://www.mhsoftware.com/connectdaily.htm
Voice: 303 438 9585

-----Original Message-----
From: John Mattos [mailto:mattosj@;yahoo.com]
Sent: 12 November, 2002 12:55 PM
To: Tomcat Users List
Subject: RE: JDBC Error, cannot establish socket - Tomcat 4.0.6/SQL
Server 2000



Hmm. I have the app specified in my server.xml as follows. dows anything
jump out at you? I even used the IP instead of the DNS entry for the DB
machine
        <!-- iN DEMAND Clearinghouse Context -->
          <Context docBase="indemand" path="/indemand" reloadable="true"
source="indemand">
           <Resource name="jdbc/indemand" auth="SERVLET"
                     type="javax.sql.DataSource"/>
           <ResourceParams name="jdbc/indemand">
             <parameter>
              <name>user</name>
              <value>tibco_user</value>
             </parameter>
             <parameter>
              <name>password</name>
              <value>tibco_user</value>
             </parameter>
             <parameter>
              <name>driverClassName</name>
                 <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
             </parameter>
             <parameter>
              <name>driverName</name>

<value>jdbc:inetdae7:10.10.0.84:1433?database=TibcoClearHouse</value>
              </parameter>
           </ResourceParams>
          </Context>
 "Turner, John" <[EMAIL PROTECTED]> wrote:
Yup. It's network related. Probably the name of the database server can't
be resolved into an IP address, or a connection request is being made on the
wrong port. SQL Server's default port is 1433, I believe.

John


> -----Original Message-----
> From: John Mattos [mailto:mattosj@;yahoo.com]
> Sent: Tuesday, November 12, 2002 2:48 PM
> To: [EMAIL PROTECTED]
> Subject: JDBC Error, cannot establish socket - Tomcat 4.0.6/SQL Server
> 2000
>
>
>
> I'm getting the following error trying to connect to my SQL
> Server Database
>
> java.sql.SQLException: [Microsoft][SQLServer JDBC
> Driver]Error establishing socket.
>
> I'm using the driver
> "com.microsoft.jdbc.sqlserver.SQLServerDriver", and the 3
> necessary jar files are in C:\Tomcat4.0.6\lib (msbase.jar,
> msutil.jar and mssqlserver.jar)
>
> Any thoughts on this? Has anyone seen this before?
>
> John
>
>
>
> ---------------------------------
> Do you Yahoo!?
> U2 on LAUNCH - Exclusive medley & videos from Greatest Hits CD
>

--
To unsubscribe, e-mail:
For additional commands, e-mail:



---------------------------------
Do you Yahoo!?
U2 on LAUNCH - Exclusive medley & videos from Greatest Hits CD


--
To unsubscribe, e-mail:   <mailto:tomcat-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:tomcat-user-help@;jakarta.apache.org>