running actual source

Apr 14, 2009 at 8:57 PM
Hello again,
I have two, probably related problems:
When I try to open Mixvideos project from 30887, message about dbproj appears. It look like dbproj needs some version of VS I don't have. Is it mandatory?
And:
If I ignore this error, it compiles ok, but error about connecting to database appears>
 

Server Error in '/' Application.

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

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.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Source Error:

Line 30:                 select s;
Line 31: 
Line 32: return projectSites(query).FirstOrDefault();Line 33:         }
Line 34: 

Source File: C:\oxite-30887\Implementations\MIXVideos\Oxite.LinqToSqlDataProvider\SiteRepository.cs    Line: 32

Can you kick me into right direction?
Apr 14, 2009 at 9:04 PM
Edited Apr 15, 2009 at 4:42 PM

Ok, now I found similar post here: http://oxite.codeplex.com/Thread/View.aspx?ThreadId=50289 . Sorry for duplicate. Is there any solution for those poor childs (like me) without VS for DB developers (like running scripts in database project directory?)

 //edit

I fixed path to correct database. Now I have another problem, query: 
SELECT [t2].[PostID], [t2].[CreatorUserID], [t2].[Title], [t2].[Body], [t2].[BodyShort], [t2].[State], [t2].[Slug], [t2].[CommentingDisabled], [t2].[CreatedDate], [t2].[ModifiedDate], [t2].[PublishedDate], [t2].[SearchBody], [t3].[UserID], [t3].[Username], [t3].[DisplayName], [t3].[Email], [t3].[HashedEmail], [t3].[Password], [t3].[PasswordSalt], [t3].[DefaultLanguageID], [t3].[Status], [t5].[SiteID], [t5].[AreaID], [t5].[AreaName], [t5].[DisplayName] AS [DisplayName2], [t5].[Description], [t5].[CommentingDisabled] AS [CommentingDisabled2], [t5].[CreatedDate] AS [CreatedDate2], [t5].[ModifiedDate] AS [ModifiedDate2]
FROM [dbo].[oxite_Area] AS [t0]
INNER JOIN [dbo].[oxite_PostAreaRelationship] AS [t1] ON [t0].[AreaID] = [t1].[AreaID]
INNER JOIN [dbo].[oxite_Post] AS [t2] ON [t1].[PostID] = [t2].[PostID]
INNER JOIN [dbo].[oxite_User] AS [t3] ON [t2].[CreatorUserID] = [t3].[UserID]
INNER JOIN [dbo].[oxite_PostAreaRelationship] AS [t4] ON [t2].[PostID] = [t4].[PostID]
INNER JOIN [dbo].[oxite_Area] AS [t5] ON [t4].[AreaID] = [t5].[AreaID]
WHERE ([t2].[State] <> @p0) AND ([t2].[PublishedDate] < @p1) AND ([t0].[SiteID] = @p2)
ORDER BY [t2].[PublishedDate] DESC

Returns SQL Error: Invalid object name 'dbo.oxite_PostAreaRelationship'.

Coordinator
Apr 16, 2009 at 4:35 AM
Sadly, no.  Not at the moment.  MIXVideos was developed by our team and we all have DB Pro installed.  Normally, you would just be able to use the MDF provided in the root Oxite branch, but they're not in sync at the moment as we've stopped workin on MIXVideos and have been making some schema changes to Oxite.  Once we get them back in sync you should be able to use the main MDF to run it.  For now all you can do is look at the code, sorry.  :(
Coordinator
Apr 16, 2009 at 8:50 AM
I've updated the App_Data file now to not only be the right schema, but also to include all the session data for MIX06 through MIX09, so you can run the exact site that is currently up on videos.visitmix.com
Apr 16, 2009 at 11:24 AM
Thanks god..err...Duncan.