I am relatively new to Toad Data Point and trying to report by joining two Microsoft SQL tables on two separate servers. One table is on an SQL Server 2005 being joined to another table on an SQL Server 2008 R2. When I Google this error message it appears that Toad thinks I am using MariaDB that requires only 2 parameters. Not sure what I am doing wrong. DATEDIFF as used here works fine when used from within SQL Management Studio with the 3 parameters. I had a similar issue with using GETDATE().
Here is the query.
184.108.40.206\kcdcss (jrizos), EmergencyContact.EmergencyContact.dbo.ClerkDocument ClerkDocument
220.127.116.11 (jrizos), LocalDR.LocalDR.dbo.ALE_CBU_CASE ALE_CBU_CASE
ON (ClerkDocument.CaseNumber = cast(ALE_CBU_CASE.ALE_CASE_ID as char))
Any advise will be much appreciated.