Performance problem when moving to new server

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
    - 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: Performance problem when moving to new server Tag: 314631
  - 2
    - 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: Performance problem when moving to new server Tag: 314630
  - 3
    - 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: Performance problem when moving to new server Tag: 314628
  - 4
    - Looking for mutliple file downloader Is there such a component that makes downloading multiple files easy? Thanks Jon Tag: Performance problem when moving to new server Tag: 314620
  - 5
    - 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: Performance problem when moving to new server Tag: 314612
  - 6
    - 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: Performance problem when moving to new server Tag: 314610
  - 7
    - 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: Performance problem when moving to new server Tag: 314609
  - 8
    - 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: Performance problem when moving to new server Tag: 314605
  - 9
    - 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: Performance problem when moving to new server Tag: 314603
  - 10
    - 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: Performance problem when moving to new server Tag: 314602
  - 11
    - 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: Performance problem when moving to new server Tag: 314601
  - 12
    - 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: Performance problem when moving to new server Tag: 314596
  - 13
    - 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: Performance problem when moving to new server Tag: 314591
  - 14
    - 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: Performance problem when moving to new server Tag: 314588
  - 15
    - 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: Performance problem when moving to new server Tag: 314584
  - 16
    - 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: Performance problem when moving to new server Tag: 314580
  - 17
    - 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: Performance problem when moving to new server Tag: 314579
  - 18
    - 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: Performance problem when moving to new server Tag: 314578
  - 19
    - 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: Performance problem when moving to new server Tag: 314577
  - 20
    - 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: Performance problem when moving to new server Tag: 314574
  - 21
    - 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: Performance problem when moving to new server Tag: 314572
  - 22
    - 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: Performance problem when moving to new server Tag: 314568
  - 23
    - 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: Performance problem when moving to new server Tag: 314552
  - 24
    - 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: Performance problem when moving to new server Tag: 314550
  - 25
    - 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: Performance problem when moving to new server Tag: 314547
- Next
  - 1
    - 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: Performance problem when moving to new server Tag: 314546
  - 2
    - 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: Performance problem when moving to new server Tag: 314544
  - 3
    - 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: Performance problem when moving to new server Tag: 314540
  - 4
    - 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: Performance problem when moving to new server Tag: 314538
  - 5
    - 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: Performance problem when moving to new server Tag: 314533
  - 6
    - 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: Performance problem when moving to new server Tag: 314522
  - 7
    - 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: Performance problem when moving to new server Tag: 314519
  - 8
    - 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: Performance problem when moving to new server Tag: 314518
  - 9
    - 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: Performance problem when moving to new server Tag: 314507
  - 10
    - 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: Performance problem when moving to new server Tag: 314505
  - 11
    - 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: Performance problem when moving to new server Tag: 314504
  - 12
    - 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: Performance problem when moving to new server Tag: 314502
  - 13
    - 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: Performance problem when moving to new server Tag: 314500
  - 14
    - 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: Performance problem when moving to new server Tag: 314498
  - 15
    - 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: Performance problem when moving to new server Tag: 314494
  - 16
    - Any cool solution to save ENTIRE screen content and state? We have an ASPX (C#) webform which hosts dropdownlists, textboxes, grids, checkboxes, etc. The users want to: #1 - "FREEZE" the entire webpage contents (and state) #2 - move IE browser to another URL (possibly several URLs ... maybe even terminate the session and restart another session an hour+ later) #3 - but eventually to return to the original FROZEN page #4 - and .... shazam .... everything is exactly like they left it I know I could write code to save the contents and state of each control into the database ONE CONTROL AT A TIME. Then reconstitute the form later ONE CONTROL AT A TIME. But that would be SOOOOOO much work. Does anyone know a COOL way to capture #1 - an entire webpage and state in a serializable form #2 - save the capture to a database file #3 - reconstitute the entire saved page later Thanks - Volking P.S. this entire operation happens in an HTTPS environment where users are authenticated against Active Directory. So security is ok. -- Frederick Volking System Architect SC Dept of Juvenile Justice Tag: Performance problem when moving to new server Tag: 314489
  - 17
    - ScriptEngine threw exception 'C0000005' This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C5A7BE.62365580 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, I'm receving the following on my webserver (Windows 2003 Server SP1) Event ID: 5 Source: Active Server Pages Error: File /KQShopping/ordercomplete4.asp Script Engine Exception. A = ScriptEngine threw exception 'C0000005' in = 'IActiveScriptParse::ParseScriptText()' from = 'CActiveScriptEngine::AddScriptlet()'.. Event ID: 5 Source: Active Server Pages Error: File /KQShopping/ordercomplete4.asp Script Engine Exception. A = ScriptEngine threw exception 'C0000005' in = 'IActiveScriptProperty::SetProperty' from = 'CActiveScriptEngine::Init()'.. and i'm getting the same on other pages. How can I determine whats = causing this issue? Will a simple err catch tell me? This site was = developed by another company about 6 years ago and I just took it over = about a year ago. We just switched to the new server so this is the = first I've seen these errors. Any ideas? Thanks, --=20 David Lozzi Web Applications Developer dlozzi@(remove-this)delphi-ts.com ------=_NextPart_000_0006_01C5A7BE.62365580 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.2900.2722" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT face=3DArial size=3D2>Hello,</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I'm receving the following on my = webserver (Windows=20 2003 Server SP1)</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Event ID: 5</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Source: Active Server = Pages</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Error: File = /KQShopping/ordercomplete4.asp Script=20 Engine Exception. A ScriptEngine threw exception 'C0000005' in=20 'IActiveScriptParse::ParseScriptText()' from=20 'CActiveScriptEngine::AddScriptlet()'..</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2> <DIV><FONT face=3DArial size=3D2>Event ID: 5</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Source: Active Server=20 Pages</FONT></DIV></FONT></DIV> <DIV><FONT face=3DArial size=3D2>Error: File = /KQShopping/ordercomplete4.asp Script=20 Engine Exception. A ScriptEngine threw exception 'C0000005' in=20 'IActiveScriptProperty::SetProperty' from=20 'CActiveScriptEngine::Init()'..</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>and i'm getting the same on other = pages. How can I=20 determine whats causing this issue? Will a simple err catch tell me? = This site=20 was developed by another company about 6 years ago and I just took it = over about=20 a year ago. We just switched to the new server so this is the first I've = seen=20 these errors. Any ideas?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial><FONT size=3D2>Thanks,</FONT></DIV></FONT> <DIV><BR><FONT face=3DArial size=3D2>-- <BR>David Lozzi<BR>Web = Applications=20 Developer<BR></FONT><A = href=3D"mailto:dlozzi@(remove-this)delphi-ts.com"><FONT=20 face=3DArial size=3D2>dlozzi@(remove-this)delphi-ts.com</FONT></A></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial><BR><FONT = size=3D2></FONT></FONT> </DIV></BODY></HTML> ------=_NextPart_000_0006_01C5A7BE.62365580-- Tag: Performance problem when moving to new server Tag: 314487
  - 18
    - A comparison among six VSS remote tools including SourceOffSite , SourceAnyWhere, VSS Connect, SourceXT, VSS Remoting, VSS.NET A comparison among six VSS remote tools including SourceOffSite , SourceAnyWhere, VSS Connect, SourceXT, VSS Remoting, VSS.NET To view the full article, please visit http://www.BetterVssRemoting.com Better VSS Remote Access Tool This article makes a detailed comparison among SourceAnyWhere 4.0, SourceOffSite 4.1, VSS Connect 1.5, SourceXT 2.1, VSS Remoting 2.5, VSS.NET 1.67 Keywords: VSS Remote Access, VSS Web Access, VSS Internet Access, SourceSafe Remote Access, SourceSafe Web Access, SourceSafe Internet Access, SourceAnyWhere, SourceOffSite, VSS Connect, SourceXT, VSS Remoting, VSS.NET 1=2E Overview What does the article do? It makes a comparison among: =B7 SourceAnyWhere 4.0 =B7 SourceOffSite 4.1 =B7 VSS Connect 1.5 =B7 SourceXT 2.1 =B7 VSS Remoting 2.5 =B7 VSS.NET 1.67 Our initiative is to make an unbiased, objective, repeatable and verifiable comparison: a=2E Real project is used. The project I use is eMule, which is at http://sourceforge.net/projects/emule/ b=2E Detailed steps are presented. You can follow the detailed steps easily. c=2E If you want to make a comment, I can be reached at [Email]bettervssremoting@yahoo.com.[/Email] If you need more info, please visit their official websites: =B7 SourceAnyWhere (SAW) from DynamSoft http://www.dynamsoft.com =B7 SourceOffSite (SOS) from SourceGear http://www.sourcegear.com =B7 VSS Connect from VoxCode http://www.vssconnect.com =B7 SourceXT from ACORDEN http://www.acorden.com =B7 VSS Remoting from Source Remoting http://www.sourceremoting.com =B7 VSS.NET from DMB Consulting http://www.dmbcllc.com =B7 Want to add a product? Write to me: bettervssremoting@yahoo.com The real result may vary if you do the test in different environment or different files are used. However, the basic concept of this comparison, such as which one is the fastest, which one has more VSS features, should be applicable everywhere. To view the full article, please go to http://www.bettervssremoting.com 2=2E Comparison Summary (5 star ***** is the best) Speed Comparison SAW ***** SOS ** VSS Connect ** SourceXT ** VSS Remoting ** VSS.NET * Stability Comparison SAW ***** SOS ** VSS Connect *** SourceXT ** VSS Remoting ** VSS.NET * Security SAW **** SOS *** VSS Connect *** SourceXT ** VSS Remoting *** VSS.NET ** VSS Feature Support SAW **** SOS **** VSS Connect ** SourceXT ** VSS Remoting ** VSS.NET * Usability SAW **** SOS ** VSS Connect ** SourceXT ** VSS Remoting ** VSS.NET * Diff/Merge SAW **** SOS **** VSS Connect SourceXT VSS Remoting ** VSS.NET IDE Integration SAW ***** SOS *** VSS Connect ** SourceXT ** VSS Remoting ** VSS.NET Cross Platform SAW ***** SOS ***** VSS Connect * SourceXT * VSS Remoting *** VSS.NET * Speed: I am totally surprised and excited by the speed of SourceAnyWhere. For some operations, SourceAnyWhere can be up to 40+ times faster than other five products. Stability: SourceAnyWhere never has any problem in the whole test. SourceOffSite has several problems when it comes to stability. The big problem of SourceOffSite is cancel. There is no cancel support in IDE integration. After a cancel operation in Add, Checkin, Checkout or Get in SourceOffSite Explorer, the CPU usage of SourceOffSite server goes up to almost 100% and can not come down, unless the server is restarted. VSS Connect and SourceXT also have problems in stability. On big file operations, they are very possible to crash. But both two have a good handling of Cancel. And, VSS crashes every time when I try adding a special directory such as "c:\" and "My Computer". VSS Remoting has difficulty to add file and it fails to operate on big files. VSS.NET has problems in big file operation during the whole test. And it cannot handle the Cancel operations. Security: What makes SourceAnyWhere unique is the password policy. SourceAnyWhere, SourceOffSite and VSS Connect use 128-bit cryptography. SourceOffSite and SourceAnyWhere use BlowFish. . VSS Remoting uses HTTPS. VSS Feature Support: Most of the six products support ordinary VSS features such as Add, Get, Checkin, Checkout and so on. However, only SourceAnyWhere has a detailed and full support for almost all of VSS features. Except SourceAnyWhere, all the products does not have supports for EOL (end-of-line). Different OS use different end-of-line characters in text files. Without EOL support, text files got to local may not be read correctly. For example, in Rational the EOL character is "/n" but in Windows it is "/r/n". When getting a text file from Rational to Windows without a support for EOL, the text will not be displayed normally. SourceXT, VSS Remoting and VSS.Net have no support for Pin. Assuming a file is pinned in VSS Server, then what if Pin is not supported? First, the pinned file can still be checked out by Client, which is a great danger to the pinned file. Second, when performing a get, the most recent version will be got, not the pinned version. This can probably cause version confusion. SourceAnyWhere has a "Server-base time zone offset" option, others don't. In my opinion, it is very important to synchronize Server time and Client time. Imagine this, the Server time is 10 hours ahead of Client time. When you edit a file and check it in at 2/23 9:00PM (Client time), but on the Server side, time of this version reads 2/24 7:00AM. So in the future when you need to get version of 2/23 9:00PM actually, you may mistakenly get another version. Usability: SAW is the best. All the Windows of SAW is in Win32 style. It can detect if a file is changed automatically. Diff/Merge In File Diff (2-way)/File Merge (3-way), SourceAnyWhere and SourceOffSite run neck and neck; VSS Remoting has a low performance IDE Integration: SourceAnyWhere, SourceOffSite and VSS Remoting all support MSSCCI Integration. VSS Remoting supports DreamWeaver integration I have not tested the IDE integration intensively. I give this rate just according to manual of the three products. Cross Platform: Besides its Windows client, SAW has a Java client built on JDK 1.4.2, so that it can cross any platform where JDK can run such as Linux, Mac, Solaris, AIX, HP-UX, SCO Unix and FreeBSD. SourceOffSite can cross Linux and Mac OS X. VSS Remoting has a web interface which can login server through web. 3=2E Test Environment Test Data Real project is used for test All eMule0.44c and eMule0.44d files are downloaded from Sourceforge Download eMule0.44c (3.1M) and eMule0.44d (3.1M) used in the test Big Files are simulated files created by us Server Configuration =B7 P4, 2.8G, 256M RAM, Windows XP Professional =B7 SourceAnyWhere profession 4.0 DEMO Server =B7 SourceOffSite4.1 with Cryptography DEMO Server =B7 VSS Connect Server 1.5 =B7 SourceXT Server 2.1 =B7 VSS Remoting Server 2.5 =B7 VSS.NET Server 1.67 =B7 Visual SourceSafe6.0 + Sp6 =B7 Client Configuration =B7 P4 Celeron 2.0G, 256M RAM, Windows 2003 =B7 ADSL connection =B7 SourceAnyWhere profession 4.0 =B7 SourceOffSite 4.1 with Cryptography =B7 VSS Connect Client 1.5 =B7 SourceXT Client 2.1 =B7 VSS Remoting Client 2.5 =B7 VSS.NET Client 1.67 4=2E Test Methodology All the three products are tested on the same computers and internet connection All the three products are tested on the same data set All the three products are tested with the same process For speed test, every action is carried out 5 times The initial state of the VSS database is empty (newly created) Tag: Performance problem when moving to new server Tag: 314483
  - 19
    - A comparison among six VSS remote tools including SourceOffSite , SourceAnyWhere, VSS Connect, SourceXT, VSS Remoting, VSS.NET To view the full article, please visit http://www.BetterVssRemoting.com Better VSS Remote Access Tool This article makes a detailed comparison among SourceAnyWhere 4.0, SourceOffSite 4.1, VSS Connect 1.5, SourceXT 2.1, VSS Remoting 2.5, VSS.NET 1.67 Keywords: VSS Remote Access, VSS Web Access, VSS Internet Access, SourceSafe Remote Access, SourceSafe Web Access, SourceSafe Internet Access, SourceAnyWhere, SourceOffSite, VSS Connect, SourceXT, VSS Remoting, VSS.NET 1=2E Overview What does the article do? It makes a comparison among: =B7 SourceAnyWhere 4.0 =B7 SourceOffSite 4.1 =B7 VSS Connect 1.5 =B7 SourceXT 2.1 =B7 VSS Remoting 2.5 =B7 VSS.NET 1.67 Our initiative is to make an unbiased, objective, repeatable and verifiable comparison: a=2E Real project is used. The project I use is eMule, which is at http://sourceforge.net/projects/emule/ b=2E Detailed steps are presented. You can follow the detailed steps easily. c=2E If you want to make a comment, I can be reached at [Email]bettervssremoting@yahoo.com.[/Email] If you need more info, please visit their official websites: =B7 SourceAnyWhere (SAW) from DynamSoft http://www.dynamsoft.com =B7 SourceOffSite (SOS) from SourceGear http://www.sourcegear.com =B7 VSS Connect from VoxCode http://www.vssconnect.com =B7 SourceXT from ACORDEN http://www.acorden.com =B7 VSS Remoting from Source Remoting http://www.sourceremoting.com =B7 VSS.NET from DMB Consulting http://www.dmbcllc.com =B7 Want to add a product? Write to me: bettervssremoting@yahoo.com The real result may vary if you do the test in different environment or different files are used. However, the basic concept of this comparison, such as which one is the fastest, which one has more VSS features, should be applicable everywhere. To view the full article, please go to http://www.bettervssremoting.com 2=2E Comparison Summary (5 star ***** is the best) Speed Comparison SAW ***** SOS ** VSS Connect ** SourceXT ** VSS Remoting ** VSS.NET * Stability Comparison SAW ***** SOS ** VSS Connect *** SourceXT ** VSS Remoting ** VSS.NET * Security SAW **** SOS *** VSS Connect *** SourceXT ** VSS Remoting *** VSS.NET ** VSS Feature Support SAW **** SOS **** VSS Connect ** SourceXT ** VSS Remoting ** VSS.NET * Usability SAW **** SOS ** VSS Connect ** SourceXT ** VSS Remoting ** VSS.NET * Diff/Merge SAW **** SOS **** VSS Connect SourceXT VSS Remoting ** VSS.NET IDE Integration SAW ***** SOS *** VSS Connect ** SourceXT ** VSS Remoting ** VSS.NET Cross Platform SAW ***** SOS ***** VSS Connect * SourceXT * VSS Remoting *** VSS.NET * Speed: I am totally surprised and excited by the speed of SourceAnyWhere. For some operations, SourceAnyWhere can be up to 40+ times faster than other five products. Stability: SourceAnyWhere never has any problem in the whole test. SourceOffSite has several problems when it comes to stability. The big problem of SourceOffSite is cancel. There is no cancel support in IDE integration. After a cancel operation in Add, Checkin, Checkout or Get in SourceOffSite Explorer, the CPU usage of SourceOffSite server goes up to almost 100% and can not come down, unless the server is restarted. VSS Connect and SourceXT also have problems in stability. On big file operations, they are very possible to crash. But both two have a good handling of Cancel. And, VSS crashes every time when I try adding a special directory such as "c:\" and "My Computer". VSS Remoting has difficulty to add file and it fails to operate on big files. VSS.NET has problems in big file operation during the whole test. And it cannot handle the Cancel operations. Security: What makes SourceAnyWhere unique is the password policy. SourceAnyWhere, SourceOffSite and VSS Connect use 128-bit cryptography. SourceOffSite and SourceAnyWhere use BlowFish. . VSS Remoting uses HTTPS. VSS Feature Support: Most of the six products support ordinary VSS features such as Add, Get, Checkin, Checkout and so on. However, only SourceAnyWhere has a detailed and full support for almost all of VSS features. Except SourceAnyWhere, all the products does not have supports for EOL (end-of-line). Different OS use different end-of-line characters in text files. Without EOL support, text files got to local may not be read correctly. For example, in Rational the EOL character is "/n" but in Windows it is "/r/n". When getting a text file from Rational to Windows without a support for EOL, the text will not be displayed normally. SourceXT, VSS Remoting and VSS.Net have no support for Pin. Assuming a file is pinned in VSS Server, then what if Pin is not supported? First, the pinned file can still be checked out by Client, which is a great danger to the pinned file. Second, when performing a get, the most recent version will be got, not the pinned version. This can probably cause version confusion. SourceAnyWhere has a "Server-base time zone offset" option, others don't. In my opinion, it is very important to synchronize Server time and Client time. Imagine this, the Server time is 10 hours ahead of Client time. When you edit a file and check it in at 2/23 9:00PM (Client time), but on the Server side, time of this version reads 2/24 7:00AM. So in the future when you need to get version of 2/23 9:00PM actually, you may mistakenly get another version. Usability: SAW is the best. All the Windows of SAW is in Win32 style. It can detect if a file is changed automatically. Diff/Merge In File Diff (2-way)/File Merge (3-way), SourceAnyWhere and SourceOffSite run neck and neck; VSS Remoting has a low performance IDE Integration: SourceAnyWhere, SourceOffSite and VSS Remoting all support MSSCCI Integration. VSS Remoting supports DreamWeaver integration I have not tested the IDE integration intensively. I give this rate just according to manual of the three products. Cross Platform: Besides its Windows client, SAW has a Java client built on JDK 1.4.2, so that it can cross any platform where JDK can run such as Linux, Mac, Solaris, AIX, HP-UX, SCO Unix and FreeBSD. SourceOffSite can cross Linux and Mac OS X. VSS Remoting has a web interface which can login server through web. 3=2E Test Environment Test Data Real project is used for test All eMule0.44c and eMule0.44d files are downloaded from Sourceforge Download eMule0.44c (3.1M) and eMule0.44d (3.1M) used in the test Big Files are simulated files created by us Server Configuration =B7 P4, 2.8G, 256M RAM, Windows XP Professional =B7 SourceAnyWhere profession 4.0 DEMO Server =B7 SourceOffSite4.1 with Cryptography DEMO Server =B7 VSS Connect Server 1.5 =B7 SourceXT Server 2.1 =B7 VSS Remoting Server 2.5 =B7 VSS.NET Server 1.67 =B7 Visual SourceSafe6.0 + Sp6 =B7 Client Configuration =B7 P4 Celeron 2.0G, 256M RAM, Windows 2003 =B7 ADSL connection =B7 SourceAnyWhere profession 4.0 =B7 SourceOffSite 4.1 with Cryptography =B7 VSS Connect Client 1.5 =B7 SourceXT Client 2.1 =B7 VSS Remoting Client 2.5 =B7 VSS.NET Client 1.67 4=2E Test Methodology All the three products are tested on the same computers and internet connection All the three products are tested on the same data set All the three products are tested with the same process For speed test, every action is carried out 5 times The initial state of the VSS database is empty (newly created) Tag: Performance problem when moving to new server Tag: 314482
  - 20
    - Make a click on a javascript link in an ASP page Hello, My name is Juan. I am new to the forum. Here I leave you a problem to see if you can help me. General Description I am developing an application in Visual Basic 6. The program has to consult an ASP page of a public argentinian service called ANSES, obtain a result from the response (the query is done by completing a form). The program sends the query with an Internet Transfer Control and the POST method supported. Up to here, all goes Ok. The problem is that sometimes, the query result may not finish in the result page, but the ASP server can respond as result a page with links. And clicking on those links makes appear the final desired result. So, my program detects if the response is effectively the final query result or a link form to click inside. This does it Ok. The problem is that I do not know to simulate a click on a corresponding form link with Visual Basic code, or simulate the submit method from that control with POST. I have tried with many entry data but no way. Details Data form filling page: http://www.anses.gov.ar/expedientes.htm ASP page: http://www.anses.gov.ar/servicios/IGTPC/Consulta.aspx Visual Basic code to automate the query response: Private Sub Command4_Click() Dim str As String Dim data As String Dim bData() As Byte Dim num As Long Dim j As Long Dim count As Long 'completa los datos del formulario de expedientes data = "txtDoc=6903892&" & _ "TipoTramite=1&" & _ "submit1=Consultar" Inet1.Execute "http://www.anses.gov.ar/servicios/IGTPC/Consulta.aspx", "POST", data, "Content-Type: application/x-www-form-urlencoded" 'bucle que espera que el control inet este listo Do While Ready1 = False DoEvents Loop Ready1 = False str = Inet1.GetChunk(100000, icString) 'salvo la página de links. El documento que puse en txtDoc devuelve varios resultados en una pagina de links. num = FreeFile Open "f:\cuil\exp-multi.htm" For Output As num Print #num, str Close num If InStr(1, str, "Para seleccionar un expediente, realice un doble click") <> 0 Then 'Mas de 1 expediente 'javascript:__doPostBack('DGExp$_ctl2$_ctl0','') j = 2 count = 0 Do While True If InStr(1, str, "javascript:__doPostBack('DGExp$_ctl" & CStr(j) & "$_ctl0','')") <> 0 Then count = count + 1 j = j + 1 Else 'no hay mas Exit Do End If Loop Inet3 = Inet1 For j = 2 To count + 1 'str = Inet1.OpenURL("javascript%3A%5F%5FdoPostBack%28%27DGExp%24%5Fctl" & CStr(j) & "%24%5Fctl0%27%2C%27%27%29") Inet1.Execute , "POST", "%5F%5FEVENTTARGET=DGExp%3A%5Fctl" & CStr(j) & "%3A%5Fctl0&%5F%5FEVENTARGUMENT=%00", "Content-Type: application/x-www-form-urlencoded" Do While Ready1 = False DoEvents Loop Ready1 = False str = Inet1.GetChunk(100000, icString) num = FreeFile Open "f:\cuil\exp-multi" & CStr(j - 1) & ".htm" For Output As num Print #num, str Close num Inet1 = Inet3 Next MsgBox "Ok. " & CStr(count) & " expedientes procesados." Else '1 expediente num = FreeFile Open "f:\cuil\exp.htm" For Output As num Print #num, str Close num WebBrowser1.Visible = True WebBrowser1.Silent = True WebBrowser1.navigate "f:\cuil\exp.htm" Do While WebBrowser1.Busy = True DoEvents Loop Do While WebBrowser1.readyState <> READYSTATE_COMPLETE DoEvents Loop WebBrowser1.document.Charset = "UTF-8" WebBrowser1.Refresh MsgBox "Ok" End If End Sub Well, the thing is that the problem as I said results in clicking the links that has the "URL" javascript:__doPostBack('DGExp$_ctl2$_ctl0','') I have tested a lot of things, changing arguments, but is does not work (it returns me the page WITHOUT the result data). Apparently it does not submit the data as it has to. Of course I will thank your answers very very much. With attention, Juan Tag: Performance problem when moving to new server Tag: 314477
  - 21
    - asp vbscript Permission how? I'd consider myself a newbie to ASP using VBSCRIPT with WMI, but I've been using Scriptomatic and learning lots. I have an ASP page with over 1K of code retrieving many objects from user defined remote computer: CDROM, CPU, Chassis, Products, RAM, Shares and more. Q1. Why do some computers return nothing while others return results? No rhyme nor reason to this. Some Win3k return nothing for certain objects and other Win3k return a result set. Q2. Why can't anyone else run this page? My XP IIS has the following authentication: Integrated, Digest, Basic. When anybody else, even somebody with the same access as myself, access the ASP page and they are authenticated against the domain, they can't get the objects listed above. I will be gratefull for any help in this matter Tag: Performance problem when moving to new server Tag: 314475
  - 22
    - Iframe Inside a form I have a form which consists of Iframe <Form method="pst" action="test.asp"> <iframe src="testingframe.asp" id="testfram" frameborder="1" scroll="auto"> </iframe> </Form> testingframe.asp has <table> <td> <tr> <input type=checkbox id="checkedName" name="checkedName"/> </tr> </td> </table> How do i acess checkedName value in my main form .... ? -Jay Tag: Performance problem when moving to new server Tag: 314469
  - 23
    - stylesheet question I have an asp page which has linked a stylesheet. On the page I have <A> tag ...which has set for various colors...visitied, hover etc....when I run the page once the link is visited it changes the color thats working fine...but when I run the page again I need to have that <A> link as a original link without visited color ...how can I do this Tag: Performance problem when moving to new server Tag: 314465
  - 24
    - write to existing file append Hi I'm trying to append an already existent text file, simple enough, but it doesn't seem to be working, here's my code <%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%> <% var stringToWrite = "date=12/0305atfuzionhouse&guest1=SomeName&mail1=somemail&phone1=Somephone22222"; var fso; var file; var ForAppending = 8; var ForWriting = 2; fso = new ActiveXObject("Scripting.FileSystemObject"); file = fso.OpenTextFile(Server.mappath("guestlist.txt",ForAppending,true)); file.Write(stringToWrite); %> I can use the create text file method but this over writes the file and when i use the above code i get Wrong number of arguments or invalid property assignment any help is appriciated Tag: Performance problem when moving to new server Tag: 314459
  - 25
    - Exporting to CSV issue I am using a SQL 2000 server and am trying to export results from a query to a text file. The code is working, expect my CONTACTNAME field has a comma, and my export is splitting that into 2 columns when I only want it to be one. Here is my code: set conn = CreateObject("ADODB.Connection") conn.open DSNtemp set rs = conn.execute("select contactname,contactnumber,contactnumber1,contactemail,address,city,state ,zip,type,sqft,0,bedrooms,baths,lotsize,acreage,garage,comments,price,0, 0,CASE MAINPHOTO WHEN 0 THEN 0 ELSE 1 END [MAINPHOTO],county from propertydata where active='Y'") csvText = rs.getString(2,,",",VBCrLf) rs.close: set rs = nothing conn.close: set conn = nothing set fso = CreateObject("Scripting.FileSystemObject") set fs = fso.CreateTextFile(Server.MapPath("csv.csv"), true) fs.writeline(csvText) fs.close: set fs = nothing set fso = nothing Again, this works, but it splits CONTACTNAME into 2 columns. The same probably in the DESCRIPTION field. How do get it to IGNORE the columns in those fields? Thanks! *** Sent via Developersdex http://www.developersdex.com *** Tag: Performance problem when moving to new server Tag: 314457

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

Top

Re: Performance problem when moving to new server by Zam

Zam
Mon Aug 29 18:18:03 CDT 2005

Hello,

IIS6 should proceed ASP3 pages faster then IIS5.

IMHO you should check database connection pool in your code...

Try to run also your web application in "IIS5 isolation mode"

With best regards,

"Brian Cameron" <2020sol@removethismpx.com.au> wrote in message
news:4313735d$0$25808$afc38c87@news.optusnet.com.au...
> 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
>
>

Top