SVN 206 - General development

BugNET Forums

Forum Development General develop... SVN 206

1/16/2007 12:21 PM

	Odiggity
26 posts

SVN 206

When I run the project I get the following:

Could not find stored procedure 'BugNET_Role_GetProjectRolesByUser'

Not sure how to get it if it's available on the SVN.

1/16/2007 1:22 PM

	admin
634 posts
bugnetproject.com

Re: SVN 206

I have made a fair number of database changes lately, are you using the test database?

Davin Dubeau
BugNET - Core Developer

1/25/2007 1:52 PM

	Odiggity
26 posts

Re: SVN 206

Been gone for a bit. I did update to v210 today and re-checked my web.config. I had it set to a database on a seperate SQL Server, so I don't think it's using the test database. That's my bad. I'm trying to get it to use the BugNET_WAP\App_Data\BugNet.mdf, but without success. Any suggestions?

1/25/2007 2:25 PM

	Odiggity
26 posts

Re: SVN 206

When trying to connect to the sample/test database I would get the following:

"Failed to generate a user instance of SQL Server due to a failure in
starting the process for the user instance. The connection will be closed."

I was able to connect to the mdf after changing the connection string in the web.config (User Instance=False) and it opened up the main BugNet app with Wahoo, rr, etc..

Also had problems with connections in VS2005 and opening/reviewing the Data Connection to BugNet.mdf. Modified the connection string as above and was able to navigate through the database.

7/17/2007 7:19 AM

	Odiggity
26 posts

Re: SVN 206

Follow up, I realize that Shared memory has to be enable in SQL 2005 and the User Instance = True. This will allow the use the MDF from the app directory without having to go into SQL 2005 and attaching the database. This also allows me to run the release under IIS and SVN versions via VS2005 to see what's coming and/or to implement it on our main release.

Page 1 of 1

Forum

Development

General develop...

SVN 206

Forum Policy

These Discussion Forums are dedicated to the discussion of the BugNET issue tracker.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:
1. No Advertising.
2. No Flaming or Trolling.
3. No Profanity, Racism, or Prejudice.
4. Site Moderators have the final word on approving/removing a thread or post or comment.
5. English language posting only, please.