Descartex Well-Known Member Licensed User Longtime User Jan 8, 2017 #1 Hi! I'm trying to link to a MS Sql Server database via RDC. I followed the steps of the guide and when i run the ?method=test it works, it shows "connection successful". I've done the setup of the config.properties file but, when i try to run a stored command, it always raises a error 500 and shows "unkown error" on the log. Code: Copy 'Select statement on config.properties sql.select_actioncodes= select... Code: Copy 'Code to run the statement reqManager.Initialize(Me, "http://***.***.***.***:17178") Dim cmd1 As DBCommand cmd1.Initialize cmd1.Name = "select_actioncodes" reqManager.ExecuteCommand(cmd1,"Select") Thank you in advance.
Hi! I'm trying to link to a MS Sql Server database via RDC. I followed the steps of the guide and when i run the ?method=test it works, it shows "connection successful". I've done the setup of the config.properties file but, when i try to run a stored command, it always raises a error 500 and shows "unkown error" on the log. Code: Copy 'Select statement on config.properties sql.select_actioncodes= select... Code: Copy 'Code to run the statement reqManager.Initialize(Me, "http://***.***.***.***:17178") Dim cmd1 As DBCommand cmd1.Initialize cmd1.Name = "select_actioncodes" reqManager.ExecuteCommand(cmd1,"Select") Thank you in advance.
Erel B4X founder Staff member Licensed User Longtime User Jan 9, 2017 #2 You shouldn't use RDC 1. Use jRDC2. Upvote 0