James. L.'s Q&A profile

• SQL Server Merge replication - examples for custom conflict resolvers?

  I have gone through BOL and various online resources including this one and I can't find any examples on how to use custom conflict resolvers to generate a result row which is a combination of the rows to be merged. BOL says it can be done, but suitable examples are missing. I have found various posts requesting examples from up to a year ago, but can see no replies with relevant information In particular I would like to see examples of 1) A stored procedure based custom conflict resolver 2) A business logic handler written in VB .Net Here's hoping aero1 Just in case the problem was due to some complexity in the table definition,  I repeated the test with an even simpler table ...Show All

• Visual Basic send to a printer in VB.net

  Isn’t there a way to send an MS Word doc to a printer in VB.net We generate dozens of Word docs for our clients daily, and would like to create a simple app that will list the files in a selected folder and allow them to highlight as few or as many as they want and send them to their default printer. I can’t seem to put my finger on any information describing a similar task in VB.net. Thanks, Michael Nicholas The solution to yoru prob is, not to create a new Process everytime for each item in yoru listbox. Use the same process, just fire the rest of the events one by one. Hint: write that Dim proc as New Process outside the loop, should help .... ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Does XNA Game Studio Express Work On MSVS2005 Professional?

  Hello, Does XNA Game Studio Express Work On MSVS2005 Professional Or Need C# Express Try a little legwork yourself and search the forum for the answer... ...Show All

• SQL Server Unable delete remote files using FTP Task

  I can create remote folder and delete it I also can create remote files but i can not delete remote files error warning is like subject any ides thanks Ignacio, Not sure if you noticed it; but the bug as been closed by MS as the could not reproduce it. I suggest you to create a valid case where they can reproduce it; otherwise I dont think the votes will count. ...Show All

• Smart Device Development How to register Directshow filter

  Hi All , I have developed a directshow transform filter for windows mobile 5.0 smart phone platform but can’t register it. Can any body help me Regards Arindam Biswas Either create a cab file project and mark your filter as requiring COM registration, or write a little helper app that would load the filter (LoadLibrary) and then call DllRegisterServer ...Show All

• Visual Studio Team System Unable to upgrade for Workstation to full TFS

  I installed the Workgroup version of TFS and we purchased the "full" license. I called in and received the Product Key. I entered the product key and say the command window open, stop IIS, restart IIS and closed. I am unable to add any users to the [server]\Team Foundation Licensed Users group. It keeps giving me this error "TF50626:Maximum Users(5) in License Group. Any help Hi Smoon, are you running in a dual tier mode You should be able to run the setup again, add remove programs -> visual studio team foundation server (databases) or (services) or simmiliar wording depending if its the app tier or data tier. You then click on change/remove. You will be presented with a s ...Show All

• Visual Studio Team System Connecting to TFS failes

  Hi, I have one server which exposes TFS to the Internet via HTTPS and it requires a certificate. I have two client-computers, one can access the TFS, the other can't. The one that failes shows the following output, when using the following commandline in a folder that has a workspace associated with this server: Commandline: tf get /recursive /noprompt > tf_get.log 2>tf_get_error.log Error: Team Foundation Server server.com does not exist or is not accessible at this time. Technical information (for administrator): Client found response content type of 'text/html', but expected 'text/xml'. The request failed with the error message: -- <html><head><title>Error</title></head><body> ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Error when getting started

  im trying to launch the starter kit and i keep getting this error what do i need to do to get the games to deploy and run on the 360, so i can start learning this It looks like you're trying to launch an XBox project on your PC. To do that, create a Windows Spacwar project. To deploy to the 360, check out the documentation. Instructions for deploying to the 360 are included there. ...Show All

• Windows Forms Interacting with other windows/apps?

  I know this is possible, just wondering if it's possible in C#.NET, and how it's done. I'd like my application to interact with other apps/windows. Examples: 1) Type some text into a notepad window. 2) Force Firefox to do Help->About. 3) Read text from a notepad window. I realize #3 could potentially be a security risk and .NET may not allow it (imagine an app reading text from some open window and sending it off somewhere via the net). And in case anyone is concerned, no, I'm not trying to write any kind of malware or virus. I'm interested in writing a program that will automate tedious processes in another application. I guess this is similar to Rexx. So, how can I do something like this Just FYI - I ...Show All

• SQL Server limiting the number of child rows

  Hi I have got two related tables (tblMembers and tblTickets) that have a 1 to 2 relationship i.e a member can have 1 or 2 tickets, but not more. How do I enforce this condition in SQL . Please help How did you do this with a check constraint The only way I can think is to it in a check constraint is to have a domain of two value: columnName tinyint check (column between 1 and 2) would do it, but it would seem clumsy to work with. You couldn't really do it in a check constraint that uses a user-defined function easily since the value isn't in the table yet, you would have to see if two already exist. Best to use an AFTER trigger for that. Basically you check once the data in in the table (inside your transaction ...Show All

• Visual Studio Team System External DB Synonyms Cause Compilation Errors

  Hello! I have a solution with two database projects in it. In both we use synonyms for any cross-database references, e.g.: USE [AdventureWorks] GO /****** Object: Synonym [dbo].[synNorthwindEmployees] Script Date: 11/23/2006 15:18:35 ******/ CREATE SYNONYM [dbo].[synNorthwindEmployees] FOR [Northwind].[dbo].[Employees] GO USE [Northwind] GO /****** Object: Synonym [dbo].[synAdvWorksEmployees] Script Date: 11/23/2006 15:25:26 ******/ CREATE SYNONYM [dbo].[synAdvWorksEmployees] FOR [AdventureWorks].[HumanResources].[Employee] The problem we're experiencing is that any view that uses a synonym for an item from the other database causes a compilation error when we build the solution. So if we have the following view in the Ad ...Show All

• Visual C++ WindowProc: cannot convert from 'LRESULT (__stdcall *)(HWND,UINT,LPARAM,WPARAM)' to 'WNDPROC'

  Hello, I am having a problem setting up a generic Win32 application . Specifically, when I'm filling out the WNDCLASSEX structure, the compiler shows an error when I try to assign the window procedure function to the lpfnWndProc member variable. Here is the relevant code : WNDCLASSEX wcl; wcl.cbSize = sizeof( WNDCLASSEX ); wcl.lpszClassName = g_szWinName; wcl.hInstance = hInstance; wcl.lpfnWndProc = WndProc;     // Error here wcl.style = 0; wcl.hIcon = LoadIcon( NULL, IDI_APPLICATION ); wcl.hIconSm = LoadIcon( NULL, IDI_WINLOGO ); wcl.hCursor = LoadCursor( NULL, IDC_ARROW ); wcl.hbrBackground = (HBRUSH)GetStockObject( WHITE_BRUSH ); wcl.lpszMenuName = NULL; wcl.cbClsExtra = 0; wcl.cbW ...Show All

• Windows Live Developer Forums UpdateOrders time set to midnight?

  Hi there, just using the UpdateOrders and it works fine except for a little something. I set the date to what I want and UpdateOrders return "success" so all is good. Not. When I retrieve the order, the time is revert to 00:00:00 whatever the initial time I set. Is this normal behaviour If so, why did you choose a DateTime type when a Date will have been more relevant since we can't set the time. This means if I want an order to end on july 19th at 23:59:59 (last second) I need to set the end date to july 20th at 00:00:00 (first second). Correct Thanks for your help. Julien Hello Julien, As of our current API version, the system will truncate the time portion of the DateTime object and only ...Show All

• Visual C++ SDI /MDI ? Pls help me!!

  hi, I have an application where there is one document and 4 views, all 4 small windows simultanously updated(4 child windows floating in the main window.) Now is that possible in the SDI, if so some clue...pls. or shoud I go with the MDI.. thanks & regards, Srikanth. You are right, the Views are not independent but they can be different. But you are free to create new frame windows with views. An example is the way the MFC creates the SDI multi Doc interface. A problem is how you create anddestroy the freame windows. But you can call CDocTemplate::CreateNewFrame at any time. ...Show All

• Visual Studio Express Editions Application failed to start, mspdb80.dll was not found error !!

  I stopped using Visual C++ Express Edition for a few days after it was working fine.  I came back to it today, opened some programs in a text editor that I had gotten from a tutorial, and tried to compile and run them on the command line using "cl /EHsc [filename].cpp".  I have done this many times in the past with the same exact files, in fact, and I have never gotten this error before. [cl.exe - Unable To Locate Component] This application has failed to start because mspdb80.dll was not found.  Re-installing the application may fix this problem. I have not deleted or moved any files since my last use, so I don't know why this is happening.  Re-installing VC++EE doesn't help either.  ...Show All