Re: using DataSource with Microsoft's JDBC drivers

[Kevin_J_Lacobie/Corp/DukeEnergy]

Excellent.  This worked for me.  Thanks!  Several of the parameters were
different than expected, and I think it was the "driverName" parameter that
was the key.


I recommend that this set-up example get added to
http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-howto.html,
 to thus provide an example for MS SQLServer access.

Thanks again,

Kevin Lacobie


Pierre-Laurent Ribault wrote:
-------------------------------------
It was not straightforward here either, but we finally found a working
configuration, using a usenet post by a MS guy as the base for our
experiments (Look for the thread "Steps for Setting up DataSource in
Tomcat4.0 Using SQLServerDataSource" in the
microsoft.public.sqlserver.jdbcdriver group on Google)

Here is the server.xml chunk that is working for us:

<Context path="/myapp_sqlserver" docBase="myapp_sqlserver" debug="0"
reloadable="true">
   <Resource name="jdbc/SQLserverDB" auth="Container"
             type="com.microsoft.jdbcx.sqlserver.SQLServerDataSource" />
   <ResourceParams name="jdbc/SQLserverDB">
     <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>myserver</value>
     </parameter>
     <parameter>
       <name>portNumber</name>
       <value>1433</value>
     </parameter>
     <parameter>
       <name>user</name>
       <value>myuser</value>
     </parameter>
     <parameter>
       <name>password</name>
       <value>mypassword</value>
     </parameter>
   </ResourceParams>
</Context>



--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>