gearmesh's Q&A profile

• SQL Server AS400 password request

  Hi all, I'm loading a working SSIS package in VB.NET and executing it programmatically. As the 'Persist Security Info' is set, it executes fine, presumably because I executed it previously with valid login info. But, when I update the connection info (programmatically) it prompts me for a password at runtime. The connection string will be provided by the user (DB Admin) and this is running as a Windows service, so what I want to do is, in the case of invalid login info, just receive a rejection, that I can respond to in the code. I'm using the IBMDA400 data provider to connect to an iSeries. Ideally, I need a generic solution that will ap ...Show All

• SQL Server How remove blank values from report parameter list

  Hi, In report designer, while adding report parameters how to remove blank or empty values from parameter drop down list. Blank values will appear even after unchecking "Allow blank value" option. Thanx I think you messed something up. Allow blank values only means that you can put in a empty string as a parameter value. If you have a data driven combobox you will have to redefine the query that fills the combobox to make it only to show non blank values. Look for the column you specified as value column if you can filter the values out, that are retrieved from the database. HTH, Jens Suessme ...Show All

• Windows Forms How to stop code in a loop.

  Here is what I have: while(checkbox.checked == true) {      DoSomething(); } I have a button named as well, "button1".  I would like to make it so that when the "button1" gets clicked, it stops the loop.  Hope this makes sense. -Mabuti You could do something like this, as a very simple solution: class MyClass {     private&n ...Show All

• Visual Studio 2008 (Pre-release) CLS Compliant ?

  In Feb CTP, I find this: public Collection< ToolBar > ToolBarTray. ToolBars { get ; } It seems WPF DLLs will not be CLS Compliant Thanks! Oh, the rule has changed : http://blogs.msdn.com/bclteam/archive/2004/12/21/328585.aspx ...Show All

• SQL Server Creating report based on parent-child dimension

  Hi I have a problem to create a report based on a parent child-dimension When I go to reporting services, and I create a new report based on a cube, I drag my parent-child dimension to my data-layout. Then the dimension is immediatily ragged down. Anyone an idea to solve this. Does anyone have an example to create a report based on a parent-child dimensions Thx ...Show All

• SQL Server Change an Access Database to SQL Server

  I designed a database that works well in Access and I want to get it to run in SQL Server. How do I learn how and what to do to change over to SQL Server Run the Upsizing Wizard by opening the database to be upsized in Access. Click Tools, click Database Utilities, and then click Upsizing Wizard. There's a whitepaper which describes this process in detail. Have a look here: http://www.microsoft.com/technet/prodtechnol/sql/2000/Deploy/accessmigration.mspx This is for SQL 2000, but it should be similar for SQL 2005. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Distorted texture after lost/reset device

  Hi, I'm drawing a textured mesh using DrawIndexedPrimitive, using an effect interface. After a windowed/full screen toggle the texture appears distorted. Interestingly when I draw another mesh in wireframe mode in the same render call the problem doesn't occur. Can somebody help Nico Depending on where you load the textures to, you need to release them and recreate them. Make sure that you are properly handling them. Look at the Samples in the DirectX SDK install directory and also under lost devices in the documentation. It explains clearly how you must handle a lost device and how to reset it. I hope thi ...Show All

• Windows Forms designing a gui with panels

  I want to create an application with a menu system like outlooks, where you can click on a button or image and the contents area will display a different "form".  how would i go about starting this Rick I'm not sure if there's standard functionality to do that like with radiobuttons although the documentation says something about mutually exclusive checks. I can't check at the moment how it works. Is the CheckedOnClick property set to true If that doesn't work, I would set CheckedOnClick to false, respond to all menuitem's click events and set the Checked property manually. ...Show All

• Visual Studio I want to add additional documentation to VS help system.

  I have VS 2005 installed and it comes with a set of documentation which you can filter via drop down box, which is great. But I am doing some sharepoint development and I really don’t want to switch between the two systems or more if I have other SDK docs I need to look at, can I add the sharepoint SDK or any .chm file to the VS help system which should be automaticly searched via dynamic help also. I think I am asking for the impossible. Cheers, David Hello David, you're only asking the 'sort of' impossible. :) Actually there are some options for integrating content from other Microsoft ...Show All

• .NET Development How can I find forum moderators?

  I have a question to the forum moderator of this forum. How can I find her or him Dear the moderator: Please contact me. Regards, Hello, Kean I'd like to know the reason why my following thread is locked because Faq says to do so. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=165123&SiteID=1 ...Show All

• SQL Server Display Boolean parameter LABELS

  I tried to put a boolean parameter on my report with values (True, False) and Labels (Yes, No). On Visual Studio it displays the labels, but when exported on the Report Server it diplays the values (True, False). Is there a way to tell Reporting Services 2000 to display the labels of boolean parameters instead of the values Hi Remi, I had the same problem in Reporting Services 2005, where in the report preview in Visual Studio the parameter labels were displayed as 'Yes' and 'No' but when the report was deployed to the report server it retained 'True', 'False'. To get around this I changed the parameter type to String instead of ...Show All

• Visual C# Is this possible??? Word document to SQL

  I have some documents (all are exactly the same) with some people information (name, address, phone number,...) and i want to copy into my sql database, but only the information. If in the document if have: Name: XXXXXX XXXXXXXX Address: SSSSSS SSSSSSSS Phone; AAA AAAA And I have the same fields in the SQL Database, so I want to copy directly from the document. Is this possible Thank You I don't know if people will understand what i need I would go with what dkocur2 has suggested.. cheers!! pradeep_tp ...Show All

• Visual Studio Express Editions Connecting with C# 2005 Express

  I downloaded the SQL Server 2005 Express Advanced. Everything seems to be working fine. I have on my pc C# 2005 Express and Visual Studio 2005. The only product I have installed in Visual Studio 2005 is the SQL Server Reporting Services. Which is fine as I only want to use C# Express. In VS 2005 I can go to Data Connections and add a my database I created in SQL Server Managment Studio Express. Great. So now I want to connect to my db with C# Express. Two things: First off, under Change Data Source there's only two options: Microsoft Access Database File and Microsoft SQL Server Database File. Where is the regular Microsoft SQL S ...Show All

• SQL Server I am unable to install SQL Server 2005 on Win XP SP2 box

  I get to the point of starting the services and receive the following message after about 4 minutes of trying to start. I tried in Mixed Mode and Windows Authentication Mode. Message: TITLE: Microsoft SQL Server 2005 Setup ------------------------------ The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." For help, click: http://go.microsoft.com/fwlink LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=setup.rll&EvtID=29503&EvtType=sqlsetuplib% ...Show All

• Software Development for Windows Vista Workflow Lifecylcle Events

  I use a Windows Service and have attached EventHandlers to the Workflow Lifecylce Events(Created, Started, Aborted, Persisted, Loaded, ....). My question: By the time such a event (e.g. WorkflowStarted) is fired, my EventHandler executes some code to write into a log. The only information about the WorkflowInstance I could find in the WorkflowEventArgs is the InstanceId. I would like to get more information about the workflow: What type, .... How could this be possible Thanks You want to look at using a TrackingService. See my post here http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=438487&am ...Show All