Joannes Vermorel - MSP's Q&A profile

• SQL Server SQL 2005 Management tools

  Hi, I installed sql 2005 dev for testing sharepoint, and the management studio was not installed. Now, i am afraid to try to install it because i am thinking it may uninstall or re-install all sql components (and probably erase existing instances and sharepoint data may be lost. I have installed on an other pc the client tools, but i cannot connect to that instance, and i cannot attach the user databases (i get the 5123 error) Can anyone help me how i can install management services without messing up the sharepoint instance Even though i am not selecting database services, it tells me: The following components will be installed: -SQL server Database Services (database services) -Client Components (C ...Show All

• Visual C# How to always force rebuild C# project?

  Hey I have this C# project (.csproj extension).  I want to have it always rebuild every time, regardless.  How do I do that   Is there a flag or something I can manually throw into the project file (xml tag) Hello All. CodeJingle: I'm afraid I don't quite follow. Rebuild every time -- when, and regardless -- of what ...Show All

• Visual C++ Debug has different memory?

  Hi, I am trying to create many instances from one application, but every instances should have different event. So every time I execute my application, one instance will create a new event. I use the following lines: string temp = "A"; while(OpenEvent(EVENT_ALL_ACCESS, FALSE, (LPCWSTR)temp.c_str()) != NULL) { char now = temp.at(temp.size()-1); now ++; temp.at(temp.size()-1) = (char)now; } myEvent = CreateEvent(NULL,TRUE,FALSE,(LPCWSTR)temp.c_str()); It maybe not so effective, but it works well (I execute the output exe multiple times and I get different event for every instance) until when I want to debug the code and I run my visual studio in the DEBUG mode, and then I run the executable and I get the same event as the one ...Show All

• Windows Forms Export table data in Access Database

  Hi, I need to export a table data in Access Database into a text file using C# interface by a press of a button. I need advise on which method is required to use for this Tks. I tested on my Login Table but received the following error: private void btnAR_Click( object sender, System.EventArgs e) { //Pass the filepath and filename to the StreamWriter Constructor StreamWriter sw = new StreamWriter("C:\\JSM.txt"); string strDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("C:/Database.mdb"); string strSQL = "SELECT * FROM Login where id=" + Convert.ToInt32(Request.QueryString["User_ID"]) ; ...Show All

• Visual Studio how to automate the build process

  I want to automate my project's build process. let us assume two projects. 1. web service project 2, Windows/Web project which consumes the web service as it consumes the local web service project , visual studio attaches it to the dynamic port and updates the web references. now my problem while automating the build is to get the dynamic url and update the webreferences before the build. ...Show All

• Windows Forms c# and .mdb or any other database application

  I am working on a project that I will be using Microsoft Access to store data. When I package this software, is there a Microsoft Access Runtime I can include that will allow other users to use my software without having Microsoft Access Installed Hopefully that is clear enough. My software uses Microsoft access but if a user does not have Access or a runtime they will not be able to use my software. Thanks in advance -Mike Are you saying "access runtime" errors are not directly associated with their corresponding .dll's Are you also saying the com objects that are imported are not referencing Access application .dll's If the applica ...Show All

• Visual Studio Team System Removed Project But, source Control Still exists

  I had a TFS project that was deleted using the tfsdeleteproject command. the project was removed from TFS but, the source control root node is still there. I have verified that in the DB the project is flagged as "isDeleted". When i try to delete the root node from Source Control I get TF10169 error. How can I remove this from source control Thanks, Chris We do not support permanent deletion. Additionally, there are some bugs in the Source Control Explorer client around the display of deleted projects. Please continue discussion in this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1001787&SiteID=1 ...Show All

• Visual Studio Team System Problem: TFS Proxy not working - defaulting access as local\ASPNET

  Trying to use the TFS proxy is failing at the VS IDE with the usual: The source control proxy 'ProxyServer' is not responding, so the request will be sent to the main server. Please verify your settings. Additional information: TF15013: The requested Team Foundation Server is not registered with the proxy server. Both the proxy and master are in the same domain. Proxy.config has been updated with the correct information as per instructions. Proxy Service Account is a domain account - the same as the Master service account. This account is a member of the team Foundation Valid Users group. The strange thing is that the error message in the proxy application log is: Event Type: Warning Event Source: TFS Proxy Server Event Catego ...Show All

• .NET Development .NET Framework 2.0 does really support XPath 2.0?

  Hi to everybody, today I am facing a really tough problem. I am trying to compile the following XPath 2.0 expression : ancestor::node()[1]/position() in order to get the ordinal position of a context node within its context node-set. Here it is the simple code that I'm using: XPathExpression expression = XPathExpression.Compile(xpathExpression, nsMgr); Here it is the simple code that I'm using but when I execute the program I receive this error: ' ..... /position()' has an invalid token I have tried to evaluate the same expression with Altova and it's work. Could be a bug of the Microsoft's XPath 2.0 implementation thank you for the answer now the story is more clear. Do you have any idea how t ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Input Devices - XNA only for gamepad?

  I have a USB device (for windows) which I'd like to get running on my XBox 360. What do I need to write to get that to work I doubt that all USB devices automagically work with XNA's XInput API. The documentation seems to indicate XInput only supports the gamepad. Rob Epler wrote: Why I want to develop games AND hardware for the 360. If you want to do that, you will have to engage in an ISV/IHV relationship with the Xbox organization. XNA was created to help you build games that can run on the Xbox 360, it was not (and never will be) designed to completely open up the Xbox. ...Show All

• SQL Server "Show Group Subtotals" Reappear when opening a report

  This should be pretty simple... I have a report that I've designed in Report Builder with many groups.  I added an aggregate.  By default, it subtotals at each level.  For all the groups (but 1) I right clicked on the group header and unchecked "Show Group Subtotals". I save the report to the report server in "My Reports".  When I open the report, all of the subtotals return. Does anyone know why this occurs   I'm going to have a hard time selling this to business users if they have to go through each group and uncheck the "Show Group Subtotals" every time they want to modify a report. Regards, Dan This is a known issue that is fixed in internal builds. The release ...Show All

• .NET Development dataset slow

  I have an application that is concatenating to a string (of course I'm using the stringbuilder class and appending) that is REALLY slow. The query to the oracle database is very large so I go to the database to get some of the records - that I append and write to the file. Now, I go back to the database and get some more of the records, append and write to the file, too. So, each time through the loop I have maybe 50000 rows in my dataset. I append the rows from the dataset together and write it to a file. Well, the query is quick and so is writing it to the hard drive. The machine slows down during the concatenation. I checked for thrashing and I've upped my swap files - but the server does not have a hardware problem, really. ...Show All

• Visual Studio Team System How to deploy one project to multiple servers...

  I am using the database professional to create a generic DB that I have a copy of on two different servers with the exact same database code (procedures, functions, tables, etc.) and I was wondering how I can use one project to make all my changes and then deploy those changes to each of the two servers using the deploy functionality rather then do a schema comparison for each of the different servers and then running a seperate script on each server. Is there a way to package the comparison engine in an executable Our database schema is part of a COTS product we supply and support. We do not have direct access to our customers databases. Additionally, not every change to the db is implemented at every lo ...Show All

• Visual Studio Team System Control deployment of static data

  Hi, Firstly, if this question is answered in the documentation then I apologise. I'm usually the first to slay someone for igoring the principle of RTFM. I have a database schema stored in VSTS4DB and I'm making the assumption that when VSTS4DB attempts to deploy these objects it will do so in the correct order according to FK constraints. (I think that's a fairly safe assumption) Either that or it deploys all tables and THEN all the keys. Anyway, some of my tables have a bunch of static data that needs to be inserted once and once only - when the schema first gets deployed. So here's some questions Is it possible to "attach" an INSERTION script to a schema object. Effectively saying "scriptXYZ.sql is the s ...Show All

• Smart Device Development how to hangup a call?

  how to hangup a call hi Ilya I have seen your link. There are many P/Invoke api. but I do not knew how to call them. which parameter for the api is right such as : LONG WINAPI lineGetNewCalls( HLINE hLine , DWORD dwAddressID , DWORD dwSelect , LPLINECALLLIST lpCallList ); if I want to call linegetnewcalls at c#. how to define HLINE, DWORD , LPLINECALLLIST type data as parameter for lineGetNewCalls Thank you ...Show All