Rob Vermeulen wrote: >> >> I'm trying to get MMBase running on a MS SQL Server 2000. >> >> >> >> - Installed MMBase 1.5.1 on a Orion webserver (works). >> >> - Installed the MS SQL jdbc driver for MS SQL Server 2000. >> >> - Created a database names MMBASE, created a user MMBASEUSER with >> db_owner rights on the database. >> >> - Followed the document "Database not supported?" Daniel Ockeloen wrote. >> >> >> >> But get the following error: >> >> 07-12 11:02:03 INFO MMBase: >> --- >> Init of MMBase >> 07-12 11:02:03 INFO MMBase: Loaded load class : class >> org.mmbase.module.database.support.MMSQL92Node >> 07-12 11:02:03 ERROR MMBase: Can't get a JDBC connection (database >> error)java.sql.SQLException: No suitable driver >> 07-12 11:02:03 FATAL STDERR: java.sql.SQLException: No suitable driver >> >> Does anyone know how to get this running????? >> >> Doesn't MS SQL Server 2000 support SQL92? >> >> >> > > I suppose you didn't specify yet a jdbc driver for your ms sql server. > Take a look into the following configuration file > /config/default/modules/jdbc.xml, and adapt the driver setting to your > ms sql server jdbc driver.
Maybe you also have to change the config/modules/mmbaseroot.xml. Here's also setting for the databasetype: <property name="database">hsqldb</property>. This property defines which database.xml must be used (these are inside the config/database dir). But I'm not sure which one is best for MS SQLServer. It could be you need a special database-class for MSQLServer. Gerard
