Question Re: Database Logon issue with Microsoft OLEDB Driver 19 f... in Technology Q&A

Database Logon issue with Microsoft OLEDB Driver 19 for SQL Server but works ok with OLEDB Driver 18

RohitKanade — Fri, 18 Oct 2024 07:24:03 GMT

We have Crystal Report SAP Crystal Report Runtime engine 13.0 17 installed.

When we install new Microsoft OLEDB Driver 19 for SQL Server, it gives logon issue but

for OLEDB Driver 18 OLEDB Driver 18, it works ok. we would like to migrate from 18 to 19 OLEDB.

SQL Server is - 13.0 version

Can you please guide about it?

Re: Database Logon issue with Microsoft OLEDB Driver 19 f...

DonWilliams — Sun, 20 Oct 2024 00:29:02 GMT

Firstly you need to upgrade CR for VS to the latest SP, currently it's SP 36

https://origin.softwaredownloads.sap.com/public/site/index.html

Here's a blog on helping you upgrade your app:

Upgrading a Visual Studio 2008->2022 .NET project with the latest CR .NET SDK packages

And see the Platforms info:

https://www.sap.com/documents/2016/06/f871031e-757c-0010-82c7-eda71af511fa.html

Note: SP 17 doesn't support your SQL Server or Client.

Once you upgrade your application to SP 36 it should all start working.

Note also MS ODBC 19 is not listed as being support yet, you'll have to use 18 for now.

If you don't own the application then contact the makers for an updated version.

Re: Database Logon issue with Microsoft OLEDB Driver 19 f...

RohitKanade — Mon, 21 Oct 2024 06:06:59 GMT

MS ODBC 19 is not listed as being support yet, you'll have to use 18 for now.

Re: Database Logon issue with Microsoft OLEDB Driver 19 f...

RohitKanade — Mon, 21 Oct 2024 06:09:10 GMT

MS ODBC 19 is not listed as being support yet, you'll have to use 18 for now. Are you referring Microsoft OLEDB Driver 19 for SQL Server here? OLEDB & ODBC are different software.

Re: Database Logon issue with Microsoft OLEDB Driver 19 f...

DonWilliams — Mon, 21 Oct 2024 13:40:21 GMT

As the platform indicates either one will work

Question Re: Database Logon issue with Microsoft OLEDB Driver 19 f... in Technology Q&A

Database Logon issue with Microsoft OLEDB Driver 19 for SQL Server but works ok with OLEDB Driver 18

Re: Database Logon issue with Microsoft OLEDB Driver 19 f...

Upgrading a Visual Studio 2008-&gt;2022 .NET project with the latest CR .NET SDK packages

Re: Database Logon issue with Microsoft OLEDB Driver 19 f...

Re: Database Logon issue with Microsoft OLEDB Driver 19 f...

Re: Database Logon issue with Microsoft OLEDB Driver 19 f...

Upgrading a Visual Studio 2008->2022 .NET project with the latest CR .NET SDK packages