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

[former_member361893]

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

[jose_at_sap · Accepted solution]

Hi Conor,

I believe that BI 4.1 is only 64-bit, as such it only uses the SQLA 64-bit ODBC driver and those are the only ones included.

Perhaps the easiest solution for you is to re-compile your application for 64-bit.

Alternatively, you can use 32-bit ODBC driver from SQL Anywhere.  All you files you need are in your BOXI 3.1 installation, or you can download the SQL Anywhere client from SCN.  A couple of things you need to do:

1. Ensure you're copying the required files.  The list is here: http://dcx.sybase.com/index.html#1201/en/dbprogramming/odbc-driver-deploy.html
2. Register the ODBC driver.  The procedure is here: http://dcx.sybase.com/index.html#1201/en/dbprogramming/configuring-driver-client-deploy.html

You can run both 32-bit and 64-bit SQL Anywhere ODBC drivers on the same machine, provided you ensure to use the correct files and registry entries (file names are the same, but you can rename them; registry entries are different depending on architecture).

Hopefully this helps you out.

José Ramos

Product Manager

SAP Canada

[former_member361893 · Accepted solution]

Thanks Jose your answer was very helpful