Passing only the nt logon to sql7

[Mike getlik]

Hi All,

I'm using iis 4.0 with nt security to validate users. I'm trying to only pass the nt logon to sql and use
it as a filter when selecting records. I'm looking in the odbc driver and striking out there. What
variable is the logon assigned to so that I can construct it in the sql query???? How is this
done???

Direct email would be great!

Thanks

Mike
mgetlik@notes.cc.bellcore.com

[Anthony B. Kenitzki]

What ODBC settings are you using? Are you using domain security?

I am using integrated NT security and it's working fine. I only had to change some ODBC settings to use NT secuity instead of SQL. I am able to access my SQL 7.0 database using an NT Login with ADO and VB6.

Anthony




On 12/16/98 2:53:34 PM, Mike getlik wrote:
> Hi All,

I'm using iis 4.0 with nt security to validate users.
> I'm trying to only pass the nt logon to sql and use
it as a filter
> when selecting records. I'm looking in the odbc driver and striking
> out there. What
variable is the logon assigned to so that I can
> construct it in the sql query???? How is this
done???

Direct email
> would be great!

Thanks

Mike
mgetlik@notes.cc.bellcore.com