• Toll-free  888-665-8637
  • International  +1 717-220-0012
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

3 Pages123>
emunah
#1 Posted : Monday, February 25, 2008 5:03:15 PM(UTC)
emunah

Rank: Member

Joined: 2/25/2008(UTC)
Posts: 111

We just bought bvcommerce, I attempted to run a test site on this computer, I had to load bvcommerce in visual basic so it would work, The test data was a replica of the database created for the test website. Can anyone help
Cliff
#2 Posted : Tuesday, February 26, 2008 4:14:09 PM(UTC)
Cliff

Rank: Member

Joined: 5/24/2004(UTC)
Posts: 4,147

Not exactly sure what you're asking. To help, we'd need to know about the environment you're working in; what version of Windows and IIS, etc.

BVC5 doesn't create a database with sample data for products, categories, etc., unfortunately, if that's what you're asking. Try to post more details of your problem, if you can.
emunah
#3 Posted : Wednesday, February 27, 2008 6:07:56 AM(UTC)
emunah

Rank: Member

Joined: 2/25/2008(UTC)
Posts: 111

First of all just to run it we have to use vb debugging script. Ok now that I know it does not create test data, how exactly do you transfer data into the database it created. Can you convert excel to sql or do you use xml? etc
Andy Miller
#4 Posted : Wednesday, February 27, 2008 6:48:11 AM(UTC)
Andy Miller

Rank: Member

Joined: 11/5/2003(UTC)
Posts: 2,136

Was thanked: 1 time(s) in 1 post(s)
What do you mean when you write, "we have to use vb debugging script"? The words you use do not make sense. Perhaps I don't understand the context.

After you installed the software, ran BV Site Manager, and created the site; what happened when the site first launched in a web browser? What OS did you install on? What SQL Server version?

What are you transferring data from? BV Software has programs available to transfer data from BVC2004 and SF6. The source code is available for one of them so you can create a custom importer. If you just want to enter data manually, then sign in as admin and use the admin pages to enter the data.
Andy Miller
Structured Solutions

Shipper 3 - High Velocity Shipment Processing
emunah
#5 Posted : Wednesday, February 27, 2008 10:18:20 AM(UTC)
emunah

Rank: Member

Joined: 2/25/2008(UTC)
Posts: 111

The only way to run it is to to use microsoft visual studio. When you create a test website on the computer this is what happens . It can be fixed but needs to be run in visual studio. We have enterprise manager and express. Any solution?
<H1>Server Error in '/bvc5' Application.
<HR width="100%" color=silver SIZE=1>
</H1>
<H2>Object reference not set to an instance of an object. </H2>[color=#ffffcc>

[tr ][td ]<CODE>An]</b>location of the exception can be identified using the exception stack trace below.[/code] [/td][/tr]</TABLE>
[1]<B>Version Information:[/1] Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832 &lt;!--
[NullReferenceException]: Object reference not set to an instance of an object.
at BVSoftware.Bvc5.Core.Utilities.UrlRewriter.RewritePath(HttpApplication& app, Uri sourceUrl)
at BVSoftware.Bvc5.Core.Utilities.UrlRewriter.app_BeginRequest(Object sender, EventArgs e)
at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
--&gt;
Andy Miller
#6 Posted : Wednesday, February 27, 2008 3:02:23 PM(UTC)
Andy Miller

Rank: Member

Joined: 11/5/2003(UTC)
Posts: 2,136

Was thanked: 1 time(s) in 1 post(s)
I'm pretty sure that error means that the application could not connect to the database. By chance, the first database access is in the URL rewriter, so that is how a database connection problem appears.

I don't know why running it in Visual Studio would correct the problem.
Andy Miller
Structured Solutions

Shipper 3 - High Velocity Shipment Processing
emunah
#7 Posted : Wednesday, February 27, 2008 3:21:04 PM(UTC)
emunah

Rank: Member

Joined: 2/25/2008(UTC)
Posts: 111

Would it be better to create a test website on the server via ftp?
Dean
#8 Posted : Wednesday, February 27, 2008 4:38:32 PM(UTC)
Dean

Rank: Member

Joined: 2/20/2005(UTC)
Posts: 282

• How are you installing now? (remote web server? local? how did you get the files on the server?)

• What kind of db server are you using ( example sqlexpress, sql? remote? shared?)

• Did you set up a database before you tried the install?
Marcus
#9 Posted : Wednesday, February 27, 2008 4:41:53 PM(UTC)
Marcus

Rank: Member

Joined: 11/5/2003(UTC)
Posts: 1,786

The error message above is caused by the store not connecting to the database or the database being empty. Check your connection string in your web.config file, check to make sure all your tables and stored procedures were created correctly during install, check your SQL logins to make sure they have permissions to the store database.
emunah
#10 Posted : Thursday, February 28, 2008 10:24:51 AM(UTC)
emunah

Rank: Member

Joined: 2/25/2008(UTC)
Posts: 111

dean ,

1) we installed it locally now just to test it

2) enterprise manager

and 3) I thought bvcommerce creates the database for you, or maybe I do not understand the question thanks
Dean
#11 Posted : Thursday, February 28, 2008 10:34:54 AM(UTC)
Dean

Rank: Member

Joined: 2/20/2005(UTC)
Posts: 282

Information provided is sparse.

Enterprise manager will not administrate a SQL2005 database. SQL2005 is required for BV5.

You need SQL Server Management Studio to admin a SQL2005 database.

I am not sure from your description, but you will need sql2005 or sqlexpress installed.
emunah
#12 Posted : Thursday, February 28, 2008 10:35:13 AM(UTC)
emunah

Rank: Member

Joined: 2/25/2008(UTC)
Posts: 111

Marcus,

Do I have to import a sample database from excel or whatever before I create the store? Im sorry if I sound stupid

I am used to creating my own databases and if you create a test site the software creates an empty database which cannot be filled until the store is created, correct?
Dean
#13 Posted : Thursday, February 28, 2008 11:37:13 AM(UTC)
Dean

Rank: Member

Joined: 2/20/2005(UTC)
Posts: 282

If you are installing where the proper permissions are available or locally, I do think the installer will create the database. Personally, I have never installed except on a shared server, so I had the server admin create the database first, and then I provided the connection credentials in the installer. Once the installer runs, it will create the tables, stored procedures and everything required to get the store running. At this point, the store will run without errors, but you will need to either manually enter your products from the administration side of the store, or import your products into the database. A new install does not have any sample products.
emunah
#14 Posted : Thursday, February 28, 2008 12:12:09 PM(UTC)
emunah

Rank: Member

Joined: 2/25/2008(UTC)
Posts: 111

dean, we have both of those thanks
emunah
#15 Posted : Friday, February 29, 2008 10:13:14 AM(UTC)
emunah

Rank: Member

Joined: 2/25/2008(UTC)
Posts: 111

Ok, I chatted with Marcus yesterday and this what he said to do

<SPAN style="COLOR: #1f497d">[3]Integrated security will not work because the web site runs under the ASP.NET account and that won’t have the same permissions as your account. When you run the Visual Studio web server in debug mode it’s running under your account and that’s why it works.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>[/3]

<SPAN style="COLOR: #1f497d"><o:p>[3] [/3]</o:p>

<SPAN style="COLOR: #1f497d; mso-fareast-font-family: Calibri; mso-bidi-font-family: Calibri"><SPAN style="mso-list: Ignore">[3]1)[/3]<SPAN style="FONT: 7pt 'Times New Roman'"> <SPAN dir=ltr><SPAN style="COLOR: #1f497d">[3]Use the SQL Express Manager to make sure you have BOTH SQL logins and Windows Logins turned on. By default only windows logins are turned on.<o:p></o:p>[/3]

<SPAN style="COLOR: #1f497d; mso-fareast-font-family: Calibri; mso-bidi-font-family: Calibri"><SPAN style="mso-list: Ignore">[3]2)[/3]<SPAN style="FONT: 7pt 'Times New Roman'"> <SPAN dir=ltr><SPAN style="COLOR: #1f497d">[3]Create a new SQL user account under the security area in the SQL Express Manager<o:p></o:p>[/3]

<SPAN style="COLOR: #1f497d; mso-fareast-font-family: Calibri; mso-bidi-font-family: Calibri"><SPAN style="mso-list: Ignore">[3]3)[/3]<SPAN style="FONT: 7pt 'Times New Roman'"> <SPAN dir=ltr><SPAN style="COLOR: #1f497d">[3]Make sure your new SQL account has “DB Owner” permissions to the BVC5 database<o:p></o:p>[/3]

<SPAN style="COLOR: #1f497d; mso-fareast-font-family: Calibri; mso-bidi-font-family: Calibri"><SPAN style="mso-list: Ignore">[3]4)[/3]<SPAN style="FONT: 7pt 'Times New Roman'"> <SPAN dir=ltr><SPAN style="COLOR: #1f497d">[3]Change your web.config like I showed in our chat to use the new SQL username/password[/3]

<SPAN style="COLOR: #1f497d">[3]I did all of these things and when I hit the start button nothing happens at all. I changed the code in the web config file to reflect the user id and password and named the server the computer name. We do not have sql express installed on the server we just want to see if this software will work for us and I think it should be able to run a test store on the pc without so many problems. What are your thoughts?[/3]

<SPAN style="COLOR: #1f497d"><o:p>[3] [/3]</o:p>

<SPAN style="COLOR: #1f497d"><o:p>[3] [/3]</o:p>
Noah
#16 Posted : Sunday, March 2, 2008 10:40:26 AM(UTC)
Noah

Rank: Member

Joined: 11/6/2003(UTC)
Posts: 1,903

"What are your thoughts?"

Your setup is wrong and most likely it's the database connection.

We can set up a running site here in about 10 minutes and we have hundreds of times.

Your host should be able to help you get it going on the server-side in no time at all.
Noah
birdsafe
#17 Posted : Sunday, March 2, 2008 1:48:18 PM(UTC)
birdsafe

Rank: Member

Joined: 2/21/2007(UTC)
Posts: 1,113

"We do not have sql express installed on the server" -- Marcus' number one statement was that you need to use this -- and you said you did, but yet you did not.

I think if you want to see what the software will do, you have to meet the minimum requirements for the software. SQL Express is a free download. When I tested, it worked like a charm using SQLExpress.
emunah
#18 Posted : Monday, March 3, 2008 3:08:42 PM(UTC)
emunah

Rank: Member

Joined: 2/25/2008(UTC)
Posts: 111

We do not want to install express on the server until we view the software on the pc. It is supposed to work on the pc. I have configured express correctly, i changed the web config file, when I hit the start button absolutely nothing happens.
emunah
#19 Posted : Monday, March 3, 2008 3:51:36 PM(UTC)
emunah

Rank: Member

Joined: 2/25/2008(UTC)
Posts: 111

I have sql express configured correctly, maybe I do not have IIS configured right?
emunah
#20 Posted : Monday, March 3, 2008 4:13:12 PM(UTC)
emunah

Rank: Member

Joined: 2/25/2008(UTC)
Posts: 111

this is the new error

<H2>Object reference not set to an instance of an object. </H2>
[color=#ffffcc>

[tr ][td ]<CODE>An]</b>location of the exception can be identified using the exception stack trace below.[/code] [/td][/tr]</TABLE>
Stack Trace:[/color]


[table width="100%" bgColor=#ffffcc][tr ][td ]<CODE>
[NullReferenceException: Object reference not set to an instance of an object.] BVSoftware.Bvc5.Core.Utilities.UrlRewriter.RewritePath(HttpApplication&amp; 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&amp; completedSynchronously) +64
</PRE>[/code][/td][/tr][/table]
3 Pages123>
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

©2024 Develisys. All rights reserved.
  • Toll-free  888-665-8637
  • International  +1 717-220-0012