Recent content by gregas

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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