MillBear's Q&A profile

• SQL Server Migration Problem of Sql 2000 to SQL 2005

  Hi all, We migrated our database from SQL 2000 to SQL 2005. But we faced some problems, according to the requirements of our project we dont want to apply some constraints on some fields of some tables. But when we run the database script of our old database on SQL 2005, it applied many constraints which causing some serious problems in our project. There are about 100+ tables in our database and some one told me that we have to false every constraint manually. Now, my question is that is there any solution of our this problem. Best Regards hi, can you please expand on it applied many constraints which can you post some SQL2000 DDL and how you like it to be in SQL ...Show All

• Visual Studio How to catch .net 2003/5 solution tree drag and drop event

  I am using EnvDTE to build an addin for .net 2003/2005. I am trying to catch the drag and drop event of the solution tree for both file items and folders. From the EnvDTE module, I can't find anything which is really useful to do this. Also, found that IVsHierarchyDropDataTarget and IVsHierarchyDropDataSource interfaces in the VSIP provide support for drag and drop, but I have no idea to hook them up with the IDE's solution tree so that we could catch the event. Please help on this. Thanks very much. Ivan Hi Ed, I actually tryed the EnvDTE ProjectItemsEvent, on drag and drop case, the there is no itemAdded or itemRemoved events come down to the derived handler. But remove and add from menu doe ...Show All

• SQL Server Problem - cannot connect; but I know this should work !

  Hello - I've setup SQL Server 2005 from scratch over half a dozen times now. I have remote connection down cold. Install the SQL Server. Run Surface config. Enable remote connection over TCP/IP and named pipes. Set up client alias. Restart SQL Server. (I install for mixed mode every time.) Every time this has worked up till now. Start up SQL Server Mgmt Studio, select the server to login to, enter the sa user name and password, boom, you're in. This time I cannot get in. Connection is denied both for sa and windows authenticated login as Administrator. This is the two line dump from event viewer - the first is an audit problem, the second is the error. Event Type: Failure Audit Event Source: MSSQLSERVER Event Category: (4) E ...Show All

• Windows Forms listview activate row event in user control

  Hi all, i created a user control that contains a listview and i will use the activate event of the listview to do different things based on the windowsform that the user control in it..... the problem that the listview events doesn't appear in the user control when when it is on a form ....... so is there a solution for this thx First of all, sorry for the late reply. Now, as for the first approach (exposing the whole listview to the user so he can attach event handlers to its events), in Visual basic that would be somthing like: suppose you used the designer to add a list box and you left its default name ListBox1, you will have to add a property to expose that list box like follows: Public Property ListBox() As ListB ...Show All

• Windows Live Developer Forums IM

  What is the MsnError：800？ ...Show All

• Visual Studio How can I add existed DataBase scheme to my DSL as inpuit?

  CONNECTION TO REAL DATA or SCHEMES FRAMEWORKS I want to make some generation from DB to C# classes with two tasks: 1. use DSL code or some framework - to read DB scheme and generate some classes or triggers and subscript it to compilers or SQL server. 2. incorporating some logics created in DSL to this process. Once DSL is code template engine it is expectable that it can provide some PRODUCTION input data or schemes for taking part in generation: for sample CodeSmith provides DB scheme or custom schemes for else sources and application generation become truly PRODUCTION relation and easy as breesy. does DSL can provide such a really well features _________________ EASY OF USE: I took CodeSmith yesterday first time, take 4 h ...Show All

• Visual Studio Team System When should I create a new TFS project

  Hi, I have question regarding Team System. I am a little bit in doubt of when I should create a new Team Project. I have several small internal software projects and I have one large external project. For now I have created two Team Projects one for all internal projects and one for the external project. Would you recommend me to create one per project My external project also consists of different modules and customizations for different customers, should I spilt that up Thanks Henrik Skak Pedersen. This should provide you some guidance: http://blogs.vertigosoftware.com/teamsystem/archive/2006/10/04/3867.aspx ...Show All

• Visual Studio Express Editions getting cursor position

  I have already found out how to get a few console functions that are unavaliable in the windows version of the conio.h include file. The other ones that I am interested in is finding how to get the cursor position within a console window that are wherex() and wherey() equivalent. Is there a method that retreives the console cursor position for the x and y coordinate Check my answer in this thread ... ...Show All

• Visual Studio Accessing controls inside RDLC

  Hi Is there a way to access controls inside a RDLC file in code I have 3 different martix reports in opne RDLC. depending on the input from user i need to show one of these and make others invisible. Can this be done thanks. ...Show All

• Visual Basic How to open new form and disable the parent form (until the child is open)

  I know it works like this.. Dim form1 = New Form form1.Visible = True but i want to disable the parent window while the child window is open. how to do it Not sure if this is what you are looking for, but the ShowDialog method will make the form "modal" and so the parent form is not active until the dialog form is closed. ...Show All

• Visual Studio 2008 (Pre-release) INSERTING INTO AN EXCEL FILE FROM MS ACCESS

  Hi everyone, I have been trying to write in an excel file from an access database. I am getting errors such as: Invalid argument. This is the code I am using: thecmd.CommandText = "SELECT " + tbf + ".Neid," + tbf + ".Famid," + tbf + ".RankID1,(" + tbf + ".Valeur-" + tbd + ".Valeur) AS Valeur " INTO [Provider=MSOLAP.2;Persist Security Info=False;Data Source=""C:\Developpement\Project_RCP\RCP_App\Test.xls"";Extended Properties=Excel 8.0;Client Cache Size=25;Auto Synch Period=10000;HDR=NO;].[Feuil1$] FROM ( " + tbd + "," + tbf + ")" Can anyone Help as it is urgent Cheers, Integore, Is this using ADO Have you t ...Show All

• Visual Studio Express Editions Problem of setting the position of textbox, button, etc

  Im not sure why i cant drag the textbox or button around the form to the position i like it to be. It seems to be able to stay at a fixed initial position only. I uninstalled the software and reinstall but the problem still persists. I wonder if anyone here ever face this problem, as this is very inconvenient. Ya i select file-new project-windows application, then i put a button at some particular position, after that i click the button and drag it all around the form, it does move around with the mouse pointer, but when finally i decided to drop the button somewhere at a new position, i try to click the on the mouse once again, and now nothing seems to happen,the button just sticks together with the m ...Show All

• Visual Studio August CTP

  Hello I am using Eric Woodruff's sandcastle helper and i get the following error. Can anyone tell me how to overcome this. MRefBuilderStatic (v2.0.2397.42473) Copyright Microsoft Corp. 2005 Info: Loaded 8 assemblies for reflection Info: Wrote information on 14 namespaces, 128 types, and 700 members ------------------------------- Removing duplicate topics from reflection.org 0 duplicate topics removed ------------------------------- Removing attribute information from reflection.org 93 attribute nodes removed ------------------------------- Transforming reflection output... [C:\temp_radhika\DownLoads\Test\Working\TransformManifest.bat] UnrecognizedOption: /xsl:C:\Program Files\Sandcastle\ProductionTransforms\AddOver ...Show All

• SQL Server When to copy template Excel file for output?

  I'm writing an SSIS package to run a series of select statements and save the results of each to a sheet in an Excel file. An indirect configuration file with these entries is used: \Package.Variables[User::ExcelTemplateFilePath].Properties[Value] \Package.Connections[AcculoanDatabase].Properties[ConnectionString] \Package.Connections[ExcelReportFile].Properties[ExcelFilePath] At the start of the package this setup will happen. 1) copy ExcelTemplateFilePath to ExcelFilePath 2) Set User::ReportFilePath to ExcelFilePath Creating a script task to do this is not a problem. However the task fails on validation of the tasks that write the select results to the Excel file sheets. I'm thinking the validation fails because the Excel ...Show All

• .NET Development .net remoting register 2 channel for 2 service.

  I'm using .net 1.1 working with .net romoting. here's a question, I want register 2 channels and publish 2 service. I want to publish each service for each channel. But when I publish 2 serverice. ervery channel can visit the 2 service. how can I do. thank you. What is the security solution How is it tied with the channels If it's a custom sink, then you can check the service URI yourself. ...Show All