When we are trying to fetch data for our queries in middle tier database connection mode, we are facing following error-
Method not found with 5 parameters: OpenDentBusiness.DataConnectionCancelable.GetTableConAlreadyOpen.
can you please confirm the data type and number(count) of parameters(params) to be passed to DtoGetTable to get data for query.
Method not found with 5 parameters in OD 22.3
Re: Method not found with 5 parameters in OD 22.3
The most recent version of v22.3 no longer has that method with 5 params; it is now 7 params. It sounds like your version of Open Dental on the workstation does not match the version of your Middle Tier server. It is most commonly the Middle Tier server that is left behind in version. But you shouldn't be able to connect to your Middle Tier when the versions mismatch like that... curious.
Regardless, I just verified that it works in the most recent v22.3.44 so either update to that or make sure that both the server and workstations have the same version of Open Dental installed.
Regardless, I just verified that it works in the most recent v22.3.44 so either update to that or make sure that both the server and workstations have the same version of Open Dental installed.
The best thing about a boolean is even if you are wrong, you are only off by a bit.
Jason Salmon
Open Dental Software
http://www.opendental.com
Jason Salmon
Open Dental Software
http://www.opendental.com
Re: Method not found with 5 parameters in OD 22.3
Thanks @jsalmon
Can you also please confirm the datatype of all the params in that method. It would be really beneficial for us to pass queries.
Also, when i try to perform update or insert over preference table with 7 params in connection object. it does not update any value and no error is displayed though and output from update is-
"<DataTable><Name></Name><Cols></Cols><Cells></Cells></DataTable>"
following method is called-
OpenDentBusiness.DataConnectionCancelable.GetTableConAlreadyOpen
Can you also please confirm the datatype of all the params in that method. It would be really beneficial for us to pass queries.
Also, when i try to perform update or insert over preference table with 7 params in connection object. it does not update any value and no error is displayed though and output from update is-
"<DataTable><Name></Name><Cols></Cols><Cells></Cells></DataTable>"
following method is called-
OpenDentBusiness.DataConnectionCancelable.GetTableConAlreadyOpen
Re: Method not found with 5 parameters in OD 22.3
Code: Select all
public static DataTable GetTableConAlreadyOpen(int serverThread,string command,bool wasSqlValidated,bool isSqlAllowedReportServer=false,bool hasStackTrace=false,bool suppressMessage=false,bool useReportServer=false)
Middle Tier servers will run user queries as a MySQL user with lower permission (often not allowed to manipulate data). You might be running into that scenario. Manipulating data should be done through our API though.
The best thing about a boolean is even if you are wrong, you are only off by a bit.
Jason Salmon
Open Dental Software
http://www.opendental.com
Jason Salmon
Open Dental Software
http://www.opendental.com