Michael Blome's Q&A profile

• SQL Server Copying table data from SQL Server 2005 to SQL Server 2000 - Very Slow when using OLEDB Source and Destination sources?

  An SSIS package to transfer data from a DB instance on SQL Server 2005 to SQL Server 2000 is extremely slow. The package uses an OLEDB Source to OLEDB Destination for data transfer which is basically one table from sql server 2005 to sql server 2000. The job takes 5 minutes to transfer about 400 rows at night when there is very little activity on the server. During the day the job almost always times out. On SQL Server 200 instances the job ran in minutes in the old 2000 package. Is there an alternative to this. Tranfer Objects task does not work as there is apparently a defect according to Microsoft. Please let me know if there is a ...Show All

• SQL Server Answer: My First Report

  I need to create a report for a phone directory. Basically my report needs this format. department        employee        employee        and so on..... department        employee        employee        and so on..... department My data is stored in two tables department - deptID deptName Main - deptID empName title order by Departments are listed in department table. there is an associated deptID in both tables. in the main table every employee is listed and they have a deptID that is associated with the department table ...Show All

• Smart Device Development Foreseable security risks if lock device within my application.

  Can anyone think of any security risks if I lock the device down (PPC) at an application level (not OS as apparently unsupported)   This means that the app would prevent user input until they enter a specified U/P.  App's would be hidden/start menu etc from the user.  Has any one done this, is it recommended, got a better technique Thanks as always, u guys are a great source of info.   We do this, and no risks, but it's not too easy to do.  You'll need a fullscreen app, and trap all the hardware buttons.  Also if you enable the sip, users can click Options, and then get access to the Start but ...Show All

• Visual Basic listbox object display

  hi... using vb.net 2003... newbie here...  i tried searching the forums and could not find my answer...  sorry for the inexperience i am about to bring...  anyway, i am trying to build a listbox of objects and have a string displayed, but also store a tag as well to save the key info...  i initially used a treenode object, but it displays "treenode: ....."   i don't want "treenode" displayed... then i tried creating my own object, but it wouldn't display the text...  it would only say form1.listbox1.object....  in the listbox...  how would i get a string to display while storing the key info with ...Show All

• Visual Basic Opening .NET 1.1 project in VS 2005

  Hi I need to open a project developed using VS2003, .NET1.1 in VS2005. I want to maintain it in .NET 1.1 and don't want to convert the soln to 2.0 since my production environment doesnot have 2.0 yet. how do i do this. Once a projct is converted, there's no going back: you either work it in 2003 or 2005. But there is a difference between 'development' and 'production' (or deployment). Are you saying your developers or deevelopment team don't have 2005, or are you saying the machines that you wil deploy the application to doesn't have the .NET 2.0 Framework If it is the second case, it's fairly trivial ...Show All

• Windows Forms Dialogs inheriting from dialogs inheriting from dialogs get multiple OK events!!!

  I have a stack of inherited classes from which my dialogs inherit various functionality. BaseClass (some function key and other stuff)  is parent of DialogNoDataBase (ok and cancel buttons) is parent of DialogBase (slick mechanism for passing in and out the data) is parent of vaious Working dialogs DialogNoDatabase has protected overridable bOk_click ... to respond to the OK button click event. It sets the dialog result. DialogBase has protected overrides bOk_click ... to repond to the OK button click event and handle passing out the data and calls myBase.bok_click Working Dialogs may have protected ...Show All

• Visual Studio Tools for Office MODI document

  Hi, is there a way of displaying image using MODI ( Microsoft Office Document Imaging 2003 Object Model) from the Image object it is important to me to load it from the image object because i get image object from twain driver. thx. Ludens, MODI is outside the scope of this forum, but it is documented on MSDN. Please consult the reference documentation there: http://msdn.microsoft.com/office John. ...Show All

• Visual Studio Express Editions problem with the installation of Visual C# 2005 express edition

  Hi, I downloaded the Visual C# 2005 express edition. When trying to install it, I got an error saying that setup has stopped because microsoft .net framework 2.0 could not be downloaded. Anybody could help me Thanks. Sherry Yes, you must go to microsoft.com and download .NET framework 2.0 then install it in yuor computer and then install Visual C# 2005. good luck ...Show All

• Visual Studio IScanner, scanning order, using Managed Package Framework.

  I've noticed that IScanner can jump around a file seemingly at random when SetSource() is called. This is OK for some circumstances, but a language I am implementing (using the Managed Package Framework) supports nested comment blocks, basically: /* blah /* nested */ blah! */ When my IScanner is updated sometimes the colorization goes to hell. Is there any way to force anything calling IScanner to only call it "top to bottom" (AKA, if you're going to scan the whole file, do it from the first line to the last line only). If not, can I get some details as to how other people implemented this sort of thing without screwing up colorization ...Show All

• SQL Server How can I get primary key col and other two cols in the same table become one to one relationship.

  For ex. Table Match_List ( MatchID, UserID_A, UserID_B) constraints like MatchID primary key UserID_A <> UserID_B unqiue index (UserID_A,UserID_B) but I wish to exclude duplicated rows like 1,1,2 & 2,2,1, cause UserA to UserB, and UserB to UserA are the same thing. How can I get this You can create a view based on table Match_list Create view Match_complet as select MatchId,UserID_A,UserID_B union all select MatchId,UserID_B,UserID_A You can use this view to query all the information you need. Cristy ...Show All

• .NET Development DownloadFileAsync Question

  Hi, How are you I was wondering if you'd be able to help me with the following: I am building a class using the WebClient.DownloadFileAsync method so that I may instantiate it several times and start multiple file downloads concurrently. I am trying to build a wrapper class so that all the user has to specify is the download URL and destination. I'd also like to update a progress bar on a WinForms application (one per file being downloaded). Therefore, I would like to know what is the best way to structure my class. Should I be using delegatres, raising events, or should I use the BackgroundWorker component to handle it. I a ...Show All

• Windows Forms Accessing Remote Database with Windows Forms

  I am building a disconnected application using windows forms for my solution.  I was wondering if it would be best for me to use a Web Service to access my SQL database remotely   I will have to do many things with the data, such as updating, deleting, inserting the whole SQL spectrum and I am not to familar with Web Services, but h ...Show All

• Visual C# string to int

  Hello everyone, Im trying to setup a progress bar, right now this is basically how it is set up, first I have the app count lines in a text file, this works ok: textBox2.Text = rowCount.ToString(); rowCount++; inputstring1 = StreamReader1.ReadLine(); then later, I have this where the listbox is being populated, the progress bar should show the progress of the population. textBox2 displays the number of rows, and the maximum should be this number but when I try to compile it, it gives me an error saying that it cant convert string to int, so I tried this with no luck.: progressBar1.Minimum = 0; progressBar1.Maximum = Conv ...Show All

• Visual Studio reports reside on another server and I get the "Load report failed" error

  Hi all. I have been working on this for couple of days now. I have a program that’s sole purpose is to be a dynamic report viewer. I have decided that this would be a good project to move to vs 2005 from vs6 c++ and make it a web app. So I began from scratch and have finished most of it, however I have ran into a problem with the crystal viewer. The reports reside on various servers and moving them is not an option. I have got some of them to work on the local machine, but the second I move them to a server I get the "Load report failed" error. The share permissions for the folder they reside in are set to everyone full control to try to el ...Show All

• Visual Basic Accessing a running program's ram

  I want my program to access a program's ram (when the program is running in memory) so I can debug it explicitly. I know how to edit a file by storing it in a buffer but how would I do this when a program is running. If suggestions or code samples are given, please make sure they are for vb.net and they are explained. Thanks. Hi! Access memory Your program access it's memory. Access to other program's memory is protected for security and stability reasons. If you want to make this you need a lot of reading about virtual memory, kernel, Win32 API, etc. What do you want to read in this memory There is no list of internal object ...Show All