Project and Portfolio Management Support and News Forum
Showing results for 
Search instead for 
Do you mean 

SQL Server JDBC - No suitable driver found

Highlighted
Advisor

SQL Server JDBC - No suitable driver found

We have an integration with a SQL 2008 server and use Web Services to read the SQL server table and then create a request for a new entry in the table that was setup for us.

 

The SQL server was not in a failover implementation. The DB was moved over into a failover SQL server environment.

 

Our integration process worked 100% until we tested the new connection and experiences the following error (See text in green below):

**********************************************************************************************************************

CL Local Exec

Source Command:Run Interface V1 sh ./interfaces/EITI_IRFS/bin/runInterface.sh ./interfaces/EITI_IRFS http://dppm11.vodacom.corp:8082/itg/ -jdbc jdbc:sqlserver:zamds20710\collaboration;databaseName=ppm;selectMethod=cursor -dbUser ppm -dbPassword V0d@c0m082 sh: SHELLOPTS: readonly variable '/apps/ppmadmin/ppm/dev/conf:/apps/ppmadmin/ppm/dev/lib/jboss/boot/knta_logging.jar:/apps/ppmadmin/ppm/dev/lib/jboss/boot/log4j-boot.jar:/apps/ppmadmin/ppm/dev/lib/jboss/boot/run.jar:/apps/ppmadmin/ppm/dev/server/dev/deploy/itg.war/html/client/itgcore_resources*.jar:/apps/ppmadmin/ppm/dev/conf/custom_resources/mobility_access:/apps/ppmadmin/ppm/dev/conf/custom_resources/msp:/apps/ppmadmin/ppm/dev/conf/custom_resources/suggested_items:/apps/ppmadmin/jdk1.7.0_17//lib/tools.jar' Interface repositoryDir: ./interfaces/EITI_IRFS serviceURLbaseParameter: http://dppm11.vodacom.corp:8082/itg/ jdbcURL: jdbc:sqlserver:zamds20710\collaboration;databaseName=ppm;selectMethod=cursor dbUser: ppm dbPassword: V0d@c0m082 --------------------------------------------------------- Jan 15, 2014 8:10:53 PM org.apache.axis2.deployment.DeploymentEngine prepareRepository INFO: no services directory found under /apps/ppmadmin/ppm/dev/interfaces/EITI_IRFS Jan 15, 2014 8:10:54 PM org.apache.axis2.deployment.DeploymentEngine doDeploy INFO: Deploying module : rampart-1.1 Jan 15, 2014 8:10:54 PM org.apache.axis2.deployment.DeploymentEngine doDeploy INFO: Deploying module : addressing-1.1 Imported interrupted due to error: No suitable driver found for jdbc:sqlserver:zamds20710\collaboration;databaseName=ppm;selectMethod=cursor ------------------------------------------------------ exit code = 1 Errors occurred during command execution.

*******************************************************************************************************************

 

If anyone has a suddestion?

 

Regards

 

Alfred

 

Alfred Puth
PPM Consultant
EOH Application Management