CDONTS and ASPUpload

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
    - Using client certificates in ASP Hi there, I have an ASP page, which have to connect to an SSL server that requires a client certificate, but I get the following error: Erroror Type: msxml3.dll (0x80072F0C) A certificate is required to complete client authentication /test/test.asp, line 34 Here goes my code: const DQ = """" dim responseText dim strRequest dim objSrvHTTP dim objXMLDocument dim objXMLReponseDocument strRequest = "xxx test xxx" set objSrvHTTP = CreateObject("MSXML2.ServerXMLHTTP") set objXMLDocument = CreateObject("MSXML2.DOMDocument") set objXMLReponseDocument = CreateObject("MSXML2.DOMDocument") objXMLDocument.async = false objXMLDocument.loadXML(strRequest) 'objSrvHTTP.setOption(2) = SXH_OPTION_SELECT_CLIENT_SSL_CERT 'objSrvHTTP.setOption(3) = "Local_Machine\My\www.notourwebsite.com" objSrvHTTP.setOption 3, "cert_name" objSrvHTTP.open "POST", "https://host:8443", false objSrvHTTP.SetRequestHeader "content-Type","text/xml" objSrvHTTP.send objXMLDocument ' Line 34 Response.Write objSrvHTTP.responseText Response.End <snip> Can someone please help me with this issue? Thanks in regards, Jess --- Jess Nielsen Systems Developer Tag: CDONTS and ASPUpload Tag: 272143
  - 2
    - query search on access db ... scratching my hair ... help plz I have posted this Q earlier also, but NO solution so far. I still hope there must be someone with a solution. My Q: displaying only SPECIFIC records from an access db with ASP query. e.g. let's say there r 700 records in a DB; out of that 50 are from NY, 100 from NJ and rest from other states. (i) If i want to display all 700 records, then the script works fine, the paging function (previous 1 2 3 4 .... next) works perfectly. (ii) Now, if i run a query and want to display only the records from NY >> then the trouble starts. the results of query: number of records (50), number of pages (3 at 20 records per page), and its display on first page (first 20 records) --- all these are returned correctly. BUT, the next pages of the query results (the 21-40 records on page 2 and 41-50 on page 3) are not displayed. Intead all the 700 records start getting displayed from next and previous querystring buttons. here is the demo i have put up: http://www.as.pgims.org/query/query.asp Any kind souls out there??? Tag: CDONTS and ASPUpload Tag: 272141
  - 3
    - video conferance using asp Dear All how can i make video conferance using asp Tag: CDONTS and ASPUpload Tag: 272140
  - 4
    - activating access hyperlink from asp i have a database, one of the fields is a hyperlink to a htm file. i want to activate it automaticly as the asp file is loaded no click is needed.so that the background of the BODY part will remain and that text will be of the htm file. Both the background and the htm file are one record in the database, i tried: <BODY backgound='<%details("background")%>' HREF=<%details ("htmfile")%>'> the background field is a text field, containing the gif file address, and the htmfile is a hyperlink field , linked to the htm file. and i need to activate automaticly, can you help me? thanks a lot niv Tag: CDONTS and ASPUpload Tag: 272137
  - 5
    - make zip files on IIS Hallo, can somebody advise me, how to put a few text files into zip archive on IIS5 on user request on some asp page? Thanks a lot LK Tag: CDONTS and ASPUpload Tag: 272136
  - 6
    - Rounder A Number Up!! I am dividing a value by two..what i need is to round the number up if it is not a whole number. Any suggestions on how to do this ?? Help appreciated!! AK Tag: CDONTS and ASPUpload Tag: 272121
  - 7
    - Template problem Hi, I posted this somewhere else, but I don't think it was quite the right place, so I'll try here. I know a little about asp, but not much. This is on a FrontPage 2000 site. I have a template page. A full page design. I have to split it into a header and a footer, for some asp pages. To do this, I marked the beginning of the content area with xxxx. Everything above that, I saved as the header. Everything below it, I saved as the footer. I can open the template as an ASP page or as an HTML page, and it's fine. I can open the header (htm) or the footer (htm), and they are fine. But when I open one of the ASP pages of my cart program (that calls the header and footer files), I get this error message: Active Server Pages error 'ASP 0140' Page Command Out Of Order /header.htm, line 1 The @ command must be the first command within the Active Server Page. The first line on the header is: <%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%> But that is the same first line on all the other pages that do work. Could it have something to do with the fact that the cart ASP pages are written in vbscript? If so, what would I do about it? Thanks for any help! Jill Tag: CDONTS and ASPUpload Tag: 272117
  - 8
    - Problem with "Custom paging" of DataGrid control I created a page to show RealEstate Data with images retrived from the MSSQL 2000. I am using a DataGrid control: <asp:datagrid AllowPaging="True" OnPageIndexChanged="Pageindexchanged" > Sub PageIndexChanged(ByVal sende.........) myDataGrid.CurrentPageIndex = e.NewPageIndex myDataGrid.DataBind() End Sub It works just fine and I am able to go thru the records. The problem begins when I trying to implement Custom paging which is a very important for large number of records and aspetially in my case with a images,becouse if you using a Custom paging the page is receiving only current record baced od page index. So, when I am chenging my code to: <asp:datagrid AllowPaging="True" AllowCustomPaging="True" OnPageIndexChanged="Pageindexchanged" > Sub PageIndexChanged(ByVal sende.........) intStartIndex = (e.NewPageIndex * myDataGrid.PageSize) myDataGrid.CurrentPageIndex = e.NewPageIndex BindDataGrid() End Sub the event OnPageIndexChanged become not available! I have no idea what is happened. I got the same sittuation with Sorting event. I will be appretiate for any help. Alex. Tag: CDONTS and ASPUpload Tag: 272114
  - 9
    - 255 limit of field size hi there I'm creating a database site and using access. I've created a number of fields i.e date, time, description, cost The only problem is that the description info is larger than the 255 character limit imposed by access. How can I solve this one? Thanks in advance raj Tag: CDONTS and ASPUpload Tag: 272102
  - 10
    - Strip time from date? Could someone help me work out out a way to either convert a smalldatetime value from my database(access) to a normal date with out the trailing time. Is it simple matter of using FormatDate or does one need to do string maniupulation? Current 9/13/2003 11:36:00 AM What I want: 9/13/2003 Thanks Jason Tag: CDONTS and ASPUpload Tag: 272099
  - 11
    - newbie question: Which s/w to use for ASP writing hi folks. newbie to ASP here having previously only worked with Flash and basic HTML.. my question is which software packages do you all us to write your code? I've been using UltraDev 4 (for my HTML stuff), and MM flash (obviously) Should I stick with UltraDev or would you recommend getting hold of Visual InterDev? thanks..and I hope I don't upset you all by asking lots of daft questions in the future Alistair Tag: CDONTS and ASPUpload Tag: 272098
  - 12
    - Checking links Hi all win 2k pro sql server 2k asp - vbscript I got the below code from somewhere ages ago. I have a list of links on my site that link to other sites but I want to check if the link is a valid link automatically and if it fails after x checks (checks every 7 days) then to mark the link as a possible broken link the below seems to take ages to process and was wondering if there is a better way to do the below. thanks for any help & tips. Al Set xmlhttp = CreateObject("MSXML2.XMLHTTP") on error resume next xmlhttp.open "get", sURL, False xmlhttp.send if err.number = 0 then iStatus = xmlhttp.Status else 'error might be "DNS error" iStatus = 404 end if on error goto 0 Set xmlhttp = nothing ' if status =200 then it is a VALID url. if iStatus = 200 then ' valid link ' update db here else ' invalid link. ' update db end if Tag: CDONTS and ASPUpload Tag: 272097
  - 13
    - The connection with the server was reset Hi Everyone I'm using serverXMLHTTP to retrieve pages, but in some cases its throwing "The connection with the server was reset" back to me, im not completly sure what the message means, when i used other variations of the the http component i get similair errors, though sometimes it pulls through (once every so many'th times) any help/clues would be appreciated Richard Tag: CDONTS and ASPUpload Tag: 272096
  - 14
    - query a DB - pass the query to next page I am running a querry on an access database and have set the number of records/page displayed at 20. if there are more than 20 records returned, then 1st page will show the first 20, the next page will show next 20 and so on.... The trouble: the count of total records displayed is correct and the first page is displayed correctly. But when i click on *Next* to go to the next page, all the records of the database get displayed (not the 2nd page of records from the query). here is the demo i put up: http://www.as.pgims.org/query/query.asp Any help? Tag: CDONTS and ASPUpload Tag: 272094
  - 15
    - Site and component that turn IP number into www.sitename.com? Is there a site where I can enter an IP number and get the URL name, for example 123.234.34.55 ->www.google.com Also, I know there are custom components that do this but don't know their names. Thanks *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: CDONTS and ASPUpload Tag: 272089
  - 16
    - Redirecting zip file Hi All, Good Morning, The problem which i am facing is related with IIS 6.0 in Win2K3. The problem: I have a ASP page which redirect a zip file which resides in the Application data path, while access this page i am getting the PAGE CANNOT BE FOUND error, with the URL "http:\\172.16.10.98\CWSLite\Temp\Client.asp". But if i brows the same with URL http:\\localhost\CWSLite\Temp\Client.asp then i am getting the zip file. Please any one help me to get the file with IP address URL. Thanks in Advance. Regards, Nagaraj M Tag: CDONTS and ASPUpload Tag: 272084
  - 17
    - Problem using com object in IIS 4 Hey all, I've been having a weird problem using com objects in IIS 4. I've built a middleware system that can be called with XML requests over HTTP. The request is sent to an ASP page which creates a com object that handles the request. This com object usually calls other asp pages that handle sub functions. This has worked fine, but now I have a new component that is giving me a lot of problems. It's a component that contains a few calls to a SQL db using ADO. It works fine for a while, but then I start getting an error in the backend component. I have very good error handling, so I get an XML response back with the error number and location. I have been able to pin point the line of code that gives the error (5, illegal function call). But it's almost impossible that an error would happen there... The line of code contains an add to a collection. I add a simple variable to a collection. This runs fine for a long time and then I get the error. On my local machine the code works fine. As soon as I plug it into IIS it goes wrong. The error always occurs in the same spot. After this error has occurred, I can no longer use any component that uses my database component. If I leave the machine alone for a while it will pick up again... I'm confused... Thanks, Dirk. Tag: CDONTS and ASPUpload Tag: 272078
  - 18
    - URL Checker - (One Stage Further) Hello Groups, I have been testing a script I found that checks URL as valid... It uses the XMLHTTP.4.0 object sURL = "http://www.bbc.co.uk" Set obj = CreateObject("MSXML2.XMLHTTP.4.0") on error resume next obj.open "GET", sURL, False obj.send iStatus = obj.Status on error goto 0 this works fine on most URLS, though I do have some problems with redirected URLs, what I have managed to do is do a database select statement outside of the script and check my database of URLs.. This works fine.. My Database of URL are the backend of a search engine I have written, what I was wondering, is instead of me doing a seperate external check of the URLs using the database as above, can I do something like..... When the user clicks on a URL, they have a varable director.asp?url=blar blar blar, this goes to a page that does a redirect to the URL. Is it possible for me to use the XMLHTTP object to do the redirect, and this way would it be possible for me to have the users of my site check the URL by grabbing the value of the statuscode from the XMLHTTP object before it is redirected. I would like to be able to have the links constantly checked by the users rather than me have to manually as above say every month. something like this, if you see below I would be very keen not to make the jump to the URL slower, so once the URL had been checked using XMLHTTP then maybe it would be possible to use the redirect... CLICK ON LINK | CHECK URL EXISTS USING XMLHTTP | UPDATE DATABASE WITH LAST CHECKED TIMESTAMP | REDIRECT TO THE URL I am not sure if any of this is possible, butjust simple I would like the user clicking on the link actually check it for me, and have a column in the database called last_checked TIMESTAMP Graham Mattingley Tag: CDONTS and ASPUpload Tag: 272077
  - 19
    - asp site map Hi, I would like to create a site map for my map site which is in ASP. I tried to use Visio to create a web site map but it fails because my asp home page requires to authenticate. Is there any other tool to create a sitemap from username/password protected website? thanks jerry Tag: CDONTS and ASPUpload Tag: 272075
  - 20
    - Server Application Unavailable I'm new to ASP.Net. I have a very simple application that was working last week. Now I get this message when I try to run it from VS.Net: Server Application Unavailable The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request. Administrator Note: An error message detailing the cause of this specific request failure can be found in the system It is only a single page at this point with a few images and labels. I believe IIS is running (version 5.1). I am running Windows XP SP1. I suspect it might have had something to do with installing the latest security patches. Any ideas? Thanks, Ted Tag: CDONTS and ASPUpload Tag: 272061
  - 21
    - how to keep cookies or sessions between 2 sites? Hello, I have 2 separate web sites on 2 different boxes www.xyz.com on box 1 www2.xyz.com on box 2 Users log into box 1 via regular ASP/Database authentication, and I keep a session variable to mark authenticated users. There's a link that would send users to box #2 at www2.xyz.com. How do I check whether these users are authenticated or not? I do not want to present a login screen again. Is it possible? If so, what are ways to do it, if not session/cookies? Thanks! HH Tag: CDONTS and ASPUpload Tag: 272054
  - 22
    - Problem using com object in IIS 4 Hey all, I've been having a weird problem using com objects in IIS 4. I've built a middleware system that can be called with XML requests over HTTP. The request is sent to an ASP page which creates a com object that handles the request. This com object usually calls other asp pages that handle sub functions. This has worked fine, but now I have a new component that is giving me a lot of problems. It's a component that contains a few calls to a SQL db using ADO. It works fine for a while, but then I start getting an error in the backend component. I have very good error handling, so I get an XML response back with the error number and location. I have been able to pin point the line of code that gives the error (5, illegal function call). But it's almost impossible that an error would happen there... The line of code contains an add to a collection. I add a simple variable to a collection. This runs fine for a long time and then I get the error. On my local machine the code works fine. As soon as I plug it into IIS it goes wrong. The error always occurs in the same spot. After this error has occurred, I can no longer use any component that uses my database component. If I leave the machine alone for a while it will pick up again... I'm confused... Thanks, Dirk. Tag: CDONTS and ASPUpload Tag: 272052
  - 23
    - Problem using com object in IIS 4 Hey all, I've been having a weird problem using com objects in IIS 4. I've built a middleware system that can be called with XML requests over HTTP. The request is sent to an ASP page which creates a com object that handles the request. This com object usually calls other asp pages that handle sub functions. This has worked fine, but now I have a new component that is giving me a lot of problems. It's a component that contains a few calls to a SQL db using ADO. It works fine for a while, but then I start getting an error in the backend component. I have very good error handling, so I get an XML response back with the error number and location. I have been able to pin point the line of code that gives the error (5, illegal function call). But it's almost impossible that an error would happen there... The line of code contains an add to a collection. I add a simple variable to a collection. This runs fine for a long time and then I get the error. On my local machine the code works fine. As soon as I plug it into IIS it goes wrong. The error always occurs in the same spot. After this error has occurred, I can no longer use any component that uses my database component. If I leave the machine alone for a while it will pick up again... I'm confused... Thanks, Dirk. Tag: CDONTS and ASPUpload Tag: 272050
  - 24
    - Problem using com object in IIS 4 Hey all, I've been having a weird problem using com objects in IIS 4. I've built a middleware system that can be called with XML requests over HTTP. The request is sent to an ASP page which creates a com object that handles the request. This com object usually calls other asp pages that handle sub functions. This has worked fine, but now I have a new component that is giving me a lot of problems. It's a component that contains a few calls to a SQL db using ADO. It works fine for a while, but then I start getting an error in the backend component. I have very good error handling, so I get an XML response back with the error number and location. I have been able to pin point the line of code that gives the error (5, illegal function call). But it's almost impossible that an error would happen there... The line of code contains an add to a collection. I add a simple variable to a collection. This runs fine for a long time and then I get the error. On my local machine the code works fine. As soon as I plug it into IIS it goes wrong. The error always occurs in the same spot. After this error has occurred, I can no longer use any component that uses my database component. If I leave the machine alone for a while it will pick up again... I'm confused... Thanks, Dirk. Tag: CDONTS and ASPUpload Tag: 272049
  - 25
    - Creating Text File I'm using ASP 3.0. I'm taking form contents and dumping it into a text file on the server. My question is how to add the TIME to this statement. I create the text file with the name of file, month, day and year. I would like to add TIME to it. ------------------------------------------------------------- set fso = createobject("scripting.filesystemobject") Set act = fso.CreateTextFile(server.mappath("/data/"&g_filename & "-"& month(date())& day(date())& year(date()) &".htm"), true) ------------------------------------------------------------- Thank you, Erik Tag: CDONTS and ASPUpload Tag: 272048
- Next
  - 1
    - Passing Coordinates If this doesn't fix the post-date issue, I'm at a loss. Anyone care to enlighten me? Tag: CDONTS and ASPUpload Tag: 272046
  - 2
    - messagebox inside ASP page How can I send messages to user like messageBox from a ASP page without doing postback over the page. thanks for your help Oscar Tag: CDONTS and ASPUpload Tag: 272040
  - 3
    - unwanted session timeout I have a simple form connecting to an Access database where users log in, fill out the form, and submit. Everything works fine. However, sometimes it takes a user 20 minutes or more to fill out the form. When the user then hits "submit" he is given the login page instead of the response page I have built in. If the user fills the form out in less than 20 minutes or so, it works fine. I have Session.Timeout=720 (2 hours) but this hasn't changed anything. Does anyone know what I'm missing? I'm pretty new at asp so forgive me if it's something simple. Thank you in advance, Rob Tag: CDONTS and ASPUpload Tag: 272032
  - 4
    - Unpsecified Error with ODBC Connections This happens a lot to my databases. I store them at the root of my developing files, i.e. c:\My Projects\Proj1\database.mdb. Randomly, the security settings on this database will drop to the basic secutiry, myself and SYSTEM. I need IUSR on it so I can access it through my ASP pages... I get errors like this: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data. /amr/common/adovbs.inc, line 4 and Provider (0x80004005) Unspecified error /amr/common/adovbs.inc, line 4 and line 4 is this 2 Dim Connect 3 Set Connect = Server.CreateObject("ADODB.Connection") 4 Connect.Open "dsn name" I will reset the permissions, then the ASP script will access the database once, like read or write, then this will happen again. I have to reset the permissions on the database file. Sometimes i'll have to do this 3 or 4 times until the permissions stick. It only happens on a few of my projects, not all of them. Also, what helps at times, is within IIS, to check server extensions. This seems to do something to it to help it to work. Any Ideas? -- David Lozzi Associated Business & Technology Group www.associatedbtg.com I should've known that....but I had a brain fart. Tag: CDONTS and ASPUpload Tag: 272031
  - 5
    - Preventing windows from suggesting usernames in login boxes?? How can I prevent this from happening? For example when the asp application works in a public terminal where we don't want successive users to know the login password and user name of the previous ones? Thanks *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: CDONTS and ASPUpload Tag: 272023
  - 6
    - ASP Pages will not display I had to restore my server from backup. When I did, I could no longer access any asp pages on my web server. The error says HTTP 500 Internal Server Error. I have turned off friendly HTTP error messages and it gives me less info. All it says is server application error. html or htm pages work fine. I have reinstalled com+ so that I can now access the components services snap-in. When I go to the properties of the website and then into home directory and change the application protection to low the pages display correctly. This makes me think it is a permissions issue with the iwam_machinename user. The two event logs that are logged in event viewer on the server each time I try to access an asp page are as follows: Event Type: Error Event Source: W3SVC Event Category: None Event ID: 59 Date: 9/12/2003 Time: 6:30:30 AM User: N/A Computer: HPFMS Description: The COM Application '{3D14228D-FBE1-11d0-995D- 00C04FD919C1}' at '/LM/W3SVC/3/Root' failed to activate out of process. For additional information specific to this message please visit the Microsoft Online Support site located at: http://www.microsoft.com/contentredirect.asp and..... Event Type: Warning Event Source: W3SVC Event Category: None Event ID: 36 Date: 9/12/2003 Time: 7:06:21 AM User: N/A Computer: HPFMS Description: The server failed to load application '/LM/W3SVC/3/Root'. The error was 'c000003b'. For additional information specific to this message please visit the Microsoft Online Support site located at: http://www.microsoft.com/contentredirect.asp. Please help!! Thanks in advance for any info that you can give me! Tag: CDONTS and ASPUpload Tag: 272022
  - 7
    - script ASP in an onClick event i need to insert, in a onClick event of a submit button in a form, a call to an ASP script, like follows: <INPUT TYPE="SUBMIT" NAME="btnSend" onClick="<% A_Function_Or_Sub_in_VBScript %>"> the problem is that teh event triggers only event on the client page, not on the server..how to solve the problem??? thx to all.. Tag: CDONTS and ASPUpload Tag: 272021
  - 8
    - ASP vs. HTML for Search Engines Hello, I'm wondering if anyone can shed some experience on how to have search engines index a website that is a store using products stored in an asp database. I've been creating static html pages each time I update my inventory but it seems like there has to be a better/quicker way. Thanks for any help! --Linda deforgel@aol.com Tag: CDONTS and ASPUpload Tag: 272019
  - 9
    - Are stored procedures practical using ASP only? Hello, The aspfaq.com seems to really push stored procedures, and I hear the same advice here all the time. So I want to take the advice. Is it possible to create and practically maintain, delete, use, etc.. stored procedures soley from asp (i.e., no GUI or console- like being hosted on Brinkster)? The tutorial on aspfaq.com mentions that stored procedures can be created from asp code- how? Do you just send the stored procedure you'd type into the GUI with oConn.execute() instead? Thanks! Tag: CDONTS and ASPUpload Tag: 272015
  - 10
    - NEWBIE: How to create a log file Hello All, I'm new to ASP and am having problems with CDONTS.NewMail not always delivering my mail. Unfortunately, it always seems to fail on a particular recipient, so he's getting steamed! In my code, I create two e-mails, one to an end-user, and one to a sales rep. The e-mail to the user always succeeds, but the email to the sales reps fails about 15-25% of the time. I'm trying to debug the ASP page, and I figure using a log file may be the best way. I want to test the sales rep's newMail object and write to a log file when it fails (IsNull()), but I don't know how to create a log file in ASP. Example: Dim newMail newMail = Server.CreateObject ("CDONTS.NewMail") if(IsNull(newMail) then ' Code to write to a log file goes here ' Record the e-mail info for re-send later ' What goes here else ' Code to create the mail components goes here newMail.Send newMail = nothing end if I know this is super-simple and just need a quick code snippet. Thanks -tomas Tag: CDONTS and ASPUpload Tag: 272008
  - 11
    - Limit User How can i limit the number of users on my .ASP page, i want only one user to be using the page at a time, The query i have on my page is big and takes a lot of my system resources. John Tag: CDONTS and ASPUpload Tag: 272007
  - 12
    - Passing coordinates Tag: CDONTS and ASPUpload Tag: 272006
  - 13
    - protected download of files... I am creating a series of downloadable articles, career tools, spreadsheets, etc. However, some of the content is for "registered" guest. The registrants are stored in a database and logon. I want to ensure that someone registered cannot simply pass someone the path to the files for download. However, I am not creating an actual system user name for the folders where the various documents exist. I don't want someone to logon, retrieve the path to a file, and be able to send that path or return to that path without having to logon. How do I accomplish this? Consider the following: serverroot/registeredcontentfolders would be protected by a single logon name - not accessible via anonymous access. User's logon to site and I auth them with their user name but on the server side, auth with the single account I am establishing for access to the protected folders. Any insight would be appreciated. Thanks, Matt Tag: CDONTS and ASPUpload Tag: 272005
  - 14
    - ASP with MYSQL Sometimes you dread the day you woke up and said that you will become a Computer Engineer. Not that you love being one, but its just one of those days for me. I have extensively worked on ASP, Access And Sql Server, on win 2k. Now the requirements have changed. The DB has to be MySql. Right now, I m working with a Win2k server and running ASP on IIS. That will eventually be run on Linux on Chilli ASP. I dread that day too now. The thing is, I have got The connection between ASP and MySql running after much difficulty, because I suck at DSN connections and all. Now, that its running, I can't seem to get the RecordCount for any recordset I open with MySql. I worked around it to avoid it, but now I m stuck with the Paging problem, cause whenever I try to page a recordset, the following error pops up :- Error Type: ADODB.Recordset (0x800A0CB3) Object or provider is not capable of performing requested operation. /WorldMediaServices/admin/ListCategory.asp, line 102 AND THE REVELANT CODE FOR THE PAGE is :- <% set Res = Server.CreateObject("adodb.recordset") SQL = "select * from A_Categories" if not request("Category") = "0" then SQL = SQL & " where name = '" & request("Category") & "'" end if SQL = SQL & " order by name" Res.open SQL,Application("Conn"),3,2 Res.PageSize = 10 Res.absolutepage = 1 %> Line 102 being the last one. I don't know where the problem lies, the configuration of MySql for Windows or ASP. Any help would be really appreciated. Thanks Regards Jawad Tag: CDONTS and ASPUpload Tag: 272002
  - 15
    - System resource exceeded. Hello one of our servers (win2k adv server, IIS5, MDAC 2.8, full patched), once a day in the afternoon starts giving this error on every site that uses asp: Microsoft OLE DB Provider for ODBC Drivers error '8007000e' [Microsoft][ODBC Microsoft Access Driver] System resource exceeded. the memory used goes from 800Kb to 1,5Gb (1Gb of physical ram available), and even though the cpu used isn't 100% we need to reboot because everything dramatically slows down. There are many sites hosted on this server and we never had this problem before... The culprit must be one of the new sites then. Is there a practical way to find out which site is the culprit? Thanks Tag: CDONTS and ASPUpload Tag: 271997
  - 16
    - Script language choice I see that ASP allows you to specify the scripting language of your choice - including (if you get the COM object) PERL, REXX and more. That seems pretty good, I think. Out of the box, it supports VBScript and JScript. The question is (and I know that personal preference will come into this) what would you choose to use out of JScript and VBScript? Does one actually have more capability than the other? -- jeremy Tag: CDONTS and ASPUpload Tag: 271992
  - 17
    - can Session.Contents can be a string array? Hello, My script builds a list of files in a folder. These files are stored in an 2-dimensional array, called "a_files". To speed up the script, I don't want the filelist everytime being read on the server. Therefore I wanted to send the contents of a_files to a session variable. However, with Session.Contents("sFiles") = a_files I get the following error message: *********************** Response object error 'ASP 0106 : 80020005' Type Mismatch ? An unhandled data type was encountered. *********************** Is it impossible to store an array to a session var? Is there another way to store the array somewhere in memory so it has not to be rebuild everytime? tia bartp -- HyperART Paul Van Ostaijenlaan 4 3001 Heverlee Tag: CDONTS and ASPUpload Tag: 271991
  - 18
    - "the link could not be saved" error I have two ASP pages. They basically query a database, and spit out the information as plain text in CSV format. The first has the SQL query hardcoded into it. The second takes a SQL query from a webform. Now, the hardcoded results, I can click "Save Page As" when the results come up and save it as a text file. The other, while it seems to be the same results exactly, gives me an error when I try to save the page locally: "The link could not be saved. The web page might have been moved or had it's name changed." !?!? The page has not been moved, nor had it's name changed. In fact, what's sent back to the browser in each case if virtually (if not actually) identical. What's the problem? [begin code from page that cannot be saved]  <% response.ContentType="text/plain" Set oConn = Server.CreateObject("ADODB.Connection") oConn.Open sDataSource Dim sql Dim count sql = Request.Form("sql") Set objConn = oConn.Execute(sql) fieldCount = ((objConn.Fields.Count) - 1) Do Until objConn.EOF For count = 0 to fieldCount Response.Write "'" & objConn(count) & "'" If count <> fieldCount Then Response.Write "," Else Response.Write VbCr End If Next objConn.MoveNext Loop %> [end code] [begin code from hardcoded page that can be saved]  <% response.ContentType="text/plain" Set oConn = Server.CreateObject("ADODB.Connection") oConn.Open sDataSource sql = "SELECT TABLE1.StudentFirstName, TABLE1.StudentLastName, " sql = sql & "TABLE1.StudentEffectiveEnrollmentDate, TABLE1.StudentTel, TABLE1.StudentAddress1," sql = sql & "TABLE1.StudentAddress2, TABLE1.StudentCity, TABLE1.StudentZip," sql = sql & "TABLE2.InventoryKitID,TABLE2.InventoryKitItem1ID," sql = sql & "TABLE2.InventoryKitItem2ID,TABLE2.InventoryKitItem3ID," sql = sql & "TABLE2.InventoryKitItem4ID,TABLE2.InventoryKitItem5ID," sql = sql & "TABLE2.InventoryKitItem6ID " sql = sql & "FROM TABLE1 INNER JOIN TABLE2 ON " sql = sql & "TABLE1.StudentID = TABLE2.InventoryKitStudentID " sql = sql & "WHERE TABLE2.InventoryKitInventoryKitStatusID = 1 AND TABLE2.InventoryKitStudentID <> 0 " sql = sql & "ORDER BY TABLE1.StudentLastName" Set objConn = oConn.Execute(sql) Dim X X = 1 Response.Write "'Last Name'," Response.Write "'First Name'," Response.Write "'EED'," Response.Write "'Phone'," Response.Write "'Address 1'," Response.Write "'Address 2'," Response.Write "'City'," Response.Write "'Zip'," Response.Write "'Kit'," Response.Write "'CPU'," Response.Write "'Monitor'," Response.Write "'Printer'," Response.Write "'Printer Cable'," Response.Write "'Curcuit Breaker'," Response.Write "'Headphones"&VbCr Do Until objConn.EOF Response.Write "'"&objConn("StudentLastName")&"'," Response.Write "'"&objConn("StudentFirstName")&"'," Response.Write "'"&objConn("StudentEffectiveEnrollmentDate")&"'," Response.Write "'"&objConn("StudentTel")&"'," Response.Write "'"&objConn("StudentAddress1")&"'," Response.Write "'"&objConn("StudentAddress2")&"'," Response.Write "'"&objConn("StudentCity")&"'," Response.Write "'"&objConn("StudentZip")&"'," Response.Write "'"&objConn("InventoryKitID")&"'," Do Until X = 7 If objConn("InventoryKitItem"&X&"ID") > 1 AND objConn("InventoryKitItem"&X&"ID") < 999999Then sql = "SELECT InventorySerialNumber FROM TABLE3 WHERE InventoryID=" sql = sql & objConn("InventoryKitItem"&X&"ID") Set objConn2 = oConn.Execute(sql) Response.Write "'"&objConn2("InventorySerialNumber") Else Response.Write "'" End If X = X + 1 If X <> 7 Then Response.Write "'," Else Response.Write "'" & VbCr End If Loop X = 1 objConn.MoveNext Loop %> [end code] -- Sugapablo :: russREMOVE@sugapablo.com http://www.sugapablo.com | ICQ:902845 Tag: CDONTS and ASPUpload Tag: 271988
  - 19
    - Passing coordinates I have script that fetches the coordinates from mouse. I would like to pass this mouse coordinates to page2.asp How can I do that? <script language="JavaScript1.2">  </script> </body> </html> Tag: CDONTS and ASPUpload Tag: 271987
  - 20
    - CSV files into VB Arrays in ASP Can anyone tell me why when using a .csv file called book1.csv with the values below the code below does not recognise values read in after the first line in a loop. please feel free to run the code to see what I mean: book1.csv: RGB01,1,2,3,4 RGB02,1,2,3,4 RGB03,1,2,3,4 RGB04,1,2,3,4 <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <html> <% csv_to_read="book1.csv" set fso = createobject("scripting.filesystemobject") set act = fso.opentextfile(server.mappath(csv_to_read)) imported_text = act.readline imported_text = replace(imported_text,chr(13),",") imported_text = replace(imported_text,chr(34),"") split_text=split(imported_text,",") num_imported=ubound(split_text)+1 total_imported_text = act.readall total_imported_text = replace(total_imported_text,chr(13),",") total_imported_text = replace(total_imported_text,chr(34),"") total_split_text=split(total_imported_text,",") total_num_imported=ubound(total_split_text) dim pinstore(500) Dim I Dim iCols counter = 0 for i = 0 to (num_imported -1) step 1 if i mod num_imported = 0 then pinstore(counter) = cstr(split_text(i)) counter = counter + 1 end if next for i = 0 to (total_num_imported - 1) step 1 if i mod num_imported = 0 then pinstore(counter) = cstr(total_split_text(i)) counter = counter + 1 end if next for i = 0 to counter -1 response.write pinstore(i) & " Is in the list<br>" if pinstore(i) = "RGB01" then response.write Pinstore(i) & " = Matched<p>" end if if pinstore(i) = "RGB02" then response.write Pinstore(i) & " = Matched<p>" end if if pinstore(i) = "RGB03" then response.write Pinstore(i) & " = Matched<p>" end if if pinstore(i) = "RGB04" then response.write Pinstore(i) & " = Matched<p>" end if next %> </body> </html> *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: CDONTS and ASPUpload Tag: 271984
  - 21
    - User Variable Do you know how to get windows login variables (i.e. the LOGON_USER server variable) from ASP without having to fill in the challenge response message box that automatically appears when you configure IIS to Integrated Windows Security for a particular site? I don't want users to have to log in again to the site as they have already logged in to windows but I want to use their username on the back end to verify permissions. Is it possible? Tag: CDONTS and ASPUpload Tag: 271979
  - 22
    - Functions vs. subs and role reversal Hi all, First off I know the difference between functions and subs, basically a function returns a value on execution of a code block wheras a sub just executes a code block (more or less). I have found however that if I 'call' a function in the same way as I would a sub the function executes the code as if it were a sub ie: Call openDB 'this is a function which creates a connection object to my database called dbConn which is the available to the rest of my code. openDB is most definitely a function and this method of calling it works perfectly well. My questions are thus: 1) Am I just ignorant of calling procedures? 2) Is it a good idea to call functions like this, or should a sub be a sub and a function be a function? 3) If not a good idea then why not? Any links or thoughts on this 'problem' would be highly appreciated. Colin Mc mahon Tag: CDONTS and ASPUpload Tag: 271978
  - 23
    - Importing CSV file to VB Script Array I've been working on some coursework that requires the use of an excel spreadsheet and a CSV file to be read into an ASP page and worked with. What I have done is set up an array to store the values from the CSV file and accessed the spreadsheet using an Excel Recordset. For some reason only the first 2 values in the CSV file (stored in the array as the first and last) are comparing properly with values from the spreadsheet. When the comparisons are made I have used a loop to go through all the records in the recordset and then another loop to search the array. If I hard code the values instead of the array values the results are as expected. I've tried making sure all the values are trimmed and preceeded with the "cstr" operation and still no joy. Even when I've written the comparisons to screen it is saying "RGD11 = RGD11 = False" Has any one got any clues as to what is going on??? Tag: CDONTS and ASPUpload Tag: 271970
  - 24
    - Front Page Server Extention Problem Hi all I have installed Front page server Extention on IIS 5.0 it was working fine. I was able to load project from Visual Interdav and doing well. Yesterday I installed a security update from Microsoft and after that every thing stop working and I am getting the error below when ever I am trying to connect to server using V Interdev. Error Shows that FP Server Extention is not installed but its there even I removed it and installed it back error is still there. "An HHTP error occured. The server could not complete your request. Contact your Internet Service Provider or Web Server administrator to make sure that the server has the FrontPage Server Extensions installed, and that the Web application exists on that server" I dont know about Server Extention too much. If some one know the problem or give any link where I can find more about Server extention will be very thankfull. Kind Regards Fayyaz Tag: CDONTS and ASPUpload Tag: 271969
  - 25
    - error handling in asp-userfrindly messages hi ... I want to do error handling in my application. I have made a complete application. but when I encounter errors (like mentioned below) I want to do error handling. how can I do it? I mean like in this case I can see if the record is being added duplicate then I can always check for duplicate records and throw a message. but I will face so many errors like this??? do we have a list ..whereby I can get all the error numbers and there meanings and I generate my own user-friendly errors? I hope I am clear..thanks for any suggestion Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC Microsoft Access Driver] The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again. Tag: CDONTS and ASPUpload Tag: 271968

Hi

I don't know if this is the right forum but I need some help and advise.

I want to create a form where I can enclose files from local disc and mail
with CDONTS.

I want to use a form including the following:

Fill in a form with following fields:
From: (name)
Email: (address)
Subject:
Text: (Body)
Enclosed files: (from my local hard drive)

I may also need to use radio or check boxes etc.

I have the following idea:

1. Fill in form and upload enclosed files to temp folder on server using
ASPUpload 2.1
2. Send mail using CDONTS including both form data and files which I pick
from temp folder at the server.
3. Delete files from temp folder at server.

I have tried several ways to code but get stuck all the time.

Do anybody have any hints how to solve this or know any good site
describing
procedures?

Rgds
Lars

Top

Re: CDONTS and ASPUpload by Curt_C

Curt_C
Sun Sep 14 14:08:30 CDT 2003

what have you got so far? What specific problems have you hit?
Also, I'd suggest CDO instead of CDONTS (CDONTS is obsolete).

--
----------------------------------------------------------
Curt Christianson (Software_AT_Darkfalz.Com)
Owner/Lead Designer, DF-Software
http://www.Darkfalz.com
---------------------------------------------------------
..Offering free scripts & code snippits for everyone...
---------------------------------------------------------

"Lars" <lars@andreasson.pp.se> wrote in message
news:3f647ad3$1@news.wineasy.se...
> Hi
>
> I don't know if this is the right forum but I need some help and advise.
>
> I want to create a form where I can enclose files from local disc and
mail
> with CDONTS.
>
> I want to use a form including the following:
>
> Fill in a form with following fields:
> From: (name)
> Email: (address)
> Subject:
> Text: (Body)
> Enclosed files: (from my local hard drive)
>
> I may also need to use radio or check boxes etc.
>
> I have the following idea:
>
> 1. Fill in form and upload enclosed files to temp folder on server using
> ASPUpload 2.1
> 2. Send mail using CDONTS including both form data and files which I pick
> from temp folder at the server.
> 3. Delete files from temp folder at server.
>
> I have tried several ways to code but get stuck all the time.
>
> Do anybody have any hints how to solve this or know any good site
> describing
> procedures?
>
> Rgds
> Lars
>
>

Top