How can I create ODBC connections in an on-prem installation?
Means the SQL Server computer was unable to process the client login packet. This may be because the packet was created improperly or because the packet was damaged during transmission. It can also be caused by the configuration of the SQL Server computer.
SQL ="SELECT [accountid],[accountnumber],[ap_AccountTypeName],[ap_Categoryidname],[ap_crmaccountid],[ap_ResponsibleidName],[name],[OwningBusinessUnit] "
+ "FROM [EDW].[CRM].[CRM365_Account] CRM365Acc "
+ "where not exists ("
+ "select * from [EDW].[CRM].[CRM365AX_Account] CRM365AXAcc "
+ "where CRM365AXAcc.accountid = CRM365Acc.[accountid]) "
+ "AND CRM365Acc.[ap_AccountTypeName] = 'Customer'";
André Arnaud de Cal... 291,661 Super User 2024 Season 2
Martin Dráb 230,379 Most Valuable Professional
nmaenpaa 101,156