AbleCommerce Shopping Cart Software

Hi,
I'm having trouble getting the install for the 30-day trial to finish on a box running Vista, VS2005 and SQL Express 2005.
This is our standard dev environment due to other projects we're currently working on.

Has anyone got this working? I can't get the install app access to the SQL Server. NT AUTHORITY\IUSR has dbo permissions, and I also created a login and gave it the following roles:
"public", "db_accessadmin", "db_securityadmin", "db_dlladmin", "db_datareader", "db_datawriter" .


I'm quite sure this is Vista specific. Anyone have any ideas?

thanks
John

It would help to know the error message you are receiving, please post it if you are still having trouble.

Is your SQL 2005 Express installed locally on the dev PC or remotely?

We can't be much help on the DB issue without an error message to go on. I will give you two gotchas for running on vista that I know of:

#1) IPv6 - if you access your install at to your local machine (like http://localhost/someurl) then Vista will send the remote caller as an IPv6 string and this triggers an exception in our IP Firewall code. For the time being you have to access the install via an IP if it's your local machine (do 127.0.0.1 instead).

#2) IIS application pool must be set to use classic asp mode rather than integrated pipelining

johnco wrote:Hi,
I'm having trouble getting the install for the 30-day trial to finish on a box running Vista, VS2005 and SQL Express 2005.
This is our standard dev environment due to other projects we're currently working on.

Has anyone got this working? I can't get the install app access to the SQL Server. NT AUTHORITY\IUSR has dbo permissions, and I also created a login and gave it the following roles:
"public", "db_accessadmin", "db_securityadmin", "db_dlladmin", "db_datareader", "db_datawriter" .


I'm quite sure this is Vista specific. Anyone have any ideas?

thanks
John

John,

It sounds like you're trying to connect to SQL Server using a Windows Login account where you may want to try using a username and password that you can configure for the respective Database within SQL Server. You can review various connection string options at http://www.connectionstrings.com if needed.

I am trying to do the same thing as the first post. Just trying to get a 30-day-trial to install/run on my local machine for the first time

I opened up the project in Visual studio 2008/Vista OS and trying to get it to run through the debugger. I am using the included .mdf database file with the database.config set to:

<connectionStrings>
<add name="AbleCommerce" connectionString="Data Source=.\SQLExpress;Integrated Security=True;AttachDbFileName=|DataDirectory|\AbleCommerce.mdf;User Instance=true;" providerName="System.Data.SqlClient" />
</connectionStrings>

When I run the debugger for the first time it jumps to the page /Install/UpdateKey.aspx and gives me this sever error:


Server Error in '/ablecommerce' Application.
--------------------------------------------------------------------------------

Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[NullReferenceException: Object reference not set to an instance of an object.]
CommerceBuilder.Services.AbleCommerceHttpModule.a(Object A_0, EventArgs A_1) +3955
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.1434; ASP.NET Version:2.0.50727.1434

Any ideas? Thanks!
~Josh