Moving Hosts - DB connection issue

This is a good reference.  Have you seen this?

http://wiki.earlyimpact.com/how_to/move_store

 

I'd suggest going to any page, let's say viewcategories.asp and examine the included file references.  Poke around and see if you can find another db connection.  it's going to be there somewhere.

I'd expect that the location of the SQL server would be different (or if using a DSN, maybe it would have a different name), so to check that you're hitting the new db, try this:

In viewcategories.asp, find:

'// Page Count iCategoriesPageCount=rs.PageCount

Just above that, look for something like the following (stock PC line):

rs.Open query, conntemp, adOpenStatic, adLockReadOnly, adCmdText

In this case, "conntemp" is the db connection string. As per Greg's comment, this connection string might have been changed to some other constant. What'ever constant you find there, try adding the following just above it (again using the stock PC constant name here):

response.write("conntemp=") & conntemp response.end

Then hit viewcategories.asp directly in your browser (the above will only show on the "no parent") category page, not any other category/sub-category page.

This will show you the db connection string being used here. Compare that with the new host location and what you have in storeconstants.asp. If it's different, then you should be able to trace it down from there relatively easily. If it's the same, then you'd need to try the same sort of thing on a db call that's directly related to whatever data appears to be coming from the legacy location rather than the new one.