Michael Cheung's Q&A profile

• Microsoft ISV Community Center Forums DLookup help?

  Hi there - im building a contact management system and require some help. I have previously had help with VBA in terms of defining what users can and cant do within the system when logging in via a username and password which was incredibly useful. Im now at further along the route and now want to incorporate an activity system that will record all hours that employees will have worked against clients. However we have a lot of clients! The users login name('login_name' which is held in 'tblusers') is also entered into a 'leadofficer' field in 'tblcompany' so that we know which user is responsible for managing that client - this is done through a combo box on the company entry form so it looks up the values from the table 'tblusers'. On th ...Show All

• Visual Studio "Entering break mode failed for the following reason: Source File XXX does not belong to the project being debugged

  I get this modal message box if I copy a solution with multiple projects from one folder to another and try to run it. This never happened with the previous version. I have tried everything I can think of: rebuilding, deleting all the dlls/pdbs to force them to be recreated, editing the csproj & sln files with notepad looking for references to the old folder structure... Somewhere vs.net is picking up the old folder path because it appears in the message box but I can't discern where this information is stored. We used to have an option "Rebuild All" would this not correct this problem How do I force the IDE to rebuild the pdb's and point them at the right place Thanks in advance I had this problem as wel ...Show All

• SQL Server Database Synchronization IN Analysis Services

  Hi, I am getting errors while synchronizing databases between two machines in my LAN using the SQL server 2005 Management Studio – analysis services’ synchronize option. After the XMLA script generated by deployment wizard from my cube was executed successfully. I kept my system as the Development server and the other system as the Production server. Then in the Production server’s SQL server 2005 Management Studio – analysis services’ synchronize option I gave source server name as mine and source database as the cube filename. Then executed the synchronize command and the errors appeared ( "peer prematurely closed the connection”; “error was encountered in the transport layer"). What is the reason for this REsult obtain ...Show All

• SQL Server Workbench won't connect

  I am having problems with SQL Workbench not being able to connect to remote SQL servers. I can connect fine on the localhost. An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 1265) If I reboot the machines enough times it seems to start working. However I will soon be moving into production and will be unable to reboot the machines. I found a 3 part blog post on troubleshooting this but it didn't help. Any ideas Steve Thanks for the replys ...Show All

• SQL Server Distincts databases on the same stored procedure

  Hi!     I need to use two distincts databases on the same stored procedure. One, database1, is where I want to place the procedure, and where the table the procedure populates is (table1). The other, database2, hosts the table (table2) from where I select some data to put into table1 in database1.     Database1 name is fixed, while database2 name may change. So, I would like to pass database2 name as a parameter to the procedure. In this simple example, it works fine: use database1 go create procedure teste @db_name varchar(10) as exec ('select * from ' + @db_name + '.dbo.table2')     But the problem is that in my procedure, database2 is used in a cursor, something like this: create ...Show All

• Visual C++ C++ (Visual Studio 2005) class question

  I am new to programming with C++, but am old at programming itself. Here is my dilemma: I am writing a program that will calculate the area of a room using C++, but I also need to create and define a class so that the code will be put int a method of that class rather than in main. I have the basic program down and it runs just fine, but when it comes to creating and defining a class so that it runs from the class instead of main is where I loose it. My question is, how do I create a class, when the class is created, what do I need to put into it and how would I get my program to work using this newly created class I've been looking at this for days and am not getting anywhere. Any help is greatly appreciated. ...Show All

• Windows Forms exception during axhost.dispose

  when I create an activeX control at runtime which in fact is a .net control exposed as a com object, the hosting axhost class gets the following exception during its dispose: The object's type must be __ComObject or derived from __ComObject. Parameter name: o When the activeX control is created by other means (e.g. visual basic 6.0) the dispose works fine. The control is created by calling new AxHost(CLSID_OF_THE_CONTROL) Is the .net control missing any necessary interface implementation to work with axhost System.ArgumentException was unhandled by user code Message="The object's type must be __ComObject or derived from __ComObject.\r\nParameter name: o" Source="mscorl ...Show All

• Visual Studio Express Editions Visual Basic 2005 connect to remote db error [StrClr)

  I am having an error when trying to connect to a remote database. CODE: Dim connectStringBuilder As New SqlConnectionStringBuilder() connectStringBuilder.DataSource = "****" connectStringBuilder.InitialCatalog = "***" connectStringBuilder.IntegratedSecurity = True connectStringBuilder.UserInstance = True connectStringBuilder.UserID = "***" connectStringBuilder.Password = "***" connectStringBuilder.ConnectTimeout = 15 connectStringBuilder.ContextConnection = True Dim myConnection As SqlConnection = New SqlConnection(connectStringBuilder.ConnectionString) myConnection.Open() My error occurs with my Dim myConnection... line. Any help is appreciated. [ERROR] Th ...Show All

• Visual Basic Help Making A Simple Web Browser

  Hello everyone I was wondering if anyone could help me. Im trying to put a Progress Bar in My Web Browser to see How much og the Page Has Loaded like in IE. Thanks alot Brad implement the ProgressChanged event of the webbrowser control. This event is fired when the progress changes of the downloaded document. the event gives you a WebBrowserProgressChangedEventArgs. In here there are 2 properties, one is CurrentProgress and the other is Maximum progress. So with these 2 I guess you can do some calc or just keep seeing what the currentProgress downloaded is and build up your progress bar this way. http://msdn2.microsoft.com/en-us/library/system.windows.forms.webbrowser.progresschanged.as ...Show All

• Visual C# Same KEY & IV for TripleDES Encryption as well as Decryption in 2 different Win Services.

  Hi, I want to encrypt as well as decrypt a file using TripleDES. My problem is that I am autogenerating the KEY & IV while encrypting the files. As per my project requirement, I have to keep both Encryption & Decryption parts in two differents windows services. Can any one please guide me how to supply same KEY & IV for both I am using the following coding for encryption & decryption: //.......................... private static void EncryptData(String inName, String outName, byte [] tdesKey, byte [] tdesIV) { //Create the file streams to handle the input and output files. FileStream fin = new FileStream(inName, FileMode.Open, FileAccess.Read); FileStream fout = new FileStream(outName, ...Show All

• SQL Server Refreshing metadata of transformations in the data flow

  Hello, I created a slowly changing dimension object and used an OLE DB Source object with a SQL Command to feed it. After all the SCD objects are created, I get a warning about a truncation which might happen. I adjust the source query with the right converts, so the query uses data types and lengths which match the target table. I update the OLE DB Source with the new query. Column names are unchanged. Now how do I get this data flow to reflect the new column lengths Do I have to throw away all objects and recreate the SCD The refresh button in the SCD object doesn't do it. This is also a problem when adding columns to your dimension table. Because I modify the stuff that the SCD generates, it's VERY teadious to always have to th ...Show All

• Smart Device Development Setting textbox caret position in the onfocus event

  I have subclassed a TextBox and would like to select the text everytime the TextBox got focus. So, I override the OnGotFocus event like this: protected override void OnGotFocus(EventArgs e) { SelectAll(); base.OnGotFocus(e); } This routine works fine except that the base TextBox always change the caret position back to where I clicked into the textbox somewhere after the GotFocus event. I added the following to the click handler and the text is selected with the cursor at the end of the selected text. private void tbx1_Click(object sender, System.EventArgs e) { tbx1.Select(0, tbx1.Text.Length); } ...Show All

• Windows Forms Can not turn off automatic update

  I made Windows application which manualy checks for updates each time when the application is started. Although I turned off auto updates, I still get sometimes before I launch the application update form which wasn't created by me. My manifest looks like that: ....... <deployment install="true" mapFileExtensions="true"> <deploymentProvider codebase="http://some.url/> </deployment> ....... What do I do wrong One problem, why I can't use default mechanism is, that my application is not available just in english language. I have to custumize the design. Second reason is that, because I made my own form, it is possible to use application ...Show All

• SQL Server using SQL Express in file mode on Vista

  Hi! We use SQL Express in our Applikation in file mode. Users can create databases in different folders and pathes. Each time a user loggs into our applikation, we attach the db he choosed, and every time he closes the applikation, we detach the db. While this works fine in Windows XP, we have serious problems with Windows Vista. We tried a connectiong string with "attachdbfilename", "sp_attach_db" and SMO server.AttachDatabase Where could we get some more advice for our problem. It is in fact an issue of UAC. Best regards, Reinhold Hi Reinhold, So what is the problem you're seeing Please give details such as error messages, directories where you're trying ...Show All

• Visual Studio Express Editions Finding the database on a PC where my app is published

  Good day every1 (I'm dutch so my english will be not that good ) I have a little question about using MS Access to bind data in Windows Forms. Here it is: I made a database in MS Access with a table. I also made a new project with a windows form. I made some txtboxes in it with the databindings of MS Access database. Now when i run the project and select my own made button: New, I can enter a new name, adres, ...etc. Then i click on a button: UPDATE DATABASE. ( What does it do: It enters the name, etc. in the database of MS access (updates data)) Now if I run the project again, again and again the name is still there (that's just FINE) This all was some information about my program but now comes the question : If I pub ...Show All