Manuel Müller's Q&A profile

• SQL Server Creating SQL 2005 Logins during installation

  Hello, We use one standard account with a password that is never given out. In SQL 2000 we had a script to extract the password in encrypted format so that it could be run as part of the installation process. That same process does not work for SQL 2005. Below is a sample of the script that we were deploying for SQL 2000 installations. ------------------------------------------------------------------------------------------------------------- -- Login: CPAPP declare @pwd varchar(50); SET @pwd = CONVERT (varbinary(256), 0x01003402EC1BDADF45C9D788C23459BC36D73E5B2B9F2F235138F6BB8D0CD2317FCBA41EB59D191801AC287A14FF) EXEC master..sp ...Show All

• SQL Server Connection Error: (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.

  Hello, Please bear with me as I am no Sql Server guru, but am getting this error that is preventing me from continuing with my development work.  I am the only developer on my team running Sql Server 2005 and it has been working just fine for the last week.  I opened the Management Studio this morning, just like every other morning and got this error: TITLE: Connect to Server ------------------------------ Cannot connect to (local). ------------------------------ ADDITIONAL INFORMATION: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provide ...Show All

• .NET Development Search for COM Server.

  How to get typelib from com object and then found it's destination (file, that containes registered com object) I'm not sure what you mean by "get" the typelib, but if you have a non .NET Dll you use the LoadTypeLib Win32 API to get a ITypeLib interface and then go from there. ...Show All

• SQL Server Cannot save Maintenance plan

  I use sa to login to sql 2005. I can save Maintenance plan using wizard. However, when I try to save maintenance plan using the maintenance plan design screen, I received error message "Apply to target server failed for job ...". When I check the job, there is no step in the job. In the Maintenance wizard, there is no maintenance clean up task. I want to create a task to delete my backup file if it is older than certain days. Any suggestions are welcome. Thanks in advance. Although Maintenance Plans are built on the SSIS infrastrcucture, they do have some aspects that we do not cover. Best to start in the SQL Server ...Show All

• Windows Forms C#2005 - UserControl in Datagridview

  I followed the example "DataGridView Custom Column Sample" http://msdn2.microsoft.com/ms180996(en-US,VS.80).aspx I have a usercontrol to look for some data on a table of a database. My usercontrol needs of a connection, a tablename, and a keycolumn to work. I have seen that the datagridview creates my control in the moment which I enter to the cell automatically. How can I pass these data to my control Thanks Mauro Because otherwise   the value in this .TableName is null. I have noticed that assigning all the values of the column before making the databinding with the table is important, other ...Show All

• Visual Studio Team System Test Mix - How does it work?

  Hello, I created a load test of 12 different Web Services. Each web Service request is in its own test (.cs file). I added each test to the "Test Mix" with different percentages. when I run the test with an increasing number of users and monitor at the DB level the requests seem to be grouped in bursts of similar Web Services requests. Is there any documentation on how the test mix randomizes test script execution I would hope that a virtual user would pick a "test name" randomly according to it's specified distribution % and execute it once, pick a new one and repeat. Is this correct Thanks! John ...Show All

• .NET Development sqlTransaction problem

  have a DataTable with an autoincrement primary key that is retrieved from the database after insert. When I execute my InsertCommand within an SqlTransaction the rows in the DataTable are updated with the autogenerated key from SQL Server. However, when one of the inserts fail and I rollback the entire transaction, all my DataRows are left with the invalid keys from the database and a RowState of Data RowState .Unchanged instead of Data RowState .Added. So, when I rerun this code: Me. DataAdapter .Update(Me.Table) nothing happens. No inserts are performed. This kind of defeats the purpose of having an SqlTransaction . No change ...Show All

• Visual Studio Copying files

  Dumb question of the day but can someone please tell me why this works (ie, it lists files):  <ItemGroup>   <MyFiles Include=" \\someserver\someshare\droppath\somebuild\Debug\*.dll " />  </ItemGroup>  <Target Name="Build" >   <Message Text="@(MyFiles)" />  </Target> and this doesn't:  <ItemGroup>   <MyFiles Include=" $(DropLocation)\$(BuildNumber)\Debug\*.dll " />  </ItemGroup>  <Target Name="Build" >   <Message Text="@(MyFiles)" />  </Target> and this does:  <ItemGroup>   <MyFiles Incl ...Show All

• Visual Studio Express Editions TreeView question #3

  Hi Making progress, but slowly. Current problem is trying to use a property as shown in the system help (shown below). When I try to use this to get the collection of checked nodes I get an error that says: CheckedNodes is not a member of 'System.Windows.Forms.TreeView'. Everything I have read points to this as being the way to get the collection, but yet, in the final analysis it doesn't do it! I suppose this problem is related to the fact that it says Namespace is something to do with Web controls. Question is: how do I get a collection of Checked checkboxes from my form based TreeView Do I need to iterate through and collect them ...Show All

• Visual Basic CANT DEPLOT APPLICATION

  Ok this is my first time doing this click once deployment thingy But im trying to basiclly deploy my application so that others can download and use it the problem is i dont know where to deploy it to I need help i tried microsofts website but it wont let me get acess to it. I would have thought it was obvious that Microsoft is not providing web space for every person who downloads an Express version. You can deploy to your local machine. If you want people to be able to download it, then you need to provide server space. ...Show All

• Smart Device Development MinimizeBox = True And Form.Close, Diiferent behavior between CF1.0 and CF2.0

  In CF 1.0 and WM2003, if MinimizeBox of a form was set to true and you were to call Form.Close, it would mimimize the application. With CF 2.0 and WM2005 however, the same scenario closes the form completely. Is this the expected/desired behavior If so, how can one programmatically minimize a form or send it to the back. Form.SendToBack does not seem to work if called from the contructor, form_load or form_activate. I'd like to know the answer to this please! Why has the behaviour changed I spent ages working out exactly how different true/false combinations worked for ControlBox & MinimizeBox when I first developed this ...Show All

• Windows Forms Dynamic webbrowser creation on form

  I am trying to dynamically add a webbrowser control to a tabpage. The application traverses a file structure which has multiple folders, subfolders and files. When a root folder is found I create a new tab page, if a file is found in that folder I add a browser control and set the navigate property to point to the file which it should then display. If a subfolder is found I create a new tabcontrol, tabpage and then add a browser control. Again I set the navigate property to point to the file it should display. This works fine if I hardcode the form. In other words, If I drag the tabcontrol onto the form, create the tab pages and then d ...Show All

• Windows Forms Child is not a Child Control of this Parent

  Hi, I have created a userControl which I want to be able to draw and add new components during design time. I have added the following attribute to my class. [Designer("System.Windows.Forms.Design.ParentControlDesigner,System.Design",          typeof(System.ComponentModel.Design.IDesigner))]     public class RollUpTab : System.Windows.Forms.UserControl Which has a GroupBox as part of it. Within this class I overide the OnControlAdded method as follows protected override void OnControlAdded(ControlEventArgs e)   { this.gpbox_MainGroup.Controls.Add(e.Control); } Now when ever I add a contr ...Show All

• SQL Server What is the best way for users to view cubes?

  Hi, Our company is about to purchase SQL Server 2005 as an upgrade to running the reporting out of MS Access (so I am new to SQL Server). I have been trying out Analysis Services cubes and would like to know how others using SQL Server are allowing users to view cubes. I am using the Cube Browser from within an Analysis Services cube project which is excellent. This made me think that there must be an equivalent program that end users are able to use, although I haven't yet come across anything obvious. I have heard of Data Analyzer from Microsoft, although this looks a bit too simple for serious data analysis. Also I have seen the option o ...Show All

• .NET Development inserting into access database

  Hello, I am trying to create a form to insert a new person into by access database. I have italisized the part where i am having the error. "Caracter not valid" is the error which i am getting for using " " and its the same when i use "@". I need to insert lastname , firstname and teamid into the access databse through form and i am using oledb connection can anyone please help me sort this issue. i am copying the entire code here <% @ Import Namespace = "system.data" %> <% @ Import Namespace = "system.data.oledb" %> < script ...Show All