BO 4.2 SDK sessionmgr

[former_member590090]

we just switched from BO 4.1 to 4.2 and our Java/VBA applications that used BO SDK fail to connect to any of the 4.2 servers. they work fine for 4.1 servers. does anyone know if I need to be using a different syntax for connecting to 4.2 environments? any sample code connecting to 4.2 environments would be very helpful.

here is my excel VBA code:
Set sessionManager = CreateObject("CrystalEnterprise.SessionMgr")

Set Set eSession = sessionManager.Logon(userName, password, CMS, authType) Set

iStore = eSession.Service("", "InfoStore")

[DellSC]

There were major updates to the security libraries with 4.2 SP4. While best practice is to always recompile your code using the latest libraries, it hasn't really mattered that much in the past. However, the new security requires that you remove ALL of the BOBJ libraries from your existing code and replace them with the new version (there are differences in the file names and you don't want the unneeded relics of the older version sitting out there!) Then recompile/redeploy with the new version.

-Dell

[ayman_salem]

It works for me.

Verify that you are using the correct DLL from the new version 4.2

    Dim SessionManager As SessionMgr
    Dim esession As EnterpriseSession
    Dim iStore As InfoStore
    Dim Users, Groups, AllGroups As InfoObjects
    Dim UserItem, GroupItem As InfoObject
    Dim UserObject As User

    On Error GoTo ErrorHandler
    Set SessionManager = CreateObject("CrystalEnterprise.SessionMgr")
    Set esession = SessionManager.Logon(LoginName_tb, LoginPassword_tb, CMS_tb, "secEnterprise")
    Set iStore = esession.Service("", "InfoStore")

[former_member590090]

Thanks Ayman, can you tell me which folder you are getting these DLLs from? I have tried importing dlls from ...\BOBJInstall\win32_x86 but excel will not allow me to import from this location. i'm curious where yoru DLLs coming from

[ayman_salem]

I used Excel 32Bit and DLLs from "...\BOBJInstall\SAP BusinessObjects Enterprise XI 4.0\win32_x86"

If you want to use a 32-bit COM object in a 64-bit environment, there is a workaround (a search for "Use a 32-bit COM object in a 64-bit environment" gives you lots of links to it).

[former_member590090]

thank you everyone for your help. the problem was outside of BO, there was a subnet issue that blocked connection to the server I was connecting to. thanks so much to everyone that responded. i really appreciate it.

[former_member590090]

thanks for your help. i'm using the following references for my VBA code lib.png

[former_member185603]

are you using the 4.2 libraries to build your project?