Search results for query: *

I've got a Classic ASP vbscript application that I'm testing on two new Windows 2008 R2 servers, with one running SQL 2000, and the other running SQL 2008 express The SQL 2000 seems to run it just fine. But the SQL 2008 express times out. I set in the script the query timeout to be 0...

I've been battling this issue for a few days now... I am relatively new to Win2008 r2 and also new to 64 bit. Got a credit card processing encryption tool of dll and exe file that my website must call. I believe the dll file is 32 bit...so I've put it in the SysWOW64 folder. (on an older box it...

I have moved a Classic ASP application to a new Windows 2008 R2 server, and installed MS SQL 2000 for it. All went well until I tried to run the first page of the website, where it says: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC SQL Server Driver]Login...

I'm trying to display from a log table records that have unique counter fields and date, and often the same IP address creates multiple entries, but I'd only want one record per IP address, and have all of it sorted by the date created. here is what I have now, but it is still not listing...

My SP runs once an hour by a SQL job is selecting from the database a number of records that have a field with a date that is not older than 5 days, yet older by a variable passed in. The problem is, my logic only names it by DAY, and not fine-tuned to the HOUR at least. WHERE Active = 'T' AND...

Hi All, Hoping someone could point me in the right direction here. I moved a classic asp website from an old WinNT4 to Windows2003 server, and the good old asp file upload doesn't work now for some reason. The error I get is: "Invalid procedure call or argument" The code is: Set oFS =...

Hi All, Got an e-mail today from google webmaster tools. Subject: Malware notification regarding "domain.com" (I've changed the domain only in it.) When I go to my website, sure enough, something is off. The sources files are classic asp, and look clean and fine. When I go to the SQL database...

Hi all, I've never done random row selections before, but the need has come. Basic scenario: MS SQL Server 2000 table1 = users table2 = postings table1.ID = table2.USER_ID is a decimal. table2.DATE_POSTED is a date format Result needed is a table of the postings but: - only one record from...

Hi all, I've got a total of 1.5 million records, with daily 100K new and 100K deleted that have expired. I'm trying to display about 1.2 million of these records with pagination of a 25 at a time. If I do that, it times out. I've added TOP 100, to at least have some result, but still takes too...

Hey Everyone, Here is my code: ... SET @CountDeleted = 0 SET ROWCOUNT 500 delete_more1: UPDATE tblQuarantine SET Expire = 1 WHERE ((DATEDIFF(day, MsgDate, GETDATE()) > 15) AND (Expire <> 1)) SET @CountDeleted = @CountDeleted + 500 IF @@ROWCOUNT < 1 GOTO delete_more1_skip IF ((@@ROWCOUNT > 0)...

Hi, I've created a job in Jobs on our SQL server, but not sure what I need to put in the Step's Command area. I need to check TableA where EmailTo is same as Email in TableB and add a single record in TableC and TableD with a summary of the records found in TableA. TableA has MsgID...

Hi, I'm having some difficulty creating a SQL SELECT statement to combine multiple records into one. Basically using two tables, call'm table1 and table2. For each record in Table1, there are 6 records in Table2. Table1 has a bunch of fields amongs ForecastMonth, ForecastYear (both being...

Could someone help me to see where my goof-up is? I'm don't use javascript regularly enough to know it well enough, so any help would be great! This basically seems to run fine on InternetExplorer, but not on Google Chrome. When I cut it back to single line of adding two numbers, it works fine...

Hi, I have a sales forecast table called tblSalesForecasts which amongst many fields includes SalesForecastEncID(Unique ID to this table.) ModelEncID(unique ID to model, not unique to this table) BaseModel(the name of the product) In a second table I have the forecasted month data...

I'm getting this error: if I get rid of a variable completely in my script, it seems to decrement by one. I don't have any integer variables, they are all strings, so I'm wondering what number or variable is overflowing here. Is there a control for the scripts? (BTW, the script is a pretty...

I'm still using good old ASP with VBScript, and my application has grown so big, I get the error message: After a lot of testing, I've discovered this number is probably the number of variables I have used in the script. The actual line number seems to be wrong, as occasionally the line it...

Hey Everyone, I've built an online ticketing system, where users need to log in, and can upload files. In order to not allow anybody not logged in to use a direct link to the files, I have an asp page, that checks for an active session, and on demand, it streams the requested file in binary. It...

I've got a Windows 2003 Server with Exchange 2003. It ran for 1 month before developping this problem. One day just started rebooting, without ever reaching the login screen, or even desktop background to be displayed. I tried the Win2003 server dvd: booted from it, tried recovery.. received...

Hi, My Exchange2003 box on a Windows2003 was running fine for about 1 month, when it crashed. SYMPTOMS: From what I could tell on the screen, it couldn't boot. It started loading Windows2003, and before it would show the desktop color background and login options, it would die and reboot...

Hi, I'm loged on the workstation as Administrator, and I can open outlook2000. And I see my e-mail account folder. Why can't I open multiple mailboxes? I added others, but it gives me an error msg pop-up, and can't access that other user's inbox. I need to copy large amount of e-mails to his...