MuscleHead's Q&A profile

• SQL Server Importing data from MS Access using DTS 2005

  Guys, I am new to DTS 2005; having trouble on how to connect to MS Access to pull data what kind of connection manager should I use (OLE ) and what specific Data Flow Source type Please respond. Thanks You can use GetOleDbSchemaTable to check whether the sheet exists. http://support.microsoft.com/kb/309488 ...Show All

• Smart Device Development Unable to create cab files in visual studio 2005

  Hie, i think i am facing the same problem, so i just reply here instead of starting a new thread. if this isn't the same problem, i will create a new thread later. i followed the how to article on using smart device cab project to create the cab files. i successfully created the cab file and when i copy it to the device via activesync, it install successfully. but when i package it into a installer and use ce application manager to install, it say this is an invalid setup file. so i open the cab file and compare it with the sql ce cab file. and guess what, it is different. In the cab file that i create, it doesn't have a *.999 file, but all the other cab files like sql ce, sql ce client, and compact framework have. so, what am i d ...Show All

• Software Development for Windows Vista Writing to HKLM

  I'm using the RTM release of Windows Vista and testing my application to see if it will run on Vista as a standard user. I'm seeing some strange behaviour and I'm wondering if anyone can help me figure this out. My application writes some data to HKLM\Software. I was expecting to see this write getting redirected to the VirtualStore when running as a Standard user. However, that does not seem to be happening. My app is able to write to HKLM\Software. My app is not running with elevated privileges and Virtualization is ON. I even tested my app with the Standard User Analyzer tool thinking it would possibly show me some errors when writing to registry but nothing showed up there either. Strangely enough, I see the same behavior when running ...Show All

• Visual Studio What's wrong with MSVS SP1? It does not extract at all...

  The file name is: VS80sp1-KB926601-X86-ENU.exe After quite a few hours(> 4 + ) waiting, it still did about 60% of extraction... and the process seemed dead. I killed it a few times and re-executed it, it didn't work at all. I rebooted my Windows XP several times. Still didn't work. What's wrong I am using MS Visual Studio 2005 Academic version. Thanks Check this blog to see if anything mentioned in there might fit to your symptoms: https://blogs.msdn.com/heaths/archive/2006/12/29/the-visual-studio-2005-service-pack-1-installation-experience.aspx -- SvenC ...Show All

• .NET Development Doubt in NGEN and CLR

  Hi, I need some basic low level details of what happens when you ngen a .NET assembly. Lets take a c++ code which when compiled creates a binary executable. On executing this binary, the OS allocates memory for the process and executes it. No concept of runtime or CLR here. Everything is present in the binary. I read the MSDN and understand that .NGEN creates a native image of the code and avoids JIT compilation while execution by the CLR. Hence, at the end, I understand that the ngen creates binary code for specific processor. If the native code (binary) is ready then why cant the OS take care of executing it and why the .NET runtime has to do the execution What does the CLR do then for a ngended assembly I seem to get co ...Show All

• Visual Studio Team System Report Builder based reports are broken after installing SP1

  Hi We've just installed SP1 both on server and workstation machines. Everything works fine except SQL server reports built with Report Builder. All of them are just custom chart reports displaying statistics in different views. Now they're appearing blank. Reports built using Visual Studio (not using report model) are working fine. We're using standard report model generated over TfsReportDS data source. I've tried to regenerate report model but this doesn't help. All report definitions opened in Report Builder are looking OK. Any thoughts on resolving this issue i'm glad everything seems to be working fine now. btw, we dont recommend using report builder against our cube since we've noticed some issues with it - w ...Show All

• Windows Forms Refreshing Datagrid

  Hi, I have a requriement in which I have to refresh the datagrid every second without clicking on Refresh button. How can I go about doing this in C# 2.0 Quick help would be appreciated. Regards, Pooja. If you want to refresh your DataGrid along with the data in a timely manner then use a Timer object. In its tick event refresh its under lying datasource. Like if you are using a DataSet filled by a DataAdapter then call DataAdapter's update method. ...Show All

• Visual C# Warning: "The referenced component 'System' could not be found."

  Does anyone know why (or even better, how to fix) VS 2005 randomly generates warnings like: "The referenced component 'Some .NET assembly' could not be found." then when you click on the reference in the Solution Explorer, it magically fixes whatever problem it thought it had How do I stop these warnings from showing up again Thanks for any help with this. dougzhoez Did you had .net 2.0 beta before you installed vs2005 I had similar problem with a different component. uninstalling the beta version is not always clean. Go to <WINDOWS>assembly folder and check if you have multiple copies of System assembly with the same version I had to delete multiple copies for my ap ...Show All

• .NET Development Fatal Execution Engine Error (7A05E2B3) (80131506)

  hello and thanks in advance for your help :) i am having an issue with the "Fatal Execution Engine Error (7A05E2B3) (80131506) " causing my program to crash. this is an intermittent problem, but i have tracked it down to using some external DLL calls. I have an application that is using the National Instruments GPIB drivers to communicate with some electronic test equipment. I have used these DLLs in VB6 for many years and have NEVER had a problem. here is an example of the declare statements i am using: Declare Function ibwrt32 Lib "Gpib-32.dll" Alias "ibwrt" ( ByVal ud As Integer , <MarshalAsAttribute(UnmanagedType.VBByRefStr)> ByRef sstr As String , ByVal cnt As Inte ...Show All

• SQL Server Output Varchar column

  Hi, I am dumping varchar(40) column from a OLE DB Source to Excel file but it is failing due this error [Excel Destination [239]] Error: Column "ItemDescription" cannot convert between unicode and non-unicode string data types. How can I resolve this issue Thanks On my package, I'm importing a text file to a table. I also have to export to excel, to check the data later. I have 50 columns of many data types and when i export to excel, i have to convert all this columns to Unicode_String. Is there some way to convert a lot of columns to a same data type If i could in the Data_Conversion component select all the columns and change the data type, the problem already would be solved, but i can't. If you knows a ...Show All

• Software Development for Windows Vista GetStreamOfSections stops responding after SubmitTuneRequest

  I'm developing a BDA based TV application using GetStreamOfSections on the standard "MPEG-2 Sections and Tables" filter to retrieve the MPEG2 information tables. Everything works correctly at first, however when I submit a new tune request to the tuner the GetStreamOfSections stops sending data. The symptoms are not consistent - If I am listening to multiple tables then sometimes all of them stop responding. Sometimes only some of them. Similarly, even with 1 table it doesn't alway stop responding, however it does most of the time. Does anybody have any suggestions on what may be happening and how to avoid it I had the same problem with GetStreamOfSections. I solved it, by inserting a separat ...Show All

• SQL Server Upload a Sql website to a host server

  Hi I have built a site in Visual Web developer Express 2005. it works fine on my local machine but when I load it up to the server I get the following error message: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) My connectionstring in my web config file: < add name = " ConnectionString " connectionString = " Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True " providerName ...Show All

• Visual Studio 2008 (Pre-release) svcutil and IDictionary

  I use the /ct option on svcutil to specify the collection types I want it to use for lists and dictionaries: /ct:System.Collections.Generic.IList`1 /ct:System.Collections.Generic.IDictionary`2 The first one works - it generates all generic list types using IList<T>. But the second one does not work. It still uses Dictionary<K, T> instead of the interface I specified. Is this a known problem or am I missing something Thanks... Hi, ReyCri, thanks for the follow up. Apparently I was reproing your problem different with the way you used it. Because I didn't see your contract, so I tried to repro it for datacontract so I used commandline option /dconly and /ct, in this case, the svcutil generated something li ...Show All

• SharePoint Products and Technologies Can you use Active Directory Manager data in workflow?

  I can’t seem to find a way to automatically rout a workflow task to a user’s manager using the person’s "manager" value from Active Directory. This seems like such a basic task, but I don’t see any option for it in the workflow roles available in SharePoint or SharePoint Designer. Has anyone had luck with this I found this site that has an Active Directory Role sample. I installed the WFSamples but haven't had time to look at them yet. I know that you can't access AD roles in InfoPath, and it might be the same for SharePoint Designer. I think Visual Studio will be the way to go. http://msdn2.microsoft.com/en-us/library/ms741720.aspx I say start with one workflow that grab ...Show All

• Windows Forms TreeView problem

  Hi, I have a treeview control that will not select the correct node. I have the following method that builds the treeview's nodes based on an id that is passed in: private void LoadTree( long lId) { DataTable dtTree = GetTree(lId); System.Windows.Forms.TreeNode parent = null ; System.Windows.Forms.TreeNode tn = null ; long lParentId = 0; if (dtTree.Rows.Count > 1 && tvLocations.Nodes.Count > 0) { // find the parent node in the root nodes foreach (TreeNode t in tvLocations.Nodes) { if (Convert.ToInt64(t.Tag) == Convert.ToInt64(dtTree.Rows[0]["location_id"].ToString())) { parent = t; lParentId = Convert.ToInt64(parent.Tag); break ; } } // ...Show All