BusinessObjects Board

[XI 3.1] List of available db connections

server administration XI Server Discussion
#1

hello,

is there a way to get a list of the connections (name and db instance) ?

I have a lot of different connections and everytime i will need to revise them i will need to open designer to see the connections, Then klick on each to get information about the used instance. If you have about 200 connections not quick to do and fault intolerant.

QueryBuilder only lists encrypted values. But i don’t even need a password of the instance. Only Connectionname and instance.

Is there any smarter way?

thanks
semura

semura :de: (BOB member since 2010-08-16)

#2

Hi,

Try using this utility from the BOB’s Download section:

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

#3

thanks for your answer.
when i start the VBA it tells me while processing
Dim DesApp As Designer.Application

“Can’t find project or library”

I run it on a machine with BOXI Client 3.1 SP5.
Do i need some kind of SDK installed?

semura :de: (BOB member since 2010-08-16)

#4

Hi,

Can you check what libraries are referenced in the VBA Project? You would probably need to use libraries of BO XI 3 instead of BO XI r2.

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

#5

Hi

i actually don’t know how to check this.
I have only R3 installed anyway.

Can you tell me how i can check the linked libraries?

thanks
semura

semura :de: (BOB member since 2010-08-16)

#6

Hi,

Open the tool in Excel. Open MS Visual Basic editor (using Alt+F11). Go to menu Tools / References. Check what libraries are referenced there.

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

#7

Hi,

i checked it and choosed “BusinessObjects Dersigner 12.0 Object Library” from the list.

Now it works perfectly!

thanks for your help!
kind regards
semura

semura :de: (BOB member since 2010-08-16)