function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Class path is not find SQL Server Dataloder commandline

Hi have issue with connecting SQL server 2000 in commandline dataloder

I added sqljdbc4.jar,sqljdbc.jar file in process.bat file and in the path even tho it says class not found exception
Also here is my bean property
<property name="driverClassName" value=""/>
<property name="url" value="jdbc:sqlserver:\\localhost;databaseName=DB;user = uname;password=pwd"/>

Still it is not loading.I am wondering which jar file support sqlserver 2000

Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver c
lass ''
        at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(Basic
        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou
        at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource
        at com.salesforce.dataloader.dao.database.DatabaseContext.initConnection
        ... 5 more
Caused by: java.lang.ClassNotFoundException:
        at$ Source)
        at Method)
        at Source)
        at java.lang.ClassLoader.loadClass(Unknown Source)
        at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
        at java.lang.ClassLoader.loadClass(Unknown Source)
        at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(Basic
        ... 8 more

Please see if these links help:

Here is the funpart
sqljdbc4.jar,sqljdbc.jar drivers wont work  for SQL Server 2000.

Add msbase.jar,mssqlserver.jar,msutil.jar file in process.bat files or your path
<property name="driverClassName" value=""/>
You need to use  above class path.

Thats is the fun still u need to deal with not updated DBs,