Capturing identity of the user

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ ASP Server
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - problem accessing cookie values I have a pdf form that is submitting to an asp 3.0 page. I am setting a cookie value at login time that I need to access in this processing page. For some reason, the cookie is not being detected on that particular page but is being detected on other pages on the same server when I test for it. This problem only occurs on the processing page when I post to it from the form. If I navigate to it directly, the cookie is detected. This is happening no matter what version of adobe reader or acrobat is used. Tag: Capturing identity of the user Tag: 314685
  - 2
    - ASP to EXCEL Hi, Im creating an Excel file using ASP Versions : Office 97 The formattting is not working properly in Excel 97, but the same works fine in Office XP & 2000 Is there any additional code has to be added in my code to get a formatted output in Excel 97 version? Please help. Thanks. MyCode --------- set Cn=server.createobject("ADODB.connection") Cn.open sqlconstring tfName = "salesexcel.xls" set Rs=server.createobject("ADODB.recordset") sql = "select * from sales WHERE month(saledate)=8 and day(saledate)=28 year(saledate)=2005" Rs.open sql,Cn,1,3 Response.ContentType = "application/vnd.ms-excel" Response.AddHeader "Content-Disposition", "attachment; filename=" & tfName if not rs.eof then Response.write "<table>" Response.write "<tr><td colspan='2'>ID</td><td colspan='2'>Executive</td><td colspan='2'>Sales Done</td></tr>" while not rs.eof Response.write "<tr>" Response.write "<td colspan='2'>" & rs(0) & </td>" Response.write "<td colspan='2'>" & rs(1) & </td>" Response.write "<td colspan='2'>" & rs(2) & </td></tr>" rs.movenext wend enf if Response.write "</table>" set Cn = Nothing ------------------------------------------------------------- Tag: Capturing identity of the user Tag: 314684
  - 3
    - Multimedia - MP3 Does any know how to hide the audio media from the page or embedded file the way flash does? Explain. I have 5 MP3 or WMA files in hosting service and I want the user to select them for playing in the embedded windows media player in a asp page I know how to hide the control of the media player but by looking at the source of the page you can tell what file is playing and location of it cutting and paste link on the browser then anyone can still it and that what I want to avoid. I was trying to do it with flash but I am not good at it so gave up and trying to do it in just plain .ASP Can this be possible.? TIA. Tag: Capturing identity of the user Tag: 314665
  - 4
    - Select DB Columns Dynamically! A Form has a select list which lists all the column names of a SQL Server database table. Users will select one or more than one column from this select list & after submitting the Form, the records of only those columns that he had selected in the previous page will be displayed to him. This is the Form code: ---------------------------------------- strSQL="SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='tblSheet' ORDER BY ORDINAL_POSITION" ............. ............. objRS.Open strSQL,objConn <form........> <select name="colname" multiple size=5> Do Until(objRS.EOF) %> <option><%= objRS("COLUMN_NAME") %></option> <% objRS.MoveNext Loop %> </select> ---------------------------------------- & this is the ASP page that retrieves the records: ---------------------------------------- <% Dim strColNames,arrColName,strEachColName strColNames=Request.Form("colname") arrColName=Split(strColNames,", ") ............. ............. ............. Dim strSQL strSQL="SELECT " & strColNames & " FROM tblSheet" ............. ............. ............. objRS.Open strSQL,objConn %> <table border=2> <tr> <% For Each strEachColName In arrColName %> <th><%= strEachColName %></th> <% Next %> </tr> <% Do Until(objRS.EOF) %> <tr> ---------------------------------------- Now how do I loop through the recordset to display the recordset to the user? Had the column names not been generated dynamically, objRS("ColumnName") would have sufficed but how do I do the same here? Thanks, Arpan Tag: Capturing identity of the user Tag: 314659
  - 5
    - Need Help With QueryString & Password! An ASP application retrieves records from a SQL Server database. In the first page of the application, the user has to enter a password & the columns retrieved from the DB table depends upon the password. For e.g. if the password entered is say, pwd1, then that user should be displayed the records of Column1 & Column2 only. If the password entered is say, pwd2, then that user should be displayed the records of Column1 & Column3 only. If the password entered is say, pwd3, then that user should be displayed the records of Column1 & Column4 only. Now after the records are displayed, the user should also be given the option of sorting the records. I am implementing this by making the column header a hyperlink which has the column name & the sort order as the querystrings, something like this (the records are being displayed in a tabular format): ---------------------------------------- <% Dim strColName,strSortOrder,strPwd strColName=Request.QueryString("colname") strSortOrder=Request.QueryString("sortorder") strPwd=Request.Form("pwd") 'assume that the user is displayed the records of Column1 & 'Column2. When the user comes to this page for the first time 'after entering his password in the previous page, both 'strColName & strSortOrder are empty strings. Dim strSQL If(strColName="col1" Or strColName="") Then If(strSortOrder="" Or strSortOrder="asc") Then If(strPwd="pwd1") Then 'columns retrieved depends on the 'password strSQL="SELECT Col1,Col2 FROM tblSheet ORDER BY Col1 ASC" ElseIf(strPwd="pwd2") Then strSQL="SELECT Col1,Col3 FROM tblSheet ORDER BY Col1 ASC" ElseIf(strPwd="pwd3") Then strSQL="SELECT Col1,Col4 FROM tblSheet ORDER BY Col1 ASC" End If ElseIf(strSortOrder="desc") Then 'the same code in the If condition will come here, the 'only difference being using DESC in the ORDER BY clause. End If End If 'Column1 is common for both pwd1 & pwd2, thus using Or in the 'next If statement If(strPwd="pwd1" Or strPwd="pwd2") Then If(strColName="col1" Or strColName="") Then If(strSortOrder="" Or strSortOrder="asc") Then %> <a href="Records.asp?colname=col1&sortorder=asc">Column 1</a> <% Else %> <a href="Records.asp?colname=col1&sortorder=desc">Column 1</a> <% End If End If %> ---------------------------------------- As seen in the above code, I am passing the column name & the sort order through the column header (which is a link) as querystrings. This correctly sorts the columns & serves my purpose. But the problem is since the columns displayed depends on the password entered by the user, when it comes to sorting the records, even the password has to be passed somehow along with the column name & the sort order. Of course, the password can be passed as a querystring along with the column name & the sort order but that's definitely not a wise idea. So how do I pass the password when the user clicks one of the column headers to sort the records? One way of carrying the password forward is by encrypting the password & then sending it through the querystring along with the column name & the sort order but I would like to avoid such a solution. This solution will be my last option. Please keep in mind that the columns displayed to a user depends upon the password; so the password has to be sent somehow along with the column name & the sort order (column name & the sort order are being passed through the querystring). For e.g. if the password entered is pwd1, then the user sees the records of only Column1 & Column2. Next he clicks the column header 'Column 1' (which is a hyperlink with the column name & the sort order as the querystrings) to sort the records based on Column 1. When the link is clicked, pwd1 also has to be carried forward so that this user is displayed the records of Column1 & Column2 only & not the records of the other columns. Thanks, Arpan Tag: Capturing identity of the user Tag: 314654
  - 6
    - checking for window existance Is there any way to check the existance of a window by the name ? I'm using this code: window.open("http://www.google.com",'targetWin1') If I open a window using previous code without getting immediatly return value of open method, can I get it in a second moment ? For example using the value of param sName of open method ? regards Tag: Capturing identity of the user Tag: 314644
  - 7
    - Deleting blank lines from text file I have a text file being create with the FileSystemObject. It's being built based on results from a SQL query. All this is working fine, but so that I have a carriage return VBCRLF at the end of each row, I have an empty row at the end of my text file. How do I delete this last line? Here is the end of my script: csvText=csvText & vbcrlf rs.movenext loop How should I do this? Thanks!! *** Sent via Developersdex http://www.developersdex.com *** Tag: Capturing identity of the user Tag: 314640
  - 8
    - £ to $ conversion Hi I want to be able to show prices in £ to UK customers and $ for every one else. Is there a way to do this. Thanks D Tag: Capturing identity of the user Tag: 314636
  - 9
    - ASP Classic and .Net Components Hello, I have just moved an ASP Classic website to a new hosting company that has a number of .NET components available. The website works fine after the move with one exception. We were creating PDFs using ASPPDF for ASP but now it looks like only ABCPDF.NET is available. My knowledge of ASP.NET is very limited at this time and I am planning on converting the site to ASP.NET soon but I really need to get the PDF working as soon as I can. Is any of the following possible... 1) "wrap" the ASPPDF com control so I can use it at the new hosting company as a workaround for now? This would be the easiest for me as I would not need to change the asp classic code (maybe a little). Maybe place the asppdf com control in the .bin directory? The control does need registered in it's current form. 2) access the ABCPDF.NET component from a classic asp page? 3) write the pdf code in ASP.NET and then call that code from an ASP Classic page? If I write this as a web service can I call the web service from an ASP Classic page? I would need to pass a parameter, maybe two parameters to the pdf code 4) I am open to any suggestion other then migrate the website to asp.net at the moment as I need to get this up and working in the next few days if possible. If you have any thoughts on this subject please let me know. (code samples would be wonderful!!) Cheers, Rhek Tag: Capturing identity of the user Tag: 314634
  - 10
    - Performance problem when moving to new server Hi All, We need to move an old asp database application that I wrote to a new server. But when we do we start getting serious performance problems as more and more users connect. By old I mean old, its using a MS Acccess 97 database as the back end which is on the server also. There are no code changes just a streight move from the old server to the new server. I testing it seemed ok, its only when a few users start connecting that the performance get really bad. It seems the initial connection time is one of the obvious problem areas. The original server is running on Windows 2000 Service Pack 4 with IIS 5 The new server is running on Windows 2003 Service Pack 1 with IIS 6. Whats different between the two versions that mightr be causing this problem. Can anyone help? TIA Brian Tag: Capturing identity of the user Tag: 314632
  - 11
    - display problem Hi, I have a strange problem when i try to display my data on a web page. Everything's fine until i try to display a Date Value. If i try to display this, no problem : obj("data1") obj("data2") obj("data3") obj("data4") But if i try to display this, only "data1" and "data2" will by displayed : obj("data1") obj("data2") obj("DateData") obj("data1") (if i put DateData at the beginning, i will have a blank page) (if i put DateData after Data1, only Data1 will be displayed) did someone have any idea of my problem ? Thank you Tag: Capturing identity of the user Tag: 314631
  - 12
    - Charset in XMLHTTP or an alternative solution? Hi, I'm trying to get some data from an external website using XMLHTTP, but my problem is that the data is with special danish characters in (ÆØÅ), which are being replaced with "?" due to UTF-8. I've tried to specify the charset using response.charset, but that doesn't seem to have any effect. Any suggestions, or alternative solutions to XMLHTTP? Thanks. -- Med venlig hilsen Sune Christesen http://www.ActiveWebs.dk/ Tag: Capturing identity of the user Tag: 314630
  - 13
    - Correct HTTP response status code on "Access Denied" page. Hi, I have a password-protected area on my site. I'm not using any server authentication methods: Instead I prompt the user for a username and password using an HTML form and check these against a database of registered users. I was thinking that this page should be returning a HTTP status code of "401 Unauthorized" instead of its current "200 OK". My reasoning being that this would let search engines know what's going on when they request a protected page and get redirected to the "Access Denied" page. I experimented with adding response.status = "401 Unauthorized" to the "denied" page, but now it displays a (Windows/IE) username & password prompt instead. The HTTP sniffer shows that the www-authenticate field is set to "Basic". My question: How can I indicate to the search engines that the page it is requesting requires authentication, yet have it not display the login/password dialog box? Thanks in advance, --Diarmaid McGleenan Tag: Capturing identity of the user Tag: 314628
  - 14
    - Looking for mutliple file downloader Is there such a component that makes downloading multiple files easy? Thanks Jon Tag: Capturing identity of the user Tag: 314620
  - 15
    - LOGON_USER becomes null Hi, I create a web site in a Windows 2003 server/IIS6, and I used asp pages to get ServerVariables. After I set FrontPage Extension 2002, some ServerVariables like LOGON_USER become null. Any body has an idea? Tag: Capturing identity of the user Tag: 314612
  - 16
    - Importing comma delimited file I've been asked to develop a semi-automated type situation where we have a database table (sql server) and periodically, there will be a comma delimited file from which we need to import the data, replacing the old. I naurally know that we can use [truncate tablename] to kill the other data, but does anyone have any examples of importing a comma delimited file into SQL Server with ASP? Tag: Capturing identity of the user Tag: 314610
  - 17
    - Session Problems with Desktop Shortcuts in IE I have an issue that I've been encountering in an ASP application I'm working on. Most of the application is written in ASP, but there is one page written in ASP.NET. The ASP.NET page needs to have access to the ASP Session data to run correctly. In order to achieve this I create my own HTTP request for a certain ASP page with the name of Session variable that I want is stored in the query string of the request. The requested ASP page sends back the Session value in the response (you can see more on this at http://searchvb.techtarget.com/vsnetTip/1,293823,sid8_gci951935_tax293033,00.html). This seems to work in general but we have noticed a few difficult to reproduce problems with this. When multiple instances of the web app are set up in different virtual directories and the user creates desktop shortcuts to access each installation, there appears to be problems with the Session data. When the user opens up more than one shortcut at once, it looks as though all the browsers are running under one IEXPLORE.EXE process. This would explain things if the ASPSESSIONID cookie, which holds the ID for the Session data to use for a particular user, is held in the shared process. However, on different servers the Session bug is not always reproducible. In other words if the user has a desktop shortcuts to "http://Server1/app1/login.asp" and another to "http://Server1/app2/login.asp", the Session accessing will have problems. However if you do the same thing on a different server, that is "http://Server2/app1/login.asp" and to "http://Server2/app2/login.asp", the bug will *not* occur. The servers are running different versions of Windows and IIS, so I'm sure that has something to do with it, but I just can't figure out what. Through some experimentation using FireFox and Live HTTP Headers, we found that sometimes FireFox will contain two ASPSESSIONID cookies, where the characters after "ASPSESSIONID", but before the '=' sign, are different. Since both FireFox browsers were running in the same process and yet somehow correctly handled the Session data, we assumed these extra characters helped the server distinguish which Session data the browser needed. However, these cookies have magically stopped appearing (though FireFox still seems to handle the Session correctly). And I've never gotten the multiple cookie thing to happen in IE. Has anyone heard of this issue? Since people use desktop shortcuts quite a bit, I would have expected this issue to have occurred a number of times in the past, but I'm having trouble finding any info on it. Dave Tag: Capturing identity of the user Tag: 314609
  - 18
    - Indenting HTML code in a textarea the question is simple... is there any way to indent HTML code inside a simple textarea?... tnx! martin Tag: Capturing identity of the user Tag: 314605
  - 19
    - trying to open excel from a page (changes in 2002+) hi.. i'm trying to have excel open up a webpage which basically contains a table. in excel 2000 if i specify content type text/csv this works by displaying an open/save dialog box and clicking open, launches excel and displays data as a table (desired result ) however in machines with excel 2002+ excel simply displays the html code. trying to specify application/excel opens an excel plug-in inside the browser which poses a problem becouse the excel has links to pdf file that obscure the plug-in. Tag: Capturing identity of the user Tag: 314603
  - 20
    - 100% height of a div inside a TD This is a multi-part message in MIME format. ------=_NextPart_000_0080_01C5ABC5.EFAC9860 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I've got the problem described in the table above. I've put a div red with some text inside a TD, but its height is less = than 100% of TD height as you can see. I've defined the following styles: div.test { background-color:red; height:100%; width: 100%; }=20 table.test { border: 1px solid #CCCCCC; background-color:yellow; }=20 td.test { border: 1px solid #CCCCCC; } does anyone know a solution ? Please help me. Regards to all 2 2b 1=20 4 5=20 7 8=20 ------=_NextPart_000_0080_01C5ABC5.EFAC9860 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1515" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY><FONT face=3DArial><FONT size=3D2> <DIV> <STYLE> div.test { background-color:red; height:100%; width: 100%; } =09 span.test { background-color:blue; height:100%; width:100%; }=09 </STYLE>  I've got the problem described in the table above.</DIV> <DIV> </DIV> <DIV>I've put a div red with some text inside a TD, but its height is = less than=20 100% of TD height as you can see.</DIV> <DIV> </DIV> <DIV>I've defined the following styles:</DIV> <DIV> </DIV> <DIV>div.test { background-color:red; height:100%; width: 100%; } </DIV> <DIV>table.test { border: 1px solid #CCCCCC; background-color:yellow; } = </DIV> <DIV>td.test { border: 1px solid #CCCCCC; }</DIV> <DIV> </DIV> <DIV>does anyone know a solution ?</DIV> <DIV> </DIV> <DIV>Please help me.</DIV> <DIV> </DIV> <DIV>Regards to all</DIV> <DIV> </DIV> <DIV> <STYLE> div.test { background-color:red; height:100%; width: 100%; } =09 span.test { background-color:blue; height:100%; width:100%; } table.test { border: 1px solid #CCCCCC; background-color:yellow; } td.test { border: 1px solid #CCCCCC; } </STYLE>  =20 <STYLE> div.test { background-color:red; height:100%; width: 100%; } =09 span.test { background-color:blue; height:100%; width:100%; } table.test { border: 1px solid #CCCCCC; background-color:yellow; } td.test { border: 1px solid #CCCCCC; } </STYLE> <TABLE class=3Dtest id=3DTable1 cellSpacing=3D0 cellPadding=3D0 = width=3D300 border=3D0> <TBODY> <TR> <TD class=3Dtest>2<BR>2b</TD> <TD class=3Dtest> <DIV class=3Dtest>1</DIV></TD></TR> <TR> <TD class=3Dtest>4</TD> <TD class=3Dtest>5</TD></TR> <TR> <TD class=3Dtest>7</TD> <TD = class=3Dtest>8</TD></TR></TBODY></TABLE></DIV></FONT></FONT></BODY></HTML= > ------=_NextPart_000_0080_01C5ABC5.EFAC9860-- Tag: Capturing identity of the user Tag: 314602
  - 21
    - asp component error Hi I am having a problem with a com object on WinXP Pro. It is properly registered, but gives me the following error: Server object error 'ASP 0177 : 800401f3' Server.CreateObject Failed /code/cgi-sec/upload.asp, line 3 Invalid class string I do not have windows firewall active and it does the same thing with firewall/virus/spyware software disabled. It runs fine on my Win2K Pro desktop. The MS Knowledgebase entries are no help. Thanks fo all help, Bill Tag: Capturing identity of the user Tag: 314601
  - 22
    - Functions pass by ref or by value? I have a function called GetRS which takes in a SQL string and returns a recordset object. Does this mean that a copy of the recordset is returned or is it passed by reference? Obviously this could have a large impact on performance for large recordsets. Tag: Capturing identity of the user Tag: 314596
  - 23
    - ASP does not work We have a new installation of Win XP Pro, SP2 with IIS 5.1. None of the ASP pages will function - they just display ALL the code on the page, including code between script tags. .asp is listed in Application Mappings for the Default Web Site properties. Seems like I'm missing something obvious...??? Tag: Capturing identity of the user Tag: 314591
  - 24
    - Best ASP 3.0 Editor? This is a multi-part message in MIME format. ------=_NextPart_000_000A_01C5AA56.CF8386E0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable I'm currently using Dreamweaver MX as my editor but continually have = problems with it. Any suggestion for a "lighter" weight editor for 3.0? Kev ------=_NextPart_000_000A_01C5AA56.CF8386E0 Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Dwindows-1252"> <META content=3D"MSHTML 6.00.2800.1515" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>I'm currently using Dreamweaver MX as = my editor but=20 continually have problems with it.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Any suggestion for a "lighter" weight = editor for=20 3.0?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Kev</FONT></DIV></BODY></HTML> ------=_NextPart_000_000A_01C5AA56.CF8386E0-- Tag: Capturing identity of the user Tag: 314588
  - 25
    - Displaying carriage returns in a memo field Can someone please help with a suggestion as to how I can keep the formatting (carriage returns) that the user enters into a memo field and then display that later. I figured I might be able to use: 'replace carriage returns with BRs comment=Replace(comment, chr(13), "<br>") but obviously net.! The <pre> tag doesn't sem to help either as the embedded return is lost by the time you get past Request.Form...... thanks .les. Tag: Capturing identity of the user Tag: 314584
- Next
  - 1
    - Date Question Hi all, I need a script that tells the user what the date is for monday and what the date is for friday for the current week based on the current day. Any help? Tag: Capturing identity of the user Tag: 314580
  - 2
    - User Account Security Hi I'm trying to design a web application where people can create user Ids and passwords while signing up and then use that information to login to an account. (I know, very basic). I just can't get my mind around how to make this system most secure. the user id and password is verified at the time of logging in and at that point, I would like to create something like a session key before openning the new page. I basically don't want to start the new page by passing regular parameters through the URL because that's very easy to manipulate and break. Can someone give me some information about creating a secure system like this and/or forward me some useful sources?? btw.. I'm using, IIS as my server, ASP.Net and VB.Net. Thanks Farsad Tag: Capturing identity of the user Tag: 314579
  - 3
    - MSXML posting SOAP message with Client Certificate I get the following error, I've seen many news forum with similar issue but never a concrete solution. anyone have an idea what could be causing this not to work? msxml4.dll (0x80072F0C) A certificate is required to complete client authentication Here's the code: strPostToURL = "https://cert.here.com/SOAP/" strCert = "cert.here.com" strRequest = server.MapPath("/xml/Sample_XML.xml") set objXMLDocument = CreateObject("MSXML2.DOMDocument.4.0") objXMLDocument.async = false objXMLDocument.load(strRequest) set objSrvHTTP = CreateObject("MSXML2.ServerXMLHTTP.4.0") objSrvHTTP.setOption 3, strCert objSrvHTTP.open "POST", strPostToURL, false objSrvHTTP.setRequestHeader "content-Type","text/xml" objSrvHTTP.send objXMLDocument <-------------------- Error occurs here Response.Write objSrvHTTP.responseText Set objSrvHTTP = Nothing Set objXMLDocument = Nothing Response.End Resources I've looked up and followed that didn't help: http://support.microsoft.com/default.aspx?scid=KB;en-us;q290761 http://support.microsoft.com/default.aspx?scid=kb;EN-US;q294266 http://support.microsoft.com/default.aspx?scid=kb;EN-US;q301429 http://support.microsoft.com/kb/289481/ http://support.microsoft.com/kb/302080/EN-US/ Tag: Capturing identity of the user Tag: 314578
  - 4
    - Posting Data From .aspx to WorldPay Hi, I am writing a script that requires two actions performed on the same page; 1) upload pictures and store them on the server & 2) Send all of the variables from the WebForm to the WorldPay servers via the POST method. I am aware of the Server.Transfer and Response.Redirect methods but neither of these will do what I want. Are there any soluitions out there in C# that I can used to do this easily (running out of time on this project!)? Thanks for your help. Tag: Capturing identity of the user Tag: 314577
  - 5
    - Using ScanLine I'm trying to create an asp page for Scanline from Foundstone (http://www.foundstone.com/index.htm?subnav=resources/navigation.htm&subcontent=/resources/proddesc/scanline.htm) with the asp below. (for our network monitoring site) sl.exe starts on the web server processor goes to 50% but just hangs there. The asp page then eventually times out. (I have to kill the sl.exe process on the server) Any ideas where I'm going wrong.... [-------------code---------------] Dim wshShell Dim oResult Set wshShell = CreateObject("WScript.Shell") Set oResult = wshShell.Exec("sl -nsr "&startaddress&"-"&endaddress) Do Until oResult.StdOut.AtEndOfStream oline=oResult.StdOut.Readline&"<br>" response.write oline Loop Set oResult = Nothing Set wshShell=Nothing [-------------code---------------] Many Thanks Tag: Capturing identity of the user Tag: 314574
  - 6
    - how do I upload files to server? Hi, I need to allow a user to upload images to my website. I can't use an asp.net solution, just asp 3.0. Please advise. many thanks, NEIL Tag: Capturing identity of the user Tag: 314572
  - 7
    - Odd "Invalid class string" error In an asp page in localhost I have this: Set x = Server.CreateObject("Scripting.Dictionary") And I get this error: Invalid class string If I omit Server like this: Set x = Server.CreateObject("Scripting.Dictionary") I get this error: ActiveX component can't create object: 'Scripting.Dictionary' In the same asp page this works fine: Set conn = Server.CreateObject("ADODB.Connection") In a Visual Basic application this works fine, too: Set x = CreateObject("Scripting.Dictionary") I reinstalled VB without success. Why do I get "Invalid class string" in the first case? Tag: Capturing identity of the user Tag: 314568
  - 8
    - Date/Calendar query Hi all, I have an events database (Access) that contains 2 fields, StartDate and EndDate. The fields are set as Date/Time long date. The server is UK date format (dd/mm/yyyy) I have a small calendar that changes the day of the month to a link if an event exists for that day. I start off on day 1 of the month and use a loop through the month until the last day. Each run through the month queries the DB to see if an events exists with this sql: sql="SELECT ListingsID FROM tblEventsListings WHERE StartDate <= #" & DispDate & "# AND EndDate >= #" & DispDate & "#;" The DispDate is generated as part of the loop and is producing the date correctly. My problem is that if an event has the same start/finish day (single day event) then it gets missed. Also, an event that runs over a couple of months seems to randomly be displayed. eg, the calendar will show an event exists for 4 days, then 5 days of no event then events exist for the rest of the month. (The whole month should reflect an event on every day.) Sorry if this is a bit long winded! I'm stumped! Is there a better way to do this loop? Simon Tag: Capturing identity of the user Tag: 314552
  - 9
    - runat=server! The following code snippet ---------------------------------------- <script language="VBScript" runat=server> <% a=1 %> </script> <%= a %> ---------------------------------------- throws the "Expected statement" error pointing to line no. 2. Why? Thanks, Arpan Tag: Capturing identity of the user Tag: 314550
  - 10
    - server application error I use to always be able to view my local ASP pages at http://localhost, but a few days ago, it started giving me the following notice: =================== Server Application Error The server has encountered an error while loading an application during the processing of your request. Please refer to the event log for more detail information. Please contact the server administrator for assistance ================================================== I assume that something is up with IIS, but I don't know where to look. It happens on each and every ASP page I try to view. I haven't changed anything, haven't put up any Microsoft patches or anything. I suspect spyware. I run the usual anti-spyware/adware programs quite often, and catch one or two items just about every time. That dang Winfixer came in a couple weeks ago, and it was pretty nasty, but I digress. Anyone seen this error before? Disclosure: I posted this to the IS group, and received no answer yet, so this could be considered a cross-post Tag: Capturing identity of the user Tag: 314547
  - 11
    - Request.BinaryRead()! Under what circumstances can Request.BinaryRead() be useful & when should it be used? Assume that the value of Request.Form("anyvalue") is "a" (without the quotes). The output of <% Response.Write(Request.BinaryRead(10)) %> is "??a" (again, without the quotes). How does ASP compute this value? Thanks, Arpan Tag: Capturing identity of the user Tag: 314546
  - 12
    - Global.asa good practice? In my Global.asa file I have the following 2 subs for opening and closing my db connection: Sub OpenConn() Dim conn Set conn = Server.CreateObject("ADODB.Connection") conn.Open Application("ConnString") End Sub Sub CloseConn() conn.Close Set conn = nothing End Sub Then in my asp pages I simply call the subs when I need to open and close the db connection. Eg.: Dim Test Test = "Select XXX from SomeTable" OpenConn() Set rs = conn.Execute(Test) Do While Not rs.eof Response.Write(rs("XXX")) rs.MoveNext() Loop CloseConn() Is this good practice to have the 2 db subs in the Global.asa? Tag: Capturing identity of the user Tag: 314544
  - 13
    - String Gets Truncated: VBScript End of String Character? Help, I am using an encryption routine that occasionally will encrypt a string using some extended ASCII characters (ASCII code > 128) I am wondering if there is a reserved character in VB that signifies the end of a string of characters. Here is what happens: I am encrypting certain fields before adding them to a SQL string. On occassion, the SQL string will simply end in the middle of the encrypted value. Example code sSQL = "EXEC SaveDetails " & _ " @iDetailID = " & iDetailID & ", " & _ " @sEncryptedText = '" & _ replace(EncryptText(sText),"'","''") & "', " & _ " @iOtherValue = 6" Normally Response.Write would print something like this: using Response.Write(Server.HTMLEncode(sSQL)): EXEC SaveDetails @iDetailID = 3, @sEncryptedText = 'aw@##@QASV@#AV (!', @iOtherValue = 6 Occasionally on certain inputs for sEncryptedText it will print: EXEC SaveDetails @iDetailID = 3, @sEncryptedText = '@#DFVIDXZI Is my encryption algorithm possible generating a reserved character that signifies the end of a string? Does such a character exist in VBscript? Any help would be appreciated. FYI, I'd rather not post my encryption routine. Please let me know if you feel it would be necessary. Tag: Capturing identity of the user Tag: 314540
  - 14
    - Under High IE Security buttons don't work Hi All, I've got a set of asp pages used to register students into the ResNet database. Testing things out under different browser security settings I ran into a problem. The following buttons.... <INPUT type=button id="EditInfo" name="EditInfo" value="Edit Information" class="ButtonBlue" style="WIDTH: 150px" onclick="location.href='EditResNetInformation.asp'"> <INPUT type=button id="GoToGetMAC" name="GoToGetMAC" value="Continue" class="ButtonBlue" style="WIDTH: 150px" onclick="location.href='GetMACNow.asp'"> ....on page ReadySetGetMAC.asp (in text following) do not do anything in the onclick when Internet Explorer has High Internet zone Security. No error is given.....it looks as if the page has only been refreshed. GetMACNow.asp (also in text following) is 1 of the 2 pages which can be called from the ReadySetGetMAC.asp page. Right now it is nothing fancy at all. If I place http://<MyIPAddress>/WebRegTest/GetMACNow.asp directly into the address I can go to GetMACNow.asp as I can go directly to the 2nd page when directly addressed. I seem to be able to go between other asp pages in this project with nothing similar happening. Also the pages seem to work correctly when using Firefox or Netscape, but I'm not certain I've got them set to their highest security setting. So......why don't those buttons work, in particular (I guess), under IE's High Security settings and how do I get them to work under these settings? Thanks. gdr *******asp pages****** ******************begin code ReadySetGetMAC.asp************************ <%@ Language=VBScript %> <% OPTION EXPLICIT %>   <% 'On Error Resume Next Response.Buffer=true Response.ExpiresAbsolute = #January 1, 1990 00:00:01# Response.ExpiresAbsolute = Now() - 1 Response.AddHeader "pragma", "no-cache" Response.AddHeader "cache-control", "private, no-cache, must-revalidate" '------------------------------------------------------------------------------ Dim NewValID Dim cnMain Dim rstGetConnectionInfo Dim strStudentIDNumber Dim strLastName Dim strFirstName Dim strEMailAddress Dim strCellPhoneNumber Dim strRoomCode Dim strResidenceHall Dim strRoomNumber Dim strPortNumber Dim strConnectionDate Dim strConnectionSemester Dim strConnectionYear Dim strMACAddress Dim strOSVersion NewValID = Session("StuID") Set cnMain = Server.CreateObject("ADODB.Connection") Application("ResNet_ConnectionString") = "Provider=SQLOLEDB;" & _ "Data Source=MySQL;" & _ "Initial Catalog=MyDB;" & _ "User ID=IUSR_FAKE;" & _ "Password=*******;" & _ "ConnectionTimeout=15;" & _ "CommandTimeout=30;" & _ "CursorLocation=3;" & _ "Packet Size=4096;" & _ "Use Encryption for Data=False;" cnMain.Open Application("ResNet_ConnectionString") Set rstGetConnectionInfo = Server.CreateObject("ADODB.Recordset") cnMain.spGetOnlineStudentConnectionInformation NewValID, rstGetConnectionInfo If rstGetConnectionInfo.EOF <> True Then strStudentIDNumber = rstGetConnectionInfo(0) strLastName = rstGetConnectionInfo(1) strFirstName = rstGetConnectionInfo(2) strRoomCode = rstGetConnectionInfo(3) strResidenceHall = rstGetConnectionInfo(4) strRoomNumber = rstGetConnectionInfo(5) strPortNumber = rstGetConnectionInfo(6) strConnectionDate = rstGetConnectionInfo(7) strConnectionSemester = rstGetConnectionInfo(8) strConnectionYear = rstGetConnectionInfo(9) strMACAddress = rstGetConnectionInfo(10) strOSVersion = rstGetConnectionInfo(11) strCellPhoneNumber = rstGetConnectionInfo(12) strEMailAddress = rstGetConnectionInfo(13) Else 'there is no record of this student.....send 'em to apology page Session("StuID") = "" Response.Redirect ("ResLifeValidationFailure.htm") End If %> <HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0"> <title>Last Edit Get MAC Address Next</title> <link href="resnet.css" rel="stylesheet" type="text/css"> </HEAD> <BODY> <p align="center"><img src="ResNet_InetActivation.jpg" width="598" height="151"></p> <h3>Here is your information we have entered.</h3> <h5> <%=strConnectionSemester%> <%=strConnectionYear%> ResNet Registration<br> Date of Activation Request: <%=strConnectionDate%><br> <%=strFirstName%> <%=strLastName%>;  <%=strStudentIDNumber%><br> <%=strResidenceHall%>  <%=strRoomNumber%><br> Port Number: <%=strPortNumber%><br> Cell Phone Number: <%=strCellPhoneNumber%><br> E-mail Address: <%=strEMailAddress%><br> OS Version: <%=strOSVersion%><br> MAC Address: <%=strMACAddress%> </h5> <p><h3>If this NOT correct, you may edit your information<br> by clicking the Edit button below,<br> or you may call the Support Desk @ 6776. </h3></p> <h5> Please click the Continue button below to finish ResNet Internet Activation. </h5> <P align="center"><INPUT type=button id="EditInfo" name="EditInfo" value="Edit Information" class="ButtonBlue" style="WIDTH: 150px" onclick="location.href='EditResNetInformation.asp'">     <INPUT type=button id="GoToGetMAC" name="GoToGetMAC" value="Continue" class="ButtonBlue" style="WIDTH: 150px" onclick="location.href='GetMACNow.asp'"> </P> <h5>If you do not have Internet access within 24 hours,<br> please contact your RCC or the Support Desk at 6776.</h5> </BODY> </HTML> ******************end code ReadySetGetMAC.asp************************ ******************begin code GetMACNow.asp************************ <%@ Language=VBScript %> <% OPTION EXPLICIT %>   <% 'On Error Resume Next Response.Buffer=true Response.ExpiresAbsolute = #January 1, 1990 00:00:01# Response.ExpiresAbsolute = Now() - 1 Response.AddHeader "pragma", "no-cache" Response.AddHeader "cache-control", "private, no-cache, must-revalidate" '------------------------------------------------------------------------------ Dim NewValID Dim cnMain NewValID = Session("StuID") 'connection not used yet 'Set cnMain = Server.CreateObject("ADODB.Connection") 'Application("ResNet_ConnectionString") = "Provider=SQLOLEDB;" & _ ' "Data Source=MySQL;" & _ ' "Initial Catalog=MyDB;" & _ ' "User ID=IUSR_FAKE;" & _ ' "Password=*******;" & _ ' "ConnectionTimeout=15;" & _ ' "CommandTimeout=30;" & _ ' "CursorLocation=3;" & _ ' "Packet Size=4096;" & _ ' "Use Encryption for Data=False;" 'cnMain.Open Application("ResNet_ConnectionString") 'connection not used yet %> <html> <head> <meta NAME="GENERATOR" Content="Microsoft Visual Studio 6.0"> <title>MAC Address and OS Version</title> <link href="resnet.css" rel="stylesheet" type="text/css"> </head> <body> <p align="center"><img src="ResNet_InetActivation.jpg" width="598" height="151"></p> <p> </p> <p align="center"><a href="GetMACHandler_test.asp">CLICK HERE</a></p> <p> </p> <h5>If you do not have Internet access within 24 hours,<br> please contact your RCC or the Support Desk at 6776. </h5> </body> </html> ******************end code GetMACNow.asp************************ -- Gary D. Rezek University Nerworking Systems and Services South Dakota State University Tag: Capturing identity of the user Tag: 314538
  - 15
    - CDONTS Issue I have a web database that just keeps users info for clients uploading/downloading files. Whenever someone uploads a new file this script sends out an email to notify the company. Script only works for a short time once I change my email adddress, then just stops. Can't figure it out, any help would be great. Function SendMail(EmailComponent, RemoteHost, SenderAddress, SenderName, RecipientAddress, RecipientName, strSubject, strBody, isHTML) if SenderName = "" then SenderName = SenderAddress if RecipientName = "" then RecipientName = RecipientAddress IF EmailComponent = "CDONTS" THEN Set mailObj = Server.CreateObject("CDONTS.NewMail") mailObj.From = SenderAddress mailObj.To = RecipientName mailObj.Subject = strSubject mailObj.Body = strBody mailObj.BodyFormat = 0 mailObj.MailFormat = 0 mailObj.Send Tag: Capturing identity of the user Tag: 314533
  - 16
    - Response.Status, force 404 return from ASP I want to return a 404 response from an ASP script (IIS 5). Response.Status lets me set the response string, but if I don't include any HTML text myself, the result is an empty page. Is there a way to 'redirect' it to the server's default 404 response, as if the URI really doesn't exist, but without really redirecting it so the URL isn't replaced in the browser's address bar? Tag: Capturing identity of the user Tag: 314522
  - 17
    - emergency error '80040e14' i get error '80040e14' from this codes.. sqlbul="select * from buyers where sesid="&session.SessionID set rsbul=baglantim.execute(sqlbul) if rsbul.eof then response.redirect "index.asp" end if toplam=rsbul("toplam") i tried like this sqlbul="select toplam from buyers where sesid="&clng(session.SessionID) response.write sqlbul response.end set rsbul=baglantim.execute(sqlbul) it returns select toplam from buyers where sesid=477419109 i run it in query analyser it works well.. how can i get rid of this message Tag: Capturing identity of the user Tag: 314519
  - 18
    - with (NOLOCK) vs. SET TRANSACTION ISOLATION LEVEL I wondering which one of the following I should use to get the best performance. 1. "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED" OR 2. "WITH (NOLOCK)" I notice that when I use the #1 "SET TRANSACTION..." it sets a lock Mode type of "Sch-S" (Schema stability Lock) which described by SQL Books Online as "Schema stability (Sch-S) locks do not block any transactional locks, including exclusive (X) locks" When I use #2 "WITH (NOLOCK)" it returns a lock type mode of "IS" (Intent shared) which is explained as: "[IS lock] Indicates the intention of a transaction to read some (but not all) resources lower in the hierarchy by placing S locks on those individual resources." it later explains an "S" lock as: "No other transactions can modify the data while shared (S) locks exist on the resource." This is how I tested bot executed both: strSQL = "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;" strSQL = strSQL & "SELECT intNumVisitors FROM HitCounter;" set objRS = objConn.execute(strSQL) OR strSQL = "SELECT intNumVisitors FROM HitCounter WITH (NOLOCK);" set objRS = objConn.execute(strSQL) I thought that "WITH (NOLOCK)" was supposed to do exactly what "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;" does but that doesn't seem to be the case? What's up??? I am confused! Can someone clarify why this appears to be the case. Thanks, Ed *** Sent via Developersdex http://www.developersdex.com *** Tag: Capturing identity of the user Tag: 314518
  - 19
    - Jear function Hello, i have a function, thet show me the jears, from now until 5 jears later. That happens with this function: Function JaarArray Dim sJaar() redim sJaar(Year(Date)+6-2005,2) i=1 For p = 2005 to Year(Date)+5 sJaar(i,1) = (p) sJaar(i,2) = (p) i=i+1 next JaarArray = sJaar End function Who can change this function, zo he do this: He must show, all years, from 1950, until now, but now we are in the year 2005, buth he must automaticly change 2005 to 2006, zo then i can see 1950, until 2006.. Who kan help me with this function? Tag: Capturing identity of the user Tag: 314507
  - 20
    - Russain language support on IIS6 Hello Support, We are working with a Russian based client. Our web based application is written using "classic" asp in English. We would like to change the user interface text to the Russian language. Please advise on the process to output ASP and HTML in Russina using an IIS 6 English web server. Thanks in advance. -Mark Tag: Capturing identity of the user Tag: 314505
  - 21
    - Looking for ASP application that interfaces with a Newsgroup Can someone point me to an ASP application that interfaces to a Usenet newsgroup? FOR EXAMPLE, I'd like an application that would display the posts here in microsoft.public.inetserver.general, on a webpage in a forum format (I wouldn't use an actual Microsoft webpage, it's just an example). Thanks, Tony Tag: Capturing identity of the user Tag: 314504
  - 22
    - Reflect Changes to Code Behind Page Hi, I just inhereted a website. I made a change to a simple SQL string in a .aspx.vb page. If I don't have Visual Studio, is there a way to "publish" the pages and show my changes? thanks very much, Paul Tag: Capturing identity of the user Tag: 314502
  - 23
    - date formatting I have a client that wants a time field to resolve to 7:00 PM rather than 7:00:00 PM (wants the seconds gone). vbLongTime provides the later but vbShortTime produces a 24 hour version or 19:00. Any suggestions? Thanks! Tag: Capturing identity of the user Tag: 314500
  - 24
    - upload file to remote computer Hi, I'm looking for a method to upload a file from a site to the Unix server running my database. How can I connect this computer to create a file on it ? and can can I read and write the files on it ? I'm able to upload to the server running IIS but that's not what I want. Thanks, Alban Tag: Capturing identity of the user Tag: 314498
  - 25
    - browser 4K limits I've been reading where browsers can limit cookie sizes to 4K. I have a cookie-based cart and one customer that wants to put 50+ items in the cart. It works fine down around 30 items. Is it possible to raise that limit? thanks Tag: Capturing identity of the user Tag: 314494

Hi...

I have made a asp page that accepts some data from user and stores it in MS
Access database. Now...I want to identify the user who filled the form and
store this information in database. About the enviornment....the server has
Windows 2000 server installed. Clients have Windows XP. Server also has
Exchange 2003 installed and every client has Outlook Express installed. Every
user has to login to his account inorder to use a machine. A given user can
login on any machine.

How can i find the identity of the user who submitted the form? Is it
possible to find out the current logged in user given the IP address of the

machine? If yes, how and will there be any chances of error due to delay in
replication?

Since ASP can use 'com' components on server, i think there should be some
way to achive this. What do you think? For any clarifications post a reply or
mail me at mailanoop@gmail.com

Thanks in advance....

- Anoop

Top

RE: Capturing identity of the user by software_at_darkfalz

software_at_darkfalz
Wed Aug 31 15:06:02 CDT 2005

1) Turn off anonymous auth and make the user login.
2) setup user/pass for each user

You can't, not reliably, reverse IP to get name, nor can you use machine
name.

--
Curt Christianson
site: http://www.darkfalz.com
blog: http://blog.darkfalz.com

"talk_positive" wrote:

> Hi...
>
> I have made a asp page that accepts some data from user and stores it in MS
> Access database. Now...I want to identify the user who filled the form and
> store this information in database. About the enviornment....the server has
> Windows 2000 server installed. Clients have Windows XP. Server also has
> Exchange 2003 installed and every client has Outlook Express installed. Every
> user has to login to his account inorder to use a machine. A given user can
> login on any machine.
>
> How can i find the identity of the user who submitted the form? Is it
> possible to find out the current logged in user given the IP address of the
>
> machine? If yes, how and will there be any chances of error due to delay in
> replication?
>
> Since ASP can use 'com' components on server, i think there should be some
> way to achive this. What do you think? For any clarifications post a reply or
> mail me at mailanoop@gmail.com
>
> Thanks in advance....
>
> - Anoop

Top