How to get NT user id.

[kmsam2]

I'm using PB6 to connect MS SQL Server with integrated security, that mean use NT authenticate to login to database.
In the application, how to get the NT login id for user?
any sample code? Because I need to create a audit trail table.

Thanks.

Sam.

Sam.

 

[mbalent]

We use a 'logon' nvo which has the following local external function:

Function boolean GetUserNameA (ref string name, ref ulong len) library "ADVAPI32.DLL"


This function retrieves the username.

//user win32 getusername

string ls_temp
ulong lul_value
boolean lb_rc

lul_value = 255
ls_temp = space(255)
lb_rc = GetUserNameA(ls_temp, lul_value)
If lb_rc Then
as_name = ls_temp
Return 1
Else
Return -1
End If

 

[kmsam2]

Sorry, not familar with nvo,
how to code "Function boolean GetUserNameA (ref string name, ref ulong len) library "ADVAPI32.DLL"

into PB6?


Sam.

 

[pgaec]

Open the nvo
In the menu bar, select
Declare > Local External Functions and paste
"Function boolean GetUserNameA (ref string name, ref ulong len) library "ADVAPI32.DLL"