Richard III's Q&A profile

• Microsoft ISV Community Center Forums Automation to send a Microsoft Outlook message using Access 2000

  I'm trying to send an email from my Access 2003 database, using MS Outlook. The users must have the ability to attach a file that resides on the network share drive. I have a field that holds the path to the existing file. Please Help!!! Everything out there is referencing libraries that I do not have. I'm currently referencing Microsoft outlook 11.0 Object Library. Per our support engineer: Base my understanding ,your question is how to send a mail with an attachment . You can use CDO. CDO (Collaboration Data Objects) is a Microsoft technology that is designed to simplify the creation of messagi ...Show All

• Visual Studio Team System Compilation 1.1 and 2.0 framework compatible assemblies using MSBUILD

  Hi All, I have large number of Solution and Project files developed in 2003. The project files use large common code base. I need to move to 2005 eventually, will there be any way to maintain the same code base ,solution files, project files which can be modified to build assemblies targettting .NET 1.1 and 2.0 framework. By using MSBUILD , Please let me know ow to manage solution and project files that need to work in both VS2003 and VS2005 . Is there a way of doing this using MSBUILD Thanks in Advance. V Hi Varun - If you are planning on using Team Build to build your sources, here is a post that can he ...Show All

• .NET Development Trouble serializing an array...

  I've tried serializing an array and an arrayList and still can't get it to deserialize. It seems to serialize OK, I think. Any tips for serializing/deserializing arrays Thanks Devin Please provide more information about the failure. Does it throw an exception or do you get an invalid array Also please specify if you are using XmlSerializer or the BinaryFormatter. Thanks ...Show All

• SQL Server How to add YTD (Calculation) to Time Dimension?

  Is there any you can add YTD to Time Dimension as attribute Or it has to be Calculation Then how do we do this Is this need to base on Dimension or Measure I would prefer this to be base on dimension and show in Time dimension hierarchy. Any inputs on this are highly appreciated.   There are several ways to accomplish this.  If your users want a way to select Monthly values vs, QTD, YTD from a selector/slicer you will need to create a Time Utility Dim or a Time Ref Dim. This Dim will only contain one member for the lowest level of detail.  ie. Month or Daily.  You would then cr ...Show All

• .NET Development Encrypting sections of Web.Config

  I have a websever running IIs 6.0 and the .Net 2.0 framework. I'm trying to encrypt sections of a web.config file on one of the websites that I host on this server. I have about 20 different websites each with their own IP address. From several MSDN docs and posts here and there I've learned that I can use the aspnet_regiis command to encrypt certain sections of my web.config. I'd like to encrypt the sections that contain passwords - such as the connectionStrings and the mailSettings. (I'm trying to implement the new Membership classes and the login control). My problem is that the documentation I have says a couple of things that I'm ...Show All

• SQL Server Substitute portions of results

  Is there any way in SQL to substitute every instance of a particular string with another during a query Specifically, I've got "\n" stored in my database, but I wish to have it replaced with "<br />" (ahh - they say) when I pull it from the database... ...Show All

• Windows Forms Move Mouse Cursor

  How can I move the mouse cursor   (Control.MousePosition is Get only.) Thanks. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=24257&SiteID=1 ...Show All

• Visual Studio Tools for Office Combobox into perticular cell

  Hi, I am using following code to bind the ListObject: DataSet dsTrims = new DataSet (); string strWhere="select col1, col2, col3, col4 from tableTrims"; dsTrims = MyProvider .ExecuteDataSet(System.Data. CommandType .Text, strWhere); this .bindingdataSource1.DataSource = dsTrims.Tables[0]; myListObject.AutoSetDataBoundColumnHeaders = true; myListObject.SetDataBinding(bindingdataSource1); Now as per my requirement l want that all cells corresponding to "col3" column i.e. all the cells below to the col3 that has all data for col3 should be appeared as/in combobox/dropdownlist. And com ...Show All

• Visual Studio Sourcesafe Web Service SSL Problem

  Hello, I have found various posts describing this problem, but I don't understand the answers given in any of them! Please help! When I try and connect to VSS through Visual Studio using HTTP, I get the following error: "The certificate authority is invalid or incorrect" I know that my server SSL certificate is a temporary one, and IE also complains when I browse to it so I'm not too surprised (IE says "The security certificate was issued by a company you have not chosen to trust. View the certificate to determine whether you want to trust the certifying authority.". Apart from this IE considers it valid. H ...Show All

• SQL Server Integers in SQL Server

  I'm having a problem with the way integers are stored internally and how they are returned with a SELECT statement.  In the project I'm working on, I have to move data from an Excel file to a database so I'm using DTS and a group of stored procs to pull this off.  What happens is: DTS pull data from Excel into temp tables Stored proc pulls from the first temp table into a supertype table IDENTITY column assigns primary keys Stored proc then loads primary keys into a cursor and, starting with the LAST record, moves the PK into the appropriate subtype table and assigns the correct foreign key enteries. Next stor ...Show All

• Visual C# error reporting?

  How can I shut off the feature that wants to report errors to Microsoft whenever I run a C# program that has an error   I am talking about the standard...an error has occured and it wants to send a summary of the error via an internet connection to MS. Thanks, Alex That error reporting is a windows thing. It is the same box that pops up when any program crashes with an exception. The best way to not let this happen is to catch all exceptions in a Application.ThreadException event and then display your own exception message and exit gracefully. The problem is that your app is terminating on an exception ...Show All

• .NET Development language problem

  Hi all, I'm consuming a .net webservice with a string parameter. When I try to send the string with Hebrew language, the webservice get the string as question marks ( ). It seems to be that the webservice doesn't recognize the encoding of the string. I send the string from the mobile as UTF-8 encoding. I use soap to call the webservice. Please help me, what can be the problem Whitch things I can do to check the problem How can see what is the sting encoding that recives with the soap call Please help... Regards... Hi, Could it be that the characters in the received string are correc ...Show All

• Visual Studio Team System CMMI Template Customization

  Does anyone know when the CMMI process guidance is going to be available for customization (ie. export-edit-import into TFS / use as template) With TFS Beta3 release, Microsoft has provided MSF for CMMI process template and it is possible to export, customize and import it back. MSF for CMMI is more formal and requires more documentation as it is intented to help with Level 3 CMMI appraisal. For a quick overview, see my blog post . ...Show All

• SQL Server Multiple threads

  Is it safe to use one database connection shared across multiple threads. Each thread has its own set of data i.e its own SQL command etc, but sharing a single database connection. Actually the scenario is that in a web site I want to open a single database connection when web application starts up. On each page hit will construct a SQL command and query/update the database. I just want to know if multiple requests come at the same time will threads be blocked if I share global connection. What will happen if one request is trying to retrieve the data and another request is updating the database using the same connection Thanks ...Show All

• SQL Server FTP Connection Manager: Set FTP password using a variable

  Hi, I want to setup an FTP task that is portable in the sense that all it's connection parameters are stored in variables. I can create expressions for properties ServerName and ServerUserName but not the ServerUserpassword.  Is there an property that I missed, there seems to be properties for everything else except the key piece of info, the password. I could create a script component using the FtpClientConnection method as a last resort but would rather not. Any ideas Thanks Dan,   I have tried a several combination of that example (including a period you are suggesting) but di ...Show All