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?