asp-classic

How can I open an IE window and run a Batch file once the tab is done loading?

Here is my current situation. I have a Classic ASP script that gathers data from multiple sources then creates an XML file. Only once the script is done running should the newly created XML file (static name) be copied to a remote server. Since ASP cannot see the mapped network drive, I can't use ASP to copy the file over to our server. ...

Where are store SessionID on the client

I have a web site in ASP 3.0. This web site initialize authentication by session on the server, and retreive the id of the user in the session. A multiple clients access to the web site with no problem. Some of them lost there session. I think is due to a client configuration with the sessionID token or someting like that. Could some b...

Overcoming text encoding from database to filesystem?

Hi folks, in my SQL 2000 database, the model names for my vehicles have accents on some of the letters, like so Scénic 2.0 On the filesystem, the filenames look correct on the server if I browse the folder on the local machine, like so: Car-2005-Renault-Scénic-2_0--Multi-Purpose Vehicle-1157-01tn.jpg When I use the filename in a li...

Getting 0x80070002 error intermittently when trying to instantiate a COM object in classic ASP

We have a classic ASP page that is instantiating a .Net object through a COM interface. It was working fine for a long time, but over the weekend we applied some Windows updates and it is no longer working reliably in our production environment. Sometimes it works, sometimes it doesn't and it seems random when it works. It doesn't fail i...

Is there a size limit when generating an excel document out of a web page using Response.ContentType = "application/vnd.ms-excel"

Is there a size limit when generating an excel document out of a web page using Response.ContentType = "application/vnd.ms-excel" ...

SQL Query to find matching values based on user input

Hi there, I'm building a website for property agents and tenants. Tenants can sign up and fill in their desired locations for properties, including Street, Town and Postcode. Once they sign up, this automatically emails agents who have properties that match those search criteria. At present I have the query set up as follows so that it...

How to access filesystem from within a .NET dll called by classic ASP?

I made a .NET dll and put it in system32 folder and RegAsm it in a win2003 server. One of the API of this dll is to create a file in c:/ folder. And when I call this API from a classic ASP script, always get this error System.IO.__Error.WinIOError So the dll or asp process does not have the sufficient access privilege? How to give it...

dynamically executing classic ASP pages

I'd like to store the contents of classic ASP pages in a table in a database, and have the ability to dynamically retrieve said contents and execute on the fly. Is this possible? ...

CLASSIC ASP - SQL Server does not exist or access denied.

Hi, I'm trying to make a connection to a SQL Server Express DB on localhost, but I get the following error message: Microsoft OLE DB Provider for SQL Server (0x80004005) [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. The code I'm using is Dim connection Set connection = CreateObject("ADODB.connec...

FileSystemObject - Reading Unicode Files

Classic ASP, VBScript context. A lot of articles including this Microsoft one, say you cannot use FileSystemObject to read Unicode files. I encountered this issue a while back, so switched to using ADODB.Stream instead, per the ReadText example here, instead of using FileSystemObject.OpenTextFile (which does accept a final parameter in...

part of the vbscript code gets trashed with hyphens

on some computers, when a client opens the specific html page, part of the vbscript code on the client side gets trashed with hyphens. i saw that the vbscript code on that page was composed of one huge code section enclosed in script start and end tags. i decided to fragment it to small sections, and it seemed better, but when i fragmene...

classic asp/asp.net website - global.asa not working

Hi, I've recently been given a website written in classic asp to configure and set up - although it also appears to have pages written in asp.net. The problem I'm having at the moment is that it doesn;t appear to be picking up settings from the global.asa file such as Application("ConnectionString").... As when I try to write them out...

Session state and garbage collection in IIS6 for Classic ASP

This is a bit of a throwback question, and probably relatively fundamental, but I'm at a loss. How does IIS manage Classic ASP session state? We have an app that stores user information in session, and when many users are using the app, it seems to be recycling session for users, even though the "expire period" has not elapsed. We su...

Setting and reading a session

Hi there, I have a couple of classic ASP pages that require a user to enter their email and a specified 'keycode' that they have been given in order to gain access to a voucher that they can have emailed to them. A voucher code is then dynamically generated and (currently) sent in the query string of the url to a second page that would...

XML selectNodes using Classic ASP

Hi all XML problem that's got me stumped, but is probably very simple... The XML is like: <header> <createdOn>16 Sep 2009</createdOn> <createdBy>Jez</createdBy> </header> <agents> <agent> <agentDetails> <agentName>text</agentName> <agentTelephone>text</agentTelephone>...

Overflow in ASP Classic

I was wondering if someone could help me, as I have gone blind to what I believe is a simple cause to a simple error. I have this code: doRound1(x1) denom1 = 5 y1 = denom1 - x1 mod denom1 if y1 <> denom1 then x1= x1+y1 end if doRound1=x1 End function 'theCalc = 20488888888.684 theCalc = cDbl(11111111111) * 1.844 ...

strategies / patterns for handling complex web crud forms?

using classic asp, over the years we have developed a framework to handle some fairly complex web crud pages. the crud class is designed as some kind of "finite-state machine" the state is preserved between posts using hidden fields, and every event on the pages raises a post with a certain action. according to the action triggered, an...

Using SQLite with Classic ASP

I am building a "quick little" app which needs a small database. I want to use Classic ASP (i.e. not ASP.NET), and I am wondering about SQLite for the database. It is possible to use SQLite from Classic ASP? How do I open / create / use a SQLite database from ASP? Any help / pointers gratefully recieved! ...

Parsing UTF-8-encoded XML in MSXML/ASP

I'm at the receiving end of a HTTP POST (x-www-form-urlencoded), where one of the fields contains an XML document. I need to receive that document, look at a couple of elements, and store it in a database (for later use). The document is in UTF-8 format (and has the appropriate header), and can contain lots of strange characters. When I...

Classic ASP FormatNumber weirdness

We have a recently internationalised application written in classic ASP. The following code replicates the issue. The value of that field in the recordset is "8.90" and is typed as varchar(255). session.LCID = 2057 nNumber = recMessages.fields(lCounter) Response.Write nNumber '' # prints 8.90 Response.Write FormatNumber(8.90) '' # print...