Sun IDM Repositor Configuration Error: Failed to load JDBC Driver
Hi Gurus,
I am new to Java IDM and predictably failed in my first attempt to install Java IDM in a Windows machine with SQL Server 2000 SP3.
I followed the Installation document step by step and I think I din' t miss any!!.. But still I got caught by an error, here it is:
I successfully installed IDM but failed while configuring Repository. I have downloaded the JDBC driver from Microsoft for SQL Server 2000, SP3. Then after that I copied the Jar from JDBC driver folder to
%WSHOME%/bin/lib folder. After this I launched the Repository configuration setup.
I got the following error while trying to connect the waveset database with Repository type as SQL Server (JDBC Driver)
com.waveset.util.ConfigurationError: Failed to load JDBC Driver 'com.microsoft.sqlserver.jdbc.SQLServerDriver':
==> java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
The Parameters that I have given for connection are:
URL: jdbc:sqlserver://127.0.0.1:1433;DatabaseName=waveset
JDBC Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
Connect as User: waveset
Connect Password: waveset
I have created the database and granted all access to user waveset.
Please help me come out of this. I tried dropping and recreating the database with a different name. Still it did not work, looks like it is a JDBC driver specific issue. Please guide me if I did anything wrong.
Appreciate any help
Thanks
