Skip to Content
Nov 26, 2014 at 11:35 AM

3.1 to 4.1 - 32 bit ODBC connections don't work, need to create 64 bit connections?


Hi guys,

I was wondering if someone could help me with this query?

OS version: Server (BIS) Windows 2008 SP2 Standard Edition

BO version (including any Service Pack/Fix Packs):

SAP Business Object BI Platform 4.1 SP01 (&) SP04+Patch1

Browser version (if the issue is related to a web application): N/A

Summary of the problem:

We have a tool which uses Java and VB to create a universe in an automated way. This tool internally uses Universe Designer Tool.

It also needs an ODBC connection. The problem which we faced is, while we were using BO XI 3.1, the ODBC connection for Sybase SQL Anywhere that was used was 32-bit.

Since we migrated to BI 4.x, it stopped working due to ODBC connectivity but as soon as we created a 64-bit ODBC connection for Sybase SQL Anywhere it worked properly.

Our concern here is why suddenly with the change of version the connectivity required is different? Does 4.1 only use 64 bit drivers?

Because according to that we may need to check our implementations.

Following is the list of dll files used for the compilation as well as execution of the tool.

  1. Interop.busobj.dll
  2. Interop.Designer.dll
  3. Interop.Office.dll
  4. Interop.VBIDE.dll
  5. Interop.VBScript_RegExp_10.dll