Newbie question

Hi -

Looks like I can run the basic hsqldb stuff, as
indicated in the 'Getting Started' section 'Create
tables' ("7 of 7 SQL statements executed
successfully").

Now for my stuff...

I've got an Oracle DB with 5000+ tables, so I'm
warming up on MS Sequel Server 2000's 'Northwind'
sample running locally (I am able to connect to it via
JDBC).

When I modify the corresponding mssql.xml and try the
same thing, I get:

Class Not Found: JDBC driver
com.microsoft.jdbc.sqlserver.SQLServerDriver could not
be loaded

My mssql.xml looks like this:

<property name="database.script.file"          
value=""/>
   <property name="database.driver.file"          
value="${lib.dir}/mssqlserver.zip"/>
   <property name="database.driver"               
value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>
   <property name="database.url"                  
value="jdbc:Microsoft:sqlserver://mfsmobile:1433;DatabaseName=Northwind"/>
   <property name="database.userid"               
value="sa"/>
   <property name="database.password"             
value="password"/>
   <property name="database.schema"               
value=""/>
   <property name="database.catalog"              
value=""/>

   <!--poperty name="jboss.datasource.mapping"      
value="MS SQLSERVER"/-->
   <property name="jboss.datasource.mapping"      
value="MS SQLSERVER2000"/>


Any ideas?

Thanks in advance...




-------------------------------------------------------
SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285