Hi,

I have an insert statement in an asp page that works fine on one server. Basically the statement traps various details and username.

I had to move the site to a new server and unfortunately its not trapping the username for me.

strSQL="INSERT INTO TBLCART (USERNAME,
VALUES ('" & Request.ServerVariables("LOGON_USER")  & "',

Any ideas

Is everything on the new server set up the same way as it was on the old server?
Maybe the access rights are set to Anonymous on IIS

Is everything on the new server set up the same way as it was on the old server?
Maybe the access rights are set to Anonymous on IIS

Ok cool. I see what your saying...the only thing is Im have the problem on a sub section of the site. This is the only place that i use such authentification. is it possible just to set the access rights not to accept anonymous logins in this section alone.

I checked online, and came across this on the microsoft technet site, which says u can secure a file as well.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.