Visual Studio :: Cannot Run More Than 2 Database Integration Tests
Nov 24, 2010
I have written some database integration tests in the format of MS unit test. If I run each test, it runs fine. If I run 2 integration tests, it runs fine. However, if I runs 3 or more test at the same time, one test will show "In Progress", and other shows "Pending", basically, it does not make any progress at all, stays there forever. I turned on SQL Server Profiler, it does not show the test hit the database at all.
I have a unit test that reads from an .xml file and it works fine on my local machine.However, in TFS when I create a new build it gives the following exception:
Failed GetArticleByIdTestOptimal Test method Test.ArticleSystemTest.GetArticleByIdTestOptimal threw exception: System.Xml.XmlException: ImportFromFile filePath=[.Articles1to5.xml]. ---> System.IO.FileNotFoundException: Could not find file 'c:uildareaTestResults fservice 2010-10-19 11_52_19_Any CPU_ReleaseOutArticles1to5.xml'..
Is there some reason why a unit test could pass locally but not in TFS? I've verified that the file is on the build server.
I recently came accross the following article on Stephen Walther's website
[URL]
Basically, it provides some excellent guidance on how to integrate your Javascript tests into Visual Studio. I followed the steps in the article and successfully managed to test Javascript methods using Visual Studio tests.
I am unable however to unit test JQuery methods (I get errors such as "window" undefined). I was wondering if anyone has successfully managed to test jQuery methods on the server using the above link?
I need a Continuous integration tool that will support both .Net Unit tests and Javascript unit tests and perform the builds.It looks like my main options are CruiseControl.NET using JUnit and NUnit or Team City and JS Test Driver.
Are there any other options and which ones have you used or had good or bad experiences with.
Need a method to integrate Stylecop in a msbuild task. We are using ccnet for cotinuous integration process. I want to integrate the stylecop results in the process.
I have been working in isolation for a very long time, and over the past few monts a new CTO introduced me to Ant and CI (however in Java, with him doing the dirty work)..just enough to make me see the benifits. Now I'm back to .Net (left off at 1.1, started again after a few years in PHP) and since I got the hang of asp.net 3.5 (mvc) I'd like to expand my knowledge and tools a bit.
Found a copy of "Expert .NET Delivery Using NAnt and CruiseControl.NET" which sounds like exactly what I'd like to study to know how to create my own automated builds and Continuous Integration, but then I realized this book was written in the .net 1.1 days (yes yes, I know a lot will still apply..I just like to be on the bleeding edge of things) Can anyone make some recomendations, give some tips, advice (and even critic) on this train of thought?
I know both these software are old and that I can update to newer version. But I need to do it with those software in particular.I have Visual Studio 2005 and Visual SourceSafe 6 installed on my computer. When I try to open Visual SourceSafe 6 database using Visual SourceSafe 6 directly, I have no problem at all.Then I try to open a project solution I took from SourceSafe using Visual Studio 2005. Right away I receive this messageThe solution appears to be under source control, but its binding information cannot be found. It is possible that the MSSCCPRJ.SCC file or another item that holds the source control settings for the solution, has been deleted. Because it is not possible to recover this missing information automatically, the projects whose bindings are missing will be treated as not under source control.
Then an invite to chose a SourceSafe Database open. I click on BROWSE. First thing I noticed : The SourceSafe available databases list is empty (while I remind, it's not in SourceSafe 6. I can see there the COMMON database and the VSS database which is located on a different server on our network. Before that, I went in TOOLS->OPTIONS->SOURCE CONTROL, and make sure Visual Source Safe was selected as the Plug-in to use for a Source Control).So I click again on Browse, and locate my srcsafe.ini file. Everything is OK. It evens confirm me that my database path is \dev2k3programmationVSS and that my database name is indeed VSS. So it found it. I then click on OK.
But when I do, the Database is not added to my available list, at all. The result, I can never select a source control, ever, which end in me not being able to work connected to the main source control of our network. Everything is working fine on every other computer in our company. Only this one have problem.Did I give enough description to my problem? I really need help on this one, because working disconnected from Source Safe can give a lot of pain to our team. Can anyone give me an hand? If you need any more info, just ask.
In my project we use UnitTests (MsTest). We run them manually and in the build script.But for some environments where we deploy manually.We are in the need of having some smoke tests. At the moment I made this smoke tests "manually" (Login, create an user, create a licence, create a product, etc). I know I can run unit tests from command line or from visual studio but...Do you know if is possible to run these mstests (or probably a small subset) from an .aspx page and show the results?EDITED: wondering if mstests or something is able to run the tests and have something visual to show in an .aspx page similar to a list of tests passed and tests failed...I am thinking on running only a small subset of tests (5-6)
I need to connect to a third-party hosted database. The VPN tunnel is already set up and an IP address has been provided to me, but I'm not sure how to access the database through the tool.
I have tried the Database Solutions tab > Data Connections > and the one listed under this is called "ASPNETD8.MDF", but when I click on this, I get this error message:
"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"
I want to use a source control in VS2010, I know my best bet is TFS, but at the moment TFS(can't afford ). As i understand TFS is the new VSS_2005(can afford)Can VSS 2005 be use as a source control for VS 2010 solutions/projects?
I have a website I''m developing and want to add an SQL databse to do some testing on my local pc. When I go through the process of adding an SQL Server DB it says
'Failed to generate an instance of SQL Server due to a failure in starting the process for the user instance. The connection willl be closed.'
how to isolate the database for the tests as in unit testing?For example my tests are deleting records from the database. I would like to isolate my database in each test a transaction otherwise I will have to deploy a new database each time I want to run my tests...
I used Data Connections to connect a database but couldn't make it.
1. I used Windows Authentication to log on to database, my database's name wasn't displayed in Select or enter a database name dropdown menu, so I enter my database's name then I pressed Test Connection button, it said "This connection can't be tested because the specified database doesn't exist or isn't visible to the specified user."
2. So I used SQL Server Authentication to log on to the server,then I put my database's name in Select or enter a database name dropdown menu box, then press OK it's said that "Login failed for user 'xxx' or Try to press Test Connection button it said that "Login failed for user 'xxx'.
I'm sure that I use a correct username and password and I think it's a problem about VS can't see my database in SQLExpress2008.
I used Visual Studio 2008 in Windows 7. The problem is, I cannot create new database (make new connection). Is it that I have to install any software or tools to support or repair the problem.
i am new to .net field , currently i am using Visual Studio 2005, Sql Server 2005(not express editions). Now while creating a website when i want to add a database through VS 2005 >App_Data>"New Item">Sql Database...i am getting an error "Connections to SQL Server Files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URl: http:go.microsoft.com/fwlink/?linkID=49251"...
secondly if i add a database through Sql Server how it will add in website that i created in VS 2005.
I have Visual Studio 2008 and SQL Server 2008 but when i create an SQL Server Database i read that i need SQL Server Express 2005, Why????.....how can i resolve this question without install it but using 2008 version?
I am having an issue with my Windows forms application. I am trying to insert a record into a table. It says the rows affected is 1 however the row is not in the database. Here is my code:
I do not have SQL Express installed as I already have SQL 2008 (Developer) on my Dev machine. When I say add new item -> SQL Database, give it a name and say "yes" to it creating me the app folder I then get the message that I need to have SQL Express installed and I can download it from blah blah.
Why will it not let me use/recognise my installed instance of SQL Server?
