Domain Name of user

Using VFP 9.2 on Windows 2000 or XP workstations. Back end is MS SQL 2000.

Some users are on the same domain as the server and so I allow them access
with "trusted_user=yes" in the connection string.

Others are outside our domain and not in a trusted domain (or any domain)
and so I intend to set up SQL Server users and prompt them for userid and
password.

I'd like to do this with one startup program if possible and so I'm looking
for something that will return the domain name. Something on the order of
sys(0) which returns the machine name and userid.

Any thoughts?

Thanks.

Dave Tiffany


.

Relevant Pages

  • Re: Complicated Connection Problems bewteen ADP and SQL Server
    ... If the workstation can see (connect to the SQL Server); ... If the user has appropriate permission to the database on that SQL ... front end on the 5-8 workstations where the users happen to sit. ... connection would fail and the adp wouldn't be able to talk to the server. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: WSS: Finding My Sites through SQL
    ... sites on a diferent server than the WSS server. ... foreach (XmlNode node in AllSites) ... and I came up with this SQL: ... Select @userId = tp_ID from UserInfo where tp_login like 'DOMAIN ...
    (microsoft.public.sharepoint.windowsservices)
  • WSS: Finding My Sites through SQL
    ... sites on a diferent server than the WSS server. ... foreach (XmlNode node in AllSites) ... and I came up with this SQL: ... Select @userId = tp_ID from UserInfo where tp_login like 'DOMAIN ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Sql Server Slow
    ... > On one of the workstations every function, ... See "ODBC Tracing to SQL.LOG Can Slow SQL Server or Consume All Disk Space" ...
    (microsoft.public.sqlserver.setup)
  • Re: Hardware?
    ... Heck even restoring a backup on another server ... Andrew J. Kelly SQL MVP ... > cluster is part of a high availability solution. ... > the workstations, you can certainly afford a basic server-grade machine. ...
    (microsoft.public.sqlserver.clustering)