BusinessObjects Board

How to find what database server is a connection using?

sdk development
#1

Hello everyone,
I need to find what database servers are my connections using.
For example, I run this following query for one of the connections:
SELECT SI_METADATA_PROPERTIES
FROM CI_APPOBJECTS WHERE SI_KIND=‘MetaData.DataConnection’ and si_name= ‘cpts’
and it returns me the following property bag:
(InfoObject:main property bag=((SI_METADATA_PROPERTIES ((SI_METADATA_BVCONN_ATTRIBUTES ConnectKEp4RXpMeDN5OHk1eXZ5bHlYeTsrel55NHo4Y3hXYHldeXF5X3hCelg4eWR4MGB6bHpReV56PWh6bHo9MHhBeWB5N3o1NVF5S10pVHk1Qj1GQHpCeVExeTN5TXpEeTx6TXpOcHlAOHpOeTZ4VFt5WHhOeVt5T3lPeTd5a2Frdzp5ZDx6O0dMNkhyenApel54Unluel5yeWAxOnpuNetworkLayerOLE DBParamKEp4RXpMeDN5OHk1eXZ4UnpYemReW3lTeER6VnlJekRDeW82eVh4RXlNeEZJWXB6VnlRPng.W0x6YHpddHlLOil4MnpwekR6N3pseFN5angxeXN5VXJ5cGV4MnpQeTN6Ynd6OVtzeVwoeUx6U3kxXXlweER4RXhWeUJ6aHF5RlhreW5KPXMxekF4QmN5T3N5a3k4ekx6NHg_dnlARXk9elQweTh6WnpVOnhLUHlpelZ4PXN5WzV4Nkd5VHluNXhHVHlQeTJZeUR6VjlUTXljeWF6M3k1Q3hXeTN5N3lna3lqekF6Ti15NlgsLnk0ejlAelx6WFp5UnppelN5Q3k8WXo9UXlNeDR6Y3Z5UXpfejhoeTl5Znk5eDB6WHpreT15WnlfN3luem15RnhXeld4P3hOeDV4QwRdmsNameMS SQL Server 2000) (SI_METADATA_SECURITY_REFCOUNT 1) (SI_METADATA_BVCONN_KIND 0) (SI_METADATA_DATACONNECTION_WITHPASSWORD 0) (SI_METADATA_BVCONN_USERNAME ) (SI_METADATA_LAST_UPDATE_TIME Mon Feb 09 13:37:22 PST 2009))))…

I can see that it’s using MS SQL Server 2000, but I have no idea to retrieve it. Is there any class or something that I could use to get it?

violeta (BOB member since 2009-07-23)

#2

Welcome to B:bob:B!

This utility from the BOB’s Download section may help you:

Marek Chladny :slovakia: (BOB member since 2003-11-27)

#3

I’m not able to run it. :cry:

violeta (BOB member since 2009-07-23)

#4

No one could help without knowing more about why you can’t run it. :roll_eyes:

Do you get any error message? Which one? Or is there any other problem?

Marek Chladny :slovakia: (BOB member since 2003-11-27)

#5

I’m getting a compile error, “Can’t find project or library”

violeta (BOB member since 2009-07-23)

#6

There are 2 versions of the utility. One for BO XI and one for BO v5.

Are you trying the utility for a BO version that you use? And which BO version do you use?

Marek Chladny :slovakia: (BOB member since 2003-11-27)

#7

I’m using XI R3, so I tried to run XI utility version.

violeta (BOB member since 2009-07-23)

#8

OK. Although I don’t have BO XI3, let’s try to make it working:

  • Open the utility for BO XI
  • Then use Alt+F11 to open the Visual Basic Editor
  • Go to menu Tools -> References
  • in my BO XIr2 environment, this library is referenced:
    BusinessObjects Designer 11.5 Object Library
  • you need to find in the list of available references something similar for your BO version. It’s probably BusinessObjects Designer 12.0 Object Library, or something similar. Check it’s check box and use OK button to close the window.
  • Then use menu Debug -> Compile VBAProject.
  • If you don’t get any error then the utility should work now.
  • Save it and use it :slight_smile:

Marek Chladny :slovakia: (BOB member since 2003-11-27)

#9

Well, it says that BusinessObjects Designer 11.5 Object Library is missing, and there’s no option to choose any other BO library.

violeta (BOB member since 2009-07-23)

#10

Do you have BO installed on your machine where you are trying the utility?

In the references window (VBA editor menu Tools -> References), there should be a long long list of various available references. You need to scroll down and find BusinessObjects Designer 12.0 Object Library or something like that, I am not sure about the number 12.0.

Do you have anything like that in the available references?

Marek Chladny :slovakia: (BOB member since 2003-11-27)

#11

I don’t have BO installed on my machine. I guess this is the problem :confused:

violeta (BOB member since 2009-07-23)

#12

Yes, it is.

Try the utility on a machine where BO is installed.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

#13

Well, it’s impossible for me to do, but thank you for your help anyways :slight_smile:

violeta (BOB member since 2009-07-23)