+ Start a Discussion
gv007gv007 

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="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>
<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 'com.microsoft.jdbc.sqlserver.SQLServerDriver'
        at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(Basic
DataSource.java:1429)
        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou
rce.java:1371)
        at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource
.java:1044)
        at com.salesforce.dataloader.dao.database.DatabaseContext.initConnection
(DatabaseContext.java:80)
        ... 5 more
Caused by: java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLSer
verDriver
        at java.net.URLClassLoader$1.run(Unknown Source)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(Unknown 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
DataSource.java:1420)
        ... 8 more
ShashForceShashForce
Hi,

Please see if these links help:

https://developer.salesforce.com/forums?id=906F00000008p7TIAQ
https://help.salesforce.com/apex/HTViewHelpDoc?id=loader_dbaccess.htm&language=en_US

Thanks,
Shashank
gv007gv007
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="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>
You need to use  above class path.

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