using MSOLEDBSQL for Crystal Reports

[former_member558453]

Hi,

I was using CR with SQLOLEDB in a .net application with SQL 2008 R2 under Windows 2008 server. Now i am trying to upgrade to SQL 2016 under windows 2016. The CR version i am using is CRRuntime_64bit_13_0_21.

in new servers im using MSOLEDBSQL driver. Some reports are working fine. But there are few reports with date parameters causing following error. Please advise. See attachment for profiler logs.

Database Connector Error: ADO Error Code: 0x80040e14

Source: Microsoft OLE DB Driver for SQL Server
Description: Incorrect syntax near the keyword 'CONVERT'
SQL State: 42000
Native Error: 156 [Database Vendor Code: 156]

[former_member11696 · Accepted solution]

That old MDAC SQL client is not completely supported my MS connecting to Newer SQL Servers.

Best thing to do is download the MS SQL Client tools and use the SQL Native 11 client in all reports.

Just update the Connection info by clicking Database, Set Location... and select the SQL Native 11 client, Verify database and save.

Need to do this for every subreport as well.

Don