SVMike's Q&A profile

• SQL Server After Install of 2005 still 2000 Engine!

  I have installed the new SQL Server 2005, but I see my local database as version 8.9.193, means SQL Server 2000. I do not know why setup did not upgrade it. What do I need to do now  I think some new options are now working because of that... Radiogeneris, please read the Books Online that came with your SQL SErver 2005 installation, it will give you a good overview as well as help you better understand your installation process/problems. You can also access it online at http://msdn2.microsoft.com/ms165606(en-US,SQL.90).aspx . After you've read the documentation, please feel free to post any follow up questions. ...Show All

• .NET Development How to use the DropDownList control

  How can I use the DropDownList control to handle active and inactive field values. For example, a Web form is used to display historical Assignment records and has a DropDownControl called ddlProjectCode. Since we are showing historical records, ddlProjectCode has to be able to display both active and inactive ProjectCodes, but when the user tries to change the ProjectCode or add a new Assignment record, then ddlProjectCode should only list the active ProjectCodes. Has anyone come accross a similar situation I thought I could use the DropDownList.Text property to display any text, even if it is not in the list, but that does& ...Show All

• Visual C++ new to VC++ 2005, have a few problems

  1-In VC++6.0 i could compile a single file by just opening a c++ source file(workspace less) and press the build button. But in vC++ 2005, if i open a c++ source file, the build command is unavalible. i tried to do it by creating an empty project and adding a c++ source file to it. well i can run the code succesfully, but i can not debug it. How can i do it 2-How can i want to add a template to my project: template<class TYPE> class CMyArray:public CArray <TYPE,const TPYE&> I can do implementation manulaly and add the function using the add function wizzard. But this is not of satisfactory. I want to use a wizzard to ...Show All

• SQL Server Securing the MS SQL Server 2005 database on client side

  Hello! I developed database driven .NET application and I need to deploy it. I faced a problem, which is "how to protect my database against direct access". I use MS SQL Server 2005 Express Edition as a DBMS and appropriate database. I want to make possible to manipulate with data in my database only through my client application. 1. How do I define SA password and instance name in silent mode of MS SQL 2005 EE installation with Mixed type of Authentication 1.1. Can I change SA password after the installation 2. If my database be attached to my new instance... Is it possible to copy my database, attach it to another in ...Show All

• Visual Studio Team System Sharepoint Services or Sharepoint Portal Server required?

  Hello I have Sindows Server 2003 SP1 plus latest updates, and am trying to install Team Foundation Server. It says it needs Sharepoint. Does it need Sharepoint Services or Sharepoint Portal Server Sharepoint services is a very small install, if I can get away with that, I would prefer that. If Sharepoint Portal Server 2003 is really needed, then I will install that. Thank you David Hi, Team Foundation Server needs Windows Sharepoint Services (WSS) which is a part of Windows Server 2003 OS. It is not the Sharepoint Portal Server Product that is needed. You can download WSS SP1 here: http:/ ...Show All

• Visual Basic Comparing VB files i.e. keeping track of changes made to VB files

  I am after a program which will allow me to compare 'differences' between two VB files i.e. compare the difference between two .BAS files, two .frm's etc. Fot text files I used to use Visual Source Safe which had the capability to easily keep track of changes made to a file. As far as I know this doesn't work for VB files as they are 'binary' files. Can anyone help How do you guys all keep track of 'changes made' between different versions of VB project files. Any thoughts would help. Thanks, Rob VB source files are text like anything else. There shouldn't be any problems. Are you literally referring to ...Show All

• .NET Development Outgoing IP?

  Hi, I have a .NET client that has a TCP/IP socket connection to a remote server. This is done from a server which has several IP addresses assigned and configured at the network card. So, now I was wondering how I could direct the outgoing request through a specific IP of those assigned to the server. Assume, server has IP's 1.1.1.1/10 - I'd like the outgoing request to be sent with IP 1.1.1.8. Is there a way to do that Thanks, Tom To expand on what Durga is saying: // create a socket Socket s = new Socket(AddressFamily.InterNetwork, SocketType.Stream, ProtocolType.Tcp); // all traffic wil ...Show All

• Windows Forms Datagridview onMouseClick onMouseDoubleClick

  Hello all, I have a custom DatagriedViewCell and i want different actions if the User clicks or doubleClicks on the cell. But only the event OnMouseClick will be processed. Without any action at the onMouseClick event (msgBox here) the Program steps into the OnMouseDoubleClick event. What to do The e.clicks property is always 1. cu phil Protected Overrides Sub OnMouseDoubleClick( ByVal e As DataGridViewCellMouseEventArgs) 'MyBase .OnMouseDoubleClick(e) 'needed MsgBox( "Double Click") End Sub Protected Overrides Sub OnMouseClick( ByVal e As DataGridViewCellMouseEventArgs) 'MyBa ...Show All

• SQL Server sseutil.exe - passing variables

  I have not been able to successfully pass variables from the sseutil.exe command line to a sql script file. For those of you unfamiliar with sseutil.exe, it is a free utility that works with both SQL 2005 and 2000. Download it from here: http://www.microsoft.com/downloads/details.aspx familyid=fa87e828-173f-472e-a85c-27ed01cf6b02&displaylang=en The ReadMe.htm file contains this:   -run <filepath> [<var1>=<val1>[,...]]      Runs a command file (SQL or extended commands) with the variables provided. I tried sqlcmd syntax for passing variables as well as other things. Nothing worked. An examp ...Show All

• Visual Studio 2008 (Pre-release) Mouse events for custom controls in RichTextBox

  I am using some custom controls and it seems that they don't receive mouse events if they are placed in a RichTextBox. When placed in a FlowDocument everything works fine. I must mention I am using Dec CTP. I had a chance to test it, and yes, it is working using VisualTreeHelper.HitTest. ...Show All

• .NET Development How to transform a fault statement from wsdl

  Hi, Is it possible to transparently use own developed exceptions from a Webservice to a client (server throws MyException and client receive MyException instead SoapException), and if yes, how to generate a exception class defined in a wsdl file using appropriate type and fault tag in a operation using wsdl.exe Hier some fragments of my wsdl: < complexType name =" AlreadyExistException " >   < sequence >          < element name =" Message " type =" string " /> </ sequence > </ complexType > < operat ...Show All

• Visual Studio Team System Team Foundation Visual Install Guides

  Full visual Guide located on a new Yahoo group: http://groups.yahoo.com/group/teamFoundation You have to join the group, but there are no membership requirements. There are two visual install guides: Word http://f3.grp.yahoofs.com/v1/QCv2Qxx5TA3c8DAQMs84s7uPsKL1JT67yl31SQoSQSYedBzv8C5Qu5S-ofO3OcHHYX8ynNpnBLYP1M0qxVB5Ow/Team%20Foundation%20Server%20install.doc PDF http://f1.grp.yahoofs.com/v1/QCv2Q_14BK7c8DAQyVbGkdsOLdEqH785DsOjB4z1FdIMAs5SCPXrpltjslTWuD5UHv5gJqIj_V4BRgsmXeYUIw/Team%20Foundation%20Server%20install.pdf There is also a couple of entries on my blog with rather extensive install details, esp. useful for those who have i ...Show All

• Windows Forms Listview causing an exception in vs2005

  I've just added a bit of code to the .net2 listview and its causing an exception in vs2005. The additional code just autosizes the last column which i learned how to do from the code project. protected override void WndProc(ref System.Windows.Forms.Message message) { const int WM_PAINT = 0xf; switch (message.Msg) { case WM_PAINT: if (this.View == System.Windows.Forms.View.Details && this.Columns.Count > 0) this.Columns[this.Columns.Count - 1].Width = -2; break; } base.WndProc(ref message); } Heres the exception message it gives me The control core.mylistview ha ...Show All

• SQL Server Please Help me with Editing XML files in SSIS 2005

  I am using a XML file and retrieving data for my SSIS 2005 (Intigration Service) package, where after  retrieving the data I need to update my  XML file with new data by using script task or XML task < xml version="1.0" > <TimeBuilder>     <StartYear>2003</StartYear>     <EndYear>2004</EndYear> </TimeBuilder> Here are some articles to start with: http://www.microsoft.com/technet/prodtechnol/sql/2005/intro2is.mspx http://sqljunkies.com/WebLog/knight_reign/default.aspx ...Show All

• Software Development for Windows Vista Inline code

  I have a .xoml file with some inline code (<x:Code> element). I can create and start the workflow if I compile the .xoml into an assembly with wfc.exe. Pointing an XmlReader to the .xoml and using CreateWorkflow will cause a validation error (can't use x:Code without creating a new activity Type). I'm guessing this is a security feature and the behavior won't change. Yes No Scott - I am not sure it is a security issue - but it really relates to how CreateWorkflow works - it doesn't compile anything - so the Code element won't work. You can also compile the xoml with the WorkflowCompiler and then execute the wo ...Show All