An error occurred on the server when processing the URL. Please contact the system administrator

Ok, have a client. Site is running fine. I went to develop locally on a new laptop running IIS 6. Browsed through the site locally, then hit the following message:An error occurred on the server when processing the URL. Please contact the system administrator.
I couldn't figure it out, and why did I see this generic message. To resolve it took some time, but here's what I found:
-----
Programmers Earn extra money on the side
-----

-Open up IIS 6
-Choose your site. I have multiple sites set up on different ports
-Look at the "IIS Home" for this site.
-Double click on the ASP icon
-Expand "Debugging Properties"
-Change "Send errors to browser" = true
-Reload your page.

Here's the new error:
Active Server Pages error 'ASP 0131'

Disallowed Parent Path

/xyz/zzz.asp, line 4

The Include file '../1243.asp' cannot contain '..' to indicate the parent directory.

I tried to make a quick fix with some other options, but it didn't work. Again, it's another setting in IIS 6. Here's the workaround.

Here's the reason: By default, the Parent Paths option is enabled in IIS 5.0, but it is disabled by default in IIS 6.0.

http://support.microsoft.com/kb/332117

Note: I could not recreate the steps below. For me, I had to go back to the ASP Icon and look under the category "Behavior." There I found the option to "Enable Parent Paths."

WORKAROUND
To resolve this problem without changing the application: 1. Click Start, click Administrative Tools, and then click Internet Information Services (IIS) Manager.
2. Double-click your computer name in the left pane, and then double-click Web Sites.
3. Locate the Web site and directory that houses the ASP application.
4. Right-click the application site or directory, and then click Properties.
5. Select Home Directory, and then click Configuration.
6. Click Options, and then click to select the Enable Parent Paths check box.
7. Click OK two times.

Active Server Pages (ASP) zip component

Client is looking to take multiple files such as Word documents, pdf's, etc and allow their clients to select any number of a group of files, and download them. So, because the files may be large, and there may be many, our best solution is to find something that will zip up the selected files, then present the user with the option to save it.

Research:
Look for free first

FREE
XStandard- http://xstandard.com/en/documentation/xzip/. Direct link to component: http://xstandard.com/get/qojtojqw/zip/
This tool lists out all of the commands on the home page. This allowed me to make sure it had what I needed. It looks like only 3 lines to create my zip file.

NOT FREE
WaspZip - http://www.activewebsoftwares.com/productinfo.aspx?ProductID=19
Allows you to zip and email all in one command. No specifics on the commands. I'm assuming you can just zip if necessary. Price is $396. Not worth it compared to the free.

SoftComplex - http://www.softcomplex.com/products/asp_zip_component/ - Gave a lot of information on it's capabilities. Would turn to this one prioro to waspzip. Cost is $49 for single license. Much cheaper than WaspZip

Results: We ended up using XStandard. It was simple and free. We have not had any issues with it and the commands were straight forward

Website Search engine component research

Goal here is to obtain a component in asp or .net (any) that allows us to save the indexing into SQL Server 2005.

Here are the goals:
-SQL Server 2005
-.NET or ASP
-Can schedule updates to the index
-Needs to be on a Windows 2000 or Windows 2003 server
-Will have to run once a week.
-We can choose a directory for file scans. This is not an entire site scan.

Keyoti
http://www.componentsource.com/products/keyoti-search-pro-asp-net/index.html
Price: 391.02 Single Developer license
Does not say where the indexing is stored, but references a directory.
-SQL Server 2005 - NA
-.NET or ASP - .NET
-Can schedule updates to the index
-Needs to be on a Windows 2000 or Windows 2003 server - fine
-Will have to run once a week.
-We can choose a directory for file scans. This is not an entire site scan.

OraDeveloper tools: Doesn't integrate with SQL Server, looks like it focuses on Oracle

FindinSite-MS - .NET - V1.51 : Looks like it places all in a directory

Summary: After spending an hour looking for components, it looks like we are going to use search engine builder professional. This will allow us to put our search information into an Access database. We are then going to migrate the data from there into SQL Server. It appears as though most of these search engine components are building text indexes in a directory. My assumption is that they can work on sites and on distributable disks as this seems to be a common high note on the sales pitches.

Researching how to move data from Access to SQL Server 2005 automatically

Challenge: We have an access database. This is automatically updated and generated. We want to integrate this information with our website which uses SQL Server. So, how do we do it. This blog posts some of the research.

A lot of information seems to be based around migrating from access to sql server. But, this is not what we want.

Microsoft Data Transformation Systems seems to have our solution:
Links:
Good step by step of how to set it up: http://support.microsoft.com/kb/285829
Frequently asked questions page for DTS: http://msdn2.microsoft.com/en-us/library/ms345120.aspx#dtsfss05df_topic5
The last link told me to do a search for this string for more info on Access: Creating a Package Using the DTS Import/Export Wizard
First reference: Creating a DTS Package with the DTS Import/Export Wizard: http://msdn2.microsoft.com/en-us/library/aa176533(SQL.80).aspx

NOTES: You need to specify whether you are exporting data from an instance of Microsoft® SQL Server™ to another data source (for example, a second instance of SQL Server 2000) or importing data from another data source to an instance of SQL Server. Both choices are available in SQL Server Enterprise Manager, through the Data Transformation Services node of the console tree, and as command switches through the dtswiz command prompt utility

When you want to run the package.
You can run the package after the DTS Import/Export Wizard completes, or you can schedule the package to execute on a regular basis using SQL Server Agent.

You can use the Create Publication Wizard to publish the data. For more information, see Replication Wizards.


Important Do not open a Microsoft Excel file that is being used as a source or destination during the wizard creation or execution, because a "file in use" error will occur.

Start:
I went ahead and created a new sql server 2005 database for testing. Started out by right clicking on the database name, then tasks, then import/export. I chose a microsoft access database as the source, also chose to save this package for later use. Ran the program and the tables as well as all data were created in sql server.

Now that I created it, it looks like I can use a SQL Server Agent to schedule this to run when i need it to.
http://www.microsoft.com/technet/prodtechnol/sql/2005/newsqlagent.mspx

After reading more, only the systems admin has the right to grant someone access to create an agent. This may be an issue as hosting may not allow us to run agents. Double check on hosting, otherwise, this may be a dead end.