Question

jdbc url issue

1

Hi Experts, I want to fetch data from MSSQL, And I’m using execute query activity to fetch data from database but it’s giving me error for the jdbc url. Please reply me with right jdbc url. I’m using this url in execute query activity: jdbc:sqlserver://localhost:1433;databasename=MSSQLMendix;

asked 2022-12-16

Aishwarya Salunke

2 answers

1

I am assuming query is working property on sql server if used in query language.

You can try enable trace in the log to know more details of the error. can you share the any additional details or screen shot?

answered 2022-12-16

ishtiaq ahmad

Manoj Vutukuri · Accepted Answer · 2022-12-19

Hi Aishwarya,

Can you please append the following to your ‘Jdbc Url’ encrypt=true;trustServerCertificate=true;

it should look like this

jdbc:sqlserver://localhost:1433;databasename=MSSQLMendix;encrypt=true;trustServerCertificate=true;