SQL SERVER INTEGRATION

0
I was trying to connect MS SQL server with mendix and it is showing ‘An error has occurred while handling the request. [User 'Anonymous_848f3767-1cb5-4253-a226-c3765b38ca89' with session id '65b969e9-XXXX-XXXX-XXXX-XXXXXXXX0b92' and roles 'Administrator']’   It is showing that in the port number database = ExternalDB is not valid. I understood maybe I am having problem with the constant ‘DB_URL’ that I have passed to the execute query element in the microflow. Default value-   jdbc:sqlserver://LENOVO:database=ExternalDB; Have I written this right?
asked
1 answers
0

Hi,

Try to give the URL with the Port number, the default port is 1433, you can check the below link on how to construct the JDBC URL with port number : 

https://learn.microsoft.com/en-us/sql/connect/jdbc/building-the-connection-url?view=sql-server-ver16

Hope it Helps!!

answered