Sybase IQ 16.1 OLEDB driver problem with SQL Server Integration Services / Visual Studio

[Daniel365]

Hello,

I have identified a critical issue with the latest OLEDB Sybase IQ driver. The issue occurs intermittently and does not follow a predictable pattern.

I am using OLEDB driver in our Visual Studio Data projects (SQL Server Integration Services - SSIS) to execute Sybase IQ stored procedures or transfer data from Sybase IQ as the source to destination tables (SQL Server).

The issue occurs during debugging of the VS project or when running via SQL Server Agent (job):

• Sometimes, the task using Sybase IQ connection finishes successfully, but no data is processed or the procedure is not executed
• One part of SSIS workflow is processed, but the subsequent steps are skipped, and the workflow pretends everything is done
• Running jobs fail due to a problem with Sybase IQ driver

Can anyone to help to solve this issue. Thanks.

System information:

• Sybase IQ Database Version: SAP IQ/16.1.040.2016/17091/P/SP04.14/MS/Windows 2012 R2/64bit
• Sybase IQ Driver: dboledb17.dll (ver. 17.0.11.2690)
• Operating System: Windows Server 2022 Standard ver. 21H2 build 20348.2655 (where SQL Server and Visual Studio run)
• Microsoft Visual Studio: Professional 2022 64bit ver. 17.10.4 (.NET Framework 4.8.09037)
• Microsoft SQL Server: Developer 64bit (ver. 16.0.1125.1)

[RobertWaywell]

Are you getting an error message? If so what is it? If not, what makes you think the issue is specifically with the driver? For example, if you revert back to an older driver does the issue go away?

[RolandKramer]

Hello @Daniel365 

your IQ Database is not upported by the OS

Note 2669590 - SAP IQ 16.1 SP 04 Supported Operating Systems and Versions

you should update your SW components first before you open a support case.

best Regards Roland

[Daniel365]

Hello RolandKramer, Sybase IQ database is running on other server (SAP IQ/16.1.040.2016/17091/P/SP04.14/MS/Windows 2012 R2/64bit). The issue occurs when we want to connect via dboledb.dll in Visual Studio Data Projects that is running on other server with OS Windows Server 2022. We tried 2019 version but we have failed with the same error. We believe that this issue came to light after certain Windows Updates from mid 2023.

[RolandKramer]

Hello Daniel, nevertheless, the Microsoft Server 2012 and 2022 are a complete different Ballgame. I would try to upgrade the IQ Server to a supported Release. Best Regards Roland

[Daniel365]

Hello Roland, today we had call with MS support and problem is in OLEDB32.DLL, that is changed after mid 2023 OS patching. I hope that workaround provided by support will close this issue.