on 07-27-2017 3:44 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello, Harpreet,
First of all thank you for your valuable feedback.
Regarding 32 bit SAP IQ odbc drivers I have a couple of questions:
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... Did you solve this error ? I am facing the same error
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.