AJMazurek's Q&A profile

• SQL Server Could not open a connection to SQL server error on Vista

  Hey, After install Visual Studio 2005 (with SQL sever express) on recent Vista build, trying to connect to a local sse database file from Data Source Window (accessible from Data/Show data source window) gives this error: --------------------------- Microsoft Visual Studio --------------------------- An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fa ...Show All

• .NET Development Upgrading from SQL 2000 to SQL 2005: Data Adapter Wizard Help.

  I had some trouble with an upgrade to SQL 2005 June so I unistalled both SQL 2005 and SQL 2000. I then re-installed SQL 2005 and the .Net framework. I am still having trouble with the INSERT, UPDATE, and DELETE statements generated in the Data Adapter Configuration Wizard of VS.NET. Here are the steps I took the first go-around; Installed SQL 2005 Express Edition Installed .Net framework 2.0 Installed SQL Serice Express Deta ...Show All

• Visual C++ how to format a two or one digits number in a two char string?

  Ok, maybe this is a very stupid question but wich is the cleanest way to convert an int to a System::String with always at least 2 chars... Now, I do this: String* convertTo2CharString(int num){ if(num<10)   return String::Concat(S"0", Convert::ToString(int)); else   return Convert::ToString(int); } I suppose that with the String::Format, I can do it with one line of code but I don't know how. Tnx. ...Show All

• Visual FoxPro How do I open an xls file I exported from a command button?

  I have successfully figured out how to export a selected portion of a table to an xls file ( :) ) from a command button. The icing on the cake would be for it to also automatically open the sheet for viewing by the user. I have figured out how to do this via a hyperlink, but now there's an additional click involved and it doesn't seem as elegant. Any ideas Thanks! wait! Nevermind! I figured it out...okay, well in reality I found an exa ...Show All

• Visual C++ (MSVCRT) _iob disappeared?

  What can I do to replace the functionality of _iob Seems to be missing in MSVCR7/8 (using VS2005). Error 1 error LNK2001: unresolved external symbol _iob main.def In my def, I'm redirecting this export as such: _iob=MSVCR80._iob I also tried: _iob=MSVCRT._iob ...Show All

• Visual Studio Team System How to get target information during running a Test project

  Hello all, I have set up a Team Build Type to build my solution of multiple configurations, such as "Debug|Win32", "Release|Win32", "Debug|Pocket PC 2003", "Release|Pocket PC 2003" and so on. Within the same solution, there is a Test project which perform a BVT test. I config the Team Build Type to run this BVT test after building in TFSBuild.proj as following: ...     <RunTest>true</RunTest> ...   ...Show All

• SQL Server Adding nongrouped data into Group row

  This may sound a bit weird...but here it goes.  I have in my SSRS 2005 report one table.  In that table I have: Header1 Groupp1 Footer1 Some of the fields in the Group look like this: Company Number    Branch    FeeGoal  The problem I have is FeeGoal.  It comes from a table that is simply joined to my main dataset (via the dataset's stored proc) on company number.   So ...Show All

• Windows Forms Direct ADO instead of Web Service

  Has anyone ever re-written the webservice data provider for TaskVision to be just a another class in the main TaskVision project so that TaskVision can just go directly to SQL to get it's data instead of through a webservice. For the purposes o ...Show All

• Visual Studio Team System All tests failing with "Can't save results of the run since ResultFilePath is null."

  Has anyone else run into this problem My unit tests were fine yesterday, then today VS kept hanging while trying to the load the tests in the Test View. In the past, I removed then re-added a new Unit test project with success. However after doing that, I get "Can't save results of the run since ResultFilePath is null" for every test I try to run. Little help Thanks, Peter I need some mor ...Show All

• Visual C# invalid cast

  This piece of code works fine and needs no explicit cast in vb.net. itemId = arrCart(cartId, i) When I converted it to C#, however, it complained that it cannot do the implicit conversion. So I tried: itemId = (int)arrCart[cartId, i]; But I get an exception error read: Specified cast is not valid. itemId is an integer and arrCart is a two dimensional array object: int itemtId; object[,] arrCart; Can anyone tell me how to correct this ...Show All

• Visual Studio Team System Can I run a query as a data source to a SQL Server database?

  Hi, all. Is it possible to run a query in the data source rather than connect it to a table I have a SQL Server database that I would like to run a query on rather than select from a specific table. Thank you. Yulia, I beleive you are asking about Data Driven Unit Tests. It is not possible to specify a query but you can create a view or stored procedure on your SQL server and specify the name of the v ...Show All

• Visual Studio Team System Iteration Names Cached - By Design?

  When I change an iteration name in the Team Explorer (Team Project Settings -> Classifications), the new name does not display in my work items until I get out of Visual Studio and fire it back up again. I thought maybe it was cached by design, but if I change the ProjectModelHierarchy names, a Work item's "Classification Area" updates without having to get out of Visual Studio. It this a know "issue" Your first case was corre ...Show All

• .NET Development How to enable DataGridView updates for xpath extract results

  Hi, I wrote a program to extract part of XML elements, fill in the dataset with extracted elements,and display them in dataGridView (C++). for example : to extract only ADDRESSES and display the Id,Street,Postcode, city and country as the table columns in dataGridView <MEMBER> <GENDER>FEMALE</GENDER> <AGE>35</AGE> - <ADDRESSES> - <ADDRESS> <ID>1</ID> <STREET>cranbrook ave</S ...Show All

• Visual C# ASP.NET - Atlas

  ASP.NET “Atlas” is a package of new Web development technologies that integrates an extensive set of client script libraries with the rich, server-based development platform of ASP.NET 2.0. “Atlas” enables you to develop Web applications that can update data on a Web page by making direct calls to a Web server — without needing to round trip the page. With “Atlas”, you can take advantage of the best of ASP.NET and server-side code while doing m ...Show All

• SQL Server Error during set partner statement (SP1)

  Hi! I have the following error during setting partner on mirror server Msg 1431, Level 16, State 4, Line 1 Neither the partner nor the witness server instance for database "masterserver" is available. Reissue the command when at least one of the instances becomes available. The partner is available through telnet. I've also checked ports vai netstat and have no found errors. There are two noteworthy erros in the error log ...Show All