Bassam72's Q&A profile

• SQL Server SQL server 2005 POOR performance on a good dev machine

  Hi there, I was wondering why my installation of SQL server 2005 on my Del inspiron notebook is so slow when using the Management Studio. I get the message that sql server is waiting for a process to finish quite often and it just seem to be bloody slow in general- like when i populate a table by hand I have a dual core intel 2.6gHZ Dell Inspiron with 1gigs of RAM and a 7200rpm drive. It should be more than sufficient. Regards Mike I am having exactly the same issue on my dual core AMD. It runs faster on my 2.8 celeron laptop on MSDE 2000. Something is wrong with SQL Express and dual core. I wish MS would get on this problem ...Show All

• SQL Server SqlServerCe.dll

  Hello, Iam devloping a product for a mobile unit using Windows mobile database. (*.sdf) Is it possible from other form applictions, such as ordernary Windows forms Have a wonderful day! This is the purpose of SQL Server Everywhere Edition. One SDF file that can be used on desktop with Windows Forms apps and also on device with .NET Compact Framework Windows Forms apps. Darren ...Show All

• Windows Forms Tooltips Cut Off

  Has anyone experienced balloon style tooltips (IsBalloon) being cut off Many of my tooltips in my application have the last few characters cut off by the end of the balloon. It looks as if they are miscalculating the length of the text. Is there anything that can be done So do this toolTipText = " " & toolTipText & " " Must be a problem with visualstyles... got windowblinds installed ...Show All

• Visual Studio 2008 (Pre-release) MediaElement - not playing video.

  I am having a lot of trouble playing an MP4 video in MediaElement. I have installed a DirectShow filter which GraphEdit shows is being used to render the video, and it also shows okay in WMP 11. Unfortunately the video (several MP4s that I have tried) fail to show in MediaPlayer. No exception is thrown and the MediaFailed event is not fired. I initially thought this might be codec related but I have now tried 3 different MP4 codecs. ...Show All

• SQL Server Connecting to Oracle on 64-bit (x64) machine

  Hi, Has anyone received the following error when trying to create a connection to an Oracle database using SSIS installed on a 64-bit (x64) machine "Test connection failed because of an error in initializing provider. ORA-06413: Connection not open" The reason this is funny to me is because I have the same Oracle/SSIS setup on a 32-bit (x86) machine and I can connect successfully. On both machines I have SSIS RTM, Oracle 9.2 and using the Microsoft Ole Db Provider for Oracle. Thanks, - Joel Oracle has released a patch that resolves the (x86) issue on x64 Windows servers. I tested the patch on two servers and I can now connect to an Oracle server via the default locations for SQL management studio and ...Show All

• Smart Device Development I want to have a button navigating to My Documents

  I want to have Buttons in a VB Form navigating to places like,My Documents, Network Places, My Pictures etc. Does anone know code for me to be able to do this... Thanks And it promised to " take you to the folder " Could you please post help URL ...Show All

• .NET Development LNK2022 error

  Hi all, We have mixup of managed and unmanaged code. Managed code we compile using /clr:oldsyntax option. We do not use packing. Now we want to compile all the files wether managed or unmanaged using /clr:oldsyntax option. When I do so , I get following errors: prfinpz4.obj : error LNK2022: metadata operation failed (8013118D) : Inconsistent layout information in duplicated types (_devicemodeA): (0x020002d7). wptinpcp.obj : error LNK2022: metadata operation failed (8013118D) : Inconsistent layout information in duplicated types (_devicemodeA): (0x02000312). prfinpz3.obj : error LNK2022: metadata operation failed (8013118D) : Inconsistent layout information in duplicated types (_devicemodeA): (0x020002c8). I found that _devicemode ...Show All

• Visual Studio Team System MDX syntax question

  Hello, I am starting to play with customizing some of the TFS Reports and have been able to create a couple of simple ones on my own. I am just trying to get my head around MDX and learn the basic syntax by playing with some of the box reports. I am having a simple problem however and I don't understand what is wrong. I am trying to modify the Remaining Work report and add in a filter in the WHERE clause that only returns items where the Exit Criteria is set to false. i.e. [Work Item].[Microsoft_VSTS_Common_ExitCriteria].&[Yes]. So my modified query looks like this. ---START WITH MEMBER [Measures].[Date Key] AS [Date].[Date].CurrentMember.UniqueName SELECT { [Measures].[Date Key], [Measures].[Cumulative Count] } ON COLUMN ...Show All

• Visual C# Immediate window in C# VS2005 - how to loop through collection

  I've got an error during loading data into DataTable - "Constraint violation...Relax constraints.". I need to loop in immediate window to find DataRow that HasError. I tried: foreach(DataRow dr in dtab) if(dr.HasErrors) Console.WriteLine(dr["ID"]); but it failed: Invalid expression term 'foreach'. Is there any way to achive it Billberry I asume you just want to foreach through the rows. Your initial lines of code was not perfect. foreach(DataRow dr in dtab) if(dr.HasErrors) Console.WriteLine(dr["ID"]); It should be: foreach(DataRow dr in dtab .Rows ) { if(dr.HasErrors) Console.WriteLine(dr["ID"]); } Hope this helps. Marcel ...Show All

• Windows Forms Leftover pixels From DrawReversibleLine

  I am creating a drawing program...  When I draw a line I am capturing the mouse, and drawing a reversible line, which I store and redraw (to erase the line) if the mouse moves to another point.  The last line will be the the one I capture on mouse up. This works, except there are a few remaining jagged edges created during the process.  They all disappear after mouse up, but they are anoying anyway. Does anyone know how to fix this   When I have done this in the past against the Win32 API, it was very clean, and I am looking for that cleanliness. Do I have to use the API calls Thanks, Bob Do you know if this works correctly in Vista RC1 I have a similar program, in C# ...Show All

• SQL Server Backup databases

  Hi I'm trying to setup a back up plan for a number of databases, I initially set up one plan to include all user databases which worked fine or so I thought, when I check them a few days later I noticed that some of the databases were not appearing in the backup set, the only way I could get these to appear is to set the comp level to 90, now when we run certain applications we get an error, when I return the comp level back to 70 then the application works fine, is there a reason I can not back up any database on sql 2005 without it being a comp level 90 Thanks inadvance I see that on my system as well. Is compatibility level 80 an option for you Databases with that compatibility level ...Show All

• .NET Development Multithreading problem for multiple methods (Semaphore)

  Hello I have this problem. I use a class that has some methods in it that runs concurrently (Another object manages many instances of this class). Here is the constraint:- method1() can run up to 10 threads at a time method2() can run up to 5 threads at a time if there is method1 running (even only 1 thread), method2 cannot run. if there is method2 running (even only 1 thread), method1 cannot run. Anyone has a solution to this problem for method1 and method2 themselves to run up to 10 and 5 threads, I can control using semaphore but how to do mutual exclusion between method1 and method2 Thank you Pi. But if so (using mutex to block inside method1 so another thread cannot call method2), another thread can ...Show All

• Windows Forms Uninstall old application before installing via setup project msi?

  Is it possible to have a custom action run BEFORE the files are installed using a VS2005 setup project I need to uninstall any old versions of our software written in VB6 before installing the newer .NET version and so far I've only been able to do this AFTER the .NET files are installed which creates some problems. I suspect it isn't possible to do this except through WiX or some other more robust msi creation process but a setup project would be simpler. Thanks! The older product was installed via a WISE installer.  I think I may have a workaround for the problem now though.  I just have to change a couple things in the newer .NET version so it doesn't matter if the older prod ...Show All

• Windows Forms Using datagridTableStyles on grids that are populated to a dataset with multiple relationships

  Greetings, I have a data grid that is populated by a data set. This particular data set contains three tables (one parent and two children) that have relations set up. I'm trying to remove a column from each table when it is displayed on the grid. Removing the column for the parent table wasn't a problem. It is trying to remove the columns for the child tables that is making me scratch my head. I was thinking it was a simple matter of using similar code for each child table. However, this does not work. I'm not sure the tablestyles collection contains the child table names. ( Not sure how to check this ) Also, I'm assuming I have to create new datagridstyles for each of the new table styles. However, in debug mode these child d ...Show All

• SQL Server Union of several sets over fact table

  What will be the most efficient way to union MDX sets For example, I have User and Account dimensions. Each member in the User dimension has flags that control what accounts the user can see. For instance, by default the user can see only the accounts the user owns. If the Team flag is on, the user can see all accounts owned by the team the user belong to (I need to find all User members that share the same team).   Or, if the Confidential flag is on, the user can see confidential accounts. Based on these flags, I need to find the union among the allowed sets of accounts. Given our current design, the sets need to be evaluated over the fact table.   I am thinking of using an SSAS stored procedure to evaluate all of these r ...Show All