cancel
Showing results for 
Search instead for 
Did you mean: 

Error while testing dispatcher Can not load driver:'com.microsoft.sqlserver

0 Kudos

Hello All,

I'm installing IDM 7.1 on SQL Server.

I'm trying to test the dispatcher, in Identity Center, but I found the error below.

Java home: F:\Identity Centre\sapjvm_5\jre

Java lib/ext: F:\Identity Centre\sapjvm_5\jre\lib\ext;D:\WINDOWS\Sun\Java\lib\ex

t

CLASSPATH: F:\Identity Centre\java\MxDispatcher.jar;F:\Identity Centre\java\MxMC

Api.jar;F:\Identity Centre\java\sapjco.jar;C:\ProgramFiles\sqljdbc_1.2\enu\sqljd

bc.jar;

[30.11.2009 13:49:34-714] - MxDispatcher:Reading prop files

[30.11.2009 13:49:34-714] - MxDispatcher:Loading driver: com.microsoft.sqlserver

.jdbc.SQLServerDriver

[30.11.2009 13:49:34-714] - Can not load driver:'com.microsoft.sqlserver.jdbc.SQ

LServerDriver'

[30.11.2009 13:49:34-714] - Can not load driver:'com.microsoft.sqlserver.jdbc.SQ

LServerDriver'

F:\Identity Centre>_uninst

Could anyone help me out on this?

Thanks a lot in advance,

Pradeep

Edited by: Pradeep Mathew Cherian on Nov 30, 2009 7:02 PM

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Pradeep,

try the following:

In the startup script of the dispatcher adjust the following:

u2022 In Dispatcher_Service_dispatcher_<dispatcher_name>.bat

SET MXDISPATCHERJAR=%DSE_HOME%\Java\mxdispatcher.jar;%DSE_HOME%\Java\mxmcapi.jar;%MXDRIVERJAR%;%CLASSPATH%;c:\soft\sqljdbc.jar

u2022 In Dispatcher_Service_dispatcher_<dispatcher_name>.prop

DSECLASSPATH=%DSE_HOME%/Java/DSE.jar;%DSE_HOME%/Java;%DSE_HOME%/Java/sapjco.jar;c:/soft/sqljdbc.jar

test it first then continue with the startup.

0 Kudos

Hello Sven,

In my startup script of the dispatcher it's already mentioned as belows:

For Dispatcher_Service_dispatcher_<dispatcher_name>.bat

SET MXDISPATCHERJAR=%DSE_HOME%\java\MxDispatcher.jar;%DSE_HOME%\java\MxMCApi.jar;%DSE_HOME%\java\sapjco.jar;C:\ProgramFiles\sqljdbc_1.2\enu\sqljdbc.jar;%CLASSPATH%

For Dispatcher_Service_dispatcher_<dispatcher_name>.prop

DSECLASSPATH=%DSE_HOME%/java/DSE.jar:%DSE_HOME%/java:C:
ProgramFiles
sqljdbc_1.2
enu
sqljdbc.jar

Should I overwrite it with what you provided?

Awaiting your kind reply.

Thanks,

Pradeep

Former Member
0 Kudos

Hi Pradeep

In a normal Windows environment you have a space in "ProgramFiles". Sometimes one overlooks such obvious things... maybe this already solves your issue.

Else you could copy the sqljdbc.jar to another folder like C:\soft\sqljdbc.jar as Sven suggested and try it with this path.

Regards

Michael

Former Member
0 Kudos

pradeep, did you solve the issue?

0 Kudos

Hi Sven,

Yes, I marked the discussion as Answered.

The tip provided by Micheal worked. There should have been a space in 'ProgramFiles'

Cheers,

Pradeep

Answers (0)