mike.cann's Q&A profile

• SQL Server Data flow source for MS Access in SSIS package

  Hi, I am newbie to SSIS. I am facing the same problem when connecting to Access 97 database. I can't connect to the database on local machine where the SSIS is installed using File connection as well as OLEDB connection. Any help on this will be really appreciated. Thanks Vik Hi Sebastien, My sincere appology for late response as we had long weekend (Holiday) here. I have designed new test package for connecting to access. When I am trying to connect to local northwind Access database through OLE DB connection, I am getting this error: Test connection failed because of an error in initializing provider. Could not attach file 'C:\Db\Access\Northwind.mdb' as database 'Northwind'. ...Show All

• SQL Server Distribution Calculation

  Hi Can someone please tell me how I can take a set of sales orders and generate a table or set of data that show the percentage of sales per product which are in different sales ranges eg Socks - Beige 50% Orders are above $100 20% Orders are above $90 and less than 100 30% Orders are above $60 and less than 90 Many thanks for your time TV Thankyou very much Louis If I want this distribution per store do i just add the following to it select StoreID, count(*), sum(case when value >= 100 then 1.0 else 0 end) / count(*) * 100 as [100Up], sum(case when value < 100 and value >= 90 then 1.0 else 0 end) / count(*) * 100 ...Show All

• Windows Forms installation folder & windows installer

  hi all, is there a way to check the installation directory of msi package and prompt the user if the folder they choose is not valid. if so can anyone point me to the right direction ,i tried custom action or installer class c# and i am not getting no where. any help is greatly appreciated. You might be able to do a search to find that other folder, and in any case you can delete that dialog that offers the user a choice of installation folder. See if the searches here help: http://www.simple-talk.com/dotnet/visual-studio/getting-started-with-setup-projects/ around Fig 13 because a custom folder seems to be exactly what you need. ...Show All

• Visual Studio Team System DoNotDeclareStaticMembersOnGenericTypes again

  There was a post more than a year ago: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=84539&SiteID=1 . Any news on this rule Alex, Just thought I would let you know that the second bug (DoNotDeclareStaticMembersOnGenericTypes firing on protected members) has been fixed in the latest build of Visual Studio/FxCop and will present in the next release of both of these. Regards David ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Is it worth it to learn .Net for XNA?

  As a developer I have put most of my efforts into learning Suns Java libs. However, I am really looking foward to coding for XNA, my only consern is: Is it worth my time learning the .Net libs, specifically GDI+, Or will XNA use different libs for graphical output. Will there be a way to draw primitives I can't find how to draw primitives easily in .Net. I really like using Primitives for gaming becuase they save memory, and I can't draw well. Speaking of that(and getting way! off topic), has anyone heard of Kenta Cho He makes all of his games using simple primitives, although in OpenGL, and XNA is DirectX like. Anyway, my point is. Will XNA have a more game centric library than .NET and will it have prebuilt common classes like Sprite or ...Show All

• Visual Studio I cant add a project to VSS 2005 even though the option is there

  Can someone help me please. I am trying to add a project to a new VSS database on a network drive. I created the database just fine using VSS administrator and then opened it up and tried to add a project. It acts like it is going to add it but just blinks with no error message. All I have showing is $\ as the root. The network drive is a simple network storage unit and VSS easily adds the database to the drive so there doesnt seem to be a permissions problem. After it blinks if I try to add the same project a second time it says it is a duplicate but it never shows the project or allows me access to it. My workstation is running Windows XP with service pack 2. Any help would be greatly appreciated. Can you provide more information ...Show All

• Visual C++ C++ CodeDOM parser error: Internal Error

  For a component I am developing I get, when trying to bring up the component in the IDE's designer: "C++ CodeDOM parser error: Internal Error at Microsoft.VisualC.CppCodeParser.OnMethodPopulateStatements(Object sender, EventArgs e) at System.CodeDom.CodeMemberMethod.get_Statements() at System.ComponentModel.Design.Serialization.TypeCodeDomSerializer.Deserialize(IDesignerSerializationManager manager, CodeTypeDeclaration declaration) at System.ComponentModel.Design.Serialization.CodeDomDesignerLoader.PerformLoad(IDesignerSerializationManager manager) at Microsoft.VisualStudio.Design.Serialization.CodeDom.VSCodeDomDesignerLoader.PerformLoad(IDesignerSerializationManager serializationManager) at System.ComponentModel.Design.Serialization ...Show All

• Visual Basic How to retrive from a databbase using vb.net

  i want to make a search box and when the user for something i want it to search it the databse and show the resultat. can someone help me how we do this with the code. tanks well you pretty much write your SQL query in there in the SQLCommand, or if you are using a StoredProcedure, just write the name of the stored procedure and changing the "CommandType" to "StoredProcedure" in the SQLCommand. so in the example, I was just getting all the records from a table (with a search criteria), and filling the dataAdapter with results ...Show All

• Visual Basic Quick Question About DataGrid type of UI in Task Manager ???

  Hello, Please open your Task manger and see the different tabs applications, processes, performance and so on.... my question is that DataGrid has both rows and columns Drawn but in task manager there are no such horizontal lines or vertical lines. Is this control DataGrid or someone other If it is DataGrid how i can remove the lines Please answer if you know... it will only take 2 minutes. Thank you. ...Show All

• Visual Studio 2008 (Pre-release) Can anyone help with video and clip path?

  I'm trying to display a video which is clipped by a text path. The effect I'm after is to display the moving video on the 'surface' of the text. Should be simple eh I see the text path but no sign of the video. The events attached to Window.Loaded and MediaElement.Loaded fire as expected, and the video is loaded. Can anyone help me get the video displayed Thanks Dave Arkley XAML and code-behind are: XAML < Window x:Class = " VideoText.Window1 " xmlns = " http://schemas.microsoft.com/winfx/2006/xaml/presentation " xmlns:x = " http://schemas.microsoft.com/winfx/2006/xaml " Title = " Video in Text " Background = " Black " Name = " my ...Show All

• .NET Development class library

  where can i see the class library i mean where the class library are,in which folder The assemblies for the base class libraries are usually in c:\windows\microsoft.net\framework\v1.0.3705, c:\windows\microsoft.net\framework\v1.1.4322, c:\windows\microsoft.net\framework\v2.0.50727, etc. ...Show All

• SQL Server How to receive mails, when a record is entered into my error log table?

  I'm using SQL Server 2000. I want to receive a mail for every new entry, into my error log table. I want to receive the inserted value in the form of subject of the mail and some other text column's value as the body of the mail. Plz. guide me. Best Regards Trinadh P. SQLNS can certainly do this, but depending on your circumstances another technology - including Database Mail or an external SMTP XP - may be better suited for the task. If you opt for the SQLNS route, take at look at one of the samples provided with the install and mimic one that uses the SQL Server Event Provider. HTH.... Joe ...Show All

• Community Chat User Interface Oriented Application Development

  Hi all, my name is Babak K. Farahani, who was thinking about User Interface Oriented Application Development concept for just 15 years! Three years ago after lots of different implementation I decided to develop the first application that could generate applications based on the UIOAD concept. As I never thought I must register the concept at the time, I never published anything about my dreams. Recently with help of my friends, we published a paper on UIOAD and set up the www.uioad.org to ask all other developers around the world help us in completing and developing the concept. So, I invite everybody to the site and appreciate your comments, idea and ... Regards Hello, do you have a graph for it I cannot picture ...Show All

• .NET Development Choose between availible networkinterfaces

  Hi Is it possible to choose what networkinterface that i want to use when there are several availible For example, If i have a gprs connection, wifi connection and ethernet connection is it possible to choose to use the gprs connection instead of the ethernet or wifi connection This if for a laptop that might or might not have and internet connection through the lan, if the lan dont have internet access i want to use the gprs connection. I might even want to choose to use the gprs connection even if i have inbternet access through the lan. So, is this possible and if so, how Regards /Anders Hello Anders :), There is a class "NetworkInterface" in System.Net.NetworkInformation namespace, That i ...Show All

• Visual Basic item check delay, how to overcome it

  I'm using the code below to change a checkbox's checked value depending on whether or not certain items are checked in a checkedlistbox. However, there is a delay; the checkbox's value is not changed until after a second click on the checkedlistbox item. Is there another way I can do this Private Sub clstFactors_ItemCheck( ByVal sender As Object , ByVal e As System.Windows.Forms.ItemCheckEventArgs) Handles clstFactors.ItemCheck If clstFactors.CheckedItems.Contains( CheckedText1 ) Or _ clstFactors.CheckedItems.Contains( CheckedText2 ) Then chkTwoSources.Checked = True Else chkTwoSources.Checked = False End If End Sub Yes it is. The checkboxes within ...Show All