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
|
|
|
|
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. |
|
|
|
|
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
|
|
|
|
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. |
|
|
|
|
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 <!-- [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) -->
|
|
|
|
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. |
|
|
|
|
Rank: Member
Joined: 2/25/2008(UTC) Posts: 111
|
Would it be better to create a test website on the server via ftp?
|
|
|
|
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?
|
|
|
|
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.
|
|
|
|
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
|
|
|
|
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.
|
|
|
|
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?
|
|
|
|
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.
|
|
|
|
Rank: Member
Joined: 2/25/2008(UTC) Posts: 111
|
dean, we have both of those thanks
|
|
|
|
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>
|
|
|
|
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 |
|
|
|
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. |
|
|
|
|
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.
|
|
|
|
Rank: Member
Joined: 2/25/2008(UTC) Posts: 111
|
I have sql express configured correctly, maybe I do not have IIS configured right?
|
|
|
|
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& 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 </PRE>[/code][/td][/tr][/table]
|
|
|
|
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.