on 11-26-2014 11:35 AM
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.
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:
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
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 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
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.