BusinessObjects Board

VBA to extract connection username

sdk development
#1

Hi,

Using VBA I am running this query to get some connection details:

Select top 100 * from ci_appobjects where si_progid = ‘Crystal enterprise.ccis. dataconnection’

I am able to extract things like si_connection_database and si_is_olap but can’t seem to find the connection username.

Any ideas?

Thanks

ChrisTopping :uk: (BOB member since 2012-04-19)

#2

Looks like you won’t be able to get to them using that method:-

https://bobj-board.org/t/191687/2

Mak 1 :uk: (BOB member since 2005-01-06)

#3

Thanks. I think the Designer SDK provides such details but it’s not ideal having to combine the 2 methods.

ChrisTopping :uk: (BOB member since 2012-04-19)