creating chat application

TheMSsForum.com: The Microsoft Software Forum

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

- Previous
  - 1
    - Problem with global.asa & Session_End Hello everybody. With the following code: ======= Sub Session_OnEnd Application.Lock Application("online") = Application("online") - 1 Application.UnLock ' set the flag active = 0 Set dbConn = Server.CreateObject("adoDB.connection") dbConnstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("\mydb.mdb") dbConn.Open dbConnstr SQLstr = "UPDATE tbl_sessionid SET active='0' WHERE sessionid ='" & Session("sID") & "'" dbConn.Execute(SQLstr) dbConn.Close End Sub ======= the first 3 lines are executed when I force the session.abandon but the others, that set the active flag in an Access DB to 0 aren't. the same code works fine if I use it in a separate page. What's wrong with my global.asa? Thanks in advance PGei Tag: creating chat application Tag: 285685
  - 2
    - Using variable name in Href Hi Guys How can i use the variable name instead of a hardcoded value when writing a hyperlink. strBody = strBody & "<a href="default.htnk">Login</a>" I would like to use a variable name instead of directly writing default.html like below strPageName = "default.html" strBody = strBody & "<a href="<%=strPageName%>">Login</a>" Anyone know how this can be done thanks Jas Tag: creating chat application Tag: 285683
  - 3
    - javascript window reszing problem Hi I am displaying a page inside an Iframe, and I would like to enlarge the iframe window to the size of the browser when the browser window loads up. In the onload event of the browser I am calling javascript to do this and it works ok for ie.6.0 but not 5.5. Here's the script function resizeIFrame() { var oBody = PrintedLeaflet.document.body; var oFrame = document.getElementById("PrintedLeaflet"); oFrame.height = oBody.scrollHeight + (oBody.offsetHeight - oBody.clientHeight); oFrame.width = oBody.scrollWidth + (oBody.offsetWidth - oBody.clientWidth); oFrame.style.height = oBody.scrollHeight + (oBody.offsetHeight - oBody.clientHeight); oFrame.style.width = oBody.scrollWidth + (oBody.offsetWidth - oBody.clientWidth); } Does anyone know why this script would not work in 5.5??? Thanks Kuv Tag: creating chat application Tag: 285681
  - 4
    - How to Read Text file in ASP Hi, I'm write an asp to include part of a text file into my asp output html, I use FileSystemObject to get the content of the text file, but the asp just hang when it runs, the source code is listed below if anyone could help: -------------------- <%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%> <% if (String(Request.QueryString("page")) == "undefined" || String(Request.QueryString("page")) == "") { Response.Write("Please specify the page data."); Response.End() } var sFile = Server.MapPath(String(Request.QueryString("page"))); var fso = new ActiveXObject("Scripting.FileSystemObject"); if (!fso.FileExists(sFile)) { Response.Write("No Such File : " + String(Request.QueryString("page"))); //Response.Redirect("."); Response.End(); } var f = fso.OpenTextFile(sFile, 1); //1 -- ForReading var sFileTxt = f.ReadAll(); f.Close(); %> <!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"> </head> <body> <%= sFileTxt %> </body> </html> -------------------- Tag: creating chat application Tag: 285678
  - 5
    - Basic Authentication no prompt login box I have a problem with basic authentication. I redirect a user from a page to another. I don't want to get the NT prompt login, I want the user to be logged in automatically. I want to send the username/password to the page. I have read something about cookies and sending username/password through the header. With the new Windows Update 832894 it is no longer possible to use http(s)://username:password@server/resource.ext Is there any other way to redirect to another page and pass the username and password /Magnus Tag: creating chat application Tag: 285677
  - 6
    - ASP / IIS Recordset not updatable Hello, When I try to run the following code I get an error: "Recordset not updatable". It is possible to show data from the same table on a webpage, so the database name and the table nam must be correct. I 've tried several other things, also leaving out the adOpenDynamic, adlockOptimistic. If I run this code as VBA in an Access database, it works without problems. <% const DB_NAME = "C:\ASP\eOrganizer.mdb" Call Main sub Main dim cndb dim rs set cnDB = Server.createobject("ADODB.Connection") set rs = Server.CreateObject("ADODB.Recordset") cnDB.Connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DB_NAME cnDB.Open rs.Open "tblNotes", cnDB , adOpenDynamic, adlockOptimistic rs("notName") = "Meeting 1-2-2004" rs.update end sub %> -- Martin van Vliet, Amsterdam tel. 020 625 62 08 Tag: creating chat application Tag: 285676
  - 7
    - Close pop window and refresh the parent window Hi Guys Wonder if someone can help me with this. I have a form where a user clicks a button which gives them a pop up windows to allow them to add the data. The user adds the data and click save. The pop window closes and refreshs the parent window to allow the entered data to be displayed. It was all working okay until couple of days back when it stopped. Can someone offer any help. I have posted the relevant code here. Please let me know if you need to see all code. Thanks Jas <body bgcolor="#FFFFFF" text="#000000" onLoad = "checkClose('<%=bCloseWindow%>')"> function checkClose(flagClose){ if(flagClose==1) { window.opener.document.thisForm.action = "createExpense.asp" window.opener.document.thisForm.htbAction.value = "edit" window.opener.document.thisForm.htbMode.value = "edit" window.opener.document.thisForm.submit() self.close() } Sub AddExpense() Dim Rs GetPostData() sql = "Insert into expenseDetails (ExpenseId, ExpenseDate, Type," sql = sql & "Amount, City, Notes, Receipt, Billable, Bartered, BarteredDetails" sql = sql & ") values (" sql = sql & "'" & strExpenseId & "'," sql = sql & "'" & strDate & "'," sql = sql & "'" & strType & "'," sql = sql & "'" & strAmount & "'," sql = sql & "'" & strCity & "'," sql = sql & "'" & strNotes & "'," sql = sql & "'" & strReceipt & "'," sql = sql & "'" & strBillable & "'," sql = sql & "'" & strBarter & "'," sql = sql & "'" & strBarterDetails & "x'" sql = sql & ")" Response.write sql conn.execute sql 'Get the new detail id sql = "Select Max(expenseDetailId) as ExpenseDetailId from expenseDetails where expenseId = " & strExpenseId set Rs = server.createobject("ADODB.recordset") Rs.open Sql,conn,1,3 If not Rs.Eof Then strDetailId = Rs("ExpenseDetailId") If strBillable = "1" Then AddBillableExpense() End If bCloseWindow = "1" End Sub Tag: creating chat application Tag: 285673
  - 8
    - Newbie needs help with Query String Newbie here, having fun querying database thru web pages but I have a problem: I have a query string returned containing the names of some checkboxes: Checkbox=CompanyName, ContactName Then I execute the query string on this database: Set objRS=adodbConn.Execute(strQuery) How can I break this query string into 2 seperate strings so I can get the records using this?: Response.Write objRS( the two strings) Note: there could be more than 2 checkboxes returned in the query string. Thanks in advance for any help. Tag: creating chat application Tag: 285662
  - 9
    - How come my web server returns the clients ip as my isa proxy servers ip? how come when my web server asp page returns the users ip address it returns my local isa proxy servers ip address instead? for example: <HTML> <%Request.ServerVariables("REMOTE_ADDR")%> </HTML> i have multiple web servers behind my isa server. that route the user by the sub domain i.e. http://subdomain.mydomain.com http://myother.mydomain.com i only have 1 external static ip address to use. i use isa's web publishing rules for this. how can i get the web users ip address in my page? -- 5khzgjf9e001@sneakemail.com Tag: creating chat application Tag: 285661
  - 10
    - Interrogating string for number of characters, response.writing identical number of characters on new line Suppose I have strString. I want to determine the length of strString in # of characters, and write that number of characters on a subsequent line as a dummy character, say a hypen. In other words, I want to be able to dynamically create the following presentation in ASCII: Title title title title title title ------------------------- Note that the number of hyphens equals the number of characters in "Title title title title ...", which would be stuffed in strString. Any help out there? BTW, thanks to all the smarties in the group who have helped me out over the past few years. The community has helped make my career. -KF Tag: creating chat application Tag: 285657
  - 11
    - General Q about SOAP I'm looking for a 30,000 foot view on this quesition. I want my SQL Server box/IIS server to be able to demand information at will from a remote server running UNIX. I need the information to be restricted from the general public (available only by authentication, for instance) and made secure during transit (e.g. encrypted stream). I've installed a Thawte cert on my machine. Is SOAP an appropriate technology to deploy in this case given my security needs? Is there a better choice of tech that still allows interoperability/flexibility with varying data stores on the other end? Does SOAP allow authentication against certificates and/or MAC numbers, or does it generally autheticate using other means (e.g. passwords.?) What's the best practice? The stuff in question isn't exactly banking info, but it would be a Bad Thing if the information stream were captured. Thanks for any insights. -KF Tag: creating chat application Tag: 285656
  - 12
    - Very Weird , plz help K i got this prob : Im building an app that will read from a foxpro dbf , find out if the table is empty and if it is it will be overwritten with a blank one (using filesystemobject) My prob is this, On my local pc all goes well , when i upload it to the server i get a file does not exist error , both the server and my pc have exactly the same folder tree and the same files ( ive checked it over 100 times now ) but the error still persists. I have a folder called DirEscrita in wich i have put the dbf file to scan for data , and i get this error when trying to do a simple select on it: Microsoft OLE DB Provider for ODBC Drivers error '80040e37' [Microsoft][ODBC Visual FoxPro Driver]File 'trf.dbf' does not exist. /exporta.asp, line 12 I know that it cant be a prob with the code , cause it works fine locally ( im on a XP PRO IIS 5.1) , could it be the server? ( IIS 5.0 ) Tag: creating chat application Tag: 285654
  - 13
    - TURN $12 INTO $12,000 NOW!!! PEEP THIS SHIT YALL MY FRIEND GOT $500 LAST WEEK TRYING THIS SHIT: make extra cash GREAT WAY TO BECOME RICH...INSTANT THOUSANDS This is no scam, read it!!!!!! ------------------------------------------------------------------------ -------- HOW TO TURN $12 INTO $12,000!!!!!!!!!!!!!!!!!!!!!!!!!!!! THIS REALLY CAN MAKE YOU EASY MONEY!! IT WORKS !!! BUT YOU HAVE TO FOLLOW IT TO THE LETTER FOR IT TO WORK!!!! : A little while back, I was browsing through newsgroup, just like you are now and came across an article similar to this that said you could make thousands dollars within weeks with only an initial investment of $12.00! So I thought, "Yeah, right, this must be a scam", but like most of us, I was curious, so I kept reading. : Anyway, it said that you send $2.00 to each of the 6 names and address stated in the article. You then place your own name and address in the bottom of the list at #6, and post the article in at least 200 newsgroup. (There are thousands) No catch, that was it. So after thinking it over, and talking to few people first, I thought about trying it. I figured what have I got to lose except 6 stamps and $12.00, right? Like most of us I was a little skeptical and a little worried about the legal aspects of it : All, So I checked it out with the U.S. Post Office (1-800-725-2161) and they confirmed that it is indeed legal! Then I invested the measly $12.00. Well GUESS WHAT!!?. Within 7 days, I started getting money in the mail! I was shocked! I figured it would end soon, but the money just kept coming in. In my first week, I made about $25.00. By the end second week I had made a total over $1,000.00! In the third week I had over $10,000.00 and it's still growing. This is now my fourth week and I have made a total of just over $42,000.00 and it's still coming in rapidly. Its : Certainly worth $12.00, and 6 stamps, I have spent more than that on the lottery!! : Let me tell you how this works and most importantly, why it works?.also, make sure you print a copy of this article NOW, so you can get the information off of it as you need it. STEP 1: Get 6 separate pieces of paper and write the following on each piece of paper "PLEASE PUT ME ON YOUR MAILING LIST." Now get 2 US $1.00 bills and place TWO inside EACH of the 6 pieces of paper so the bills will not be seen through the envelope to prevent thievery. Next, place one paper in each stating the above phrase, your name and address, and 2 $1.00 bills. What you are doing is creating a service by this. THIS IS ABSOLUTELY LEGAL! Mail the 6 envelopes to the following addresses: #1) Corteney Tomson P.O. Box 55 Dupo, IL 62239 #2) Brad Taylor 6 Terry Ln. Hutchinson, KS 67501 #3) Cedric Etienne 239 Autumn Breeze Way Winter Park, FL 32792 #4) Stephen Mitchell 1977 Alcovy Trace Way Lawrenceville, GA 30045 #5) Melissa Martinez 15440 sw 74 cir ct #607 Miami, FL 33193 #6) Maurice Sawyers 49 Middle Rose St Trenton, NJ 08618 STEP 2: Now take the #1 name off the list that you see above, move the other names up (6 becomes 5, 5 becomes 4, etc?.) and add YOUR Name as number 6 on the list. STEP 3: Change anything you need to, but try to keep this article as close to original as possible. Now, post your amended article to at least 200 newsgroups, message board. (I think there are close to 24,000 groups) All you need is 200, but remember, the more you post, the more money you make!---- DIRECTIONS----HOW TO POST TO NEWSGROUPS, MESSAGE BOARD----------Step 1) You do not need to re-type this entire letter to do your own posting. Simply put your cursor at the beginning of this letter and drag your : Cursor to the bottom of this document, and select 'copy' from the edit menu. This will copy the entire letter into the computer memory. Step 2) Open a blank 'notepad' file and place your cursor at the top of the blank page. From the 'edit' menu select 'paste'. This will paste a copy of the letter into notepad so that you can add your name to the list. Step 3) save your new notepad file as a .txt file. If you want to do your postings in different sittings, you'll always have this file to go back to. : Step 4) Use Netscape or Internet explorer and try searching for various newsgroups (on-line forums, message boards, chat sites, discussions.) Just example you log on any search engine like yahoo. com,google. com,altavista. com,excite. com then you search with this subject ? millionaire message board? or ?money making message board? or ? employment message board? or ?money making discussions? or ?money making forum? or ?business message board? etc. You will find thousand & thousand message board. Click one by one then you will find the option post a new message. : Step 5) Visit these message boards and post this article as a new message by highlighting the text of this letter and selecting paste from the edit menu. Fill in the Subject, this will be the header that everyone sees as they scroll through the list of postings in a particular group, click the post message button. You're done with your first one!. : Congratulations? THAT'S IT! All you have to do is jump to different newsgroups and post away, after you get the hang of it, and it will take about 30 seconds for each newsgroup! ** REMEMBER, THE MORE NEWSGROUPS OR MESSAGE BOARD YOU POST IN, THE MORE MONEY YOU EILL MAKE!! BUT YOU HAVE TO POST A MINIMUM OF 200** That's it! You will begin receiving money from around the world within days! You may eventually can rent a P.O. Box due to the large amount of mail you will receive. If you wish to stay anonymous, you can invent a name to use, as long as the postman will deliver it. **JUST MAKE SURE ALL THE ADDRESSES ARE CORRECT. ** : Now the WHY part: Out of 200 postings, say I receive only 5 replies (a very low example). So then I Made $5.00 with my name at #6 on the letter. Now, each of the 5 persons who just sent me $1.00 make the MINIMUM 200 postings, each with my name at #5 and only 5 persons respond to each of the original 5, that is another $25.00 for me, now those 25 each make 200 MINIMUM posts with my name at #4 and only 5 replies each, I will bring in an additional :$125.00! Now, those 125 persons turn around and post the MINIMUM 200 with my name at #3 and only receive 5 replies each, I will make an additional $625.00! OK, now here is the fun part, each of those 625 persons post a MINIMUM 200 letters with my name at #2 and they only receive 5 replies, that just made me $3,125.00!!! Those 3,125 persons will all deliver this message to 200 newsgroups with my name at #1 and if still 5 persons per 200 newsgroups react I will receive $15,625.00! With an original investment of only $12.00! AMAZING! When your name is no longer on the list, you just take latest posting in the newsgroups, and send out another $12.00 to names on the list, putting your name at number 6 again. And start posting again. The thing to remember is, do you realize that thousands of people all over the world are joining the internet and reading these articles everyday, JUST LIKE YOU are now!! So can you afford $12.. and see if it really works?? I think so? People have said, 'what if the plan is played out and no one sends you: the money? So what are the chances of that happening when there are tons of new honest users and new honest people who are joining the internet and newsgroups everyday and are willing to give it a try? Estimates are at 20,000 to 50,000 new users, every day, with thousands of those joining the actual Internet. AND YES YOU HAVE TO SEND THE MONEY FOR THIS TO WORK!!!dont try not to,IT WONT WORK TRUST ME Tag: creating chat application Tag: 285652
  - 14
    - creating manual line breaks in a single string I want a script that will force a manual line break after 'N' characters. In other words, it will take a string, say, strString, and insert manual line breaks every 78 characters. Anyone have some snippets I can poach? My e-mailer component will do this for me, but I'd like to know how to do it "by hand" if necessary. Thanks, -KF Tag: creating chat application Tag: 285649
  - 15
    - [SQL] Selecting item from table, whether or not it has corresponding entry in 2nd table... Hiya! I have a question: I have 2 tables... "Inventory" and "Price" These tables are used by 2 restaurants... the inventory has what they sell, and prices has the corresponding prices to those items for each location. What I want to do: I want to get a list of all items in the "Inventory" table and the corresponding price from the "Price" table for a location, unless the column "SHOW" (in the "Price" table) is set to "N" It might sound like "Just use a LEFT JOIN"... but if there is no entry for the item in the "Price" table, I still want a result I tried using: =============== select i.name, p.price1 from inventory i LEFT JOIN prices p ON p.itemID=i.itemID where ( (i.itemType=7) AND (i.canusa='usa') AND (p.storeID=99) AND (p.show='y') ) =============== But that only returns the items that have prices set up in the prices table... So I tried adding =============== OR (NOT EXISTS (SELECT * FROM prices where (p.itemID=i.itemID) AND (i.itemType=7)) ) =============== to the end of the WHERE conditions, but this returns everything in the inventory table I then tried changing the whole statement to: =============== select i.name, p.price1 from inventory i LEFT JOIN prices p ON p.itemID=i.itemID where ( (i.itemType=7) AND (i.canusa='usa') AND (p.storeID=99) AND (p.show='y') ) OR (i.itemType=7) AND (i.canusa='usa') AND (NOT EXISTS (SELECT * FROM prices where (p.itemID=i.itemID) AND (i.itemType=7))) =============== Now that does work... BUT, I am repeating some of the conditions of the WHERE statement: (i.itemType=7) AND (i.canusa='usa') And I am wondering if this is the most efficient way of doing it, or if its just some bandaid approach that works and the true logic has escaped me? (and is the "not exists" condition going to give some extra load the server or not) Any help is appreciated Thanks, Clint Tag: creating chat application Tag: 285644
  - 16
    - Option selected Hi All, I am displaying few values in a List box. I would like to put first item as selected by default. i.e <option value="some value" selected>Name</option> Here is my code. <SELECT size=15 id=select1 name=select1> <% do while not Rs.EOF %> <Option value=<%=Rs("value")%>><%= Rs("Name") %></Option> <% Rs.MoveNext loop %> </SELECT> Can anybody please help me. Thanks in Advance. Ram Tag: creating chat application Tag: 285637
  - 17
    - ADO fails FSO works on a share IIS 5.0 is running on a Win2K Server called serverA as a domain user. The domain user has administrator rights on the server. The database is on serverB(Win2K server). The IIS domain user also has full rights to the share. The database is an Access97 database that is part of another application. I made a copy of the database and did a compact and repair on the copy. It opens fine with Access 97 and has no security restrictions. The short of it is I can write to and read from the directory using: Set ScriptObject = Server.CreateObject("Scripting.FileSystemObject") Set MyFile = ScriptObject.OpenTextFile("\\serverB\care\vcare4x\database\fc01\testfile.txt", 8,true) So the base permissions should be OK. I get the dreaded 80004005 Microsoft Jet database engine cannot open the file '(unknown)'. when I try this code: MdbFilePath = "\\serverB\CARE\VCARE4X\DATABASE\FC01\vc40clin_IIS.mdb" Conn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & MdbFilePath & ";" When I put a copy of the database on the IIS server (not a permanent option) the page works fine. Why does the FSO work but not the ADO? Tag: creating chat application Tag: 285631
  - 18
    - minus one date from another Is there a way if someone enters a date, like 02/02/04, and have that date subtract from 02/04/04; so the number 2 is returned, and if you wanted to see if 02/05/04 is greater than 02/04/04 returns true? Tag: creating chat application Tag: 285600
  - 19
    - SSL Hello I want to know how to send data through forms HTML with SSL and ASP. Which is the difference betweeen the use of ASP with and without SSL? Is it only the https and not the http or implies another changes? Thank you very much. Tag: creating chat application Tag: 285586
  - 20
    - [OT] Server 2003 + Access I know this is OT but, I don't have the energy to subscribe to the Server 2003 NG's just to ask a simple Q. I've noticed that Server 2003 (IIS6) doesn't seem to support database's..... anyone know anything about this? -- Regards Steven Burn Ur I.T. Mate Group www.it-mate.co.uk Keeping it FREE! Disclaimer: I know I'm probably wrong, I just like taking part ;o) Tag: creating chat application Tag: 285579
  - 21
    - IISCart / shopping cart opinions Need a shopping cart for small site with only a few products that don't change very often. Looking for something under $1000 that can be seamlessly integrated into a custom design. Preferably ASP-based, but not necessarily. Off-the-shelf package ok too... Has anyone used IISCart ? Please post your opinions as it seems like a viable solution so far... I've browsed thru the Aspfaq list, but would welcome personal recommendations based on experience. Thanks much, Mike Tag: creating chat application Tag: 285568
  - 22
    - Global asa refresh I have an application that loads an array in the global ASA file. Sometimes that array gets lost for no real reason, resulting in a ubound error. MS has a solution which involves removing virus-scanning and backup procedures...which is not an option. My question is simple...is there ANY way to force the Global.ASA to relaod that array? Currently I have to go in and edit the global.asa, add a few spaces and then backspace and save and it causes a reload. I could easily check if the variable exists, but if it does not I do not know where to go. thanks *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: creating chat application Tag: 285564
  - 23
    - Hit Counter How to make a simple Hit Counter ? I am old VB Programmer, trying to learn ASP... alfa_beveren@hotmail.com Tag: creating chat application Tag: 285560
  - 24
    - INclusione randomizzata in ASP Salve volevo sottoporvi un problema ho un index in http://www.palermoclub.com che utilizza diverse inclusioni testa.asp per la testata centro.asp per il centropagina sotto.asp per il piè dipagina per dare un pò di vivacità al mio sito volevo creare una visualizzazione random dell'inclusione centro.asp Ho realizzato diversi centro: centro.asp, centro1.asp, centro2.asp ecc.ecc. Come fare per randomizzare l'inclusione centro.asp Esiste la possibilità? Vi sarei molto grato Saluti Tag: creating chat application Tag: 285557
  - 25
    - How to get the second table from sp_help result? I am using SQL Server 2000 and I want to be able to list out all the field names and their datatypes from a particular table. I found out that sp_help does that but unfortunately when using a recordset, I could only get the first of the 3 tables. Is there anyway to get the second table using a recordset because that is the one with all the info about the fields and their datatypes? Or is there another way of finding out the datatypes of the fields? Tag: creating chat application Tag: 285553
- Next
  - 1
    - Re: ASP keeps restarting (Windows 2000 Server) Maybe this isn't the right place for this, but I've done a lot of looking on this so if someone could direct me to the right place I'd appreciate it. I run a Windows 2000 Server server and one of my sites is quite database intensive and uses a mixture of PHP and ASP scripts to access an Access database using a system DSN. Lately I've been having problems with ASP. Occasionally I or a user receive the "RPC server is unavailable" error message on a web site. I've set the application protection to "High" and been able to locate which site is responsible for these errors, however it turns out to be my site and I have no idea what to do next since I have dozens of ASP scripts written over the course of several years and any one of them could be causing this. Here are the messages that I've been seeing in the System Log and Application Log. During heavy traffic periods I'm seeing the ASP entry every few minutes sometimes, and during low traffic it goes fine for hours. Can anyone point me in the right direction? I'm really stuck and I'm all out of ideas other than converting all my ASP to PHP since those scripts are running fine. System Log: Event Type: Warning Event Source: W3SVC Event Category: None Event ID: 37 Date: 2/2/2004 Time: 10:54:57 PM User: N/A Computer: VIMM Description: Out of process application '/LM/W3SVC/1/Root' terminated unexpectedly. For additional information specific to this message please visit the Microsoft Online Support site located at: http://www.microsoft.com/contentredirect.asp. Application log: Event Type: Information Event Source: Active Server Pages Event Category: None Event ID: 3 Date: 2/2/2004 Time: 10:55:01 PM User: N/A Computer: VIMM Description: Service started. -- Vimm ------------------------------------------------------------------------ posted via www.WebFrustration.com ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Tag: creating chat application Tag: 285550
  - 2
    - Generating Page Breaks in Word from ASP Hi - apologies in advance if this is not the correct forum - tried searching loads, and still to find a workable solution. Generating a word document from ASP - no problem. Inserting page breaks into the generated page, so that when loaded into Word it forces a page break, I cannot manage: No matter if I use: <p STYLE="page-break-after: always"></p> or <%=chr(10)%><%=chr(13)%> ..when opened in Word it will not start content on a new page. Any ideas? Thank you, <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <% Response.Buffer = TRUE Response.ContentType = "application/msword" response.AddHeader "content-disposition", "inline; filename=xxx.doc" %> <% 'code to get a recordset here %> <html> <head> <title></title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body style="font:verdana"> <p> </p> ' first generate table of contents <% for i = 0 to numrows %> <%=rsSolArr(0,i)%>: <a href="#<%=rsSolArr(0,i)%>"><%=rsSolArr(1,i)%></a> <br> <% next %> 'now generate actual content <% for i = 0 to numrows %> <p STYLE="page-break-after: always"></p> <a name="<%=rsSolArr(0,i)%>"></a><%=rsSolArr(0,i)%>: <%=rsSolArr(1,i)%><br> <%=rsSolArr(2,i)%><br><br><%=chr(10)%><%=chr(13)%> </div> <% next %> </body> </html> *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: creating chat application Tag: 285548
  - 3
    - Including an include file from another site Hi All Could you please confirm whether it is possible to include an include file, which is on another site, but still on the same set of web servers. I want to upload a default paeg to a number of web sites for certain domains, but I would like the majority of the code for this page to be on 1 central site so that if I need to do an update of this page I only need to update it on one site. The code I am using is as follows, but I keep getting a HTTP 500 error: default.asp page on each site contains  shell.asp page on main site contains: <HTML> <BODY> hello </BODY> </HTML> Any ideas? Thanks Robbie Tag: creating chat application Tag: 285547
  - 4
    - Call to guid property of Scriptlet.TypeLib times out Hi; I use following code in an ASP page to generate a GUID: <% dim obj Set obj = Server.CreateObject("Scriptlet.TypeLib") Response.Write(obj.guid) Set obj = nothing %> It worked fine on my WIN2000 computer running IIS. I recently bought a new computer with XP Pro and this page times out. I now it is the call to obj.guid. I have seen the same behaviour on another XP machine as well. The funny thing is if I paste this code into VB and display the guid in a message box, it runs without a problem. Any ideas, is this not supported in XP? Thanks Thomas (tborn_news@hotmail.com) Tag: creating chat application Tag: 285544
  - 5
    - Global.asa and Session_OnEnd Dear All; I wrote this code in the global.asa but it dosen't work inspite that it works in any asp file and also in the global.asa file but only in the session_onstart part.This code is to delete a txt file at the end of the session.The file was created during the user's session and has the name of the session id. The session variable "session("mpath")" is the varible which will hold the path of the created file. This is my first question also I want to know how to set the session.timeout and where to place it in the code? <SCRIPT LANGUAGE=VBScript RUNAT=Server> sub session_onstart session("id")=0 session("mpath")="" end sub sub session_onend set fsoglob=server.createobject("scripting.filesystemobject") cpath=session("mpath") set Cfolder=fsoglob.getfolder(cpath) for each file in Cfolder.files if instr(1,file.name,session.sessionid&".txt",1) then fsoglob.deletefile(file) end if next fsoglob.close set fsoglob=nothing end sub </script> Thank You Tag: creating chat application Tag: 285543
  - 6
    - page / product clicks ? Hi I have list of products listed from a search criteria, Now I wanna show the client TOP VIEWED LIST OF PRODUCTS or number of hits for each product. So the page hits using the counter component will give me the hits for the entire which has all the products. Perhaps I could catch it in the product DETAIL page, how do I list the number of hits for each product. Secondly I have IIS 4.0 make sure you recomend the right component. Thanks much! Tag: creating chat application Tag: 285538
  - 7
    - Newbie has database question This ASP is REALLY COOL!, But I have an ADO question: How do I get a list of all the tables in a database? I found the Northwind database on my computer, now I'ld like to get a list of the tables in it onto a web page. I'ld like to populate a list box with the tables, and when one is selected and submitted, a list of fields in that table would come back. Sorry if this is the wrong NG, maybe there's an ADO group? Tag: creating chat application Tag: 285536
  - 8
    - IIS6 running asp scripts I am trying to use IIS 6 to run an asp script that connects to another server to run the task. I have tried using the identities tab to specify the user to use but the script always connects as anonymous to the remote system. Am I missing something simple here or was IIS 6 not designed to perform this type of task? Tag: creating chat application Tag: 285527
  - 9
    - communications between sessions? Does ASP allow communications between sessions? Usually Response sends the response to the destination from which the Request came. Is it possible to send the Response to some other client who is connected to the same page at this moment? Tag: creating chat application Tag: 285523
  - 10
    - passing a string to a function by mouse-click on it? I have a section of a website which is heavily loaded with technical terminoogy. I have a Glossary database running from ASP code which accepts a string and returnd it's meaning (is there is meaning). Now I want a cusotmer, instead of copying a word into a field, just click a word. I do not make all the words hyperlink. Is there any smart way to acheive this? I realise that this is a clent-side question, but perhaps someone can direct me into correct direction? Tag: creating chat application Tag: 285520
  - 11
    - HTTP and HTTPS Hi, I have a site that requires a checkout process. THe checkout process occurs in the secure server. I need to pass session variables from one server to the next. Any ideas how to do this thanks Tag: creating chat application Tag: 285519
  - 12
    - Question RE: set nocount on I was having the same old bug "Operation is not allowed when the object is closed." I know about set nocount on. But here's my question. This bug was happening with the following code: alter procedure spShowPrioritizedViruses ( @NVirusID int ) as set nocount on if (select count(*) from Viruses where Virus_ID = @NVirusID and Virus_ID in (select top 20 Virus_ID from Viruses order by IsNull(priority, 1000000))) > 0 begin select top 20 Virus_ID, CaroName + Isnull(' (' +cast(Priority as varchar(10)) + ') ', '') as CaroName from viruses order by isNull(priority, 1000000) end else begin select top 19 Virus_ID, CaroName + Isnull(' (' + cast(Priority as varchar(10)) + ') ', '') as CaroName, priority into #tmp from viruses order by isNull(priority, 1000000) select * into #tmp2 from (select Virus_ID, CaroName + IsNull(' (' + cast(Priority as varchar(10)) + ') ', '') as CaroName, Priority from Viruses where Virus_ID = @NVirusID union select * from #tmp) Top20 select Virus_ID, CaroName from #tmp2 order by IsNull(priority, 1000000) end drop table #tmp drop table #tmp2 =========== My question is, when I run the stored proc, it doesn't return "1 row updated", it returns the actual recordset selected at the end. What does nocount have to do with anything? If we said that selecting INTO caused some sort of counting, the last SQL statement is not an INTO statement, it's straight select, so why would there be counting going on? Is there really rhyme and reason to the way microsoft stuff works, or are we just hitting the side of the TV until the right parts connect? Please post answer here. Tag: creating chat application Tag: 285513
  - 13
    - Index Server & Site Server + PDFs I fire the following code on Index Server (different obj) and it returns a PDFs no problem, but when I change the object to use the MSSearch for Site Server I don't get any PDFs. Anything in the code that would cause this? I can see the PDFs getting crawled in Site Server, but when I try and search I don't get any pdfs. :< <% Set objQuery = Server.CreateObject ("MSSearch.Query") objQuery.Catalog = "test" objQuery.Query = "jerkstore.pdf" objQuery.Columns = "Title, DocAddress, Description, Rank" objQuery.SortBy = "Rank[d], Title" objQuery.MaxRecords = 100 Set objRS = objQuery.CreateRecordset ("sequential") Response.Write objRS.Properties ("RowCount") & " documents match the query<BR><BR>" Response.Write "<TABLE BORDER=1>" For I = 0 To objRS.Fields.Count - 1 Response.Write "<TH><STRONG>" & objRS (I).Name & "</STRONG></TH>" Next Do While Not objRS.EOF Response.Write "<TR>" For I = 0 To objRS.Fields.Count - 1 Response.Write "<TD>" & objRS (I) & "</TD>" Next Response.Write "</TR>" objRS.MoveNext Loop Response.Write "</TABLE>" objRS.Close Set objRS = Nothing Set objQuery = Nothing %> Tag: creating chat application Tag: 285508
  - 14
    - SQL or XML? I've been using ASP with SQL Server for some time now, and while I've occasionally looked into XML, its benefits have never seemed apparent enough to me for me to dig any deeper and make any use of it. Well, I'm using a utility now that exports my QuickBooks data into either an Access DB or a group of XML docs. I've been using the Access option and then importing that data into my SQL database so I can build a client section displaying invoices and estimates online. I'm not entirely satisfied with the Access option, as it requires that I delete all my SQL tables before I import an update of data (or I end up with doubled records of older data). It would be a great solution to simply upload the new XML docs to update the online data. But. Does XML work comparably to SQL, to allow me to manipulate the data, create recordsets from it, etc., or is it really a whole different thing made for a whole different purpose and I should stick to what I'm familiar with, even though it takes an extra step or two? Tag: creating chat application Tag: 285495
  - 15
    - Empty Recordset??? I'm calling a SQL stored procedure with the folowing code. It seems to work fine but I want to know if it doesn't return any rows and the oRsCatList.eof is not working. lcDisplayCatList = "Y" Set oConn = Server.CreateObject("ADODB.Connection") oConn.Open Session("strConn") Set oCmd = Server.CreateObject("ADODB.Command") set oCmd.ActiveConnection = oConn oCmd.CommandText = "spCategoryList" oCmd.commandtype = AdCmdStoredProc oCmd.Parameters.Append oCmd.CreateParameter("@CatID", adInteger, adParamInput) oCmd.Parameters("@CatID") = lnCatID set oRsCatList = oCmd.Execute if oRsCatList.EOF then lcDisplayCatList = "N" end if Even when it doesn't return any rows, lcDisplayCatList is still = "Y" Can anyone help point me in the right direction? TIA -Bruce Tag: creating chat application Tag: 285494
  - 16
    - Including .htm files conditionally? Hi I'm considering using .asp to implement a selective inclusion of .htm files containing tables into a HTML code sent to browser from IIS. My question is if it is possible to make an .asp page that depending on two variables passed in the query (start-month and end-month) return to the browser a page that includes only files with names within the specified months? Lets take it ones more: ;) 1. the .htm files are ready for use and named month01.htm (january) etc. 2. the user enters wanted months on a form in the browser 3. the .asp constructs HTML code that starts with some static html code, inserts the table for the first month, then some other text such as "February", then the next month etc stopping with the month defined on the input form. Is this type of thing possible with .asp using some scripting language? Or do i need my own IIS Extension for this too? Also, is it possible to let a server side script analyze a file to extract information from the table to calculate the sum of the values in all the tables in each column? Could the filtering and calculations be done "easily" with client scripting? Rgds, Sten Tag: creating chat application Tag: 285490
  - 17
    - ENABLE/DISABLE POPUP - VBSCRIPT Hi, I create a popup web page using: newWin = window.open(.....) In the popup window I have href links. The popup takes a while to load and I donâ??t want the users to be able to click on a link until the popup information has finished loading Does anyone know what Visual Basic Script commands I can use to disable then enable the display in the popup window while the text and hyperlinks are loading (preferable I would still be able to see the text in the popup while its disabled, but if not thatâ??s ok!) Thanks very much for any help! Cheers Barbara Tag: creating chat application Tag: 285485
  - 18
    - Formatting date I'm currently entering the date into my date field using the now() function, which delivers this result: 2/2/2004 9:08:09 AM which is fine for some cases. However, when retreiving this result, sometimes I'd just like to pull up the first part, such as the 2/2/2004 and cut out the rest. How do I take this date output, and format it to show only what I want? I'm writing all this in ASP. Thanks, Bill Tag: creating chat application Tag: 285484
  - 19
    - CyberCash replacement Can anyone recommend a CyberCash replacement for ASP(x)? Tag: creating chat application Tag: 285483
  - 20
    - Chiisoft ASP - Chili!Upload problem..... Hi, i'm using a Chilisoft ASP component - Chili!Upload I have a form as such: ___________________________ <FORM ACTION="getfile_lnx.asp" METHOD="POST" ENCTYPE="multipart/form-data"> <INPUT TYPE="FILE" NAME="FILE" size="70"> <INPUT TYPE="SUBMIT" VALUE="Upload"> </FORM> ___________________________ This is then submitted to : Set fbase = Server.CreateObject("Chili.Upload.1") Response.Expires = 0 fbase.SizeLimit = 500000 fbase.AllowOverwrite = false fullpath = fbase.SourceFileName ____________________________ If the user presses the upload button without first selecting a file I get an error: Chili.Upload.1 error '80020009' Filename is empty. No file was selected However I try to catch this error, I just cannot. Please can you help me get around this. Thanks David Tag: creating chat application Tag: 285477
  - 21
    - How to use grid control in the asp page thru Visual interdev(Beginner) Hai ! I use the Grid control with the data environment and the recordset control by dragging from the data env. But if i run the page alone in the iexplorer it tells the error like pm.script liabrary not found even though i open it in the scripting libraries. How to solve this With thanks Raghu Tag: creating chat application Tag: 285472
  - 22
    - Type mismatch: 'HTMLEncode' I'm getting the above error and I can't figure out why... Here is the line: Response.Write Server.HTMLEncode(queryRS("characterization")) Running IIS 6.0 DK Tag: creating chat application Tag: 285467
  - 23
    - Pre-formatted text Hi I have been given some text that needs to be displayed on a web page. The text is pre-formatted (includes things like lists etc) and displays okay if I wrap it using the <pre/> tag. However, the font used is rather "naff" and looks too different to the rest of my web page. I'm not sure how I can (or even whether I can) override the font used with the <pre/> tag. If not, is there another tag I can use to display pre-formatted text? Thanks Griff Tag: creating chat application Tag: 285465
  - 24
    - access right Hi all, I would like to do sth like this: when clicking a page, it show you do not have the authorize to view the page, but after login, it is ok to view the contain. Could anyone give me a example or link, I do not have the ideas.. Thanks in advance. Tag: creating chat application Tag: 285464
  - 25
    - asp html email Im emailing using Jmail and i'd like to send an html encoded email. The form is setup and it emails out but when i receive it the comes back as the html code. what do i need to do so that it will display as an html page? Tag: creating chat application Tag: 285458

Hai
I am shine from India. Is there any one who knows to create a chat application with voice mail and web cam facility using ASP
If any one plz help me it's very urgent
Any suggestion would be greatly appreciated
rgd
shin

Top