We're using 4.1.12, ours looks like this:
<Resource name="jdbc/name" auth="SERVLET"
type="com.microsoft.jdbcx.sqlserver.SQLServerDataSource"/>
<ResourceParams name="jdbc/name">
<parameter>
<name>factory</name>
<value>com.microsoft.jdbcx.sqlserver.SQLServerDataSourceFactory</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.microsoft.jdbcx.sqlserver.SQLServerDataSource</value>
</parameter>
<parameter>
<name>driverName</name>
<value>SQLServer</value>
</parameter>
<parameter>
<name>description</name>
<value>SQL Server DataSource</value>
</parameter>
<parameter>
<name>serverName</name>
<value>our-server</value>
</parameter>
<parameter>
<name>portNumber</name>
<value>1433</value>
</parameter>
<parameter>
<name>selectMethod</name>
<value>cursor</value>
</parameter>
<parameter>
<name>databaseName</name>
<value>our-db-name</value>
</parameter>
<parameter>
<name>user</name>
<value>our-user</value>
</parameter>
<parameter>
<name>password</name>
<value>our-password</value>
</parameter>
<parameter><name>loginTimeout</name><value>3000</value></parameter>
<parameter><name>maxActive</name><value>100</value></parameter>
<parameter><name>maxIdle</name><value>10</value> </parameter>
<parameter><name>maxWait</name><value>50</value> </parameter>
</ResourceParams>
> -----Original Message-----
> From: John Mattos [mailto:mattosj@;yahoo.com]
> Sent: Tuesday, November 12, 2002 2: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>
