IfulConsultant's Q&A profile

• SQL Server Retrieve Data from Web Services Using DTS (SQL Server 2000)

  The project I'm currently working on involves combining data from one SQL Server 2000 databases and XML returned from a web service into a 3rd SQL Server 2000 database. This process must be scheduled to happen once a day. If it weren't for the Web Service, I'd say that this is a no-brainer and I'd use DTS. However, I'm not sure if I can even access a Web Service with DTS. Has anyone done this or have any tips ...Show All

• Visual Studio Express Editions Office 2000 has VB Installer / Configuration Problem after installing VB Express 2005

  I am an absolute beginner with VB. I installed VBE 2005 without a hitch but since doing so I have a problem with Word and Excel. Each time I launch them I get a message saying "Please wait while Windows configures Visual Basic Express 2005 ENU". If I let the installer run it chugs aways for several minutes. There is lots of hard drive activity and I notice MSIexec runs in the task list with lots of MSInnn.tmp entries (where nnn is a nu ...Show All

• Microsoft ISV Community Center Forums Adding minimize button to userform in design mode?

  Hey Having terrible trouble trying to get the minimize button displaying on my userform. This should be relatively simple but i can not get it no matter what i try! I got this of Google: Visual Basic forms can be made non-sizable by setting the borderstyle property to 0, 1, 3 or 4. However, that also means that the user cannot minimize the form to the taskbar. I only have the option to choose between 0 & 1. Does anyone know of any w ...Show All

• Visual Studio 2008 (Pre-release) Why simple large forms are rendered that slow?

  Hi   Some project, like the one that I’ve been working on the past 2 years, require large forms, combined from hundreds of controls, a single form can go 10 or 20 pages long.   We are currently using Microsoft InfoPath 2003 with the .NET framework, and although it is not that fast, rendering of a large from with a 1000 text boxes for example will take couple of seconds.   Of course our forms are much complex than jus ...Show All

• Visual Basic Access multiuser - info about group

  hello everybody! It’s any way in VB, how I can indentify user group, in which is user for example, user tester log in, and I want to see him messagebox "User tester is in group Users" thanks a lot... Hi! I assume that you are talking about Active Directory. Here is some code that uses the DirectoryServices namespace to lookup the groups that "someuser" belongs to. You may need to tweak the filter on the DirectorySea ...Show All

• SQL Server MySql SSIS Hangs with ODBC Drivers

  Hi, we are writting a SQL Server Integration Services package to import data from a MySql database to a Sql Database. We are using ODBC 3.51 Drivers to connect to the MySql Database in SSIS. The package runs perfectly in design mode. When we schedule the package to run, the package seems to hang about 1/3 of the times. What can this be. We used to the package and ran it from a Sql Server 2005 to a Sql Server 2005 database. This setup works ...Show All

• .NET Development WebDAV delete just email attachment in Exchange Server

  Guys I'm trying to implement C# code to delete attachments from the emails using WebDAV in exchange server. WebDAV allows to delete emails easily but can't really figure out how to delete attachments from the email if there is any. I've got following code however but comes up with an error message "The remote server returned an error: (401) Unauthorized." PerformDelete( "http://mydomain.com/public/developers/TestDi ...Show All

• .NET Development How to modify & insert into XML without loading the whole file in memory

  I am working with large xml documents, over 50 MB. I know how to read it using XmlReader class and Xquery but except DOM I didn't found a way to update nodes, or insert new nodes. There is any way to use XmlDocument class and not load the whole document into memory, can I use buffers, or what I should use into my C# app to be able to load, modify, insert and then save XmlDocument does not support partial updates back to disk. Th ...Show All

• Windows Forms binding datagridview with two tables

    Hi all. Im trying to do a dgv with fields coming from two tables as this: Table1(Customers) CostumerID (Int, Primary) CostumerName (String) Table2(Orders) OrderID(int, Primary) CustomerID (int) OrderDate (Date)  I want my datagridview to display the fields as follows, mixing the fields from those tables. OrderID, OrderDate, CustomerID(table2), CustomerName i can do this by generating an access view, add to my dataset&n ...Show All

• SQL Server How can i insert a default row if it doenst exists already?

  Hi, I am currently loading dimensions using a Sql Server Destination and i was wondering if i can create a middle step to insert a certain row so i would identify in my dimension the undefined records... I know i can do it with sql statement but i was wondering if there is a better way. Best Regards, Luis Simoes Would this not be part of the fact load, you wish to infer the dim member from the fact data when there is not already a ...Show All

• Visual Studio Team System Mobile Distributed Application in Application Diagram

  I've a quick question: how can I design a mobile solution using VSTS In AD there's not a mobile application and using a Windows Application instead I cannot implement it usign a the mobile application template. Also in LDD there's not a Device Client (I've used a windows client). For a BizLayer component (for windows application as well) I cannot use a Windows Application because it cannot be implemented usign a Class Library Project templat ...Show All

• Visual C# UserControl Close, Exit, Terminate, Etc.

  Does anyone know of a way to determine when a UserControl is being closed by the user in C# There used to be a Terminate event in VB6 that you could capture. I can't find anything like that for UserControl. Thanks. I also got the following useful information from another forum. namespace FormCloseCapture { public partial class UserControl1 : UserControl { public UserControl1() { InitializeComponent(); } ...Show All

• Visual Studio Team System Error 32000 TFSSetup Application tier

  Hi, I tried to install Team Foundation Server (CTP July) with SQL 2005 (CTP June DEV). The Data-tier installation worked well. There are 3 Windows 2k3 Server participating(DC, App, SQL). All of them are running in a Virtual Server environment. But during install of the application tier I got the following Error: file - dd_vsinstall80.txt: [08/30/05,13:52:37] vs70uimgr: DisplayMessage_START:Error 32000.Failed to execute action. last r ...Show All

• Windows Forms Lock second form as active??

  I have an application with two forms. The application launches and the first form opens maximized. You click options from the main menu and the second form opens. I have the second form set to always be on top, but I would like to mak ...Show All

• Visual FoxPro Spacing columns in a grid.

  Is there a way to set up grids so there is a slight margin between the columns (I'd like a little space between the text of the control and the left grid line) I can't use the margin property though because its not just for the left side of the control but all around. Thx, Aleniko Aleniko, You can set the Text1.Margin = 4 and the Column.Sparse = .F. this will only add space to the left and right o ...Show All