We are running on Sybase SQL Server 11 with Open Client 11 and version 4.1.3 of BO. We are trying to figure out how to avoid creating and maintaining a login to the server for each BO user but we still want to be able to pass into the server the actual user id from BO so that we can see who is using resources. We were able to do this in 3.1. We called the unique id ‘bouser’. What would show up on the server when the user name was queried was: …bouser ‘userlogin’… On 4.1, we have not been able to figure out how to do this. Does anyone know if and how this can be done in 4.1?
Thanks,
Theresa Iserman
In a message dated 98-08-08 22:51:34 EDT, you write:
We are running on Sybase SQL Server 11 with Open Client 11 and version
4.1.3 of BO. We are trying to figure out how to avoid creating and maintaining a login to the server for each BO user but we still want to be able to pass into the server the actual user id from BO so that we can see who is using resources. We were able to do this in 3.1. We called the unique id ‘bouser’. What would show up on the server when the user name was queried was: …bouser ‘userlogin’… On 4.1, we have not been able to figure out how to do this. Does anyone know if and how this can be done in 4.1?
Part of the problem is the interface that BusObj uses to Open Client. In version 3 (of BusObj) you were able to define five pieces of information: the login, password, database, server, and user name. The user name was not used for validation, it was simply passed through to the database so that the sp_who command could show a distinction between all of the folks that logged in with the same login.
In 4.x I have not figured out how to use that same feature. There is no place on the connection screen where you can define the additional information any more. As far as I know, you will not be able to define your connection strings the same way in version 4, and therefore will lose that feature. I would be more than interested to learn otherwise, if someone else on the list can share additional info.
Regards,
Dave Rathbun
Integra Solutions www.islink.com See you in Orlando in… a few weeks!