SQLServerDriver cannot be found

[patrickkahle]

hey everyone,

i have created a simple rest api in Talend that load some informations from a mssql database. 

If i run this Job in Studio, it works for me:

But when i'm export the Job to the cloud and deploy the task and test it in the api tester, i get the error message "com.microsoft.sqlserver.jdbc.SQLServerDriver cannot be found by c360.Systems_0.1.0"

Where is my mistake?

Thanks and best regards

Patrick

[patrickkahle]

Hello,

I have found a simpler solution for myself. I have placed the file mssql-jdbc-12.8.1.jre11.jar in the lib folder of my Talend Runtime. Since then it works without problems.

[dmtgrp]

Hello @Nic_D4t4,

Thank you for taking the time to respond to me.

I followed your procedure, and indeed, I no longer encounter the previous error when deploying my web service on the TMC. However, this time, I encountered the following error, as shown below:

Aperçu

Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

[dmtgrp]

Bonjour @Nic_D4t4,

En suivant votre procédure, et les actions que j'ai trouvé dans le tutoriel suivant :

https://cogito-ergo-dev.fr/blog/775/talend-et-authentification-windows-pour-acceder-a-sql-server/ 

j'ai pu résoudre mon problème.

Merci à vous tous pour votre contribution à ce sujet.