I had the misfortune of a SQL server crash. I re-installed the SQL server from ground up using W2K3 server w/ latest SP and installed SQL 2008 instead of the SQL 2005 since I could not find the older SQL 2005 disks. From a backup from 3 months ago I extracted the Product cart DBs (so the only difference would be the changes in pricing) and re-attached those to the SQL 2008 server. Made the changes to the connection string to point to the new server and tested.

 

I get no errors (so far as I can tell using the control panel. I can see the products and make the changes in the price without an errors).

 

However when I browse the site as a shopper would I get an error when I go into the detail page of the product (usually by clicking the link via description of the product). The error is as below.

 

***********************************************************************

Error At 11/10/2010 2:41:21 PM
* CustomerRefID: 419150932-144121
* Session ID: 419150932
* Error Number: -2147217865
* Error Source: Microsoft OLE DB Provider for SQL Server
* Error Description: Invalid object name 'pcSearchFields'.
* Last Query: SELECT DISTINCT optionsGroups.OptionGroupDesc, pcProductsOptions.idOptionGroup, pcProductsOptions.pcProdOpt_Required, pcProductsOptions.pcProdOpt_Order FROM products INNER JOIN ( pcProductsOptions INNER JOIN ( optionsgroups INNER JOIN options_optionsGroups ON optionsgroups.idOptionGroup = options_optionsGroups.idOptionGroup ) ON optionsGroups.idOptionGroup = pcProductsOptions.idOptionGroup ) ON products.idProduct = pcProductsOptions.idProduct WHERE products.idProduct=6 AND options_optionsGroups.idProduct=6 ORDER BY pcProductsOptions.pcProdOpt_Order, optionsGroups.OptionGroupDesc;
* RequestMethod: GET
* ServerPort: 80
* HTTPS: off
* LocalAddr: 192.xxx.xxx.xxx

* HostAddress :192.xxx.xxx.xxx
* UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; .NET CLR 1.0.3705; .NET CLR 1.1.4322; InfoPath.2; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)
* URL: /pc/viewPrd.asp
* FormData:
* HTTP Headers:
*****************************
HTTP_CONNECTION:Keep-Alive
HTTP_VIA:1.1 XXXXXX

HTTP_ACCEPT:image/gif, image/jpeg, image/pjpeg, image/pjpeg, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, application/x-silverlight, application/xaml+xml, application/vnd.ms-xpsdocument, application/x-ms-xbap, application/x-ms-application, application/x-shockwave-flash, */*
HTTP_ACCEPT_ENCODING:gzip, deflate
HTTP_ACCEPT_LANGUAGE:en-us
HTTP_COOKIE:pcfront%5FvisitedPrds=%2A6%2A57%2A120%2A56%2A55%2A; ASPSESSIONIDSSRTSDST=DFMLLPIBEFCMKEEJDPPHDNIL
HTTP_HOST:www.xxxxxxxxxxxx.com
HTTP_REFERER:http://www.xxxxxxxxxxxxx.com/pc/home.asp
HTTP_USER_AGENT:Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; .NET CLR 1.0.3705; .NET CLR 1.1.4322; InfoPath.2; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)
*****************************
------------------------------------------------------

Can anyone help? I thought it could be the SQL 2008 instead of the SQL 2005, as that seems the be the only thing that has changed. I had a difference SQL UserID / PWD previously which I recreated. I changed that to the 'SA' user in the connection string without any difference.

 

I have also checked rights and tried both Master and the Product cart DBs as the default DB for the User ID....no difference.

 

Any ideas would be most welcome!

However, I have a programming background and I have worked with SQL server and I believe it is an SQL issue. Since that is the only thing that has changed. The backup from which the DB was restored was a working backup i.e. the site was working without any issues. Added to this the only thing we usually change is the price. So no new products etc.

 

I would appreciate any insight!

 

If the economy was better I would not have hesitated using your recommendation as the 1st option.

 

I decided to recreate the batabase by running the script in the Database folder. I have completed that successfully, and am trying to log into the control panel and I need the userid/pwd. Since it has been a while since I initially did it I and after reading the manual quickly (I may have missed something) I believe I have to use the temporary userid and pass work I was given initially by Early impact. I tried using it and it does not allow me in.

 

Did I miss something??

 

I also went to browse the site and I can get to it but obviously there are no products.

 

 

Any ideas ont eh userid/pwd??

 

Thanks