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

    IIS 5.0 / HTTP 500 Error / Mising COM+ Applications ???

    Hello, I have a win2K Server running IIS 5.0. Serves HTML fine, but no ASP. Sure, sounds simple right? You've seen this issue before, I'm sure. But here's what else I can tell you... Web site properties are set to: - Execute Permission: Scripts Only - Protection: Low (IIS Process) -...
  2. gregas

    Issue connecting/creating : Server Error(80070005)

    Hi, Thanks in advance for the response. SUMMARY: I am having trouble creating a project on a development web server. When creating the project in VInterDev, I get a "Server Error(Error Code: 80070005). [No space between the "Error" and "(Error Code)"] Here are some...
  3. gregas

    Access 2000: Win2K vs. Win98

    Thanks all. Got it sorted. Turns out the project uses DAO 3.51 AND Access 9.0 Object Lib. So, once those components are on the final production machine -- should be good to go. Thanks again. asg
  4. gregas

    Access 2000: Win2K vs. Win98

    Hello I have an Acc2000 database that runs a simple query. The query was developed on a Win2K machine -- needs to work in BOTH Win2k and Win98. Right now, there is an error: "Unrecognized database format" What components are missing? Shall I use P&D Wizard to distribute the...
  5. gregas

    ODBC SQL Driver (Login) issue

    Don- Thanks for the reply. Turns out the development server's IIS was fiddled with -- had to reset my DSN entries -- all good now! Cheers -asg
  6. gregas

    Displaying elements of XML text from SQL

    Thanks in advance for the response! Here's the situation: I have an XML string being stored in a SQL 7 database that I would like certain parts (elements) of to be displayed on a web page. Essentially, I'd like parse the string and get some info out of it. The exact design of the column is...
  7. gregas

    ODBC SQL Driver (Login) issue

    I switched to basic auth in IIS. Yet, I am still getting the problem. asg
  8. gregas

    ODBC SQL Driver (Login) issue

    I've got a 3-tier ASP/VB/SQL system with standard login. Three different environments: local, test, production. Test and Prod login works fine. Logging onto the local environment (my machine) generates this error: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT...
  9. gregas

    Redirect from within a popup window ?

    I have a form in a popup window that creates an object (namely, a "Prospect"). The form creates the object fine, but when I click "Save" I want to redirect the user to another form -- within the popup window -- while passing some of the newly created object parameters (such...
  10. gregas

    IIS Lookup Table help!

    Apologies for clogging the queue! Solved my own issue again. The DLL required is: lkuptbl.dll (FYI)
  11. gregas

    IIS Lookup Table help!

    Anyone seen this before? Error Type: Active Server Pages, ASP 0134 (0x80004005) The object has an invalid ProgID of 'IISSample.LookupTable'. I am trying to debug a SQL/VB/ASP app locally and the application cannot load because the global.asa stops at the first line of lookup table code. Any...
  12. gregas

    Remove Duplicates - NEW TWIST

    I am pleased to announce that the issue is solved! To all that responded -- thank you! This was my first post to Tek-Tips and I will definitely use this in the future. Due to some referential integrity, deleting the duplicate records from Customer was NOT enough! The final solution required...
  13. gregas

    remove dupes qry

    I am pleased to announce that the issue is solved! To all that responded -- thank you! This was my first post to Tek-Tips and I will definitely use this in the future. Due to some referential integrity, deleting the duplicate records from Customer was NOT enough! The final solution required...
  14. gregas

    Remove Duplicates - NEW TWIST

    Excellent, thanks Joe -- that definitely works! It actually turned out to be a little nastier with some other table dependencies (db integrity) and such. I implemented a similar solution with multiple queries and a macro. Again, gracias! -aaron
  15. gregas

    Remove Duplicates Query

    Terry, The big issue I'm having is that I need to preserve the CustomerIDs from the records that I do keep. As there are NO distinct records in the Customer table to begin with, I simply cannot select distinct records. If I run a long SQL statement with all the fields (except CustID, of...
  16. gregas

    Remove Duplicates -- NEW TWIST

    Much thanks for responding. As you can attest, the design of the table is attrocious. Yes, the PK is CustomerID and it does allow duplicates. Not only that, but it's type double (not int). Unfortunately, that's the way this table is set up and I have to deal with it as such. Just to let you...
  17. gregas

    Remove Duplicates -- NEW TWIST

    My apologies for not being more clear the first time -- I figure this will change the responses this time. The table in question is a Customer table that tracks Customers as they enter data from a Web form. I did not design the table nor the database (nor can I change the existing design)...
  18. gregas

    Remove Duplicates - NEW TWIST

    My apologies for not being more clear the first time -- I figure this will change the responses this time. The table in question is a Customer table that tracks Customers as they enter data from a Web form. I did not design the table nor the database (nor can I change the existing design)...
  19. gregas

    remove dupes qry

    Thanks for responding. My apologies for not being more clear the first time. The table in question is a Customer table that tracks Customers as they enter data from a Web form. I did not design the table nor the database (i.e. I cannot change the current design of the table), but the way it's...
  20. gregas

    Remove Duplicates Query

    Thanks for responding. My apologies for not being more clear the first time. The table in question is a Customer table that tracks Customers as they enter data from a Web form. I did not design the table nor the database, but the way it's set up currently -- Customers enter data on a form...

Part and Inventory Search

Back
Top