I am attempting to move my BVC5 sp2 carts from a 32-bit server to a 64-bit server due to high memory usage. (The 64-bit OS unit supports 16GB vs 3GB on 32-bit OS and I am using 2.8GB all the time on the 32-bit OS installation.) When I install the Carts, all seems to go well and install correctly but when attempting to log in I get an error message: "Object reference not set to an instance of an object."

The cart is on Server#1 and the SQL database is on Server #2.

Server #1: Server 2003 64-bit Enterprise w/sp2, ASP 2.0 configured to run as 32-bit, IIS configured to run as 32-bit, 32-bit Server 2005 SQL installed (BVC5 could not find 64-bit SQL, so I used 32-bit. BVC5 would not connect to a local install of 32-bit SQL on 64-bit OS but would connect to 32-bit SQL on 32-bit OS. BVC5 would not connect to a 64-bit SQL on 64-bit OS).

I finally seem to have gotten very close (it installed w/o errors in the installer). Any ideas on the Object ref error? Has anyone put BVC5 on a 64-bit OS? If so how did you do it?

Stack Trace:
[NullReferenceException: Object reference not set to an instance of an object.]
BVSoftware.Bvc5.Core.Utilities.UrlRewriter.RewritePath(HttpApplication& app, Uri sourceUrl) +311
BVSoftware.Bvc5.Core.Utilities.UrlRewriter.app_BeginRequest(Object sender, EventArgs e) +69
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

Scott Tafel
WindRider Technology
307.742.6305

Thanks for the reply! I worked over the SQL port listener and it works now.

SQL Server Configuration Manager >> SQL Server 2005 Network Configuration: Named Pipes Enabled, Listen All=Yes, IP Address for listening is correct, TCP Dynamic Port # set (I used 1111), TCP Port = 1433. The default instance listens to port 1433 and the named instance to 1111. The default of "Named Pipes" is disabled, which would prevent the connecting string from using a named connection (you would need to specify the IP address and port instead).

This problem related to SQL being on one server and the websites on a different server. After you configure it to listen to ports, go to the Website server and use the portqry command to test the SQL servers ports. You can just type portqry and the portqry help will give you the switches/options to use. You can also check out http://support.microsoft.com/kb/310298. You may need to open the SQL ports on the firewall if your SQL server has the firewall turned on. For more info on SQL not listening follow this link: http://search.microsoft....&q=sql+not+listening