V Shankar's Q&A profile

• SQL Server Which method to use for synchronization?

  I have three options in my mind to synchronize my data of sql server compact edition with sql server 2000/sql server 2005. 1)Merge Replication 2)Remote Data Access 3)Web Service All the data would be residing on Sql server 2000/2005 and user will get their data after being authenticated and will change the data and add new data and then again will synchronize with server with new changes. Please suggest me solution, my opinion is going towards Web service. Thanks howdy, if you are after a client/server free, over http, loosley coupled approach then a service oriented architecture using web services for synchronisation is the way to go. This is outlined nicely (at a high level) in the ...Show All

• Visual Studio Team System Automating DB Deployment and running under a set user account

  Hi We're looking at automating deployment of our DB's using TFSBuild. One thing I've noticed is that the build types execute under the TFS Service account. Now it seems that in order for us to create databases etc using TFS Build we need to give the TFSService account db permissions. So I'm just wondering is there anyway to specify which user account certain tasks are excuted under For example it would be great to be able to specify our "DBBuild" Build Type executes under our "bd-dploy" account instead of the TFSService account. Thanks Andy, The only way to get a particular build type to use a different user account would be to setup a dedicated build machine for it and ha ...Show All

• Visual Studio 2008 (Pre-release) WCF Large message size Issue

  1) Service returns a List back to the client. 2) Service is of type netTCPBinding 3) It is hosted as a windows service 4) The dataobjects in the list are heavy weight objects. (each item in list can be about even 1) 5) If the number of objects crosses 2-3. WCF throws the error message present in appendix named “ Buffered Error ”. I checked this error message on the internet and it doesn’t return many resolution. 6) I tried changing the following attributes to its maximum values but it still doesn’t help a. maxBufferPoolSize b. maxBufferSize c. maxReceivedMessageSize d. maxStringContentLength e. maxArrayLength f. maxBytesPerRead ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XACT won't set LoopEvent property

  Hi, I have a problem getting sounds to loop from within XACT. I open my project, open the Sound Bank window, select the sound name and highlight Play Wave - this causes the Event Properties panel to reveal LoopEvent, amongst others. Now, when I try to open the combo box to set "No" to something else, I get a dialog saying: "Object reference not set to an instance of an object." So, two questions: 1. Is there a way around this bug in XACT 2. Preferably I'd like to set the sound to loop from within my code. Is there a way to do this in Beta2 Many thanks =) Mark Hi Mark, I've seen a few variants on this error dialog popping up in the forums, but I haven't bee ...Show All

• Windows Forms Select treeview node with enter

  Hi there, The event AfterSelect, does not allow the user to scroll through the nodes with the keyboard. It selects the first node it comes to. I have already utilized NodeMouseClick for users who prefer using their mouse. My question is what event would allow users to select a node with enter. One requirement is that I must be able to view the tag property of the node selected. Any code examples would be greatly appreciated as I am fairly new at this. Thanks a bunch, Daniel Sorry, I don't follow you. I'm pretty new at this and don't yet understand some of the basics. If I'm using the KeyPressEventArgs how exactly do I reference the selected node What would be the syntax. I am used to using e.node.tag. Wha ...Show All

• Smart Device Development SMS Location

  Hi all, I'd like to backup my SMS messages (inbox & sent) from my 2003se PDA/phone (I use an HP iPaq h6365). Could someone please advise where I can find this folder/file - thanks. I'd like to be able to restore my SMS messages should my phone require a hard reset. Thanks, Gav Thank you. I don't really program much myself, but you have answered the question. If anyone knows of any ready to compile code that'd be a big help to me. I found the following web sites if they help: http://forums.microsoft.com/msdn/ShowPost.aspx postid=1216679&isthread=true&siteid=1 http://www.developer.com/ws/pc/article.php/3381221 http://forums.microsoft.com/MSDN/ShowPost.aspx PostI ...Show All

• .NET Development How do I display the Connection string builder dialogue?

  I know there is a way to do this as I've seen the code somewhere but cant find it anymore. Please help. This is the answer (kindly provided by Ben Fidge   on another forum I found) MSDASC. DataLinksClass oClass = new MSDASC. DataLinksClass (); object oCon = new ADODB. ConnectionClass (); (oCon as ADODB. ConnectionClass ).ConnectionString = "Provider=SQLOLEDB.1" ; oClass.PromptEdit( ref oCon); MessageBox .Show((oCon as ADODB. ConnectionClass ).ConnectionString); add references to the following COM libraries: Microsoft ActiveX Data Objects 2.7 Library Microsoft OLE DB Service Component 1.0 Type Library see http://groups.google.com/group/microsoft.public.dotnet.framework.adonet/browse_thread ...Show All

• Visual Studio Express Editions Open with...?

  I installed Visual Basic 2005 Express Edition on my PC that has Windows Xp on it. I made a program that i want to run on my laptop with Windows 2000. When I build and publish the program and take it to the laptop the files won't open and I don't know what program to use to open them. The laptop is too slow to install VB on if thats what it takes. Just to check a few things. First, once you wrote your code, did you select Build/Publish and follow the publishing wizard to create a directory that includes a setup.exe and the other associated files If you didn't, you may be running into a problem with the fact that you're trying to distribute object files or source files that don't include any executable c ...Show All

• Visual C# System.AccessViolationException: Attempted to read or write protected memory

  I am using .NET 2.0 VS2005. I am writing a network application to allow users from other PC to talk to my application (running at my PC) to print through my printer driver. I got this runtime exception: System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. at PrintGateway.PrintEngine.OpenPrinter(String szPrinter, IntPtr& hPrinter, IntPtr pd) at PrintGateway.PrintEngine.SendBytesToPrinter(Int32 flag, String szPrinterName, String docname, IntPtr pBytes, Int32 dwCount) in E:\PrintGateway\PrintEngine.cs:line 70 at PrintGateway.PrintEngine.SendStringToPrinter(String szPrinterName, String docname, String szString) in E:\PrintGat ...Show All

• Visual Studio 2008 (Pre-release) svcutil.exe datacontract only is not generating minOccus='1'

  Call "C:\Program Files\Microsoft SDKs\Windows\v1.0\Bin\svcutil.exe" /dconly /out:..\..\DataContractXSD.cs /t:code "$(ProjectDir)Data.xsd" Data.xsd file has < xsd:complexType name =" AccessInfo "> < xsd:sequence > < xsd:element name =" User " type =" xsd:string " minOccurs =" 1 " maxOccurs =" 1 "/> < xsd:element name =" Password " type =" xsd:string " minOccurs =" 1 " maxOccurs =" 1 "/> < xsd:element name =" ApplicationID " type =" xsd:string " minOccurs =" 1 " maxOccurs =" 1 "/> < xsd:element name =" ClientIPAddress &quo ...Show All

• Windows Forms discarding user actions on a form while in busy state

  Hi, I can't seem to figure out a decent way to do this. I have a small window, and I need to discard user input while performing some lenghty task. For example, if the user wants to sync the app with a server, and this takes time. The proper behavior would be to change the cursor to a busy cursor, and prevent the user from touching any control on the form. Of course, painting should still be done, and the form should be able to move and resize (user actions like move, resize, maximize, minimize). When the job is done, the cursor changes back to the default one, and the user is able to interact with the received data. I've seen various sugestions: - disable the controls (or the whole form): not good, as the appearance of the c ...Show All

• Visual Studio Express Editions opening file error

  Dim oXL As Excel.Application Dim oWB As Excel.Workbook Dim oSheet As Excel.Worksheet Dim oRng As Excel.Range ' Start Excel and get Application object. oXL = CreateObject("Excel.Application") oXL.Visible = True ' open selected workbook oWB = oXL.Workbooks.Ope n(openfiledialog1.filename ) I am getting :- HRESULT : 0X80020003 (DISP_E_MEMBERNOTFOUND) COM exception error I am guessing it doesnt know what (openfiledialog1.filename) is and I dont know how to fix it..... Openfiledialog1.filename is called in sub button1_click...... I have tried declaring it globally but that didnt work.... If anyone can point me in the right direction, I would appreciate it.......... ...Show All

• Visual Basic Class Tree Flowchart

  What is the tool that creates flowcharts from classes inside of a VB.Net project It would be useful to have a visual aid as to what class calls (or is called) by another class. There is a tool that creates class diagrams for you, but I am unaware of any tool that creates flowcharts for your project ...Show All

• Visual Studio Toolbox Customization

  Is there a way to stop the automatic loading of local components. I have a project that has about 100 custom components and it takes forever to load them. I really don't want them in the toolbox. So is there a way to stop them Have you tried scoping you classes as internal rather than public. Not sure this will help you though. Other that that we can not come up with a solution. Thanks, Ole ...Show All

• SQL Server Error 1 Memory error: The operation cannot be completed because the memory quota estimate exceeds the available system memory.

  I get the following error when trying to process a cube on the server. Error 1 Memory error: The operation cannot be completed because the memory quota estimate exceeds the available system memory.    0 0  It runs on a Microsoft Windows NT 5.2 (3790) with the JUNE SQL 2005 Developer release. I has 4 gigs of RAM This error comes when trying to process all sizes of cubes. Try following: Navigate in the SQL Management studio to the Partitions node in your measure group. The "Summary" page on the right will list all of your partitions. Multi-select partitions you would like to process and launch the Processing dialog using Right-Click menu on the su ...Show All