Christian Paparelli's Q&A profile

• Visual C++ VCComponents.dat

  Hello, I have some questions concerning the file VCComponents.dat to which I want to add some include directories during installation of our software with the nullsoft installer. On my machine this file is stored in c: \Documents and Settings\username\Local Settings\Application Data\Microsoft\VisualStudio\7.1 Some people told me that they didn't have this file. Apparatently it is created when the devenv is started the first time. Is there a file per user, when I install VC++ for all users, or is the file then there only once for the user name "All Users" Can anybody confirm that the file should be there for the academic edition ...Show All

• SQL Server Use View to speed up?

  In my query, there is two fields using User Defined Function(UDF).  It is the UDF calculation that slow down the query.  The query will eventually become slow when more records(say over 1000) is return. I am thinking to use View to maintain the result of the query so as to speed up the process.  Is it possible   If not, what should I do Thanks. Yes, you can simplify complex query by using UDF but that doesn't mean that you will get the best performance. Query optimizer can do a better job on objects that contain statistics like tables/views. But once you use scalar UDFs in SELECT list o ...Show All

• SQL Server SSIS From SQL2K5 to MySQL

  Hi, We recently migrated from a SQL 2K to 2K5. We had an automatic DTS scheduled every night that would transfer data to a MySQL server on one of our client’s machine. It worked like a charm in SQL 2K. I am trying to figure out how I can connect to a MySQL data source using SSIS in 2K5 as I don’t see an ODBC Destination anywhere in the Data Flow Task; and run the same transfer using 2K5. Do I have to add a reference of some kind or does 2K5 doesn’t support ODBC destinations Thanks This thread should explain all: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=106559&SiteID=1 In ...Show All

• Visual Studio Tools for Office Outlook Crash after ThisApplication_Shutdown()

  I’m currently working on an Outlook Add-in using c# with VSTO 2005. The add-in creates a custom menu and pushes data into a custom “Today” page. My problem is that Outlook is crashing after the ThisApplication_Shutdown() event. My code for this event disposes and/or sets to null every variable that I create so I’m fairly confident I’m not holding onto any resources.   If I enable native code debugging I see the following error: Unhandled exception at 0x775618de in OUTLOOK.EXE: 0xC0000005: Access violation reading location 0x0756d00c.    I’m at a loss as to how to troubleshoot this. Has anyone seen s ...Show All

• Visual C++ finding the datatype of user input

  does anyone know of a way to check the datatype of a users input to see whether it is an integer or not smtraber User input to what User input is usually a stream of characters. This stream of characters might be convertible to other data type inside your program. I.E. So a stream of characters entirely consisting of characters in the range from 0x30 up to 0x39 might be converted to an integer if there is no overflow. So to check what the users input is, you have to parse it and check it and make a decision what type it might be. ...Show All

• .NET Development Updating 3 database server using Webservices

  Hi there! I'm a newbie in this area and have assigned, appears to be, tough task. Please help me out. I have to update 3 different database server(Sybase / MYSQL / MS SQL) using a client webservice.Client has one tool that can push the new records(Products) time to time and webservice(at client end) will keep the records in the cache.P lease let me know how to read the dataset from cache and how to store the records in a xml file at disk or how to update the databases that has totally different structure then the generated xml file.Please advice. FYI: Public Function WinUploadFile(ByVal UserID As String, ByVal Password As Strin ...Show All

• SQL Server 13 GB Log File that refuses to shrink

  I have a SQL 2005 Database (named SMDataTest) in simple recovery mode. For some reason, the transaction log has grown to 13 GB; howver I am unable to shrink the file. I have already taken the following steps: 1. DBCC OPENTRAN(SMDataTest) -- to chekc for active open transactions 2. BACKUP LOG SMDataTest WITH NO_LOG -- to truncate the log 3. DBCC SHRINKFILE (2) -- where 2 is the fileid of my logfile, to shrink the log 4. DBCC SQLPERF(LOGSPACE) -- to see how much space is being used No matter what I do, SQLPERF(LOGSPACE) always shows that my Log Size is 13 GB and that the log space used is .9%! Can anyone assist. Thank you in advance. MikeB ...Show All

• Windows Forms Location advice for a Custom Collection Class

  Hello, I have a custom collection class, which I plan to bind to a datagrid.  The datagrid will be used to present the end user with a list of customers stored in the system.  The datagrid will be read-only because its function is simply to display the customer list.  My application has a Business Facade Layer (client side), Business Rules La ...Show All

• Smart Device Development Receiving SMS example

  Hi all, Have anyone tried the Receiving SMS example from the MSDN library There seems to be a problem... It seems that I can deploy it to my PPC but an error of MissingMethodException at the function call to DllRegisterServer() will always occur. Need help urgently!!! Hi Vnewbie    U asked for a converted app for VB but then said got tat exmple already, wer did u get it from can u pls help me... cz i even need the same in VB... Tanx in advance... ...Show All

• Visual Studio Express Editions Variable Recreation

  Hi, a dumb question from a newbie. I have an Mdi appication in which i declare variables at the start of the class as below: Try declaring your forms without the NEW keyword. DIM Childform1 as Child Then create it in your sub-routine with Childform1 = new Child ChildForm1.MdiParent = Me ....................etc I'm not sure if this will give you the desired effect as it is a bit hard to understand what your are trying to do as normally the "Window | Tile Horizontal" command is used to arrange forms which are already open and you seem to want to create a new form each time it is used. Dave ...Show All

• Visual Studio Team System How-to Remove or reattach TFS Version Control repository?

  Hello! We are currently experimenting and playing around with TFS. We have gotten pretty familiar with TFSDeleteProject.exe. Few things have left pretty in-the-air and I couldn't find the answers myself. 1. Is there any feasible way to remove existing source control repository entirely If we experiment branching of "real projects" we'd like to get rid of some of the tests entirely. 2. Related to the deleting, suppose we are happy with the source code repository, but want to recreate the project (to base it on another process template for example). How can we attach the newly created Team Project into existing source co ...Show All

• Windows Forms Is it a bug or not a bug?

  Hi, I'm working on a project which includes WebServices and Windows Form application. The Windows Form application will call the WebServices to retrieve data from database. The data will be returned as DataSet. Now, here's the problem. On .NET Framework 1.1, if any rows in the dataset returned contain errors (marked by calling the SetColumnError() method or setting the&nb ...Show All

• Visual Studio Express Editions Problems with SQL Express Beta

  Hi, I have just installed Visual Web Developer Beta 2 with SQL Express April CTP. I'm not really to sure what to do now. I think I've got to put sqlcmd S- Server/Instance into the command prompt. I put my computer name where it says Server and SQLExpress where it says Instance. When I put that into Command Prompt, it gives me errors: VIA Provider: The specified module can not be found Error: Microsoft SQL Native Client unable to establish connection. Error: Microsoft SQL Native Login Timeout Expired   Please help me! Thanks!   Yes thanks, I will download the full versions ...Show All

• Windows Forms how to fix the size of a window?

  hi there is a windows form i want to fix it's size , in a way , that user can't maximize or minimize it. for example a window to ask username and password , it shouldn't be sizable. i set the formborderstyle property to fixedtoolwindow , but if user double clicks the frame, it will be maximize! how can i fix it thank u Hi, Just set the maximum size and the minimum size of your form (the same values).       cheers, Paul June A. Domag ...Show All

• Windows Forms VS.Net hanging on compile

  Apologies if this isn't the place but I'm getting rather desperate. I'm running VS.Net Enterprise edition on Windows 2000 Advanced Server.(not much choice in this matter) I'm pretty sure I compiled my project at least once without an issue, but I really can't remember for sure. Everything seems to work fine until I hit F5 to build my solution. It goes throu ...Show All