Chidu's Q&A profile

• SQL Server Transferring data from read-only source to destination.

  Hi, I have read only permission in the source (OLTP) database. The source database is running in SQL Server 2000 and the size is more than 200 GB. I need to pull data from source and load target which is running in SQL server 2005. Following are the objectives I want to achieve. Data should be loaded on incremental basis. Whatever changes take place (Update/Delete) in source, that should be replicated to already uploaded data. Here I want to mention that, the source database does not have any identification key or timestamp column like Updated_Date by which I can filter the data which are recently inserted or updated into the source and upload the same. The source does not maintain any history data also. So I do not h ...Show All

• Software Development for Windows Vista Application fails to start under Vista: "A referral was returned from the server." Manifest problem?

  I'm working on migrating a driver management application (written in Visual C++) to Vista. It requires access to HKLM, so it needs to run with admin access permissions. For testing purposes, we've been modifying secpol.msc to run it in admin approved mode, but obviously, that's not the right thing to do. The right thing to do, from what I can tell, is to add a <trustInfo> tag to the application manifest (which is embedded in the .exe as a resource). I did that, but now the application fails to start under Vista at all, with the error message "A referral was returned from the server." It still works fine under XP. The manifest is pasted below. Does anything look obviously incorrect If not, is there anything that could interact badly w ...Show All

• Visual Studio Team System Testing Check-In Poliy for TFS

  Hi. I've added a Testing check-in policy to TFS. However, I have two solutions, each with a .vsmdi file. When I add two policies (one for each .vsmdi file), the checkin policy requires that I run all the tests (for both solutions) even though I am only checking something into one solution. Is there any way to apply a testing check-in policy to only one solution, so that when checking in a file for that solution, it requires all the tests associated with the solution (and only those tests) to be run first. Similarly, checking in anything to do with the other solution requires only the tests (defined in the appropriate .vsmdi file) associated with the solution, to be run. Any help will be very much appreciated. Regards, ...Show All

• Visual Basic Lock XML file when in use

  Hi, I am using XML files to store some iformation that are to be processed. I use this code to interact with the XML file: Dim xmlDoc As New XmlDocument xmlDoc.Load("theXMLFile") ...Do XML stuff such as add elements... xmlDoc.DocumentElement.AppendChild(oAlarm) xmlDoc.Save("theXMLFile") What I want to do is to lock the file so that no other process can use the file. If a process wants to use the file, I also want it to wait and try again until file is available. Can anyone help me Best /M You can open a readwrite file stream and hold it open untill you are done. No other app should be able to access the file while it is open. Make sure the stream is prope ...Show All

• Windows Forms Changing Application Icon

  Hello, How do I change the icon that my application shows on the desktop (or any folder for that matter) I can change the icon shown in the title bar of the Form thru the property pages. But I want to put up an icon for the application itself, when put on the desktop. Ideas Right click the project in solution explorer, choose Properties and it's right in front of you under Resource group box ...Show All

• Gadgets ActiveX for Sidebar best practices

  I am interested in further exploring the possibilities of using/developing an ActiveX object for use in a Sidebar gadget but havent done anything like this before. What are the best ways of proceeding with this Can i use Visual Studio 2005 to create an ActiveX object i tried using ATL project, i was able to compile it but not to register it Compiled, built and registered on mine okay, with F7. I also tested it with the following code: var oTest=new ActiveXObject("TestActiveX.TestControl"); oTest.Echo Check you're not getting a compiler error, I had to do a rebuild to get it to compile the first time (right click on TestActiveX and select Rebuild) ...Show All

• Visual C++ Linker bug? data_seg(".CRT$XIU") not merged into other .CRT segments

  Using the x64 cross-compiler running on x86, linker and cl.exe file version "8.00.50727.42 (RTM.050727-4200)", the following code that works in x86 with the x86 cl.exe and link fails: #pragma data_seg(".CRT$XIU") static int (*initptr)() = APreCppInitFunction; #pragma data_seg() The problem occurs because cl.exe seems to create the data_seg as a DATA segment type (in x86 it gets generated as CODE), and link.exe does not merge the .CRT$XIU segment into the correct alphabetized sequence among the other CRT code segments (.CRT$XIA, etc.). Here is a sample from the x64 mapping file that results: 0001:00000b28 00000008H .CRT$XIA CODE 0001:00000b28 00000008H .CRT$XIAA CODE 0001:00000b28 00000008H .CRT$XI ...Show All

• Architecture High availability application

  Hi Everybody! We are starting a project to develop a mission-critical web application (therefore, availability,reliability and scalability are major concerns). We are thinking about using a SOA approach, using WCF services hosted on IIS (using a cluster in order to provide the required availability, scalability and reliability). My questions are 1) I've seen that WCF can be hosted on IIS or as Windows Services. I'd like to know the advantages and disatvantages of each approach (considering specially performance and development/deploy effort issues) 2) Is there any reference we could use in order to estimate the hardware requirements to support the solution (the information we can use to estimate it a ...Show All

• SQL Server SQL Agent Failing when trying to run my SSIS Package

  I found a similar thread posted under the same title as this by dba123. Unfortunately, his solution does not match my problem. I have a SSIS package that will run fine in debug mode, will run fine when published to the server when I right click and execute it. However, when I run it through a job, either scheduled or running the job manually, the job fails. There is an entry in the servers application log telling me that "login failed for user xxxxx" where xxxxx is the name of SQL login that I am using. I know that the login works (logged in manually to the server via management studio, and it runs fine when I run it manually). Both connection managers are SQL, no flat files or other data source types. All the commands are T-S ...Show All

• Visual Studio CDATE() Error in RDLC

  I'm having trouble with a line in my RDLC when trying to convert strings into dates I am taking the data from an xml file as a string and i need to convert the dates and decimal values into dates and decimals, so that when they are exported into excel they immediatly useable as dates and decimals. The only way i have found to do this is using CDATE(), which workd fine unless the date is blank. To get around this i am tring to use an IIF() and ISDATE() function which correctly identifies the dates and blank fields, but as soon as i put the CDATE() function in the formula it converts the dates, but brings up #error for all of the blanks. This is the line i am putting in the formula of the cell: =IIF(ISDATE(Fields!LeavingDate. ...Show All

• Smart Device Development regarding the use of thread in Smartphone

  hi , i have been in developing application in smartphone using c# .. i am using visual studio 2005 .... for my application i have loaded the resoueces using the following code ... Stream s ; Bitmap img_btYellow; s = this.GetType().Assembly.GetManifestResourceStream("Widgets.res.avblue.png"); img_btYellow = new Bitmap(s); s.Close(); i have loaded 8 '.png' images through the above code using the same stream ' s ' . the application is running fine in emulator .... but it is showing out of memory exception in the exe created inside the bin folder ... even i tried using singleton object for all the classes , that i have used .. but it s still showing the same exception .. could anyone help me in resolving this issue . ...Show All

• Visual FoxPro Visual FOXPRO ODBC Drivers... still broken in Vista RC2

  Hi. Does any one knows where i can get the Visual FoxPro ODBC Drivers for Windows Vista Thanks. Helder Santos Is there any reason to choose ODBC over OLEDB or vice versa App is in VB.Net and uses both MDB and DBF. ...Show All

• Software Development for Windows Vista Calling CreateProcessAsUser() from service

  According to some MS documents (e.g. http://www.microsoft.com/whdc/system/vista/services.mspx), it should be possible to use CreateProcessAsUser() API in a Vista service to create a process in user session. I am trying to achive this, but the function returns error code 1307 (ERROR_INVALID_OWNER) = "This security ID may not be assigned as the owner of this object." Does it work for somebody Many thanks in advance. Did you use start windbg.exe in session 0 and make the service interactive Dbgview has to run in the same session as the process being traced... Windbg doesn't have this restriction by the way. You can debug/attach accross session boundary and use it as dbgview. MSDN with regards t ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. The Relation Of Math And DirectX?

  Do I Really Have To Be Professional In Math To Be Professional In DirectX Matrix understanding is important, so is the fact that a Matrix * a Vector will give you a vector and stuff like this Also you need to understand a little about tangente that are vector on surface of object, Normal that are perpendicular vector That vector are simply 3 values x,y,z That matrix can contain Rotation/translation/Scaling Also their is math involved in Calculating light, math formula like this : Light = Material Color * (Light1 + Light2 + Global Ligth ) This is not the exact formula but DirectX microsoft help will give this to you Those mathematic formula are crucial to understand how color component give the final light ...Show All

• Windows Forms ClickOnce deployment - Application identity is not set

  I have developed a program using Visual Basic 2005 Express Edition. I have a Microsoft Access database included in the application, whose Build Action is set to "Content". To generate the connection string for the database, I use the following code: Public Shared ReadOnly Property ConnectionString() As String Get # If Debug = True Then Return "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _ Application.StartupPath & "\AnniversaryReminder.mdb" # Else Return "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _ My .Application.Deployment.DataDirectory & "\AnniversaryReminder.mdb" # End If End Get End Property When testing, I set my ...Show All