Dareman's Q&A profile

• SQL Server File Groups

  Hi everyone, While creating our database in only one disc(C or D), suppose that we create more than one file group in order to group our data files. However, in this situation; I wonder that whether it brings any benefit or advantage to us. Also, I wonder that why we always have to put our data file into separate file group if we use separate discs for data files. Is not it allowed to use only one file group even if we use separate dics Would you explain these to me Thanks Hi, There something make me still confused about this topic. For example, when we call some columns from a table with Select query statement, do the SQL server do this by first finding the file group that this table located in and then finding the corresopnding t ...Show All

• Visual Studio 2008 (Pre-release) WCF Adapter for BizTalk

  Hi every one, Anyone know about WCF adapter for biztalk Thanks Amit Hi Sajay, Im looking for some how to use samples/ documentation/ help regarding WCF BizTalk 2006 adapter (from gotdotnet community), but no luck. Please let me know if you have any information related to this. Is there anyway we can get hold of (at least a beta release of ) MS version of WCF BizTalk 2006 adapter Thanks in advance -hantana ...Show All

• SQL Server Catching an exception from a Web service task

  Hi! I am quite new using SSIS and I have a problem with catching an (SOAP) exception from a Web service task. Some times my web service task can fail and when the web service is failing, it is throwing an exception. When the task succeeds the result is being put into a variable, That part is not a problem. But catching an exception is. I have tried to use a script task and tried to get exception from the dts object model. I have not yet succeeded on that. But it might be a possible way to go. A different approach might be creating an OnError event on my web service task which I can create a task when triggered. But I have not found any solution yet and I hope some people out there have done this before or have a solution on this. ...Show All

• Visual Studio Report Viewer shows error then loads the report

  Hi I m working with client side reports (rdlc). When I load a report, report viewer displays following error: "An error occured during local report processing. Failed to load " After displaying this error for a few seconds, the report is shown correctly. Now I cant understand why this error occurs. Can anyone help me resolving the problem. Thanx in advance. I have been having this same problem, with the error message "Report processing has been cancelled" showing for a few seconds and then the report loading without any noticeable problems. I noticed that when I run the program through Visual Studio 2005 this doesn't happen, it's just when I run the .exe on its own. Have you ...Show All

• SQL Server Confusion over @@ROWCOUNT test

  I have a pair of services. One is an initiator of a conversation, another is a target. I have a pair of message types, one sent by the initiator one sent by the target. I have a pair of queues corresponding to the above services. Both queues have activation stored procedures associate with them. The intiiator sends its mesage to the queue that the target service is defined on. The activation procedure successfully retrieves the message, does some work and then sends a reply message on the same conversation to the initiating service. At this point behavior seems to become strange. Some of the time the send from the target service produces the "zero length message" error and indeed at times the message body is em ...Show All

• SQL Server FlatTextFile Licence Limitation with SQL 2005 Standard

  I have developped a package that loads a flat text file into DB. Runs OK from SQL BI Studio. When I run it from SQL IIS, I have the following error message "Erreur, le niveau de produit est insuffisant pour composant <<file IN>>" that let me think this FLATTEXT ConnectionManager is only in SQL 2005 Enterprise version Can you help Darren, I tested it again. Using TSE on the SSIS server directly. No problem when executing the DTSX from SQL Management Studio. Having error message when executing the DTSX from SQL Management Studio from my PC! I didn't install any SSIS server on my PC. ...Show All

• Visual Basic Reading/Writing INI Files

  I Add this code in a Module And i wrote this file that i called "Italian.lng": [DATA] Field1 = Speaker <DllImport("kernel32.dll", SetLastError:=True)> _ Public Function WritePrivateProfileString _ (ByVal lpApplicationName As String, _ ByVal lpKeyName As String, _ ByVal lpString As String, _ ByVal lpFileName As String) _ As Integer End Function <DllImport("kernel32.dll", SetLastError:=True)> _ Public Function GetPrivateProfileString( _ ByVal lpAppName As String, _ ByVal lpKeyName As String, _ ByVal lpDefault As String, _ ByVal lpReturnedString As StringBuilder, _ ByVal nSize As Integer, _ ByVal ...Show All

• SQL Server Preview has data but no columns returned

  In my SSIS package, I connect to an external SQL server database. This external database supports a stored procedure that I need to execute to "retrieve data". So in my package, I set the DataAccess Mode property of my OLEDB datasource to "SQL Command" and I provide the command EXEC <proc_name> <Param>,<output_param>. (The proc has an output parameter). The preview shows all the columns and data, but somehow no columns are returned....so when I try to link this data source to a copy column task, I get an error saying the source does not have any columns...any idea why this could be happening. Thanks - Manmeet Manmeet Panigrahi wrote: ok...now there is a new twist to the tale. I just foun ...Show All

• Visual Basic How to extract files from zip file

  Hello Can I extract files from a zip file I have Thanks not entirely. you may need to use 3rd party zip software like pkzip to execute it in a process and give it the right commands to extract the files or maybe some Win32 P/Invoke if the OS is Windows ME or higher as it has zip built in. The .NET Framework 2.0 has a Compression namespace but that is for GZip which is a different zip format I believe ...Show All

• Visual C# learning to live w/o pointers (C++ programmer here)

  Good evening- What I'm trying to do is take a variable, place a reference to it in a container, have some math operations act on the whole container (which might have any number of references to variables) and then be able to access the original data in the original variable. Hope that wasn't too confusing. In C++ this was performed by using references and pointers - I'd pass the variable to a function by reference, make a pointer, place the pointer into a container, do my operations, and at any time I could query the original variable and get the updated results since the pointer pointed back to it. How is this accomplished in C# I banged my head up against the wall for a few hours this evening trying a few things but I don't quite see ho ...Show All

• Smart Device Development Adjusting forms and its controls

  My application was developed to work in landscape mode with a fixed size, but assuming that i deploy my application to a PDA with a bigger screen or different resolution how can i assure that my application will adjust itself Besides if i change to vertical mode my pda doesn't adjust by it self, he doesn't create a vertical or horizontal bar, has he create in landscape mode(he creates only a vertical bar) ! Does anyone have ideias how to solve this problem I', using windows mobile 5.0 with CF2.0. There are any software to measure the amount of data transfered between my PDA and my PC I need this to simulate the amount of traffic that my application will generate in certain operations. This post ...Show All

• Visual Studio Express Editions Just a question regarding MDI form and ToolStripPanel

  Is there a possibility to disable the MDI scroll when ToolStripPanel appears on screen I created an MDI form with two ToolStripPanels at left and right (with dock property set in appropriate way) and I use those containers for a ToolStrip menu (in order to drag and drop it from left to right and vice versa on demand, like a toolbar). The ToolStripPanel is normally hidden (visible=false). It comes on screen only if appropriate button pressed. So, my problem comes if a child form is also open into mdi. In fact, the mdi form by default scrolls to right (or to left) the child form when I open the toolstrippanel, in order to preserve screen place. I want disable this behavior, because I want that toolstrippane ...Show All

• Visual C++ suggest me a forum to discuss about Driver Installer Frameworks

  i am developing a driver installer application... so i went for driver installer frameworks.. now i am using Driver Package Installer (DPInst) to install the driver packages. but the problem is some of my drivers are not digitally signed... and hence it rises a user confirmation dialog... and if i go for silent mode installation, its failing by giving error msg: "NO_OEM_CATALOG FOUND" sooo can ne 1 tell me how can i proceed with... Your best bet would be the win32 dev newsgroups at http://msdn.microsoft.com/newsgroups Thanks, Ayman Shoukry VC++ Team ...Show All

• .NET Development Interop COM: SOMETIMES, com object become System.__ComObject.

  I have to interop with COM and transport the IUnknown pointer between managed and unmanaged code. I used to create the COM instance in managed code like: appDomain->CreateInstanceFromAndUnwrap to create Object and pass it IUnknown pointer to unmanaged Code. Later, I get the IUnknown pointer and try to get the object like: step1: Build a Variant using IUnknown pointer; step 2: Marshal:: GetObjectForNativeVariant. In the most time, the procedecure works well. :( The PROBLEM is the return value of GetObjectForNativeVariant sometimes become System.__ComObject. The PROBLEM is ramdom. :( And I can not point out the reason) I has tried Activitor::CreateInstance, it doesn't work well, too. ...Show All

• Visual Studio Team System No permission to add work items

  A user is getting that they do not have the permissions to create a work item.  What could cause this At first I thought our work item type must have a [for=] clause associated with it, but it's the default with no restrictions: < TRANSITION from = "" to = " Proposed " > < REASONS > < REASON value = " Build Failure " /> < DEFAULTREASON value = " New " /> </ REASONS > < FIELDS > < FIELD refname = " System.AssignedTo " > < DEFAULT from = " currentuser " /> </ FIELD > </ FIELDS > </ TRANSITION > Secondly, I thought it was because this user is assigned to a custom group in our TFS project called Project Managers.& ...Show All