I am using SQL Server 7 With the microsoft driver no problem
Connection URL needs to be jdbc:microsoft:sqlserver://SERVERNAME:1433;DatabaseName=DBNAME;SelectMethod= Cursor Refer to http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B313181 -- Tim Coy Timco Electronics Pty Ltd [EMAIL PROTECTED] com.microsoft.jdbc.sqlserver.SQLServerDriver > Hi, > > I am trying to use microsoft's jdbc driver with my struts application, but to > no avail. Here is my datasource definition: > > <data-source key="DB" type="org.apache.commons.dbcp.BasicDataSource"> > <set-property property="description" value="My SqlServer pool"/> > <set-property property="driverClassName" > value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/> > <set-property property="url" > value="jdbc:microsoft:sqlserver://SERVERNAME:1433;DatabaseName=DBNAME"/> > <set-property property="username" value="xxx"/> > <set-property property="password" value="xxx"/> > <set-property property="maxActive" value="20"/> > <set-property property="maxCount" value="20"/> > <set-property property="minCount" value="2"/> > <set-property property="maxWait" value="5000"/> > <set-property property="defaultAutoCommit" value="false"/> > <set-property property="defaultReadOnly" value="false"/> > </data-source> > > I have the required jars located in the WEB-INF/lib of my application which is > running on Tomcat 4.1.29. When i try to connect to the database using this > driver from a test class, it connects no problem so i know that the url and > driver class name are correct. So the problem must be the type of DataSource > which I am to use. Does anybody know which datasource to use with Microsoft's > sqlserver driver? I tried using the DataSource that is in the mssqlserver jar > but this didnt work either. > > The error that I get is an Invalid DataSource. > > Any help would be really appreciated! > > Thanks > Claire > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
