Osiris43's Q&A profile

• SQL Server Restricting password to contain atleast one letter and one number

  Hi, how should I apply restriction on the password field to have atleast one number and one letter The password field is 6 characters long. Thanks, Are you talking about the SQL login password You can do this indirectly by using the Windows password policies on the SQL Server machine. Now when you create SQL logins with CHECK_POLICY option ON (this is the default) then the policy will be enforced. The Windows password policy can also be pushed from the domain controller to the SQL Server machine depending on your network configuration. This is however possible only on Windows Server 2003. ...Show All

• Visual Studio Team System TFS Migration to a new server

  Has anyone been successful in migrating a TFS server to a new machine with a new name We are currently still using the RC, but I was surprised at some of the problems I had during a migration. Specifically Sharepoint, I don't know if its been improved with the RTM, but the restore procedures I saw were just wrong. The 1st trial I did had Sharepoint completely messed up. I finally fixed it, but it took my own understanding of Sharepoint, not the backup\restore procedures provided on msdn. Has anyone else had these issues I'm sorry about the delay in getting back to you, job change sort of had me preoccupied. Short answer, no you can fix it but its not all that nice. Long answer, uninstall TFS, delete the databases (make sure yo ...Show All

• Visual Studio Team System TFS works with local machine accounts but not with domain accounts

  Currently In order to create a team project and add files view reports in report manager etc. I need to have a local user account created. My domain account which I use to get into the physical server does not work and when I try to add this account to a project with permissions it throws an error that says something about not being in domain. Can somebody help steer me in the right direction on what to look for and maybe reconfigure to get this working. Thanks Aaron TFSSETUP, TFSSERVIE and TFSREPORTS are all local user accounts on this server. The person who was doing the install would have been on the domain unless he logged in as the local administrator account. - Aaron ...Show All

• Visual Studio Team System Custom Check-In Policy: Time That Task

  I just created an interesting check-in policy and wanted to share it with you all. I'm interested in your feedback. Custom VSTS check-in policy that gathers hours worked on a task during each check-in. This policy requires check-in to be associated with only one task that is in an "Active" status. It also gathers the number of hours worked on the associated task incrementing the completed hours and decrementing the remaining hours. If the number of hours worked on code in check-in is greater than remaining work hours on the associated task, user will be asked to re-estimate the number or hours remaining for the task. http://www.gotdotnet.com/Workspaces/Workspace.aspx id=9375fae2-5104-4d46-8b3a-c0b170b08320 Reasons why I created th ...Show All

• Windows Forms Display AND Update, Relationship-Data in one DataGridView?

  Hi, the Datagridview-Componet allowed only to bind one DataTable as a Source. So it won`t be possible to show more than one Table in a DataGridView, like a Relationship. Just a example: Lets say we have this Tables and Relationship: Table: "Orders" - ID_Order - CustomerName - ShippingAdress Table: "OrderDetails" - ID_OrderDetails - UnitPrice - Quantity - ID_Order (Foreign key from the Table "Order") Now, we want to show this Relationship-Data in a Datagridview. One Solution would be, to make a Join-Select on the Database. So we get one Result (with the Data from the two Tables) that we fill into one DataTable. But now we get a new problem. It seems it`s not possible to Update (INSERT;DELETE;UPDATE) this Da ...Show All

• SQL Server Restore SQL Server Express Databases after a Disaster Recovery

  Hello, I would like to restore SQL Server Express and its databases from a tape backup to the same server. This is a disaster recovery senario. I backed up the Master, Model, MSDB and my own test database using SQLCMD scripts. I have no problem restoring these using task manager on the server before the disaster recovery. However, in my real disaster recovery testing, When the server is restored by tape drive (HP one button disaster recovery), I try to run my SQLCMD restore scripts in task manager and I cannot connect to the sql server. Also I cannot connect with Management studio. I have recieved the following error in event viewer. ---------------------------------------------------------------- Event Type: Error Event Sou ...Show All

• Windows Live Developer Forums MSN MESSENGER APPLICATION

  I am currently creating an application in vb.net. I have succeded in doing many thing. My last problem is that I dont know how to recieve the instant message one of my contact sends. I have succeded to send him instant messages but dont know how to receive them in the program. I am using the Messenger API Type Library. Thanks for your help. I am using this code to send this message. msn.InstantMessage("hh@hh.com) System.Windows.Forms.SendKeys.Send("HI") System.Windows.Forms.SendKeys.Send("{ENTER}") Would you like to own a really MSN Messenger or YAHOO! Messenger library You can send/receive instant message from your buddy not via official MS MSN Messenger or official YAHOO! Mess ...Show All

• Visual C# Problem with Interop DllImport Memory Corruption and AccessViolationException

  Hi, I am having problems with the following operation to call GetConnectionInfo in VC++ 6 from c# 2.0 C++ Constructs as follows: typedef struct _OUTPUTPOINT { BYTE cDevicePath[MAX_PATH +8]; //DevicePath BYTE cLinkPath[1024]; //Use Lib. } OUTPUTPOINT, *POUTPUTPOINT; typedef DWORD ( CALLBACK *pfnGetConnectionInfo )( POUTPUTPOINT ); C# Constructs: [ StructLayout ( LayoutKind .Sequential, CharSet = CharSet .Ansi)] public class OutPutPoint { public char [] cDevicePath; public char [] cLinkPath; } IntPtr outArray; uint retVal = GetConnInfo( out outArray); OutPutPoint output = new OutPutPoint (); Marshal .PtrToStructure(outArray, output); Mess ...Show All

• Visual C# Add-In for creating XML resources

  Hello guys, I want to create an add-in for VS which creates XML resource files using a special dtd or schema, that means I want to create special resx-files with different schema rules. - How to create an add-in in general - Any hints relating my project Thanks in advance. Regards fuddy ...Show All

• Windows Forms AxWebBrowser Changed?

  Hello, for some reason i started using the axWebBrowser coltrol about a year ago, i got the Visual Studio 2005 and the axWebBrowser has been changed to just WebBrowser and all the control calls have been changed, for instance AxWebBrowser1.LocationURL; is no longer available, its changed to WebBrowser1.URL; Also Im having Compilation Errors with the MSHTML.dll this line mshtml.IHTMLDOCUMENT2 doc = new mshtml.IHTMLDOCUMENT2 as WebBrowser1.Document; this line tells me that it fails to convert Document to IHTMLDOCUMENT2 because it has to implicit Conversion. Can anybody explain what to do how to use this new webBrowser...or get the old one back Since the Webbrowser is just IE embedded ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Wave bank file is huge

  Hi! I need help on compressing audio files. Our game music is making our XNA game quite huge. How do you make XNA compress the sound and music for the game when you deploy WilderLand wrote: That isn't entirely correct. You can compress the size of WAV files in XACT, it isn't as good as MP3 format, but it can pull down the size by 75%. Oh wow, I never noticed that. Thanks for the info. ...Show All

• Visual Studio Team System Code Analysis Error on MeasureString (CA0001)

  I get the following Code Analysis Error on this piece of code: Error 22 CA0001 : Rule=Microsoft.Globalization#CA1303, Target=DXGameEngine2.GivesCAError.MeasureText(System.String):System.Int32 : Object reference not set to an instance of an object. DXGameEngine2 public int MeasureText( string textToMeasure) { Microsoft.DirectX.Direct3D. Font font = new Microsoft.DirectX.Direct3D. Font ( DXGame .DXDevice.Device, new System.Drawing. Font ( "Arial" , 10.0f, System.Drawing. FontStyle .Regular)); return font.MeasureString( null , textToMeasure, Microsoft.DirectX.Direct3D. DrawTextFormat .None, System.Drawing. Color .Black).Width; } Can anyone tell me what I'm doing wrong Thanks... ...Show All

• Software Development for Windows Vista How to append data?

  I'm trying to write two sets of files to a data disc in separate recording sessions. I'm getting an IMAPI_E_IMPORT_MEDIA_NOT_ALLOWED error from IFileSystemImage::put_MultisessionInterfaces the second time I try to write files, but I'm sure I'm not doing something correctly. (The media is DVD-RW). What is the correct procedure for appending files to a data disc The Microsoft implementation of IFileSystemImage does not support yet multi-session for rewritable DVDs. We are aware of this limitation and seriously considering to add this feature in a later update of IMAPI. For now, multi-session support is limited to CD-R/RW, DVD-/+R Single Layer (that is, all media for which one can implement IMultisessionSequ ...Show All

• SQL Server Web Form OleDbException (0x80004005): Disk or network error.]

  Hi Everyone, Hope you don’t mind helping. I am actually following exactly the example given in Karl Moore’s ‘The Ultimate VB.net and ASP.net Code Book’, ISBN 1-59059-106-2, Chapter 4, pp 141… I am using VB.Net 2002 and create a Web Form, placing on it a Data Adapter, Connector and Dataset and link this to a Data Grid. The database is a quite large (150 Mb) Access 97 db that is shared over a network and the Provider is a Microsoft.Jet.OLEDB.4.0 connection. While in designer mode I can create the Dataset and even preview the data itself from the menu. When I run the project, the Web Form displays, connects to the Site (via IIS 5.1) but then the following error text is thrown all over the form: ...Show All

• .NET Development Error in Addition of Double Variables

  Hi, This is Aravind. I got an error due to addition of two varibles which is declared as "Double". It shows the wrong sum up. Sample Code is as below: Dim amt1, amt2, z As Double z = 0.0 amt1 = 74.68 amt2 = 168.49 z = amt1 + amt2 The Answer should be 243.17 But ...It shows "243.17000000000002"..... Why it happens ....it will leads to Big problem.... when summing up the Money values.... Can u please clarify this.... Its urgent.... Regards Aravindkumar.P SQL's 'real' data type is the same as .NET's 'Single' type. SQL's 'float' matches .NET's 'Double'. 'decimal' and 'money' roughly match 'Decimal'. SQL uses the same floating ...Show All