3TP LLC's Q&A profile

• SQL Server SSIS Package Security

  In DTS we had an Owner password and User Password. The User pasword allowed someone to run and schedule the package, but not edit the contents. Owner allowed full /designer access. I like the two levels of password security. What is the equivalent of this in SSIS I can only seem to get ProtectionLevel security to work with a single password that seems to be required to run, deploy and execute. Looks like an all or nothing proposition unless i am missing something. Actually, the single password can be used to secure the package contents..not just sensitive info, use ProtectionLevel "EncryptAllWithPassword". The resulting dt ...Show All

• Windows Forms DataGridView Binding

  Hi, i'm implementing a solution with a datagridview that is binded to a sqlexpress database made within visual studio 2005 beta 2, but i'm not able to modify or insert data into the database, it seems that fetch correctly the data present in the database, but ignores any sort of changes to the database. Also i tried executing AcceptChanges method on the dataset at runtime, but it still ignores the changes made in the datagridview control. How should i work around this Thanks Luker Ok, i inserted your form compiled, made a new DataSet using VS attached the new dataset to an access database, and it worked! ...Show All

• SQL Server OLAP administrators group.?

  hi all.. i have a problem about sql server analysis. i try to connect sql server for OLAP but i can't. sql server analysis give this error "unable to connect to the registry on the server or you are not members of OLAP administrator groups on this server" i use Windows Xp Pro and Sql Server Developer Edition. how can i solve this problem.. Please provide more details Same machine for Analysis Manager and Analysis Services or different machines Service Pack 3 or greater on both machines if different machines ...Show All

• .NET Development Sql Connection Hang

  Hi, I am using .NET 2 (beta2) and are having problems with using a SqlConnection. I have created a test application that opens a sql connections, gets some basic data and then closes the connection. When i run this application as the administrator it works fine.  However if i run the application as a standard user the application hangs indefinatly on SqlConnection.Open(). I dont get any time out or any exceptions.  It just hangs there. I am using SQL Authentication. I have tested this on many computers and the same happens. My main issue is getting this to work on Windows2000 Server (Sp4). thanks Arran   ...Show All

• Windows Forms Combo Box Error - Too Many items in the combo box

  Hi Guys, I am receiving the error listed on the subject. The error message is pretty obvious, but the question is: How many items can I add to a ComboBox   In my case the number is > 32800.... Do exist any difference depending on the Operating System   My App is running on Windows 98. Well, it seems to be limited only by  ...Show All

• Windows Forms Form designer generate code in incorrect order in my usercontrol

  Hello everyone, I create a control via visual basic .net 2002. My control uses ImageList and ImageIndex properties. I add an ImageList control to the form and bound it to my usercontrol. When I use usercontrol, Form Designer generate code with two problems: 1. ImageIndex come before ImageList (alphabetical order).      this create a problem because ImageList need to set first. 2. Form Designer generate the code for ImageList control after      my Usercontrol code. Any Idea how can I solve this problem OK, I solve the problem an ...Show All

• Software Development for Windows Vista UML WF

  This next question is actually outside of this thread but along the same lines.  Microsoft has moved away from UML yet many apps in the market were modeled with UML.  It seems the workflow in WWF is simular to dynamic diagrams like activity diagrams.  Is there any easy or theoretical transform from UML diagrams ( through XMI) to workflow diagrams ..."The design is structured so that it can be easily implemented in software and as a later step the completed design can be used to generate code.  The code generation from UML is generally secondard however to the use of the UML for discussion ...Show All

• Visual Studio Team System LoginView postback error

  We have been using the LoginView with no problems in the beta version of .net 2, when the final release came out we started to get an issue on the postback of the page our user control is in. We have a loginView and DataGridView as two seperate user controls on the same page. When the DataGrid posts back the login view reverts to the anonymous template even though we are still logged in. It does not hit the init or load events for the loginView and so we are left with a login prompt template. Has anyone got any suggestions that could help resolve this issue Thanks in advance, Anna Please post ...Show All

• Visual Basic dll needed

  I need a net dll to transform wgs84 geographic coordinates to ED50 UTM coordinates. Any help or direction . I need only this and not a full .dll that load a lot of bytes into memory at runtime and they are costly. With the amount of ram most computers have now, the basic memory needs of a dll is minimal. If you really want to have low memory cost, then make a c or c++ program to do it. ...Show All

• .NET Development Not accessing intranet web apps by Macintosh Pc,s

  I am facing a problem on my windows 2000 server to run an intranet web application. There are more than 50 (windows based) pc’s connected to the above server and access that web application successfully. But also there are more than 40 (Macintosh) computers in the network and they are not accessing the web application and return the error that resource “web address” not found . These Macintosh computers are connected to window’s 2000 through AppleTalk protocol. They can only access a shared folder on windows 2000. Please solve this problem and reply me as soon as possible. ...Show All

• Windows Forms Deploy chm file with click-once

  I'd like to include a chm file with the application that I am deploying, but no matter what subdirectory of the project I put it in I can't seem to get the file to be included in the deployment. The help file does work correctly from my application on the development machine where I have it located in the project bin directory. Right now, my deployment is just to a directory from which I burn a CD. Thanks, jerryK Have you changed the BuildAction property of the file to "Content" I think that's about all I did to get it to work.   ...Show All

• SQL Server Use Replication to Identify Updated Data?

  I am new to SSIS (though have a decent amount of experience with SQL Server 2000), and am trying to design a data warehouse and eventually a comprehensive reporting solution. Here is our setup: - We have ~150 studios all operating software which we designed (ie. we have control over the system that will be the Data Warehouse source). - All studios use merge replication back to Head Office (we maintain a duplicate of each of their databases). From my limited understanding of Data Warehousing methodology, I believe that I should prepare a 'staging area' which contains all needed data from these databases. My question is how to do this in an e ...Show All

• Visual Studio 2008 (Pre-release) System.TimeoutException in "Hello World" sample

  Hello I'm newbie to WCF so i started by playing with "Hello World" sample Everything works great except last step ( Securing Communication Between the Client and Server ) When i change binding to WSHttpBinding and run app (server then client), messages are sended ok, client ends but server hangs on HService.Close(); After a while, System.TimeoutException is thrown : System.TimeoutException was unhandled Message="Unable to claim lock within the given timeout." Source="System.ServiceModel" StackTrace: at System.ServiceModel.Channels.ThreadNeutralSemaphore.Enter(TimeSpan timeout) at System.Servic ...Show All

• Visual Studio 2008 (Pre-release) Custom TriggerActions

  Are we supposed to be able to create our own TriggerActions TriggerAction is not sealed, but the abstract 'Invoke'  method is defined as Internal in the base class, so there is no way it can be overridden outside of the WPF assembly. Drew is correct that custom TriggerActions is not really a scenario we were trying to support. In the most recent sources, TriggerAction's constructor is internal. I don't think there's anything inherently evil about custom TriggerActions, as far as I know it's just a time in the day issue. ...Show All

• Software Development for Windows Vista Why is the Activity ContextGuid not public???

  The execution context of an activity is an important piece of the workflow. So why is this important piece of information hidden Currently, there is no way for me to correctly obtain a specific instance of an activity. The main issue I am running into is with tracking. I need to track additional information that is supplied by custom activities. Also, can see the need for a workflow to be able to access other activities in a specific context in order to complete. you can do this : Guid contextGuid = (Guid)activity.GetValue(Activity.ActivityContextGuidProperty); ...Show All