Windows NT Index 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
    - Connecting to SQLEXPRESS 2005 with an ASP web app Hello, I have an ASP web app with an SQL back end. It's currently connecting to an SQL Server 2000 database using an ODBC DSN. I am currently migrating to a new Windows 2003 Server machine and SQL Server 2005 Express. As usual, the app doesn't connect right away, but I've gone through all the new Windows 2003 Server security issues and I'm able to get a normal ASP page to display. I can also connect to the SQLEXPRESS when I use visual studio or MS Access on a remote machine, even using the same ODBC DSN, but for some reason, I get an error when trying to access it though ASP. The error is; Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D) [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. I thought that sounded like the IUSR_MachineName user not being defined in teh db, but when I got to add that user, there is no IUSR_MachineName account available. Does anyone else have experience with this? Thanks! Tag: Windows NT Index Server Tag: 318854
  - 2
    - Dictionary Issue I'm using a dictionary to record some totals, however, my first attempt failed and I wasnt sure why... snippet from original code: oTotalFilters.Item(rsNetStock.fields("PartNo")) = oTotalFilters.Item(rsNetStock.fields("PartNo") ) + CInt(iNumFilters) After going back to the start, I eventually realised that the dictionary Item property didn't like 'rsNetStock.fields("PartNo")' as a parameter, so I had to use something like the following: sTest = rsNetStock.fields("PartNo") oTotalFilters.Item(sTest) = oTotalFilters.Item(sTest) + CInt(iNumFilters) Am I missing something here? Surely, my original code should have worked? Is this a known bug/feature? Thanks CJM -- cjmnews04@REMOVEMEyahoo.co.uk [remove the obvious bits] Tag: Windows NT Index Server Tag: 318849
  - 3
    - XMLHTTP character issue - converting byte array to string Hi! I'm using Msxml2.ServerXMLHTTP.3.0 to fetch a HTML page on a remote server. The fetched page is then parsed and the information of interest is extracted and send to the client browser. However, the remote server does not specify any character coding in its headers. If using ResponseText property in ServerXMLHTTP, some international characters are not decoded correctly. This is due to ResponseText assuming UTF-8 coding if no character set is specified. My solution is to use the ResponseBody property which returns the web page as an array of unsigned bytes. I then convert the data to a string using the ADODB.Stream method as described here: http://www.motobit.com/tips/detpg_binarytostring/ The string is then parsed and the required information is pulled out. This solution works just fine but I wonder if there is some more efficient (without the need for a byte to string converion) way to solve the problem. BR, Yllar Tag: Windows NT Index Server Tag: 318846
  - 4
    - Cookies problem on Win2003 Eng + IIS 6.0 I have a demo app where cookies does not work. The first page create a cookies. The second read the contet. If I browse the pages via IE6.0 the pages does not work. If I browse the pages via FireFox the pages work fine. ************ SetCookies.asp <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <title>ARXivar Test - Generazione Cookies</title> </head> <body> <form name="Test" action="./SetCookies.asp" > <strong>Pagina di generazione Cookies</strong><br><br> <input name="GeneraCookies" type="submit" value="Genera Cookies Â»"> </form> <% If Request("GeneraCookies") <> "" Then Response.Cookies("Nome").Path = "/" Response.Cookies("Nome") = "Claudio" Response.Cookies("Nome").Expires = DateAdd("h", 4, now) 'Date + 1 Response.Cookies("Cognome").Path = "/" Response.Cookies("Cognome") = "Maccari" Response.Cookies("Cognome").Expires = DateAdd("h", 4, now) 'Date + 1 Response.Write("Cookies generati") Response.Write("<br><br><a href='./GetCookies.asp'>Clicca qui per leggere il contenuto dei cookies</a>") End If %> </body> </html> ************ GetCookies.asp<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <title>ARXivar Test - Lettura Cookies</title> </head> <body> <strong>Contenuto dei cookies:</strong><br><br> Nome: <%=Request.Cookies("Nome")%> <br> Cognome: <%=Request.Cookies("Cognome")%> </body> </html> Tag: Windows NT Index Server Tag: 318845
  - 5
    - Closing Recordsets/Connections Is it sufficient to Set a Connection or Recordset to Nothing, or ought they specifically be closed first? E.g. Set rs = oConn.Execute(sSQL) 'Do stuff Set rs = Nothing Set oConn = Nothing -- cjmnews04@REMOVEMEyahoo.co.uk [remove the obvious bits] Tag: Windows NT Index Server Tag: 318843
  - 6
    - Scaling with ASP and Server Memory Issues Hi, I am hosting hundreds of websites on a webserver using a combination of sql and asp. SQL is on a different server. The web server is running win 2003 iis 6 with a single processor and 1 GB Ram. All websites are in 1 app pool. I find that i get out of memory errors or no new sessions are created when the virtual bytes for an App pool starts to breach over 1500mb. So i recycle the App pool at a limit of 1500mb. This leads to the app pool recycling 1-2 times a day. Typically the Private Bytes counter is saying 293mb and virtual bytes is 1438mb. I don't know whether this is a leak somewhere in ASP or normal with IIS but the virtual bytes only seems to increase over time and not stablise or go down as i would expect when users visit and leave a website. I have a script that i use to let uses download files from the server. It uses the response.binarywrite method. If i download a large files (i.e. over 100mb) then i see a big jump in the virtual bytes that IIS allocates in the w3wp.exe process. This does not appear to go down after the file has been downloaded although Private Bytes goes up and then down initially. I was thinking that this may be a cause of the problem?! ...or maybe it is typical for these types of large scale ASP applications? Would increasing the main memory RAM to 2GB help in this situation. The main Physical Memory still reports about 300mb free when i get the memory problems? Would it help to split the websites into a couple of different App Pools, then increase the page file size to something larger and hence each App pool gets to use a separate 2GB memory space? Would i benefit from moving to Windows 64bit edition and installing more Ram and having a large Page file to cope with the large Virtual Bytes? Can anyone offer some guidance who have had similar issues with hosting their sites? Help much appreciated. Tag: Windows NT Index Server Tag: 318842
  - 7
    - Displaying a "choose folder" dialog Hi, I'm asking for help because I read dozens of threads on this subject, but I still cannot make it work. I'm developing an ASP script (running on a SBS 2k. I'm a beginner with ASP) to use on our intranet which does searching on our file server using Indexing Services. To let the users specify the scope (from which file-server folder start to search) I need to display on client pc's (Win 2k or Win XP Pro) a "choose folder" dialog. I tried BrowseForFolder method, in lots of different ways, for example (this is a copy and paste from msdn site): ------------------------------------ ssfWINDOWS = 36 set objShell = CreateObject("Shell.Application") set objFolder = objShell.BrowseForFolder(0, "Example", 0, ssfWINDOWS) if (not objFolder is nothing) then Response.write(objfolder) end if set objFolder = nothing set objShell = nothing ------------------------------------ But the result is always the same: the client gets stuck (progress bar running and nothing happens) and after a while the server stops responding to all asp requests. How can I do that (let the user choose a folder on fileserver) using this or another tecnique? Any help is greatly appreciated Thanks in advance Guido Italy Tag: Windows NT Index Server Tag: 318840
  - 8
    - Get Rich Take advantage of a great deal Tag: Windows NT Index Server Tag: 318839
  - 9
    - sending ASP output to a excel file Hi all I have a asp page which will get the data from multiple tables (with functions and procedures)and display data in HTML tables <TABLE> on ASP page. Is there any way we can create a excel file from the output of this ASP file. I know how to export if this information on ASP page is coming from single query from a database table. Any suggestions??? Thanks mvr Tag: Windows NT Index Server Tag: 318833
  - 10
    - Visual Studion Connect to Win 2003 IIS 6.0 Server is challenged Every time developers try to connect to a Windows 2003, IIS 6.0 server they are challenged by NT. The directory is shared and they have full rights and can connect using Windows Explorer and Notepad. However, they are challenged with Visual InterDev 6.0. Only the administrator's login and password will let them in. I have re-set their permissions several times. Hmmmmm. Rich Tag: Windows NT Index Server Tag: 318831
  - 11
    - ASP on Win 2003 Server My window server is going to be upgraded from Win NT 4.0 Server to Win 2003 Server. I don't know if I can put an ASP web application on this new server without any problem. I guess ASP.NET would be better but right now I just have a classic ASP. Can you help me about this? Or any article about this issue would be greatly appreciated. Thank you, tim Tag: Windows NT Index Server Tag: 318829
  - 12
    - Way to limit total number of sessions from one IP address In trying to improve the throughput of a classic ASP app I wrote last year, I added monitoring to the application and session start and end methods. For one, I'm counting the total number of sessions and the high water mark. My monitoring has revealed a few interesting things. 1. The ASP application is being shutdown and restarted almost daily. The hosting company swears that neither the machine (shared server) nor IIS nor the application is being restarted. Is there any other way the Application_OnStart and _OnEnd methods might be invoked? 2. I found in the app log that apparently one invocation of the app was being shutdown while a new one was being started; i.e. the Startup event for the new run was logged before the Shutdown Complete event was logged (in the same file) for the old run. How is this possible? 3. At one point, about 40 new sessions were started up from one given IP address, with 5-10 seconds between start events being logged. Does this happen if the user has his browser's cookies disabled? How else might this happen (except perhaps for deliberate DoS-style hacking)? 4. Because of (3) above, I think I want to limit the number of concurrent sessions originating from a given IP address (I already keep an application-level array that tracks the IP addresses of all active sessions). To be least annoying to the end user, I presume I'd want to kill older sessions rather than not allow newer sessions (in case of browser crashing, for example). Is there a way to kill another session by ID, or to instruct another session to kill itself? Thanks tbone Tag: Windows NT Index Server Tag: 318828
  - 13
    - how to open and then close a new window? Host Environment: IIS in window 2003 server, three web servers, one load balance, ASP (not ASP.net) code set. Background: There is part A codes in one asp page (page A) to open a new window (Window B). The new window like a clock non-stop running. There is part B codes in the page A need to close window B. Problem: There is no problem if the there is only one web server. It works. When there is a load balance and more than one web server, then the window B can not be closed. Any help is appraciated. Tag: Windows NT Index Server Tag: 318823
  - 14
    - META REFRESH Can someone explain to me why the META Refresh doesn't work in an ASP.NET page? It works just fine in my old asp one! Content value has to be in quotes if not otherwise I get a warning. Thanks DOTNET -------------------- <%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" EnableSessionState="True" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"> <title>TEST</title> <meta http-equiv="refresh" content="10" /> </head> <body> </body> </html> ASP ---------- <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <?xml version="1.0" encoding="iso-8859-1"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html> <head> <title>TEST</title> <META HTTP-EQUIV="REFRESH" CONTENT=10> </head> <body> <div> </div> </body> </html> Tag: Windows NT Index Server Tag: 318822
  - 15
    - How do I check for the existence of a file? Greetings, I'm experimenting with an ASP page that reads data from a file name that is passed to it as a parameter, as in this page, which works, because the "good" file exists. http://mazes.com/asp-maze/customized.asp?file=good&firstname=jwk (make "your name is an amazing asp.general programmer" mazes. But when I try this page, with the "bad" file which does not exist, I'm not succeeding: http://mazes.com/asp-maze/customized.asp?file=bad&firstname=jwk I've tried several solutions that I found by googling. When I tried: If (ns.FileExists(zfil)<>true) then ... but even when I give it a valid name, it returns "False" I've tried using On Error Resume Next set nq=ns.OpenTextFile(Server.MapPath(zfil),1,true) if Err.Number <> 0 Then ... On Error Goto 0 I have found a workaround. Here is what finally worked: On Error Resume Next set nq=ns.OpenTextFile(Server.MapPath(zfil),1,true) if nq.AtEndOfStream=True Then zfil=custompath&"customdatadefault.asp" set nq=ns.OpenTextFile(Server.MapPath(zfil),1,true) end if But meanwhile, I'd love to hear how to check for the existence of a file. John Tag: Windows NT Index Server Tag: 318820
  - 16
    - copying page Is there a way, to make a page that gets info from a DB using scripting. then take that page, and copy it to another folder, BUT, not having the script there. making it become all html? so the page would contain html, but would be the result of what was scripted. so i guess i am saying, that the page would become the source. i hope i am explaining myself clearly Jeff Tag: Windows NT Index Server Tag: 318815
  - 17
    - Newbie question on error checking Hello, I am fairly new to ASP code and need help with error checking within my script. Specifically, I need to check for 3 things: 1. Trap the error if the script cannot find or connect to Active Directory. 2. Trap the error if the script cannot find the requested FSM Group. 3. Trap the error if the required input file is missing or it cannot create or edit the output file. I have learned a little about using the Err Object (Err.number and Err.description) but that is about it. Can anyone offer me any general tips/tricks about how best to do this or point me to some good reference material? Thanks in advance, Rich Tag: Windows NT Index Server Tag: 318814
  - 18
    - Question about For-Next Hello, I have a simple 'For Next'-code (see at the bottom). In the middle of the loop I want an IF-statement, which (if it is true) jump over to next level. I thought I could solve it through simple just writing an IF-statement and put Next in the middle, but an error message appears. Do you know how I can solve it? <% For m = 0 To Ubound(minArray,2) If Isnull(minArray(0,m)) or minArray(0,m) = "" Then Next End If Response.Write "Hello world!" Next %> Thank you! Kristoffer Tag: Windows NT Index Server Tag: 318812
  - 19
    - Form post not passing data to ASP??? I have IIS server installed on XP-pro. I also have Norton Internet Security installed. I can run simple ASP programs without any problem. But when I use forms with post method and call an asp in action, it does not pass any data to ASP. Request.Form method on a form field does not return any value. This code works on web hosting provider server, just does not work on my workstation with my own IIS server. Any help would be appreciated... Here is the form code: <html> <head> <title>Guestbook Form</title> </head> <body> <form name="form" method="post" action="seltest.asp"> Name: <input type="text" name="name1" maxlength="20"> <input type="submit" name="Submit" value="Submit"> </form> </body> </html> ------------------------ Here is the ASP code: <html> <head> <title>Entry Select</title> </head> <body bgcolor="white" text="black"> <% Response.Write (Request.Form("name1")) %> </body> </html> Tag: Windows NT Index Server Tag: 318800
  - 20
    - Length of words in a string. Hello all - I'm really at wits end on this as I'm not having much success with locating a function or other options I have. I'm working on a message board for a website and I'm needing to check the length of the words that users put in. For example, when someone puts in "yesssssssssssss!", I put together a small function that omits all of the s's as this is wreaking havoc on the layout of tables within the site. But I don't have a solution if someone types in "ssss ssasdfjskldjfaskld;jfaskdf" as random ambiguous letters. I know I can check the length of the entire string but don't know to check the words within it. Any help at this point is appreciated. Thanks, MN Tag: Windows NT Index Server Tag: 318790
  - 21
    - RegExp Question Premise: Inserting data into a database form a <textarea> and displaying this data through an HTML page. When inserting data into a database via a text area and then displaying this data any carriage return that was entered into the database was lost. I Created a function to replace a carriage return with a <BR>. I call this function when I display this data. If I enter text inside <> into a database and then display this data, any text that was within the <> is lost because it is considered an HTML tag. How can I search the string for the brackets and actually diplay them? I do not want to use Server.HTMLEncode before I insert the data into the database. This is because we often query the database from outside a web browser. Here is my function I have for the carriage return. I need to figure out how to accomplish this for both < and >. I am sure this is simple but I do not know what the .pattern should be (for a carriage return it is "\r". SET regQuote = New RegExp regQuote.pattern = "\r" regQuote.global = True catchCR = regQuote.Replace(strText, "<br>") Thanks in Advance. I will post this to an ASP and a VBScript Group. Tag: Windows NT Index Server Tag: 318785
  - 22
    - URGENT| navbar I'm paginating a recordset result with ASP I need a navigation bar like search engines (google for example) which display "previous" 1 | 2 | .... | n "Next" Queries could have hundreds of pages so I don't want to display 100+ numbers but only a defined number, say 10 just like google does Do you have any suggestions. Do you have any example url? Thanks Tag: Windows NT Index Server Tag: 318781
  - 23
    - ASP - Delete File Across Network - In Win 2003 Hi, I need to delete files across the network using web client (IE 6.x) in Win 2003 - IIS 6.0 environment. Can someone please suggest an approach I can use to acheive this. Will using FSO do the job or I have to go COM way. Thanks in advance. Parag Tag: Windows NT Index Server Tag: 318777
  - 24
    - ASP or ActiveX Hi simple question what is faster, ASP Code or compiled ActiveX DLL with same functions(queryng data from ms sql server) Regards; Mex Tag: Windows NT Index Server Tag: 318775
  - 25
    - Help wrapping text around an image I 've built a site for a client using .asp and eveything is working fine except I cannot figure out how to wrap text around an image. Everything is pulled from the database using response.write. The code works correctly but I just can't seem to figure out how to do it? I've been searching for weeks about info on how to do this - to no avail. Can anybody offer any help? thanx cobyfrombrooklyn PS the site is at www.caterdata.com/ann and the "Featured Artists" and "About" pages are what I'm concerned with. Tag: Windows NT Index Server Tag: 318767
- Next
  - 1
    - Opening ASP page causes file download dialog instead I have an issue with a particular ASP page on two web servers. Let's call these servers Dev1 and Beta1. Both Servers are running IIS 5, Windows 2000 SP4 with "almost" all of the latest patches. On Beta1, I am able to execute a particular page with no problem, that page opens up in the comes up just fine. On Win2kdev1, when I go to execute the same page, it opens a file download dialog and asks me whether I want to open or save the "file". Other ASP pages in the same directory display correctly. As far as I can tell, there is nothing obviously different between these working pages and the ASP page which causes the download dialog to open. The filetypes are all .ASP. I have verified that the app mappings (in IIS Manager, Directory/Configuration/App Mappings) are correctly set to point to asp.dll. I have removed and reset the app mapping just in case, but still get the same error. The problem can arise on a different page by doing something as trivial as changing some text and saving the page. I have compared file permissions on the file on both servers and they are exactly the same. I thought something was wrong with the page on Win2kDev1, so I copied over the page from Beta1. Same problem. I have checked the IIS logs, and I do not see any errors in the ex060120.log (for the last date that I tested this). Does anyone have any ideas for anything I can look at to try to figure out this issue? TIA. -- Neil Rossi Tag: Windows NT Index Server Tag: 318766
  - 2
    - Editable Textarea Hello all, looking for some help here! I've got a page on a website I'm developing that contains a textarea. The textarea will allow users of the site to enter a description of an item. When they submit the form that contains the textarea, the textarea and other form elements data are stored in a database. So far so good. My problem concerns carriage returns, new lines, line feeds or whatever else you want to call them :-) I want them preserved, so when the user wants to edit the description of the item, the format of the description is displayed exaclty as it was entered. The problem is that HTML renders the carriage returns as white space, so when the database is read and the textarea populated with the description field, the carriage returns are lost. I have tried the ASP REPLACE function to replace carriage returns with <br>, but the code below actually displays all the <br>'s. <%=Replace(myRecordset.Fields.Item("myField").Value,Chr(13),"<br>")%> I played around with different combinations of chr(13) and vbcrlf and I managed to get the textarea to display the description as it was entered with carriage returns, but upon further testing and editing of the description, because of the REPLACE function, the number of carriage returns was doubling each time! I'm sure this is a simple problem to fix, but I just can't find it at the moment - I hope someone can help. Many thanks, Robine *** Sent via Developersdex http://www.developersdex.com *** Tag: Windows NT Index Server Tag: 318762
  - 3
    - XML rss reader Hello I'm just new for RSS Feed based on XML files so I'd like to know if somebody knows about a good ASP class or functions to read and display these files Thanks Tag: Windows NT Index Server Tag: 318757
  - 4
    - Help: Dynamic variables syntax Hi. What's the correct syntax here: (given the recordset myRS with x records do until myRS.EOF txtvar & myRS("serial_number") = myRS("serial_name") myRS.movenext loop .asp will not build the dynamic variables txtvar1 = "Some name" txtvar2 = "Any name" txtvar3 = "Your name" .... Based on the serial_number in the current recordset How can I builde the dynamic variables, and give them a value from my recordset? Hope some of you understand, and can help me out.... Regards Mr. Smith Tag: Windows NT Index Server Tag: 318755
  - 5
    - How to send http post request in ASP Let's say if I want to send a http "Post" request to a url, and check the http status code later. How should I write the code? I have found example to use WinHttp to send "Get" request and check the http status code: ====== Set objWinHttp = CreateObject("WinHttp.WinHttpRequest.5") objWinHttp.Open "GET", strURL objWinHttp.Send If objWinHttp.Status <> 200 Then ... End If ====== How should I write the code if I need to use "POST" to send data in a form, and to check the http status code later? Tag: Windows NT Index Server Tag: 318754
  - 6
    - is it possible to get a page and put it in a variable? Hi basically i want to send a web page off by email. so i was thinking of putting some asp scrip at the end of the page to do this... <html>.....</html> <% dim a a = page_content send_email(page_content) %> but how do i get page content? Is there some variable I can read that has it stored? is there some way I can all the stuff that has gone out to browser? Cheers for any help Kal Tag: Windows NT Index Server Tag: 318753
  - 7
    - FTP a file with ASP Ray Costanzo [MVP], in a reply on December 7th, 2005 suggested the article http://groups.google.com/group/microsoft.public.inetserver.asp.general/browse_thread/thread/61b119678886a1e1/4ca193f328946c4a?q=ray+ftp&rnum=3#4ca193f328946c4a as a means to upload, via FTP, a file to another server. OK, given the flipping of the puts to gets, I am sure that with this method, I can use this to retrive files from another server and place them in a directory on my server. There are six files (the same 6 files) that I would have to download on demand, and then import them into an SQL server via Data Transformation Services. Since I am looking into downloading files that are 8Mb each and getting larger, how do you check this code for success/failure (or timeout). Wouldn't IIS timeout a script on a long transfer? Also, is there a security catch (provided that the script is hardcoded and not in the webspace)? Will this be a better solution than ASPInet that also would suffer from the same timeout (although it does support success/failure)? Sorry about the longwinded email but this part is new to me. Julian Tag: Windows NT Index Server Tag: 318750
  - 8
    - setting printer option from ASP page Hi, I have several asp pages which contains maps and I would like to provide an easy way for users to print this maps and they do not have to go through printer setup before they hit print on browser. I need to pre set the printer to landscape and 11x17 from my asp page. Is it possible? How can I do this? Thanks, Tag: Windows NT Index Server Tag: 318749
  - 9
    - question about IIS and ASP I am using IIS 6.0 and plain old ASP. My IIS server is for development, and is currently running different websites under different virtual directories. Most of these websites use ASP.NET, but we have a client on an old technology, and we wanted to put work for them under the same website in a different virtual directory. I set the virtual directory up successfully, and can access my site via: http://localhost/mynewclient/default.html where default.html is just a "hello world" page. Comes up just fine. The problem is, if I were to rename this page which contains html to a .asp extension -- i get a 404 error. Is there something special I need to do in IIS to allow the asp extensions to be run successfully? Thanks for any insight, Danielle Tag: Windows NT Index Server Tag: 318744
  - 10
    - How does one update all records displayed in a asp page Hi, I got a test asp page which connects to Northwind.mdb database. This page pulls all the rows from the Customers table. One column i.e. GoodStatus has been added to the customers table. The following is the code to display all records of the customers table with some customization. CODE: <%@ Language=VBScript %>  <HTML> <BODY> <META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0"> <title>Testing Multiple Records Save</title> <SCRIPT LANGUAGE="VBScript"> sub btn_LogOut_OnClick() dim asnwer answer=msgbox("Are you sure you want to exit?.",vbYesNo,"Warning") if answer=vbyes then window.location.href = "http://localhost/beginaspdatabase1/" end if end sub sub btn_Save_OnClick() dim asnwer answer=msgbox("Are you sure you want to save your changes?",vbYesNo,"Warning") if answer=vbyes then window.location.href = "http://localhost/beginaspdatabase1/update_all_records.asp" end if end sub </SCRIPT> </HEAD> <% myDSN="Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=C:\Northwind97\Northwind.mdb" set CN=server.createobject("ADODB.Connection") CN.Open myDSN set sRS=server.createobject("ADODB.Recordset") sRS.ActiveConnection = CN SQL = "SELECT EmployeeID, LastName, FirstName, Title, GoodStatus from Employees" 'Response.Write SQL & "<br>" 'Response.End sRS.Open SQL %> <div ALIGN="CENTER"> <big><big><font COLOR="navy">Test Database Northwind</font></big></big> <H4> <font COLOR="red">Saving changes of all records at one time</font> </H4> </div> <div ALIGN="CENTER"> <% Response.Write "<table border='1' width='50%' height='1' cellspacing='1' >" Response.Write "<th>ID</th><th>Last Name</th><th>First Name</th><th>Title</th><th>Good Status</th>" %> <% do until sRS.eof ID = sRS("EmployeeID") LastName = sRS("LastName") FirstName = sRS("FirstName") Title = sRS("Title") l_GoodStatus = sRS("GoodStatus") %> <tr> <td align='center' width = '5%'> <font color="#000000"> <%Response.Write ID%></font> </td> <td align='center' width = '12%'> <font color="#000000"> <%Response.Write LastName%> <td align='center' width = '12%' > <font color="#000000"> <%Response.Write FirstName%> <td align='center' width = '10%'> <font color="#000000"> <input type="text" name="txt_Title" size="33" value ="<%Response.Write (Title)%>" style="font-family: Times New Roman; font-size: 10pt"></font> </td> <%'Response.Write Title%> </td> <td align='center' width = '8%'> <font color="#000000"> <input type="checkbox" name="chk_GoodStatus" value="ON" <%Response.write l_GoodStatus%><%if cbool(l_GoodStatus) then response.write " checked" else Response.write " unchecked"%>> </td> </tr> <% sRs.MoveNext loop sRS.Close Set sRS = Nothing %> </DIV> <input type="button" value="Log Out" name="btn_LogOut" > <input type="submit" value="Save" name="btn_Save"> </BODY> </HTML> Now I need to change some values in the title and goodstatus field and save all the changes in whatever records made. This update has to be in asp page update_all_records.asp as pointed in the code above. I have no idea how to handle all the rows as in the present case. Any help or suggestion is appreciated. Thanks. Tag: Windows NT Index Server Tag: 318743
  - 11
    - ASP/PerlScript and reading and writing files In ASP, using PerlScript, how do you read and write to files? Tag: Windows NT Index Server Tag: 318736
  - 12
    - RSS Reader Hello I'm just new for RSS Feed based on XML files so I'd like to know if somebody knows about a good ASP class to read and display these files Thanks Tag: Windows NT Index Server Tag: 318735
  - 13
    - Errors after upgrading SQL Server 2000 database compatibility level Hello, we are preparing for an upgrade to SQL 2005 and as a result of this I became aware that the compatibility level of one of our databases was set to level 65 (current SQL server is SQL 2000 SP4). Managing this server is something I have fallen into, so I am not sure of the exact reasons its compatibility level has stayed lower. When I upgrade the level however, some of our ASP pages throw the following error: ADODB.Recordset error '800a0bcd' Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. The recordsets for these asp pages are being saved in sessions, which I know can be problematic. Does anyone have any idea though why this error would be returned after upgrading the compatibility level? Thanks a ton for any help. Tag: Windows NT Index Server Tag: 318728
  - 14
    - Locale-dependent Date&Time input via HTML forms - Hi, In our legacy asp/web-application, we have date/time-input form in USA style (i.e. mm/dd/yyyy and 12hour-scale time with AM/PM). There is also some validation code on client side, and then submitted data are used in MSSQL queries. Now I would like to know about how to generate locale-dependent HTML form layout, and what ready-made ASP code could I borrow for this task. Thank you in advance for your replies. Tag: Windows NT Index Server Tag: 318725
  - 15
    - problem with write cookie when i try to write cookie on ASP page with the line like this <% Response.Cookie ("username")="test1" %> i get the message: object doesn't support this property ormethod: 'cookie' i use windows 2000 server any suggestion? thank you Tag: Windows NT Index Server Tag: 318724
  - 16
    - Use Active Directory Group in a dropdown form control Hi, I am a newbe in ASP prog, and I am a little "bothered" about a script that I need. I would like to list IN our Active directory all group that begin named and start with "GRP-" to put in a dopsown list for a form. Somebody can help me ? Maybe for the begging, the code to only list group in AD to display in a webpage can be nice. Thanks Tag: Windows NT Index Server Tag: 318721
  - 17
    - Military Time Problem If I have a datetime sql field with afternoon datetime values like below in DATETIME VALUE, how can I display the time part in ASP as 1:00 PM, instead of 13:00 PM as seen in CURRENT RESULTS below? Currently, I'm getting my CURRENT RESULTS by using the HOUR() function. Is there a way to display just the time part in "non-Military" time format? DATETIME VALUE: 2006-01-24 13:30:00.000 CURRENT RESULTS:: 13:30 PM DESIRED RESULTS: 1:30 PM Tag: Windows NT Index Server Tag: 318715
  - 18
    - How to do use checkbox in a response.write that pulls all data Hi, I have a asp page. This page pulls all data from a query. Part of the code is as follows: <% Response.Write "<table border='1' width='80%' height='1' cellspacing='1' >" Response.Write "<th>Key</th><th>SubgrantID</th><th>Title</th><th>Unlock</th><th>Unverify" %> <% do until sRS.eof Key = sRS("SubgrantIntId") Subgrant = sRS("ComboID") Title = sRS("Title") Unlock = sRS("IsChecked") Unverify = sRS("IsVerified") %> <tr> <td align="center"> <div style="cursor:hand"><p align="left" OnClick="location.href='mainreportagain1.asp?GrantID=<%Response.Write Key%>'"> <u><font color="#0000FF"> <%Response.Write Key%></font></u></div></td> <% 'this writes out the key%> </td> <td align='center'> <font color="#000000"> <%Response.Write Subgrant%> <td align='left'> <font color="#000000"> <%Response.Write Title%> </td> <td align='left'> <font color="#000000"> <%Response.Write Unlock%> </td> <td align='left'> <font color="#000000"> <%Response.Write Unverify%> </td> </tr> In the above code, in the statements response.write Unlock and response.write unverify I would like to bring checkboxes. The back end data for these two fields in the database are actually checkboxes. I would appreciate any help to handle the situation where the rows should show checkbox values for the two fields mentioned above. Thanks. Tag: Windows NT Index Server Tag: 318710
  - 19
    - Sending binary file (PDF) over SSL using ASP script Hello, Here's a quick explanation & problem: i have an ASP (iis v5.0) application that generates a pdf file and this file is saved to the server. it is saved in a location not available to web users. i have an asp script (below) that sends the pdf file to the user as a binary stream. So that the user specifies which file to upload, the script performs some security checking and if it passes, it sends the pdf document. This works great in HTTP, but i want to do this using SSL. When i try the same thing over SSL, it gives me a 'File Download' dialog box with Open, Save, Cancel, More Info. The file name is the name of my script and file type is 'Adobe Acrobat Control for ActiveX'. When i click Save or Open i get an error message: Internet Explorer cannot download [scriptname] IE was not able to open this Internet site. The requested site is either unavailable or cannot be found. Please try again later. The key to all this is that the report can change and i need to make sure the data doesn't get cached along the way. Hence there are a bunch of header manipulation commands included in the send function. Any help would be much appreciated. Rgds, yt PDFSend.asp >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> <% Function getBinaryFile( strFilePath ) Dim oStream Set oStream = Server.CreateObject( "ADODB.Stream" ) ' Create the object oStream.Open ' Open our file oStream.Type = 1 ' 1 = Binary oStream.LoadFromFile strFilePath ' Retreive binary data from the file getBinaryFile = oStream.read ' Return the binary data to the caller Set oStream = Nothing ' Destroy the ADO object End Function if blnSecurityPass Then ' SUCCESSFUL PASS - SHOW REPORT Response.Clear Response.Buffer = True Response.AddHeader "Pragma", "no-cache" Response.AddHeader "Expires", "Mon, 1 Jan 2000 05:00:00 GMT" Response.AddHeader "Last-Modified", Now & " GMT" Response.Expires = -1 Response.ContentType = "application/pdf" Response.BinaryWrite getBinaryFile( strFilename ) Response.End End if %> >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Tag: Windows NT Index Server Tag: 318705
  - 20
    - Publishing aspx page Something was wrong with my IIS 'Service unavailable', I decided to uninstall IIS and then reinstall it, then the simple pages can be viewed but the aspx pages not. Then I uninstall SQL server 2005 and Visual Studio 2005 and reinstall it. Now I can view simple pages but not aspx pages, but when running from the debugger of Visual Studio, it Works good. When I access an aspx page 'The page cannot be found' error occurs Thanks. Tag: Windows NT Index Server Tag: 318696
  - 21
    - Reading filename and insert Can someone help me with a quick script. I need to browse filenames in a directory and insert them into my sql table. I want to run this in an ASP page. I know how to connect to the database, etc. I just need the script on how to get the filenames. directory: C:\websites\photos tablename: photos fieldname: photoname *** Sent via Developersdex http://www.developersdex.com *** Tag: Windows NT Index Server Tag: 318686
  - 22
    - For each item in Request.Form I need to iterate through a submitted form, inserting data on each pass. In the past, I have always used form elements that were named with numbers at the end, like this, name1 relationship1 name2 relationship2 name3 relationship3 With the above formatting, I could write a For... Next loop to insert all the data into my database, For i = 1 to 3 If Request.Form("name" & i) <> "" Then sql = INSERT INTO Table (Name, Relationship) sql = sql & " VALUES" sql = sql & "('" Request.Form("name" & i) "'," sql = sql & "('" Request.Form("relationship" & i) "')" 'Execute SQL End If Next Now I am working on a new loop, but do not want to go back and change the way the submitting page works. I saw on while researching that I can use a For each item in Request.Form, but tried this and it throws off my SQL statement. It adds all of the request.form values to the sql statement, which then fails. How can I make this loop? Thanks, Drew Tag: Windows NT Index Server Tag: 318678
  - 23
    - SQL timeout during asp script Could use a little help. I have an asp script that insert information into a SQL 2003 db table. The script works for about the first 3000 entries and then give me a .... DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Obviously the server is there, since this is working for the first 3000 entries. I can then do a "where id> 3000" and run it again and it'll run about another 3000 then same error. What can I do to stop this error and have the entire process run? *** Sent via Developersdex http://www.developersdex.com *** Tag: Windows NT Index Server Tag: 318677
  - 24
    - Exporting to excel Hi There, I am trying to export a recordset to an excel file using the Content Type below in the header. Response.ContentType = "application/vnd.ms-excel" Which works fine however the problem is that when I have a number in a column with a leading zero the zero gets dropped. E.G. 01760942 will be displayed as 1760942 How can I rectify this? Thanks, Kevin. Tag: Windows NT Index Server Tag: 318671
  - 25
    - Question on ASP and worldpay callback HI all I wondered if anyone can give me some advice on wow to deal with the call-back process generated by Worldpay. My understanding is that after a transaction Worldpay will send the result's to a specified URL. All of the scripts I've looked at parse the query string and display the data onto a web-page, which obviously renders a page, as there is no one to read this and it does not go to the client I'm not sure what use these scripts are. I have a couple of general ASP questions if anyone has a solution How do you make a call to an asp page that updates a database but does not render a page? I'm probably being dumb but what does the url look like? I.E can I make a call direclty to a web-service to update my DB. I'm running dot.net framework 1.1, MCMS 2002 and using visual studion 202 Any thoughts are greatly appreciated Mikey Tag: Windows NT Index Server Tag: 318670

I have written a search logic for my website using microsoft indexing
service. I designed it on Windows XP. It works great.

Then i copied that to our Windows NT webserver and it is giving me the
following error

Microsoft VBScript runtime error '800a01ad'
ActiveX component can't create object
/search.asp, line 25

Line 25 is
Set QueryObj = Server.CreateObject("IXSSO.Query")

Please help.
Thanks.

Top