Skip to Content
avatar image
Donatas Budrys

Sybase IQ 16.1 SP01 odbc driver could not be loaded due to system error code 193

Jul 27, 2017 at 02:44 PM | 757 Views

Hello,

I can't create an 32-bit ODBC connection in SAP IQ 16.1 SP01 version.

I have installed the SAP IQ 16.1 SP01 Network Client x64 (the only installer which can be downloaded from SAP Support Portal for this version) on the client computer. After installing I have successfully created a 64-bit ODBC connection. But when trying to create a new 32-bit ODBC connection (using ODBC 32-bit manager I can find Sybase IQ driver in the list) I am getting the following error "the setup routines for the sybase iq odbc driver could not be loaded due to system error code 193".

I have checked the SAP IQ NC folder and can observe that the SAP IQ ODBC DLL file is located in the Bin64 folder (the same ODBC DLL file is missing in the Bin32 folder). In the REGEDIT I can see that both 32-bit and 64-bit Sybase IQ ODBC drivers are pointing to the same dbodbc17.dll file which is located in the Bin64 folder.

As I understand the error that I am getting is thrown because the 32-bit ODBC Windows administrator is trying to use 64-bit Sybase IQ ODBC DLL library.

Can someone confirm the reason for this error? Also how can I create a 32-bit Sybase IQ ODBC connection in the SAP IQ 16.1 SP01 which could be used in the SAP BusinessObjects Information Design Tool (32-bit application)?

Looking forward your feedback.

Thank you in advance.

Best regards,

Donatas Budrys

SAP IQ
odbc | sap iq 16.1 sp01
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Sep 22, 2017 at 07:25 AM

    Hi... Did you solve this error ? I am facing the same error

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Harpreet Chaudhary
    Sep 26, 2017 at 05:39 PM

    32 bit odbc drivers have been discontinued and do not ship with SAP IQ 16.1.

    You can however download IQ 16.0 network client for 32bit, install the drivers from there and use them with IQ 16.1 server

    Add comment
    10|10000 characters needed characters exceeded

    • Harpreet Chaudhary
      Oct 03, 2017 at 12:41 PM

      Hi Donatas,

      IQ documentation is being updated with the statement about this. As soon as the update is available on sap.com, I will update this thread with it.
      From the last update I have from product management is that there is NOT going to be a 32bit driver available in IQ16.1. But all the 16.0 drivers will work with all SP & PL's for 16.1.

      Regards

      Harpreet

  • avatar image
    Pankaj Dadhich
    Jul 11, 2018 at 06:29 PM

    Hi... Is there any latest update on this. It seems still the odbc drivers for 16.1 are not working.

    Do we still have to use 16.0 drivers.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Donatas Budrys
    Jul 12, 2018 at 01:27 PM

    Hello,

    Previously as stated in the SAP Note (https://launchpad.support.sap.com/#/notes/0002512276) the SAP IQ 16.1 didn't include 32-bit ODBC driver.

    But the good news are that starting from SAP IQ 16.1 SP03 the 32-bit ODBC driver is again included in the SAP IQ 16.1 installation (https://launchpad.support.sap.com/#/notes/0002633568).

    Best regards,

    Donatas Budrys

    Add comment
    10|10000 characters needed characters exceeded