Share via

Microsoft Sql Server Native client 10.0 :Operand type clash int is incompatible with date

pdsqsql 411 Reputation points
2020-08-07T22:43:07.947+00:00

Hello,
We just migrated Database from Sql 2008R2 to Sql 2017 (Windows Server 2016) and one of our Crystal Report which we used to run was running fine.
Report using Data parameter (@Startdate and @Endate) but we are getting error:
[Microsoft Sql Server Native client 10.0]:Operand type clash int is incompatible with date

When we run Stored Procedure in Sql 2017 with passing same Date parameters, Stored Procedure running fine but it throws above error when we run through Crystal report, it works fine for Sql 2008R2 when run through Crystal Report.
User have OLE DB connection in Data Source.
We have DateTime datatype defined into Stored Procedure Variable as well as underlying table
Is it any Driver issue?
I believe that we might need to use SQL OLE DB Native Driver instead of Microsoft OLE DB provider for SQL Server or Microsoft Sql Server Native client 11.

Thanks for help!

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,187 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 21,116 Reputation points Microsoft Vendor
    2020-08-10T09:59:13.817+00:00

    Hi,

    The SQL Server Native Client (SQLNCLI) remains deprecated and it is not recommended to use it for new development work. Instead, use the new Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) which will be updated with the most recent server features. Refer to this MS document.

    This is a forum that talking issues about MS product, Crystal report is a third party product, not a MS one, so contact the software vendor support.

    Best regards,
    Cathy