Mendip162's Q&A profile

• SQL Server SQL Server 2005 Express Connecting with DB2 iseries

  Hi, I am using SQL Express 2005 sp1 When I created a linked Server to the DB2 on iseries ( V4R5) , the SELECT statement fetches me only the first record and the following message appears. OLE DB provider "MSDASQL" for linked server "DB2TEST" returned message "[IBM][Client Access Express ODBC Driver (32-bit)]Driver not capable.". Msg 7330, Level 16, State 2, Line 1 Cannot fetch a row from OLE DB provider "MSDASQL" for linked server "DB2TEST". I am using 'MSDASQL' which refers to the DSN setup on my machine using the ODBC "Client Access Driver 32-bit" Strangely when I used the same DSN in SQL 2000 within the DTS package, I was able to connect and import data ...Show All

• Smart Device Development SendMessage - button click

  Hi, I am trying to make a programatic call to a PictureBox.Click event. I have searched these forums with many different combinations of search terms, I even found an article that said this topic had been discussed several times - http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=961689&SiteID=1 . However I cannot find anything! As said above I am trying to programatically call a PictureBox's Click event, what I've read so far seems to point to using SendMessage() which best I can tell is com interop with the compact framework but thats as far as i've got. Any help you can give would be great. you want to SendMessage using the key code for that button. if it's not WM_ENTER you'll have t ...Show All

• Visual Studio Express Editions MSN Style notification...?

  Hi im lookin on how to add a notification of non-activation when the program is started... MSN style would be nice any other style is fine with me... Well I gues if thats what you are looking for - then you found the solution for this at http://www.codeproject.com/cs/miscctrl/RobMisNotifyWindow.asp All you need to do is become a member to download the sourcecode and demo ...Show All

• Visual Studio Team System Source Control Disabled

  I've been configuring (well trying to) security. somehow I've managed to disable the Source Control menu option under the Team project settings menu accress all projects. What have I done Amanda, The privilege AdminProjectRights is a discrete permission managed by the Source Control component of Team Foundation. You can view the permissions associated with the two groups with this command: tf perm /group: groupName $/ teamProjectName You can also use the tf perm command and include a permission by specifying /allow: permissionName[,perm[...]] -jeff ...Show All

• Windows Forms Adding Components to Windows Forms

  anyone have any links on how i would add a component control to my windows form I created a component and now i want it to be inside my panel on my windows form but I cant find much info on the net to help me out though.... where are you placing the code Also don't do the Container.Add (this maybe a problem I don't know but do not quote me) do this: this.pnlOrderContainer.Controls.Add(ordercomponent); and yes you have to create an instance of the control in question. ...Show All

• SQL Server help

  hi i have table with folowing columns (subid,itemid) i want to write select stmt to get subid where itemid =all group of value('1','2') like this Select subid from subscriptionItem where itemId in all('1','2') but this stmt not work help me Hi, If you mean you want those SubID that have both ItemID 1 and 2, then the above will not work. what you should is.. Select SubID From subscriptionItem Where ItemID in (1,2) group by SubID Having count(0) =2 Assuming that the combination SubID and ItemID is primary (unique). If they are not unique, which I doubt, then try: Select SubID FROM (Select distinct SubID, ItemID from SubscriptionItem where ItemID in (1,2)) si Group by SubI ...Show All

• .NET Development reflection related query

  I am facing one problem in my project. I want to find the referenced assemblies of my current assembly. I am using reflection.assembly.getreferencedassemblies() function for that. But I can't get COM converted .net dll and c++ dlls in that. why what should I do to get that dll also............... I want that dll name anyway..........please show me some way if it's not possible in .net then is it possible in c++................... Thanks in advance.................. You should get a reference to the COM module, I did when I tried it. When you add a reference to a COM module in your project, .NET automatically generates a wrapper that automatically marshals all the COM module methods. You'll fin ...Show All

• SQL Server Horizontal table

  I have seen the blog article about creating  horizontal tables but it says that you need to have a static number of rows. Is there a way to do this if you have dynamic rows   I need for information to flow down the page and then start at top of the next column and then flow down again. I need 3 columns. Unfortunately, there can be very little or a lot of information in each section.  I need to do this: Contract 1                          Contract 4                         ...Show All

• .NET Development DataAdapters - Please help Im confused

  Hi Ill try to make this as simple as possible but bear with me please. Its probably very easy when you know how!! Brief overview, I only wish to populate my appointment datatable with the apontments where activity.assignedto = a drop down selection. Tables Activity Appointments ------------------------------------------- Id (PK) -----1--| Id (PK Auto increment) AssignedTo |--m----- ActivityId StartTime Etc When you drop a table onto a dataset designer it creates a new table with a tableadapter that selects * from the table. You can add new queries to the tableadapter and it will automatically create the delete/insert/upda ...Show All

• Gadgets Gadget close/settings/move icons are incorrectly placed after Sidebar is reloaded

  Just a minor observation, but one for the MS fix list: The three (or two if you have no settings) icons that appear when you hover over a Gadget are incorrectly placed for detached Gadgets after Sidebar is reloaded. They're shifted left 6 pixels. To reproduce this: 1. Add the Calendar Gadget 2. Detach it from the Sidebar 3. Exit Sidebar 4. Load Sidebar 5. Hover the mouse over the Calender Gadget You'll see the icons are in the wrong place. To correct them drag the Gadget slightly. ...Show All

• Visual C# Adding a item to a IDictionary<String, List<String>> object

  Hello! I know this must have an stupidly easy solution, but now I just can't find it :( I have this collection: IDictionary<String, List<String>> publishers = new Dictionary<String, List<String>>(); The keys will be some web publishers names, such as "wired.com", "internet.com", etc. The values associated with these keys will be lists of urls (I'll be reading the urls from a txt file). The code: StreamReader sr = File.OpenText("blah.txt"); //initialize the dictionary structure for (int j = 1; j <= numberOfPublishers; j++) { this.publishers.Add(publisherName, new List<String>()); } string url = sr.ReadLine(); do { if (Regex ...Show All

• Visual Basic How do I print a Query Using a Print Button in a Form

  How do I print a Query Using a Print Button in a Form Hi, If you want to print the result of a query and you have it displayed on a form, the quickest way is to use the new Visual Basic Power Pack 2005 Print Form component http://msdn2.microsoft.com/en-us/vbasic/aa701261.aspx . If you want to print as text, please refer to this article http://msdn2.microsoft.com/en-us/library/cwbe712d.aspx or using your code that you have working on http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=869665&SiteID=1 . Best regards, ...Show All

• .NET Development Connecting to Remote DB ?

  Hi all, I have a web application working online, using technologies ASP & Ms Access Can I connect to the database that is located on a web server, using a vb 6 application from a local machine. & make update, delete & inserts into that db. If not then If I upgrade my product technologies to ASP.Net & SQL Server Express then Is it will be possible ...Show All

• Visual Basic TabControls

  Is there a way to hide a tab on a tab control. I am trying to hide a tab if a certain condition is meet. Davids Learning You could put all the pages in some kind of list at startup: 'Form level declaration Dim allPages As New List( Of TabPage) 'On startup - Form_Load For Each page As TabPage In TabControl1.TabPages allPages.Add(page) Next 'Then... TabControl1.TabPages.Remove(allPages(5)); ... TabControl1.TabPages.Insert(0, allPages(5)) Andrej ...Show All

• Windows Search Technologies Search stops working in Outlook 2007

  Environment: Vista 2007 (final) Office 2007 (final) Outlook 2007 Search was working fine for 2 weeks and then it stopped for no apparent reason. I made sure that my folders were indexed. I rebuilt the indexes twice. I rebooted (obviously). Nothing works. I have not tried re-installing Office but I really prefer not to. The following warning appears in the Application logs : Log Name: Application Source: Microsoft-Windows-Search Event ID: 3036 Task Category: Gatherer Context: Windows Application, SystemIndex Catalog Details: The specified address was excluded from the index. The site path rules may have to be modified to include this address. (0x80040d07) Some ...Show All