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
Sanjukta Bhattacharjee
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 :