[cbest]

Does anyone have any info about the SuperData property of Blackbaud.PIA.RE7.BBInterfaces.IBBSessionContext interface? I'm trying to determine whether this propery can get me info on the DSN being used in the session context, so that when I make direct (ADO) connections to a database I know for sure that I'm connecting to the same database that RE is attached to. Also, if this is a property that will help my cause, what's up with the license key string it requires? I've tried to use my serial number and my product/package keys, but apparently none of them are "valid" for use of this property. If any one knows something about this or knows of an alternate solution for ensuring that direct connections are being made to the same DB as RE, please reply.

[JeffMon]

SuperData is for Blackbaud internal use only. However you could just add your own login to the DB...

[jestar42]

Have a look at SessionContext.RegRoot, this gives the root location in the HKLM branch of the registry, and under the General key is the DSN that the current connection is using. I use an api function to get the string (I'm using VB6 for this)

sDSN=GetRegistryValue(HKLM, oSessionContext.RegRoot & "\General", "DSN")

which returns the DSN, that I then use to construct the ADODB connection string (using ODBC)

adDB.Connection = "ODBC;DSN=" & sDSN & ";UID=<custom db user>;PWD=******"

This still requires that you are able to create a user on the SQL server with (ideally) read-only permissions on the RE database.

Hope that helps

Wayne Tarr
London, UK