Hannah's Q&A profile

• SQL Server problem reading tab delimited flat file source with missing tabs

  I have a tab delimited flat file with say 60 columns. All columns can have null values. The file contains a blank tab for nulls. Now, if a row has null value for last 10 columns, ideally, there should be 10 blank tabs padded to the end of that row. But, this is not the case with this file. There is line break after 50 columns of that row, in the above example. Extrapolating this behavior, most of the rows have null values for last 'x' columns where 'x' is variable for each row. When I try to customize a flat file connection for this file, SSIS is not padding up the missing tabs. In the example above, it should insert ...Show All

• .NET Development overview of .Net classes

  Hi, where can I obtain an overview of the .Net-classes in a graphical form (as existed for MFC), or on a poster thank you Chris Daniel certainly points at what I consider to be one of the better posters. Note also that the winfx poster from PDC2005 has been made available online . Regards, Kit kitg@microsoft.com ...Show All

• Visual C++ MS C++ 2005 express database mismatch error when compiling

  Every time that I attempt to compile a c++ program I get a database mismatch error. When I looked this error up in the included documents, it said that I needed a newer version of dbi.dll. Where can I find this file I know that my programs work because they compile with ms vc++ 6.0 and the gcc complier. Here is the artilce where it told me "how to fix it," but I still cannot find the file that I need. Visual C++ Concepts: Building a C/C++ Program   Fatal Error C1902 program database manager mismatch; please check your installation A program database file (.pdb) was created usin ...Show All

• Visual C++ Using classes from dynamically linked DLL

  I am attempting to use classes that are defined in my custom written DLLs. I am dynamically loading the DLLs using LoadLibrary. I already know how to access functions using GetProcAddress. Is it possible to do something similar for classes No! You can not use class exports via this way with LoadLibrary. A simple approach is to create interfaces like COM interfaces and return only pointers to those interfaces from the DLL. This is alaso a very flexible aproach and you hide the implementation details fully. ...Show All

• SQL Server Deploy Reporting service 2005

  Hi, I used SQL server 2000 and SQL reporting service 2005. I have created some reports. 1. when i deploy my reports, it show deploy success, but when i browse my reports on the web it doesn't appear like the one that i have seen in SQL reporting service web cast. 2. I want to create take my reports to be run by another computer that have only SQL server 2000, what should i do Thanks a lot for our help, Chear ...Show All

• Visual Studio Tools for Office renaming an Excel sheet

  Is it possible to rename an Excel sheet using Visual Basic 2005 This is the only thing I haven't figured out yet... In the same manner you would do it in VBA code because you are just making a call against the Excel object model. You can set Worksheet.Name property to any valid sheet name. Only invalid characters are in worksheet name are : \ / * [ or ] Maximum worksheet name length is 31 chars. Since, this is a Excel specific question I would suggest posting these type of questions on an Excel programmign newsgroup. http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.ex ...Show All

• Visual C++ Problem seeing my window

  I just got Visual Studio 2005 and I tried to make a program using Win32. The program is just displaying a window. When I compile the code I get no errors at all, but nothing happens after that. My window doesn't pop up. I made sure that I had the functions: ShowWindow() and UpdateWindow, but apparently that wasn't the problem. Please help. Well, it's really impossible to comment without seeing the code...  Have you set up a message loop such as this one   while (GetMessage (&msg, NULL, 0, 0)) { TranslateMessage (&msg) ; DispatchMessage (&msg) ; } ...Show All

• Windows Forms Modifying .application dynamically?

  I am creating a configuration tool that does: 1. Creates a vdir under IIS. 2. Copy necessary files to this vdir. 3. Modify the .appliation files changing the deploymentProvider codebase to appropriate URL. The first 2 steps works fine as usual. But the third step fails. I successfully modified the codebase URL, but I got errors (see below). I guess once the .application files are create using VS 2005, the URL should not be changed. I wonder if there is any workaround This is an urgent task. ===================================== PLATFORM VERSION INFO  Windows    : 5.1.2600.131072 (Win32NT)  Common Language Runtime &nb ...Show All

• Visual Studio Express Editions Best Control To Use For Text/Graphics page that will be printed

  Sorry for all the questions, I am new to VB and having trouble finding satisfactory answers to some questions. The application I am making is going to generate a contract to be printed. The contract will contain dynamic text from a setup form, fixed text and some graphics (like a company logo). Should I Create a windows form and add the images and various text to that and then print the business area of that form One problem I have is that I don't know ahead of time the exact length of some of the text...it will fit on one page, but the length of some sections will vary and I'd like to avoid large gaps between the text. I've been ...Show All

• Windows Forms Windows Form generic form

  Hi, does anybody knows of any issue/problem/drawback on using a generic Windows Form for databinding I'm thinking about defining a generic form to handle common data operations in a new application that I'm working on, using a generic type to describe my data source entities. I've just found a trivial problem with the designer, that doesn't sincronize the autogenerated partial class code signature with my generic one. It's a trivial problem because you just need to synchronize your partial class with the one autogenerated by the designer and then everything seems to work fine. I didn't found any other kind of problem, at this moment. Do you ...Show All

• .NET Development DataRead Failure Please help...

  Hi, i'm using vb.net 2003. The problem that I encounter is the fact that after awhile, the record count shows the correct count, but, the values that it's supose to extract from the database, doesn't match. I use a datareader to extract the values, and that code are read each time the form is activated, so, it's in the From_Activated event, but, when I test it, it runs fine for the first 8 or so times, and then, the values in the Listbox starts to decrease, untill the value is NULL. here are some of the code: Label1.Visible = True lblprojectdescr.Visible = True cmbcat.Items.Clear() Dim sr As New Str ...Show All

• Visual Studio Express Editions I don't see any projects to choose from - VWDBeta2

  I go to create a new project in Visual Web Developer Express Beta 2, but don't see any to choose from. Did the install go bad or is there a fix for this no that is not correct, here is what happened. You must of used a registry cleaner. for further details look at this post http://forums.microsoft.com/msdn/ShowPost.aspx PostID=65384 It will show a description and a solution ...Show All

• SQL Server View Report using URL

  Thanks you for all the help! ...Show All

• Visual Studio Error "Operation is not valid due to the current state of the object"

  I'm trying to use the ReportViewer control (in remote mode) in a winform app. Everything works great until I try and change the ReportPath of the control (in response to a TreevIew after select event ) when the currently visible report is a report that has been drilled into from the original report specified in ReportPath e.g. ReportViewer rv = new ReportViewer(); /* other code */ rv.ServerReport.ReportPath = "/Report1"; rv.RefreshReport(); User then clicks on a link in Report 1 that jumps to Report 2 (still within the same control). Now if you try and set the ReportPath to anything you get an "Operation is not valid ...Show All

• Visual Studio Express Editions Integration of third party activeX controls in deployment

  How can I include third party activeX controls in deployment My distributed VB application does not work after installation on other PC because VB does not register the third party .ocx file on the destination platform. What to do Thank You Heiko   I'm not sure this is possible with the 'ClickOnce' deployment method. Unless someone has a way to do it VB Express, your options are: upgrade to Standard or Pro (Even then, I'm not sure what options are available). use a third party installer (free or otherwise). Before your form is loaded (Possibly Sub Main), check the registry ...Show All