bbdobuddy's Q&A profile

• SQL Server Merge Replication with SQL Mobile 2005

  We are using SQL 2005 (SP1) and mobile agents with SQL Mobile. We are seeing an excessive number of updates after a device's database is reinitialized. My understanding was that if I generate a new snapshot or reinitialize all subscriptions (from the server), the devices would only get what the database looks like right now (inserts only) after syncing and/or reinitializing, but they are actually getting the right number of inserts and a huge number of updates in Replication Monitor. Any ideas Thanks! Mike Thanks Mike. Working with MS support probably a good way to pursure this issue. they can instruct you how to trouble shooting this issue. Thanks Yunwen ...Show All

• Visual Studio Team System CA1725 : Hidden code ...

  I have the following line of code in one of my (Visual Basic) classes Public Event Disposed( ByVal sender As Object , ByVal e As System.EventArgs) Implements IComponent.Disposed FxCop produces two errors CA1725 : Microsoft.Naming : Change parameter name 'obj' of method CsMdiClientController.add_Disposed(EventHandler):Void to 'value' in order to match the identifier as it has been declared in IComponent.add_Disposed(EventHandler):Void CA1725 : Microsoft.Naming : Change parameter name 'obj' of method CsMdiClientController.remove_Disposed(EventHandler):Void to 'value' in order to match the identifier as it has been declared in IComponent.remove_Disposed(EventHandler):Void Whilst I can easily suppress these erro ...Show All

• .NET Development Visual Studio 2005

  Hi All, I am using VS 2005 (ASP .NET 2.0 using C#) with SQL Server 2005 to develop a web app. There is only one dataentry screen in my app and rest are all queryable screens. The database is small. I created an MSI and released in on the server.( I am maintaining different servers for the application and the db). For some reasons, the application is slow when accessed remotely. Help will be appreciated. Besides, are there any patches available for the VS 2005 since grid view is new to the version Thx, A there are no updates available yet - SP1 will be released in Q4 of 2006, currently in beta. any ASP.NET questions should be posted over at the ASP.NET forums, since they are dedicated for ASP.NET: http://for ...Show All

• Software Development for Windows Vista State Machine SQL Tracking DB: How to find Executing activities that haven't Closed?

  I have a state machine workflow with the SQL Tracking enabled (all events - no tracking profile). What is the best/easiest way to query the SQL tracking database tasbles to find the list of activities which have an Executing record but not a Closed record ...i.e. the list of activities that are currently "active" Michael. Two options here, either will work depending on what you're most comfortable with: 1. If you don't want to do any tsql coding you can use the SqlTrackingQuery classes and walk the collections of activities and events. 2. Do the query directly in tsql. This would be the approach I would take. Have a look at the tsql code that I posted in http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=7189 ...Show All

• .NET Development How to change ms access column name in c#

  How to change ms access column name in c#, using ADOX i have this sample on VB to change a table name: Call RenameTable("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\example.mdb", "test", "changed") Sub RenameTable (conStr, oldName, newName) 'Has to be OLE DB connection 'Create object and connect to DB... Dim objADOXDatabase Set objADOXDatabase = Server.CreateObject("ADOX.Catalog") objADOXDatabase.ActiveConnection = conStr 'Change the name... objADOXDatabase.Tables(oldName).Name = newName 'Clean up... Set objADOXDatabase = Nothing End Sub this code from: http://www.4guysfromrolla.com/webtech/tips/t030802-1.shtml May be its possible transform this sample to c# th ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Could this be used to make a Morrowind scale RPG?

  Hello, I was just wondering if XNA could be used to make an Morrowind scale RPG Mousegp wrote: so even if you use the vast amount of materials already available from the PC version Would be really all that hard honestly... cause i was planning on doing a mod with it... Judging from the scope of the game you want to do, I'm guessing you're not just going to do it for your personal education purposes. Stealing assets from a published game is not only illegal, if you violate Fair Use laws, the publisher is likely to sue you into oblivion (no pun intended). You'd better talk to a lawyer before you do something like that, before lawyers come talk to you. ...Show All

• Visual Studio Tools for Office Update KB908002 not installing during word-addin setup

  Hello devs, Im working on a setup project to install an office addin. Im using VS2005 and .NET 2.0. Im trying to get the Shared Add-in Support Update for the Microsoft .NET Framework 2.0 (KB908002) components ( lockbackRegKey.msi, office2003-kb907417sfxcab-ENU.exe, extensibilityMSM.msi) to install along with my setup project. I have installed the KB908002 update on my development machine and included it as a prerequisite in my setup project in order to have these components installed along with my solution. When I run my setup.exe file I get the dialog asking if I want to install the shared addin components on to the machine but when I press install I receive the following error: The following package files could not be found: ...Show All

• Internet Explorer Development Problem facing , if i open same application in two difeerent IE and logged in with 2 different user

  Dear sir, we have one web base application and if I open the same application in two different IE window and loged in with two different A , B user then the first user A login change to same login B. That means same user login in bith the window. if I open the same application in IE and Mozila then i am able to login with two different user. please help me to solve this problem. waiting for ur reply... With regards, Prashant bhayekar I am no expert on http authentication mechanism, but your problem is mostly due to some information in the cookie which is getting shared between the two processes (if you login from two separate firefox processes you would have the same problem ). I would recommend understanding the ...Show All

• Windows Forms Need to get the .MainWindowHandle

  I am trying to get the mainWindowHandle and store it for later; however, i can not seem to get the handle back from the new process. Before someone suggest , i will let you know that i have also tried the p.WaitForInputIdle(); however, this not only does not work it will throw and error..   private IntPtr mainHandle = IntPtr .Zero; private void button1_Click( object sender, EventArgs e) { Process p = new Process (); ProcessStartInfo ps = new ProcessStartInfo (); ps.FileName = "explorer.exe" ; ps.Arguments = "" ; p.StartInfo = ps; p.Start(); mainHandle = p.MainWindowHandle; } Can someone tell me how to get the mainWindowHandle   Erik Yes, I do think you might run into ...Show All

• Windows Forms ComboBox SelectedValue

  Hi, i have a doubt, I have a combobox and I'm binding it using BindingSource. The problem is that I show in the combobox the name of the field that is in the data base, but I store the key number in the database. My problem is that I can't insert the SelectedValue inside the database and it returns me that this field cannot be null, I really don’t know what to do, any ideas I tried setting the key using ValueMember, but this didn’t worked either. Your code example is binding your combobox to table "Grupo" to produce the pick-list, however where are you binding the "SelectedValue" property of the combo to the "Products" table e.g. this .comboBox_grupo.DataBindings.Add( new System.Windows.Forms ...Show All

• SQL Server SQL Profiler 2005 showing inaccurate duration

  We have a sql 2005 with sp1 running on a 8 cpu 64 bit system. When we run the profiler and retrieve the results the durations for a query that actually took milliseconds shows as 5K-120K millisecond. When we have the same db on a sql2000 32 bit system and run the profiler the durations are accurate. Any idea If you are taking about the duration after saving into a file then the duration is in Microseconds. From BOL Duration 13 The duration (in microseconds) of the event. Note: In SQL Server 2005, the server reports the duration of an event in microseconds (one millionth, or 10 -6 , of a second) and the amount of CPU time used by the eve ...Show All

• SQL Server Error when attempting to backup to a second disk file

  In SQL Server 2005, via the GUI, I wish to backup a database to an additional disk file (there is already an existing backup disk file for this database), so that I can have more than one backup. I've added the new disk file name, highlighted it, and clicked OK. I get an immediate error (see below). Note, the 2nd error message is specifying the existing backup disk file, not the new one I'm attempting to create. "Backup failed for Server 'WCS-DEV-TPA'. (Microsoft.SqlServer.Smo)" "System.Data.SqlClient.SqlError: The volume on device 'D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\WCS_ADV_Longmont.bak' is not part of a multiple family media set. BACKUP WITH FORMAT can be used to form a new media set. (Microsoft.S ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Day 1 - Where you at?

  So day 1 of the XNA madness has come to a close, with many more to follow. How far has everyone gotten on their first game projects I haven't spent nearly as much time as I wanted to on this, but I managed to get my head to bounce around the screen. I think the next step would be to add another head (i.e. angelina jolie) to bounce around. Maybe I'll even add collision detection so that if the heads hit, she says something like "I want you so much!" and I go "Yeah, whatever" and bounce. ...not sure if I should have mentioned the idea for this game...now everyone's going to steal it and make millions. But enough about my awesome game in the works. If anyone has anything worth checking out, upload it somewhere and post the link in this th ...Show All

• .NET Development xmltextreader and digg.com rss' feeds

  Hi, I have a rss feed reader that works fine except on any of the rss feeds at digg.com: http://www.digg.com/rss/index.xml - on this feed for example the xmltextreader will crash during the do while (reader.read) loop Sample code: Sub Main() Const URLString As String = "http://localhost/books.xml" Dim reader As XmlTextReader = New XmlTextReader(URLString) Do While (reader.Read()) Select Case reader.NodeType Case XmlNodeType.Element 'Display beginning of element. Console.Write("<" + reader.Name) If reader.HasAttributes Then 'If attributes exist While reader.MoveToNextAttribute() 'Display attribute name and value. Console.Wr ...Show All

• SQL Server Dumb, but necessary, question on SSIS feature completeness

  We have never built a data warehouse. We are not even sure what the required features are to do this. Nontheless, our developers are exploring two ETL tools: SSIS and Sunopsis. They tend to like Sunopsis because it has been around a few years, has the equivalent of source-code modules (libraries) in the tool, has a highly granular security system, has 500 companies using it. and therefore must have survived several ETL projects. (We don't know if, or how many, real-world projects SSIS has been used for.). Sunopsis is Java based and uses its own authentication scheme (no support for Windows Active Directory yet. Bummer) To the best of your knowledge is SSIS, out of the box, missing any of the standard functionalites needed to populate ...Show All