3808386 – SAP Business One connection failure with Microsoft ODBC Driver 18 for SQL Server 18.7.1.1 due to invalid MultipleActiveResultSets attribute

Symptom

After upgrading to Microsoft ODBC Driver 18 for SQL Server version 18.7.1.1, SAP Business One cannot connect to SQL Server 2022. The following errors occur:

  • ODBC trace error: [Microsoft][ODBC Driver 18 for SQL Server]Invalid value specified for connection string attribute ‘MultipleActiveResultSets’
  • Installer error at Database Server Connection: Failed to connect to the database server
  • SAP Business One client log error: Cannot connect to sbo common DB with DB user: B1_SBOCOMMON

Reproducing the issue

Prerequisites:

  • SQL Server 2022 is installed
  • Microsoft ODBC Driver 18 for SQL Server version 18.7.1.1 is installed.

Scenario for new installations:

  1. Install a new SQL Server 2022 instance.
  2. Update the Microsoft ODBC Driver to version 18.7.1.1.
  3. Run the Setup Wizard.
  4. At the Database Server Connection step, attempt to register the SQL Server

Expected behavior:

The installer connects to the database server and the installation proceeds.

Actual behavior:

The installer displays the error: “Failed to connect to the database server.”

Scenario for existing installations:

  1. Update the Microsoft ODBC Driver on the workstation to version 18.7.1.1.
  2. Launch the SAP Business One client.
  3. Select a company and attempt to log on.

Expected behavior:

The SAP Business One client logs on successfully.

Actual behavior:

The client fails to connect with the ODBC error about the MultipleActiveResultSets attribute.

The client log shows Cannot connect to sbo common DB with DB user: B1_SBOCOMMON.

Solution

SAP intends to provide a feature package or patch to solve the symptom that is described in this SAP Note. The section References below lists the related feature package or patch once they become available. Be aware that References can only be confirmed at feature package or patch release date. SAP delivers feature packages or patches only for selected releases at its own discretion, based on the business impact and the complexity of implementation.

Workaround:

Uninstall Microsoft ODBC Driver 18 for SQL Server version 18.7.1.1 and install a previous compatible version of the driver e.g 18.6.1.1.

https://learn.microsoft.com/en-us/sql/connect/odbc/windows/release-notes-odbc-sql-server-windows?view=sql-server-ver17#previous-releases

Picture of Trần Văn Sơn

Trần Văn Sơn

Với 18+ năm kinh nghiệm và 50+ dự án thành công, tôi chuyên giải quyết bài toán quản trị từ gốc rễ quy trình và con người. Phương châm của tôi là hướng doanh nghiệp vận hành theo chuẩn SAP B1 toàn cầu, đảm bảo hệ thống vận hành đơn giản, hiệu quả ở hiện tại và dễ dàng nâng cấp, mở rộng trong tương lai.
Thảo luận và chia sẻ kinh nghiệm
Bạn có gặp tình huống tương tự khi sử dụng hệ thống SAP Business One?

Bài có liên quan theo chủ đề đang xem

3777838 – Enhanced “E-Mail” type activities

Symptom Here are the updates to the E-Mail type activities: New Send As options in E-Mail type activities and Send Message window New sending option of Microsoft Outlook New Activity of “Email” Type option in Sent Emails Report – Selection Criteria window Enhanced Emailed checkbox

Xem tiếp »
Scroll to Top