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
Hi... Did you solve this error ? I am facing the same error
Hi, Marven,
Unfortunately but SAP IQ 16.1 even in SP02 is still missing 32-bit ODBC drivers.
Best regards,
Donatas Budrys
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
Hello, Harpreet,
First of all thank you for your valuable feedback.
Regarding 32 bit SAP IQ odbc drivers I have a couple of questions:
- Where can we find an official SAP statement about discontinuation of SAP IQ 16.1 32 bit odbc drivers, the reason behind it and the future roadmap how 32 bit applications would handle SAP IQ 16.1 via odbc?
- Most probably we will use SAP IQ 16.0 32 bit odbc drivers for now (thank you for a hint) but it seems to be as a workaround which in the future might introduce the troubles regarding SAP IQ 16.0 and 16.1 version and driver incompatibilities when used in the same server. Also it's very hard to tell the clients why SAP IQ 16.1 is missing 32 bit odbc drivers while one of the main SAP BI solution - Information Design Tool can't connect directly and uses the 32 bit odbc driver.
Looking forward your further feedback.
Thank you in advance.
Best regards,
Donatas Budrys
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
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.
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