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!

  • Congratulations Mike Lewis 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: *

  1. maduko

    Parse Text from Referring URL

    I'm trying to snag the Google search term from the referrer. I know that it will involve HTTP_REFERRER, but from there I'm lost. Request.ServerVariables("HTTP_REFERRER") How do I parse the q=text out of the URL?
  2. maduko

    Resources Exceeded

    I was hoping to avoid a reboot if possible. I tried restarting the site but it didn't help. I recycled the worker process and that seems to have worked for now. Thanks for the links. Already seen them- I'm already using OLE DB for all connections and nothing I found explained how to monitor...
  3. maduko

    Resources Exceeded

    I have a web server (Win 2k3, IIS6) with three sites using Access databases. Today they suddenly slowed to a crawl and one won't load at all- it shows the following error: Microsoft JET Database Engine error '80004005' System resource exceeded. /gear/show.asp, line 18 As far as I know all...
  4. maduko

    Multiple Sites get the same error message

    I inherited this server running one main website. It's a .NET site and has some sort of customized error handling going on (404 takes you to the site map page). They asked me to setup additional sites, which I did using headers. Everything is golden until I ask for a missing page on one of the...
  5. maduko

    Different users accessing different directories in FTP

    I just did this yesterday and it works great. You will probably need to give those new users "list" permission on the root if their folder is below it. However I set my main FTP account to go to a dead end folder. That keeps people from going up to other stuff and avoids the additional hassle...
  6. maduko

    Select Query for Records NOT Equal To

    I've inherited an Access database used to assign topics to individuals. The table we pull the relationship from is formatted thus: ID 100 RegID 999 TopicID 5 ID 101 RegID 909 TopicID 3 ID 102 RegID 999 TopicID 3 ID 103 RegID 909 TopicID 2 There will be several records for each RegID. My...
  7. maduko

    Use Query as Record Set

    The "email" in the above script refers to a table. I do have a query in the DB however, which is what precluded the question. It's nothing more than a select * where email <> "". Pulling from the table doesn't work because some records do not have email addresses.
  8. maduko

    Use Query as Record Set

    There is no query. Here is the full script that pulls e-mail addresses from a table. In the mail object the address is inserted using objRS("email") for each message. ..... Set objConn = Server.CreateObject("ADODB.Connection") objConn.Open "DBQ=" & Server.MapPath("newsletter.mdb")&...
  9. maduko

    Use Query as Record Set

    I'm working with a script intended to pull records from a table. It's a long story- but the page is currently getting them via a query. The following line appears to work- but it's VERY slow. Any suggestions on how to speed it up or call a table but use criteria? objRS.Open "qryEMAIL" ...
  10. maduko

    No More Connections CAL Issues

    This is the error you get if you try to access the share drive. Just plain old LAN connections- no terminal services or anything like that. If you're the "lucky one" you won't be able to send any interoffice mail either. The license manager shows 15 licenses and 13 active users.
  11. maduko

    No More Connections CAL Issues

    From what I've read this all moot since the licensing thingy doesn't actually *do* anything. It just pops up annoying messages. Bet yes, the additional licenses were added. That was last week- I hoped that over the weekend magical things would happen.
  12. maduko

    No More Connections CAL Issues

    Actually we purchased two 5 packs. So now I have 15 for what it's worth.
  13. maduko

    No More Connections CAL Issues

    Recently upgraded to a Dell P/E 2800 running SBS 2003 and need some advice. Finally got Exchange set up and everythig is going great until a few days ago we see.... "No more connections can be made to this remote computer at this time because there are already as many connections as the...
  14. maduko

    SMTP Configuration, when using an ISP as email host

    I found the Smart Host to not be very smart. For our ISP anyway that option would not work. We have it set to use the SMTP connector only and Outlook handles the POP3 part. Just FYI.
  15. maduko

    Short Date Format isn't Really

    FORMAT! Excellent, thank you.
  16. maduko

    Short Date Format isn't Really

    Ouch. That sounds like a lot of work but I'll consider it.
  17. maduko

    Short Date Format isn't Really

    I'm working on a project that involves exporting a table from Access to a text file that will be chewed on by a legacy app. I keep getting data mismatch errors and finally tracked it to the date field. It wants to see: 2/31/2006 The table with the original data has the date stored as Long Date...
  18. maduko

    Update Query fails at type conversion

    BRAVO! Thank you. Works like a champ!
  19. maduko

    Update Query fails at type conversion

    Thank you. It *almost* works now. I was using reg_id to match the transactions in the batch table. That doesn't always work! I now have the OrderID field in the query and that is unique and present on each record. Here's what I have: qryBreakfast OrderID ID amount B7E8AA 2171 $30.00 B7E8AA...

Part and Inventory Search

Back
Top