I have a need to pass the originating clients "clientname" on to a MetaFrame 1.8 (Win2000) connection through to a SQL Server 2000. Is this possible?
Reason being: we have an Access 2000 FE talking to a SQL Server backend, and our programmer came up with a home-grown locking system for particular record sets based upon the client's workstation name. If the conenction drops for whatever reason the locks are automatically removed. Now that we're developing for the MetaFrame environment we are running into the problem that any clients going through the MetaFrame Server all pass the name of the MetaFrame server to the SQL Server. But we have noticed the the parameter %clientname% is indeed the workstation name of the originating client. Can this be passed to SQL Server?
Reason being: we have an Access 2000 FE talking to a SQL Server backend, and our programmer came up with a home-grown locking system for particular record sets based upon the client's workstation name. If the conenction drops for whatever reason the locks are automatically removed. Now that we're developing for the MetaFrame environment we are running into the problem that any clients going through the MetaFrame Server all pass the name of the MetaFrame server to the SQL Server. But we have noticed the the parameter %clientname% is indeed the workstation name of the originating client. Can this be passed to SQL Server?