Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
MSOLEDBSQL (v18) driver and stored procedure calls with DateTime parameter in crystal report RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hello,

    Having problem with MSOLEDBSQL driver. I am using Crystal reports to call SQL Server 2016/19 stored procedures.

    When a stored procedure with Datetime parameter is called, it is putting the parameter as CONVERT(DATETIME, '2018-06-01 00:00:00', 120) and fails with Database vendor Error 156, Incorrect syntax near the keyword 'CONVERT'.

    With the older SQLNCLI11 driver, the same parameter was being called as {ts '2018-06-01 00:00:00'} and worked perfectly fine.
    • Moved by Dave PatrickMVP Monday, January 4, 2021 2:03 PM looking for forum
    Monday, January 4, 2021 1:53 PM

Answers