Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: POSAPAY
  • Content: Threads
  • Order by date
  1. POSAPAY

    SQL 2008 express - slower query than on SQL 2000

    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...
  2. POSAPAY

    run 32 bit dll on win 2008 r2 64bit and called from IIS from a webpage is not working

    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...
  3. POSAPAY

    Login timeout expired on Win2008R2 and MS SQL 2000 - and using Classic ASP

    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...
  4. POSAPAY

    Distinct rows based on one column, yet get the other columns

    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...
  5. POSAPAY

    SP selecting a date range to be fine-tuned to the hour

    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...
  6. POSAPAY

    file upload gives invalid procedure call on Win 2003

    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 =...
  7. POSAPAY

    How data sneaks in to the database

    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...
  8. POSAPAY

    Building a multi table random row get with some rules

    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...
  9. POSAPAY

    pagination of 1.2 million records takes too long

    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...
  10. POSAPAY

    Having a logic issue with IF @@ROWCOUNT

    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)...
  11. POSAPAY

    Creating a job to insert a record in a table about other records

    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...
  12. POSAPAY

    Combining multiple record data into single record

    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...
  13. POSAPAY

    Just trying to add some numbers and getting stuck

    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...
  14. POSAPAY

    Get a Unique list with a summary of numbers in another column

    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...
  15. POSAPAY

    Does IIS6 limit an asp page's vb script number of variables used?

    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...
  16. POSAPAY

    Does IIS6/VBScript have a max number of variables per script limit?

    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...
  17. POSAPAY

    binary stream doesn't work on pdf??

    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...
  18. POSAPAY

    Win2K3 died and keeps rebooting. Can't reinstall.

    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...
  19. POSAPAY

    Crashed and need to recover fast! HELP!!

    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...
  20. POSAPAY

    Access other mailbox???

    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...

Part and Inventory Search

Back
Top