Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to pass a userid thru Crystal to SQL (at runtime) eg Workstation id

Hello, I am desperately trying to pass thru a UserID to SQL via the connection from Crystal to SQL as I need the underlying crystal stored procedures to know who the current DB sesion user is. I have tried updating the ConnectionInfo.LogonProperties eg

ConnectionInfo.LogonProperties.Add(new NameValuePair2("Workstation id", "TestHostNameId"));

ConnectionInfo.LogonProperties.Add(new NameValuePair2("Application Name", "TestHostAppName"));

but it doesn't seem to be working. Using a SQL trace the HostName and ApplicationName is blank.

Am I missing something or Is there another easier way to do this?

VS2005/C#/SQL2005/CR11.5

Cheers,

Simon

Not what you were looking for? View more on this topic or Ask a question