Connecting Crystal Reports 2020 to Microsoft 2017 SQL Server, Express

[former_member1185011]

I am having a difficult time conecting Crystal Reports 2020 to a Microsoft 2017 SQL Server, Express instance.

Seems my database should be supported:

https://www.crystalreports.com/datasources/

When chosing tjhe OLE DB (ADO) version, via Micosoft OLE DB Driver for SQL Server or SQL Server Native Client 11.0, I cannot connect to my database.

Any tips to get a connection?

[former_member1185011]

Hmm. thanks for the link.

So, per your advice I did install the 64 bit MS OLE DB Driver. The installer noted I had an older version installed.

SQLOLEDB and SQLNCLI shouldn't be a concern if I'm at MS SQL Server 2017, correct? Depreciated?

I'm using MSOLEDBSQL via the MS OLE DB driver, I thought...

Anyhow, despite the upgade to the 64 bit MS OLE DB driver, I'm still unable to connect via

OLE DB (ADO)

I've a bone stock 2017 server instance - still using TSL 1.0

[DellSC]

One thing to remember is that Crystal 2020 is 64-bit, so you need to be sure to have the 64-bit version of the SQL Server driver installed.

You need to be sure you have the latest version of the MS OLE DB Driver from here: https://docs.microsoft.com/en-us/sql/connect/oledb/oledb-driver-for-sql-server?view=sql-server-ver15

On that page it also notes that the previous versions of SQLOLEDB and SQLNCLI have been deprecated, so you need to make sure you have the latest.

-Dell