Darrell Davis's Q&A profile

• SQL Server Only One SSIS Job Runs...

  Hi, Currently I have two SSIS jobs on my machine. The problem I'm having is, only one of the jobs executes succesfully, the other one fails for incorrect user login. Both jobs use the same configuration database and all the packages on both jobs have the protection level set to "DontSaveSensitive". Both jobs have been deployed in the exact same manner, yet only one succeceeds and the other fails. Can anybody tell me why this is going on J.Suazo wrote: Hi, Currently I have two SSIS jobs on my machine. The problem I'm having is, only one of the jobs executes succesfully, the other one fails for incorrect user login. Both jobs use the same configuration database and all the pack ...Show All

• SQL Server Combining Multiple Subreports in One Report

  Hi, I am trying to combine 5 different reports in one report. I am using them as subreports. The problem is, they are all different formats. For example, one of the report is rendered as 3 column report, and page length and width vary from report to report. When I tried to use table and list for this, my program crashed and closed my visual studio. When I use rectangle for it, then shows me the report but report is no more multiple column and page sizes were also different from the one I did in the report. Please guide me how to combine all these reports and not loose the formatting of the reports. Thanks, -Rohit I am having the same problem. The goal is to produce a single PDF consisting of a nu ...Show All

• SQL Server How Can I Ignore Accsents and diacritical marks in WHERE statement?

  How Can I Ignore Accsents and diacritical marks in WHERE statement i use sql statment for searching and i wont to search in text filds where some accent and diacritical marks have been enterd. like: i want to search for 'e' or 'o' ... letters in this text: "euoa" if i used: "Select * from table where fild like 'e' " the result will be 0 items. Also, same proplem in Arabic accents for eg: if i want to search for ' ' in this text ' ' , using select where statement. what can i do Here is a small example. You may need to read more about collation to completely solve this problem, but this should point you in the right direction. Notice that in the first example, no collation is spec ...Show All

• Architecture Design Question

  We are designing a Enterprise web application. This application will be typical 3 tier application . With ASP.net in UI layer, BusinessLogic layer and Data Access Layer in C#. Database will be SQL Server 2005. My question is what advantages we can have if we place UI layer in separate physical server and BL and DAL in other server I am planning to use remoting in this context. An excellent answer from Kareem. Just a couple of points, don't assume you need to physically distribute your business / data access layer to a separate machine to achieve scalability. You could of course locate each layer on the same server (UI, Business and DAL) and simply load balance across your web server. This wo ...Show All

• .NET Development Imagelist (error when loading the imagestream during the InitializeComponent)

  I've got a weird problem that I'm experiencing with VS2003 installed with VS2005. (The error does not occur in a machine that has VS2003 only) I have an imagelist on a form and I I can't run the program because it'll throw an exception while loading the imagestream during the InitializeComponent call. this.imageList1.ImageStream = ((System.Windows.Forms.ImageListStreamer)(resources.GetObject("imageList1.ImageStream"))); The line that sets the ImageStream is the one that throws the exception: "An unhandled exception of type 'System.Reflection.TargetInvocationException' occurred in mscorlib.dll Additional information: Exception has been thrown by the target of an invocation." I looked at the .resx file for ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Microsoft.Xna.Framework.Rectangle vs. System.Drawing.Rectangle

  I noticed that the XNA framework Rectangle does not have a Contains method like the System.Drawing.Rectangle. http://msdn2.microsoft.com/en-us/library/system.drawing.rectangle.contains.aspx I found this function handy for handling mouse clicks on my 2D tile map. Is this by design, a bug, or yet to be implemented Thanks, Trey Greetings, I posted a suggestion for the Contains function on Connection before finding this post. Sorry XNA team. Here is what I am doing to solve the Rectangle.Contains overload for a X and Y mouse point. I am using it in a Button class so the button object has a Class level member called ButtonRect. But this function could be public in a helper class that has ...Show All

• Internet Explorer Development Welcome

  Welcome to the MSDN forum for Internet Explorer Web Development. If you have questions around web development for Internet Explorer then this is the place to ask them. If you see a question that you know the answer to please chime in with a response. Some useful resources: The Internet Explorer Developer Center contains links to documentation and useful developer tools for Internet Explorer The Internet Explorer team blog has frequent posts from the team and is a great place to keep up to date on Internet Explorer To report bugs and give feedback on Internet Explorer visit the support page at http://www.microsoft.com/windows/ie/support/default.mspx Thanks Dave Massy Senior Program Manager, Internet Explorer ...Show All

• Visual Basic start menu

  Hello, how can i place a custom button above the windows xp's start button cuz with the topmost property it goes behind the xp's start button if i click on the taskbar... how can i avoid this if this not possible how can i get the name of the open windows and how can i restore them if i click on a panel with the name of one of the running windows and how can i get the icons of the notification area thnx; Sorry, i've gotten an error message with the text "your message couldn't be posted"... or something like this, that's why i dublicated. please do not duplicate post: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=631730&SiteID=1 ...Show All

• Visual Studio 2008 (Pre-release) Exception during Submit changes

  I've got exception on submitting changes after string field modification. I can provide more information if it helps. You can ask me by email. System.ArgumentOutOfRangeException was unhandled   Message="Index was out of range. Must be non-negative and less than the size of the collection.\r\nParameter name: index"   Source="mscorlib"   ParamName="index"   StackTrace:        at System.Collections.BitArray.Get(Int32 index)        at System.Data.DLinq.SimpleTrackedObject.HasChanged(MetaDataMember mm)        at System.Data.DLinq.ChangeProcessor.BuildEdgeMaps()        at System.Data.DLinq.ChangeP ...Show All

• Visual C# Need sample projects

  Hello Could someone please post a link to open source Visual Studio 2005 C# projects I am new to Microsoft, .Net and C# and I am totally lost. Are VS .Net 2003 and VS 2005 two different things To me it seems so. Thank you Hi, here's a link to Microsoft's 101 samples page to get you started. You can download samples in VB or C# version. Also, look here for C# open source projects. And yes, VS2003 and VS2005 are two different things. Simply speaking, you can use VS2003 for developing application to run on .NET framework 1.1, while VS2005 is used for developing applications that run on .NET framework 2.0. Open source projects from the above mentioned page are mainly written for .NET ...Show All

• Windows Forms '&' character replaced with '_' in windows form

  '&' character is replaced with '_'. Ex: create a windows forms application with a single form and place a label control with value initialized to 'Praveen & Kumar' (say). run the application, now the label value is shown as Praveen Kumar. '&' is replaced.I think this is due to the menu short cuts which are replaced to the character after &. please any one can help such that text given to controls is shown as it is irrespective of characters such as '&', '@','|','$','#' etc... Hi, yes, the & character is used for shortcut access. To display this character, you have two options: 1. Set the text with escaped &: "Praveen && Kumar" or 2. Set ...Show All

• Visual Studio VSS automation

  Hi, I have created a small automation program to get my projects from a VSS database. the problem is when I try it in my machine everything works without problems but when I try to run it on another machine (a server with Windows 2003) I get the HRESULT code -10550 that corresponds to: Bad username syntax: "%s" can you help me please Thanks this is the code I'm using Note: the errorMessage function is used only to print the error code CLSID clsid; IClassFactory *pClf; IVSSDatabase *pVdb; BSTR bstrPath = SysAllocString(_iniFile); BSTR bstrUName = SysAllocString(_userName); BSTR bstrUPass = SysAllocString(_password); CoInitialize(0); if(S_OK == CLSIDFromProgID(L"Source ...Show All

• Visual Studio Team System Linking Work Items

  Can someone please point me in the direction of more info on how to link work items and tasks What I'd like to do is create a high-level task in MS Project, Publish it to TFS and assign a number of related sub tasks and then get a summary update when I Refresh back to MS Project without having all the related sub tasks in my project plan. thanks Hi, The recommended practise for working with Project and TFS integration in V1, is to create and maintain your project plan separately. Dynamic recreation of the project with the summary and subtasks laid out in Project is not yet supported. We're adding support for this in the next version of Team System. For now, you will need to refresh the subta ...Show All

• .NET Development Difference between Console.WriteLine and Console.Out.WriteLine?

  Hi, What is the difference between Console.WriteLine and Console.Out.WriteLine in .NET Thanks & Regards, kalai There is no difference. Because writing data to the console is so common MS decided to expose the common TextWriter methods directly off the class. The Out property is available if you need a TextWriter , such as for piping output from another application. Internally the methods simply call the Console.Out method. For cleanless and ease you should prefer the methods exposed directly from the class. Note also that Console probably exposes some overloads or additional methods that make working with Out easier so not all the methods are necessary supported in TextWriter . Michael Taylor ...Show All

• Visual C++ Problems with Char*'s and LPCWSTR need help

  I am trying to use the openregistrykeyex or openregistrykey function from the windows.h include file and I have the following code HKEY hKey = NULL; char * temp = "String" ; int len = strlen(temp) +1; wchar_t *wText = new wchar_t [len]; if ( wText == 0) return 0; memset(wText,0,len); ::MultiByteToWideChar(CP_ACP, NULL, temp2.c_str(), -1, wText,len); const wchar_t * test = wText; //long tempResult = RegOpenKey(HKEY_LOCAL_MACHINE, test, &hKey); long tempResult = RegOpenKeyEx(HKEY_LOCAL_MACHINE, test,0, KEY_READ, &hKey); Neither work and I can't understand the cryptic error codes if someone could help me unravel the error codes error code = Error 1 error LNK2028: ...Show All