I am attempting to write a component in C# to be consumed by classic ASP that allows me to access the indexer of the component (aka default property). For example: C# component: public class MyCollection { public string this[string key] { get { /* return the value associated with key */ } } public void Add(string k...
I am currently migrating one of my clients sites to a windows server 2008 and SQL 2008 setup, but I am having massive problems with connecting to the database from the site. I have restored the database from a SQL 2k backup into the SQL 2008 server, I have setup the user correctly and can login as that user in management studio fine. I ...
I have transferred a Classic asp site running on windows server 2003 to windows server 2008 but suddenly the below code has stopped working. Const connStr_FC08 = "Provider=SQLNCLI10;Server=DS-47500;Database=TestDB;Uid=TestLogin;Pwd=test;Network=dbmssocn;" Function connDB(OpenDB) DIM conn SET conn = Server.CreateObject("ADODB.Co...
I can't figure out how to get the SCOPE_IDENTITY() back to my variables from an SQL2005 Store Procedure. My sSQL String: sSQL = "EXEC [sp_NewClaim] " & Chr(34) & ClaimNumber & Chr(34) & ", " & Request.Cookies("UserID") & ", " & Request.Cookies("MasterID") & ", " & Chr(34) & strRestaurante & Chr(34) & ", " & Chr(34) & Fecha & Chr(34) &...
We are running a website using Active Server Pages & COM+ components. The ASP pages call COM+ components which in turn communicates with external systems and respond to ASP page requests. We find that the application becomes slow over a period of time and requires restarts (like in couple of days). The website runs on good hardware and ...
Apologies in advance for the long-winded question. I'm really a database programmer, but have inherited support of a classic-ASP intranet application which has recently been migrated from IIS 5 to a new server running IIS 6. The user-base is about a dozen, all using IE 6. The UI displays hierarchies of items returned from a database, u...
To facilitate uploading on our web application we install/load an ActiveX control on the upload page. People don't realise the information bar is asking them to install this control. How do I set up the page so it instructs /suppors users and helps them install the addon and only proceeds when this is done? I can't find the trigger/http ...
Hi, I'm pretty sure the answer to this is no. I know that I can write if lcase(strFoo) = lcase(request.querystring("x")) then... or use inStr, but I just want to check there isn't some undocumented setting buried in the registry or somewhere that makes the content of VBScript strings behave consistently with the rest of the script...
I am implementing a validation class in classic ASP. How should the validation class interface with my other classes? My current setup: The User class's set methods call the appropriate validation method in the validation class. Any errors that occur are stored in User.mError. For example, here's my set method for the Email member vari...
I've just had a small nightmare with unwanted cookies somehow being created. I swear my code never created a cookie in a certain virtual directory, it just read it, but somehow my browser ended up with a root cookie and a copy of this cookie for the vdir too. Which meant the two values were separate and did not both get updated. Most ar...
I have the following C++ code: Char ^= 0xB3; Char is a single character in a string. Is there an equivalent in VBScript? ...
In classic ASP there is a global object called "Application" that is accessed simultaniously by all sessions. As the "Application" object is a shared resource, can it cause dead locks? EDIT: If not, why does it has lock and unlock methods for? Reference ...
Let's say we're tracking the end-user IP for a web service: ip = Request.ServerVariables("HTTP_X_FORWARDED_FOR") If ip = "" Then ip = Request.ServerVariables("REMOTE_ADDR") End If I've read that this is the best method of retrieving end-user IP because it works even for users on a transparent proxy. If we're using the end-user IP...
I have a loop on page to update an access database that takes 15-20 seconds to complete. I only run it once a month at most but I noticed that every time I run it the web site (IIS 6) simply stops serving pages. After the loop ends, pages begin opening again. Here's my code: For each Email in Emails if Trim(Email) <> "" then ' exec...
I have a c# .NET DLL compiled against the .NET 2.0 framework. A customer uses classic ASP but needs the functionality of the .NET DLL. Is there a way for them to use the DLL? ...
I'm using a preformatted text file as a template for emails. The file has line breaks where I want them. I'd like to use this template to send a plain text email, but when I do I'm losing all formatting. Line breaks are stripped. How do I parse this file and retain line breaks? I don't want to use a <pre> tag because I want to send plai...
I use an SQL statement to remove records that exist on another database but this takes a very long time. Is there any other alternative to the code below that can be faster? Database is Access. email_DB.mdb is from where I want to remove the email addresses that exist on the other database (table Newsletter_Subscribers) customers.mdb i...
I'm using the following code to retrieve a message from the database and then write it out to a html page: Dim strDSN, cnn, cmd strDSN = "Driver={SQL Server};" & "Server=(local)\sql2k5;" & ... set cnn = Server.CreateObject("ADODB.Connection") cnn.ConnectionString = strDSN cnn.CursorLocation = adUseClient cnn.Open set cmd = Server.Creat...
I have a DAL that I want to return an ADODB.recordset when executed from a classic asp. The object is exposed as a com object and I have a complete dal workin but I am not sure how to return an object that is a recordset that .net can use. Any help would be aprcitated. Thank you! --Nicolas ...
Has anyone tried a solution to host ASP classic pages on something else than IIS/Windows? I'm wondering if it would be a good idea to try one of the solutions for that problem. I know about Sun Java System Active Server Pages (or Chilisoft) but haven't tried it. Is there any big problems with those solutions? Does the hosted code need ch...