ReneeC's Q&A profile

• SQL Server Help with generating a password with non repeating characters

  hello all, I have to write a query to generate a password which should have not have any repeated characters. The only far that I was able to go is : SELECT SUBSTRING(CONVERT(varchar(10),@member_id),1,1) + CHAR(((ASCII(SUBSTRING(CONVERT(varchar(10),@member_id),2,1))-47)*2)+64) + SUBSTRING(CONVERT(varchar(10),@member_id),3,1) + CHAR(ASCII(SUBSTRING(CONVERT(varchar(10),@member_id),4,1))+32) + SUBSTRING(CONVERT(varchar(10),@member_id),5,2) + CHAR(ASCII(SUBSTRING(CONVERT(varchar(10),@member_id),7,1))+33) + SUBSTRING(CONVERT(varchar(10),@member_id),8,3) but this does generate repetitve character code. Please help. Thanks, Do you really care if it repeats If you jus ...Show All

• Visual Studio Team System App Server install: User account problem

  I am trying to install TFS in dual server mode and I've had no end of problems! We have set up the TFS service accounts: SVC_TFS and SVC_TFS_REPORT We have used these accounts successfully on a number of test machines, but as soon as we tried to put it on our production machine, we have had no end of problems: Database server install would not work... seemingly could not connect to the SQL Server 2005 database. This is a default instance as per the installation pre-requisites. However, we did get it working by restoring from one of the previous instances. Now, during the app server installation, when we enter the credentials for the service accounts we get the following error message: The account name is not valid or does n ...Show All

• Windows Forms SerializationException "Cannot get the member 'Child_PropertyChanged'." when de-serializing generic collection

  I have created a custom generic collection class with a signature like so: [ Serializable ] public class blGenericCollection <T> : BindingList <T>, ITypedList , IListSource , IXmlSerializable where T : blObjectBase , new () {blah blah blah} The child items that derive from my blObjectBase publicly implement INotifyPropertyChanged , as does blObjectBase itself. I'm getting SerializationException errrors when de-serializing the collection class (stack trace below) using BinaryFormatter . However, the child item classes serialize and de-serialize just fine, as does my blGenericCollection class when it is empty. But when blGenericCollection contains items - I blow up. (Side note: Xml serialization fo ...Show All

• Smart Device Development Information needed regarding the file system

  hi, I want information related to file renaming.Suppose On device, i have images named suppose xyz. Now if i rename this file to ABC. How can i get programmatically tht the file name has been changed. Actually, my appln is related to uploading of the images to the server. So i use MD5 hashed code for the file, so if the uploading breaks, next i check the file with the server already uploaded files and start uploading from where it stopped. hashing takes alot of time, so depending on the filename uploading is continued next time. the problem i m facing is, if in case user changes the filename and later when i check for already uploaded files, i cant get the file that is renamed as already uploaded. How to get the information whether its nam ...Show All

• .NET Development Ftp Upload File

  This is my code snippet for file upload. The problem is after all the bytes are written on the server, while doing requestStream.Close() I get error as underlying connection was closed. FtpWebRequest request = (FtpWebRequest)WebRequest.Create(serverUri); request.UsePassive = false; request.Method = WebRequestMethods.Ftp.UploadFile; request.Credentials = new NetworkCredential("xyz", "xyz"); Stream requestStream = request.GetRequestStream(); const int bufferLength = 2048; byte[] buffer = new byte[bufferLength]; int count = 0; int readBytes = 0; FileStream stream = File.OpenRead(fileName); do { readBytes = ...Show All

• Software Development for Windows Vista Upgrading to Vista, should I uninstall old .NET 3.0?

  In the process of learning WPF, I have installed .NET 3.0 and the Visual Studio 2005 extensions. In preperation for upgrading my OS to Vista Ultimate, should I uninstall the older .NET 3.0 first Also, to get the newest VS 2005 extensions (Orcas, Cider, etc.) should I uninstall the older versions of these extensions first What has been your experience in upgrading to Vista and getting your development environment back in working order Any tips Thanks in advance... Great answer, Brendan! Thank you very much, Bob ...Show All

• Visual C# Defining custom functions for code snippets

  Code snippets allow you to use functions to do some processing on the data that gets inserted. AFAIK, currently there are only three functions available for C# (for instance SimpleTypeName). Would it be possible in any way to expand this set of functions For instance, I'm looking for a CamelCase function to be able to create a code sinppet that outputs code such as this: private int _myNumber; public int MyNumber { get { return _myNumber }; } Because of this naming convention, I only want to specify the type and name, and not as in the current propg code snippet, also specify the fieldname. Any ideas Peter N Roth wrote: Why is functionality necessary Is there a reason why supplying another snip ...Show All

• .NET Development Dataview Sort Problem

  Hi all, I am facing a problem while Sorting a Dataview, the column datatype is Numeric. If more than one rows have NaN in this column then i get an exception i.e. Index Out of Bound Of Array, is there any workaround without changing the values of those rows having NaN in that field. DataView dvLosers = new DataView(dsTest.Tables["dttest"]); dvLosers->RowFilter = " PCT < 0.0 "; dvLosers->Sort = "PCT"; // This line is generating the exception. With the following simple code, I can't reproduce the error you got: DataTable dt = new DataTable (); dt.Columns.Add( "col" , typeof ( double )); dt.Rows.Add(-1.0); dt.Rows.Add( Double .NaN); dt.R ...Show All

• Software Development for Windows Vista INSTALLATION ERROR

  Content of log files, [07/24/06,14:20:30] Windows Communication Foundation: [2] Error: Installation failed for component Windows Communication Foundation. MSI returned error code 1603 [07/24/06,14:20:49] WapUI: [2] DepCheck indicates Microsoft .NET Framework 3.0 - was not attempted to be installed. This looks like an error installing .NET Framework 3.0. Can you please send me your error log (the error logs are in %temp%\dd_*.*) I'll pass it on to the correct people. ...Show All

• SQL Server Framework 2.0 changes - TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.

  If you connect to a server and open a query in SQL Managment studio (2005) and looses connection and then regain the connection, when you try to run the query it gives me a "TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host."   This happens against both 2005 and 2000 servers.   If I re-run the query it works.   However, this happens in our VB.NET app as well for clients with Wireless connections.   So, something has changed in Framework 2.0 regarding this, does anyone know how to tell the client to not throw this error and just try connecting the server instead which will work   Hi, The SqlClient provider does not retry operations if the underlying connection is " ...Show All

• .NET Development Subtracting from a DateTime variable

  Hi, I have a DateTime variable and I want to set it exactly as a month previous to today's date. The members Day, Month and Year are read only, so I can not make any subtract operation directly on them. Does anybody know how I can do it Thank you in advance. I'm a little curious as to how you (the OP) would want it to handle, say: "31st March 2006 less one month" Because 31st Feb 2006 isn't going to fly... ...Show All

• SQL Server Layout of Matrix Report with calculation fields

  Hi guys, I've been struggling with this for a while now. Any help would be greatly appreciated. I'm using SSRS 2005 running on an Analysis Services Cube. I display Invoice Qty and Net_List in a Matrix Report, over a periods selected by the user. 2005 2006 Inv Qty Net_List Inv Qty Inv Qty Qty % Value % Company 50 100 100 50 100 -50 Fig 1.1 I used custom code to return my Percentage fields in a table next to my matrix report. But my table cuts of earlier on the page than my matrix report, thus, it doesn’t line up correctly. I tried to f ...Show All

• Visual C++ OST(outlook offline folder) file structure information

  hi, i am developing a task in vc++, i.e read the ost file and display the data like outlook mails. But i want to know the ost file structure for reading the bytes properly. OST file is outlook offlie folder which is synchronize with the exchange server when network available. if anybody known about this ost file structure, reply to this forum. This question falls outside the scope of this forum, which is the VC++ language. This is also the second question I've seen you ask on the subject, and there's still little or no response. Try one of the newsgroups, such as http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.office.developer.binary.file_format&lang=en&cr=US . This should be better suite ...Show All

• Visual Basic PDF Document Software

  Greetings to everyone. Apologies for perhaps posting this in the wrong place. I hoping that someone here can share some valuable experience and point me in the right direction. We currently have a customer VB.NET app that populates form fields in PDF documents from data in our SQL Server database. Currently the development teams gets the documents, adds the fields and produces some configuration (XML file) that defines the sprocs and parameters and which field from the resultset to put in which form field on the PDF. We would like to be able to supply a member of our admin team the ability to just choose the fields from a list and place them on the PDF and the configuration to be generated automatically. That way they could maintain them ...Show All

• Visual Studio 2008 (Pre-release) VISIO 2007 with VSTO

  Hi I am using Visio 2007 for my business process application. I am opening Visio 2007 through my dot net application by office Addin. Finally when i build the application it gives an assembly. But I am unable to call this assembly in other dot net application. I tried through reflection also. What is the solution Regards Chris you could post your question here http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=16&SiteID=1 ...Show All