Thanks Ram, that does help some. The generate-mapping script in D2RQ
will generate a mapping, but does no verification and therefore will
take any input. Composer will verify the existence of the driver
before creating the mapping. Therefore, while the generate-mapping
script will create a mapping file, it may or may not specify a
successful connection to the database. In your case I suspect it
won't.
The "driver not found" message from D2RQ (when using the Composer
Import wizard) is stating it like it is. The driver is not being
found. In particular, you need to find the correct addressing for the
Driver Class for your SQLServer installation. It appears that
com.microsoft.sqlserver.jdbc.SQLServerDriver is not correct for yor
setup. Check the setup for your SQLServer database instance. Some
SQLServer packages require a separate installation for the SQLServer
driver. There may also be problems with getting the .jar file in the
CLASSPATH - for example Java doesn't tolerate spaces in the path.
If you can't get that to work. jTDS is an option.
-- Scott
> ...
>
> read more »