The business owner wants to keep the live pages at our original web host account and test the new pages in the WestHost account (dedicated IP). Therefore, I would assume the domain name has not been transferred.

I am having a few problems with the subdomain and not certain if it is the settings or because the domain is not transferred. I am open to suggestions about a better way to handle the WebHost subdomain situation.

################
Problem 1
I have already noticed that the program links in Site Manager, such as phpMyAdmin, do not work because they use the domain.com and not the subdomain. I can get there by entering the subdomain URL in the browser.

This makes me wonder if some of the other automatically installed programs, such as Perl::DBI, will not work from the subdomain scripts.

Jalal, I search and read a lot of your posts. With every search, it may not lead to what I needed, but I learn something new. I see the common sense of setting the domains like you mentioned. Unfortunately, I don't have the confidence to go messing about in that direction (yet); and fortunately, I didn't need to (yet).

I did get the database connection working and I wanted to share my solution here for when someone else runs into the same error.

In the script's config file where I was entering 'localhost', I had to add:
"host=localhost;database=theSpecificDatabaseName".

I figured it out by creating a Perl script that was not connected in any way to the main shopping cart program and did nothing but connect to the database. Once I could confirm it worked, I knew it had nothing to do with the subdomain issue.

Troubleshooting gets me nuts and loses me money on contract labor; but, I've got to admit that solving the puzzle is part of my addiction to web design.