I recently tried to use the Microsoft jdbc driver together with dbUnit and had lots of strange error messages. I finally gave up and switched to another driver purchased in the company I am working for, which had no problems at all.
Despite of the driver problems I would suggest to rather use dbUnit that the sql task mentioned below. Andreas Lou Fox wrote: >Does anyone have any suggestions as to how I can get the sql task to work >with the SQLServerDriver? > >Here's what my step looks like: ><sql > driver="com.microsoft.jdbc.sqlserver.SQLServerDriver" > url="jdbc:microsoft:sqlserver://JRREPORTDATA:1433" > userid="XX" > password="XXXX" > > > <![CDATA[ > insert into XXX..Table (field1,field2,field3) > select field1,field2,field3 from XXX..Table_In; > ]]> > </sql> >The error message is: >java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error >establishing socket. > > > > >-- >To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> >For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>