EmSOFT's Q&A profile

• SQL Server Management Studio Express CTP update now available

  There is a new Management Studio Express CTP download available at   http://www.microsoft.com/downloads/details.aspx FamilyId=82AFBD59-57A4-455E-A2D6-1D4C98D40F6E&displaylang=en . This update fixes the defect where installing the full Books Online documentation prevented Management Studio Express from starting.  With the update, Management Studio Express and Books Online no longer interfere with each other. To update Management Stu ...Show All

• SQL Server Can SQL express be accessed by Oracle Transparent Gateway ?

  Able to access SQL express remotely using SQL mgt Studio after certain configuration. But notice that I must use IP address /SQLEXPRESS for server name in order for connection to work. What is this "/SQLEXPRESS" Is it a standard surfix for SQL Express I have installed the Oracle Transparent Gateway on the machine with SQL Express and setup the tnsname for SQL Express. For the tnsname, have used IP address /SQLEXPRESS as the ho ...Show All

• Visual Studio Loading an Embedded Resource

  I have added an RDLC to my project.  I need to be able to load this into a stream so I can use LocalReport.LoadReportDefinition.  Does anybody have any sample code of how to load the embedded resource into a stream object NOTE: I know about the ReportEmbeddedResource property.  I can't use this because the viewer is in a different assembly than the embedded resource. OK, I figured it out: ...Show All

• Visual C# replace

  Hi, This is what I have which is assigned to a string variable. I would like to replace the \\ to \ How is this done please I tried: string strData = strData.Replace("\\", @"\") But it does not work. Thanks strData = "{\\rtf1\\ansi\\ansicpg1252\\uc1\\deff0{\\fonttbl\r\n{\\f0\\fswiss\\fcharset0\\fprq2 Arial;}\r\n{\\f1\\froman\\fcharset2\\fprq2 Symbol;}}\r\n{\\colortbl;\\red0\\green0\\blue0;\\red255\\green255\\ ...Show All

• Visual Studio Team System TFS API Help [Urgent]

  Hi! I would like to create a team project, work item, resource allocation, etc. from my application using TFS API. But i do not know where to start   I found Microsoft.TeamFoundation, Microsoft.TeamFoundation.Client, Microsoft.TeamFoundation.Proxy.Portal provides APIs for all the above functionalities.  But it is very difficult to me to understand the usages of these APIs. Please do the needful asap. Regards, Sheik ...Show All

• SQL Server An error occurred while receiving data: '10054(An existing connection was forcibly closed by the remote host.)'.

  What does this error mean I get this in the transmission_status column of  sys.transmission_queue An error occurred while receiving data: '10053(An established connection was aborted by the software in your host machine.)'. Also, does the number in this message correspond to error 10053 in sys.messages Thanks       It means that the peer is closing the connection during l ...Show All

• Visual Studio 2008 (Pre-release) runtime compilation of Linq code

  Hello, Would you know of any ways to provide on-the-fly compilation of C# 3.0 code There must be some CSharpCodeProvider for it somewhere.. Thanks, NR Why would you need it You might create source code and invoke Linq compiler to generate an assembly, inmemory perhaps. ...Show All

• SQL Server MIRROR database questions

  Hello all. I was reading an article by Rich Heiges called Mirroring - A New Look at HA. It left me with 2 questions (A) Can I change the operating modes of the principal and mirror roles on the fly, or do I have to stop the MirROR process (B) It said that MIRROR supports 32-bit to 64-bit H/W interoperability -- but will it support interoperability between 32-bit and 64-bit instances of the database Thanks! you ...Show All

• Visual C# Custom control draws incorrectly when moving another window over it.

  This issue has seriously frustrated me. I am overridding OnPaintBackground to draw a gradient background in my custom control. It resizes great - very smooth, no flicker. When I try to move another window across it, it will repaint itself repeatedly... but it will repaint the area that was hidden by the window as if it was the entire control. So if I am starting the gradient from blue to green...When I move a window over half of the control, an ...Show All

• SQL Server multiple columns in "in" search

  Is it possible to put a set of columns into a select statement using "in" For example: select count(*) from table1 where (col1, col2, col3, col4) in (select a.col1, a.col2, a.col3, a.col4 from table1 a where........) This is possible in this form for Oracle and DB2 but I cannot get it to work in Sql Server. Any ideas No. SQL Server doesn't support row value constructors yet. You ca ...Show All

• Visual Studio Team System TF30177:Team Project Creation Failed

  I am trying to create Team Project on VSTS Beta 3. I am getting following issues 1) Unable to create Team project Error and Stack below: 10/26/2005 4:13:12 PM | Module: ELeadServiceMediator | Team Foundation Server proxy retrieved | Completion time: 0.5793852 seconds 10/26/2005 4:13:12 PM | Module: ELeadServiceMediator | The template information for Team Foundation Server "VSTSRC" was retrieved from the Team Foundation Server. | Completion time: ...Show All

• .NET Development WSE3 Custom Policy Assertion / Filter : SecurityPolicyAssertion vs. PolicyAssertion

  I'm implementing a custom authorization filter against the WSE3 stack. My filter is similar to the Microsoft.Web.Services3.Design.AssertionAssertion except that it has finer granularity than WebService. I originally attempted to implement the assertion and filter by subclassing SecurityPolicyAssertion and ReceiveSecurityFilter respectively. However, the state of the SoapEnvelope during the ReceiveSecurityFilter subclass's ValidateMessageSe ...Show All

• Visual C# running an app in the background

  i recently developed an app using C#. this app prints using officee 2003, and when it does the office opens and prints, however i need the office to run in the background without appearing to the user. any suggestions Yes.The behavior it's ok.By calling a .doc only by it's filename you firstly fire 1 process which is Explorer (the shell actually) which receives your settings (hidden etc etc)).Explorer will match the extension and fire ...Show All

• Visual Studio Express Editions I got an error

  I'm getting this message when adding an GIS OCX library to my VB Express project. "Attempted to read or write protected memory. This is often an indication that other memory is corrupt." I have the tested the memory and it's ok. The "Factory" says it works well with VB2005 PRO. Is there a difference between VBexpress and VB2005 PRO Regards, jalegom No difference between Express and ...Show All

• Visual Studio Express Editions Command object

  In Visual Basic.Net 2003 there were oleDbCommand objects which I used to create a select statement. I then created an oleDbDataReader in code. The command object then executed the reader object which I used to fill my comboBox with items. I did this so that I could update the items in the combobox from another form and so the comboBox would put the string in my database field and not the ID. My question is: I don't see the command object and ...Show All