I'm trying to run the sql test from a webtest, using the MSSql JDBC driver for SQL 2000. However I keep getting a "Class Not found".

I've defined a classpath env. variable pointing to where the drivers downloaded.

My test looks like:

<target name="main" >

<webtest name="database" >

<steps>

<sql

driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"

url="jdbc:microsoft:sqlserver://Server:1433;DatabaseName=dbname"

userid="userid"

password="validPword" >

Insert into table

The error msg:

INFO (com.canoo.webtest.steps.Step) - Running with: Canoo Webtest: R_1581.

INFO (com.canoo.webtest.steps.Step) - Exception thrown from this class: org.apache.tools.ant.BuildException

INFO (com.canoo.webtest.steps.Step) - Message was: Class Not Found: JDBC driver com.microsoft.jdbc.sqlserver.SQLServerDriver could not be loaded

ERROR (com.canoo.webtest.steps.Step) - Cannot handle unexpected exception in ste

p TestStepSequence at C:\DOCUME~1\XXXX\MYDOCU~1\Tests\webtestRoutines\webtest

Routines\databaseTest.xml:19: with (taskName="steps")

C:\DOCUME~1\XXXXX\MYDOCU~1\Tests\webtestRoutines\webtestRoutines\databas eTest.

xml:24: Class Not Found: JDBC driver com.microsoft.jdbc.sqlserver.SQLServerDrive

r could not be loaded

at org.apache.tools.ant.taskdefs.JDBCTask.getDriver(JDBCTask.java:366)

at org.apache.tools.ant.taskdefs.JDBCTask.getConnection(JDBCTask.java:304)

at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:346)

at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)

at org.apache.tools.ant.Task.perform(Task.java:364)

at com.canoo.webtest.ant.TestStepSequence.executeSteps(TestStepSequence.jav a:43)

at com.canoo.webtest.ant.TestStepSequence.doExecute(TestStepSequence.jav

....

Any solutions?

Luke Templin