BI Java SDK on 64bit platform

[Former Member]

Hi,

Sorry for reposting this question but it is quite critical for us and if someone came across this problem recently and knows how to solve we would really appreciate your help. We have NW2004S installed on MS Windows x64 Enterprise Edition running on Xeon Intel processors (for which Sun provides special JDK, refer to note 941595). Our portal app has to connect to our SAP BW backend. For that we use BI Java SDK and particularly OLE DB Provider. Following the instructions we were able to successfully connect to BW in our local development environment (which is workplace). When we deploy to our 64bit "world" however, we get the following exception:

java.lang.UnsatisfiedLinkError: C:\WINDOWS\system32\sapbiado.dll: %1 is not a valid Win32 application

at java.lang.ClassLoader$NativeLibrary.load(Native Method)

at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1586)

at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1511)

at java.lang.Runtime.loadLibrary0(Runtime.java:788)

at java.lang.System.loadLibrary(System.java:834)

at com.sap.ip.bi.sdk.dac.connector.odbo.impl.Connection.<clinit>(Connection.java:123)

at com.sap.ip.bi.sdk.dac.connector.odbo.OdboManagedConnection.<init>(OdboManagedConnection.java:144)

at com.sap.ip.bi.sdk.dac.connector.odbo.OdboManagedConnectionFactory.createManagedConnection(OdboManagedConnectionFactory.java:90)

at com.sap.ip.bi.sdk.dac.connector.impl.BIConnectionManager.allocateConnection(BIConnectionManager.java:28)

at com.sap.ip.bi.sdk.dac.connector.odbo.OdboConnectionFactory.getConnectionEx(OdboConnectionFactory.java:148)

We think that we need a 64bit version of sapbiado.dll on our server. I tried to find it but without any luck. Can someone point me at the right direction?

Thanks,

Alex

[former_member239282]

If you are developing with the BI ODBO Connector, you need to install an ODBO driver for your data source.

In addition, you need to copy the JNI library sapbiado.dll into a location in your system path (for example, into your WINNT\system32 directory). You can find sapbiado.dll in the following location:

[installation drive]:\Program Files\SAP\JDT\ecplise\plugins\

com.sap.tc.ap\comp\BI_UDI\DCs\sap.com\bi\sdk\odbo\_comp\gen\

default\public\default\lib\native\OS_libs\NUC\ntintel\32\.

• if it helpful rewards points are appreciated

[Former Member]

Hi Pierluigi,

Thank you for your reply. We did all that and does work fine in our 32bit environment. But the problem is in our 64bit environment. As you can see from an exception excerpt I provided in the previous message, sapbiado.dll library is not considered a valid 32 application because it is called by a 64bit java process. We believe we need a 64bit version of BI Java SDK to make it work.

Thanks,

Alex

[Former Member]

Hi Alex,

We are having a similar issue. Were you able to find a 64-bit version of BI Java SDK or sapbiado.dll? If you have found a work-around for this, please post it here.

Thanks,

Bhaskar