Frode Fiplingdal's Q&A profile

• Visual Basic VISUAL BASIC & SQL SERVER

  I TRIED TO RETRIEVE DATA USING VB CODE AGAINST SQL SERVER, BUT I GOT TIMEOUT ERROR MESSAGE: "Run-time error '-2147217871(80040e31)': Timeout expired". (I GUESS BECAUSE THAT PARTICULAR CODE TAKES MORE TIME THAN NORMAL PROCESS). HOW CAN I GET RID OF THE TIMEOUT ERROR I TRIED WITH "ON ERROR RESUME NEXT", BUT IT DID NOT WORK EITHER. Please help If your error is actually a timeout error and not a connectivity issue then you can alter the default (15 seconds I believe) by adding the "Connect Timeout = ##" parameter to your connection string (replace the "##" with the number of seconds you wish to w ...Show All

• Windows Forms Representing Database Table Inheritance in a DataSet

  I am sure you've all run across the idea of 'required' duplication of information in your databases. This is the idea of for instance, a person in the employees table can also be a customer but you must enter the information twice, once in the employees table and once in the customers table. Not 'really' a big deal, but we are investigating methods to automatically handle this without entry duplication. In this simple example, we see unique information as a 'Person' so we have a Persons table Persons PersonId LastName FirstName Then we have an Employees table Employees PersonId SocialSecurityNumber And ...Show All

• Software Development for Windows Vista SetWindowsHookEx and JournalRecordProc

  Hi, SetWindowsHookEx(WH_JOURNALRECORD,JournalRecordProc,hInstance,0) This is failing on Vista build 5231. Is this just not supported yet in the beta or is there a change to the SDK that I'm not aware of Thanks, Marcus Hi, I am looking for an answer to this also. When I call SetWindowsHookEx specifying Journal record I get an access denied error. Other hooks such as low level mouse seem to work fine. Does anyone have any infomration on this thanks, tim ...Show All

• SQL Server Export the data as an XML file?

  I have two tables in my database like this. AppsTable with columns INSTANCE_NAME, VALUE. SecondTable with columns UID,SID,XID I need the xml file like below. - - where commonID  is the Value of  UID from the second table, appInstance name is the instance_name from the appstable.           If i have values like this in second table:                SID        UID           XID ...Show All

• Windows Forms DataGridViewComboBoxColumn and Enum values

  Hi, I'm trying to use a ComboBoxColumn in a DataGridView to allow editing of an enum value in a class. E.g public enum Stuff {    Apples,    Pears,    Oranges } public class MyTestClass {     public Stuff MyStuff { get { return m_MyStuff; } set { m_MyStuff = value; } }     public string MyString { get { return m_MyString; } set { m_MyString = value; } }     private  Stuff m_MyStuff = Stuff.Apples;    private string  m_MyString = "Test";     public test() {  } }   So I want to use a Dat ...Show All

• .NET Development How to show Window's Network Analyzer?

  I want to use the default network analyzer of Windows XP in my application. This Analyzer appears in “Networking” tab in “Task Manager”. Can anybody help me that which API in .NET will show it Thanks Take a look at the System.Net.NetworkInformation namespace.  You should be able to find most of what you need there.  Please post back to this forum if the namespace does not expose something you need. ...Show All

• Visual Studio How to register an Add-in

  How do I register an Add-in if I create it manually and not by using the "Visual Studio Add-in Wizard"   Let me rephrase my question... I want to use an existing Add-in (I have the dll file and the .AddIn file)... what should I do next in order to be able to see the Add-in in the Add-in Manager    BTW, I am using Visual Studio 2005 on Windows XP.   Thanks, Sami. Go to Visual Studio -> Tools -> Options -> Environment -> Add-in / Macros Security and add the path to the two files in Add-in File Paths. Now you should be able to see the Add ...Show All

• Windows Forms Changing MDI Child form icon

  I'm writing a WinForms application using VB.Net 2005, with an MDI interface. Each MDI child form can change its form icon at any time (it's a monitoring app, and the icon is a quick visual indicator of status). However, if the MDI child is maximized, then the icon doesn't update. Icons change just fine if the child form is in normal ir minimized state. CommonGenius.com wrote: That's because when an MDI child form is maximized, it is merged with its MDI parent, and there is only one icon. You will have to set the icon of the MDI parent form when the child is maximized (and set it back if a ...Show All

• .NET Development Please help - a question on XPath...

  Dear Expert, Please take a look at the bottom sample XML codes. I would like to write a XPath that finds out the ProjectId based on a given File Name . For example, the file name file1.txt corresponds to the ProjectId P007 . My XPath was written as follows: xPath = "/Sample/Projects/Project[./Files/File/Name='file1.txt']/ProjectId" This xPath is then put into the following code fragment for processing: XmlTextReader xtr = new XmlTextReader(xmlFilePath); xtr.WhitespaceHandling = WhitespaceHandling.None; XmlDocument xd = new XmlDocument(); xd.Load(xtr); XmlNodeList xnl = xd.DocumentElement.SelectNodes(xPath); Unfortunately, it seem ...Show All

• Visual Studio Tools for Office Error when finishing Deployment Package wIZARD

  Hi All, I'm trying to create an msi to deploy an security policy. I run an Deloyment Package Wizard , choose Machine policy to deploy and selected a file name for an msi. After pressing Finish I'm getting an error message saying: "The wizard experienced an error modifying G:\Test.msi." I have a clean install of Win2K +VS2005B2 on dual P3 processor box with a lot of disk space... Thank everybody in advance for any suggestions/workarounds Boris Hi All Sorry for offtopic. This is probably general security issue. I found no appropriate place to discuss this in respect to Net 2.0B2... I'm following this arti ...Show All

• SQL Server Does Full-text extract searchable metadata (Properties) from documents?

  When I create a full-text index on a word document for example. I want it to load metadata (property) fields that can be search independently from the word list. For example, queries like: cat and dog and (Author <contains> 'Mary Jones') This quarantees that Mary Jones only occurs in the word docs author metadata field and not within the document itself. The property fields for an email document would be: to, from, cc, bcc, subject. Is this possible You can't do that I am afraid with full text in SQL Server. You can't specify the property in query. You can search on different colum ...Show All

• Visual Studio Tools for Office Cypress questions

    I read the Cypress announcement and I have some questions. It is unclear to me what functionality will be usable in VS2005 and what will require an upgrade to VS2007. Specifically, I am interested in Word application-level add-in support (like IDTExtensibility2, as opposed to the document-centric approach of the current VSTO) and custom taskbars. I also am interested to know whether any of these features above (and any others) will be supported by Cypress under previous versions of Word (2003 and/or XP). I am a bit confused about the following statement: " I want to be clear that Cypress is not a super-set of all t ...Show All

• SQL Server Unable to retrieve data from AdventureWoks

  Hi all, I have one question. It looks easy, but, I couldn't figure out the problem. I download and attach the AdventureWorksDB and AdventureWorksDW sample databases. I run the following query to test its functionality. use adventureworks go select * from production.location go and it gives me an error messeges which says: Msg 208, Level 16, State 1, Line 1 Invalid object name 'production.location'. Similar type of query is executed successfully in the adventureworksDW database. Please let me know if you have any idea Hello, Where is the Location table located It cannot find the table. ...Show All

• SQL Server Main differences between new Express Report Server and Standard one?

  So far, I haven't been able to find a good list of what the major differences are between the express Reporting Server and the standard one. We are developing an application that will be doing the reporting through SQL server reporting services. Some of our smaller clients will be using SQL Server express instead of enterprise or standard. Anything majorly different in the Express version Check out this link - http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx Thanks, Sharmila ...Show All

• Windows Forms "Custom" MasekdTextBox - BackColor prob

  Hi, I build a control derived from MaskedTextBox with regex matching on the content and depending whether the content is good or bad I change the back color of the the textbox. The only problem I have is that sometimes, yet not always, 1px wide of the inner border remains the old color until the textbox is hovered. So, when the textbox backcolor changes to green, there's still a 1px wait border of the previous red background. However, this doesn't happen always, only sometime. I invalidate the textbox and the base, etc. yet nothing helps to get rid of that. Any ideas   durstin wrote: This is&nb ...Show All