Randy Trexler's Q&A profile

• SQL Server transactionoption=required

  Hi I set the transactionoption = required at package level. This package has a couple of dataflow taks and both the tasks are set transactionoption = supported. If one of them fails, both the tasks should be rolled back. When I run the package, it simply hangs at the first dataflow task with no error message. I had to stop debug to stop the execution of the package. My system has DTC service enabled with Network DTC access enabled and the sql server is running on my local machine, which is windows xp box. Any idea why this happens and the solution or workaround for this Thanks Ramani Hi Mohit Thanks for the suggestions. My package has just two data flow tasks, and both are ...Show All

• Visual Studio Tools for Office Fuzzy text in a label control

  Hi, I've added some controls to the top of a sheet in an Excel file. The problem I'm having is that the text on, say a label, is blurry or fuzzy. It almost looks like when smoothing is being applied but actually makes it worse. I've tried various fonts and sizes and that doesn't matter. The rest of the text on the sheet looks fine. Has anyone seen this before, and hopefully knows what's happening I'd appreciate any help. Thanks. Hi Art the reason for this is that, at design time and until the VSTO customizations finish loading, all you see is a graphical representation of the control, rather than the control itself. The graphical representation doesn't render very well, is all :-) (which helps you recognize if there's a p ...Show All

• Visual FoxPro ActiveX control created in multithreaded VFP COM dll

  I just can't to solve the problem. May anyone say why a MSWinsock control isn't work in VFP COM dll. In common exe this all works fine, but in the COM dll nothing happens, while I invoking Connect method. Really nothing! The State property remains 0 at all. Help if you know   cosmmm wrote: I just can't to solve the problem. May anyone say why a MSWinsock control isn't work in VFP COM dll.   I just understood one thing: I organized a loop to wait an answer from the server and used the INKEY(.1) command. In this case all works fine. But in COM dll INKEY command causes the error "User-interface operation not allowed at this time". So MSWinsock control doesn't have idle ...Show All

• Visual C++ Ambiguity of Common Interface in two COM component when generating RCW by VS2005

  My situation is described as below: 1. Define an interface in "CommonInterface.idl": interface Interface1 : IUnknown { [, helpstring("method Add")] HRESULT Add([in] int a1, [in] int a2, [out] int *sum); }; Compile it to generate corresponding .h, _i.c, _i.p files; (I do not know how to compile a sole .idl file, so I create a ATL project, write the definition of interface in .idl flieand compile it) 2. Create two COM component by ATL project, both use the Interface1: "SampleCOM1.idl": library SampleCOM1Lib { import "CommonInterface.idl"; // import idl file defined Interface1 importlib("stdole2.tlb"); [ uuid(EBBD4C25-4C46-4355-B0DA-586945ACD464), helpstring("Sample1 ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Subscription not available on my Xbox!

  Hi! Is there any reason why the Creators Club Subscription is not showing up on my Xbox I live in Norway, but I've not read anything about any region restrictions on this download. I want in on the fun too! Yes, sorry, failed to mention that it was the "New Downloads" in the Games section. Here's another picture from the bottom of my "All Game Downloads" section . ...Show All

• Software Development for Windows Vista Transactional persistence of multiple workflow instances: pooled connections maxed out

  I’m trying to poke WF in various ways to make sure we can use it in a large project. The system will largely create the workflows in batches. For example every night we may create 4000 or so workflows. If I’m dealing with a batch of 4000 I don’t think I’ll be creating the workflows and starting them right away like this: WorkflowInstance instance2 = workflowRuntime.CreateWorkflow(typeof(Workflow1)); instance2.Start(); I’m more thinking I’ll be creating all the workflows, getting the WorkflowInstanceID, recording this against an item in the database which the workflow is tied to. This needs to be in a transaction as I need to ensure the workflow is persisted and the WorkflowInstanceID is also recorded against the relative item in the datab ...Show All

• Visual C++ basic (default) Console ap using STL has Manifest error on DEBUG but not RELEASE.

  I am using MSVC 2005, and I added VCRedist.exe and SP1 recently. It is running under WinXPpro (version 2002, SP2), on a Pentium 4 3.40GHz machine. I created a basic Console application using defaults in the wizard. - manifests were turned on by default (Linker property: Manifest File: Generate Manifest = YES) When I added my test code to _tmain(), and compiled it under both DEBUG and RELEASE, it looked fine. std::string hello("Hello, world"); printf( "%s", hello.c_str() ); But when I ran it under DEBUG, it gave me an R6034 error ( attempted to load the C runtime library without using a manifest ). But when I run the RELEASE mode, it looked like it ran fine (ctrl-F5). What is wrong I tried to look at the R6034 p ...Show All

• Visual Studio Team System SQL error = 7202 on linked servers

  Hi, I have created 5 projects using the new database project wizard. Importing the scema from SQL Server 2005 with no problems but one. I keep getting this error message even though when I query sysservers there is a server named ANNEALING. The SQL code works great on the on-line server. "Error 166 TSD4001: Could not find server 'ANNEALING' in sysservers. Execute sp_addlinkedserver to add the server to sysservers. (SQL error = 7202) C:\Documents and Settings\donron\My Documents\Visual Studio 2005\Projects\CMC-iSQL-SERVER_RuntimeAnnex\CMC-iSQL-SERVER_RuntimeAnnex\Schema Objects\Stored Procedures\dbo.HBADailyStackCollector.proc.sql 6 1 CMC-iSQL-SERVER_RuntimeAnnex" I have the same type of SQL code in another databas ...Show All

• Visual C# update datagrid

  how can i update a changed datagrid if(dg.haschange()) // dg is your datagrid name { dg.aceptchange() ; // or something like that dataadapter1.update( dataset or your table name) } /// dataadapter is a control to update from datatable or dataset to database does it help you/ DongMT, Vietnam ...Show All

• SQL Server Are these queries possible without cursors or a while loop?

  I appreciate any help or advise! Thanks assuming the contents of the table are: 1 52 PUERTO RICO 2 52 PUERTO RICO 3 10 MA 4 52 PUERTO RICO 5 5 NY 6 10 MA 7 5 NY 8 52 PUERTO RICO 9 10 MA 10 11 RI 11 12 PA 12 13 CT 13 14 GA (1) detect if there are duplicates and select those records create table twoCol ( id int identity(1,1), colOne int, colTwo varchar(30), modified_last datetime ) I would like to detect all duplicate rows based on colOne and Col2 e.g(all three of these rows have same colOne and Col2) 3 10 MA 6 10 MA 9 10 MA e.g(all four of these rows have same colOne and Col2) 1 52 PUERTO RICO 2 52 PU ...Show All

• Visual C# Delphi objects equivalents

  Hi! I'm looking for some objects that in Delphi was very usefull for me. TStringList : In Delphi, a listbox is a graphical component with a TStringList, y managed code i can use TStringList like no graphical object but can use with strings .add, .delete, .insert .loadfromfile() ... is very usefull. ArrayList is the equivalent of TList, i'm looking for operate with strings. TThread: In C# i'm launch threads with Thread aganist a function, in Delphi i can define a TThread Object that is like a class with its own internal functions, and the thread runs like a little program in the app. Which ar the equivalents Regards. The closest equivalent to TStringList would be StringCollection , List<string> or Collection<string> dep ...Show All

• Visual Studio Team System Cannot start build

  When I try to start a build on our server, the response back is 'Failed to retrieve data from the server. Please verify the network connection and try again'. I tried reinstalling the TFS build software and that did not help. I also checked the event logs for any errors, but there were no events from the build. There were no changes made to the server that I am aware of that would have caused this to start happening. This happens both in Visual Studio and with the TFBuild command line on either the build server or my local PC. Are there any logs I can look at or tracing that can be done to figure out what is happening or has anyone else seen this problem Thanks in advance, Joe G. It looks like the time o ...Show All

• SQL Server Inner join queries Between sql2005 and sql2000

  We have the follwoing environment Sql2005 64 bit edition standard edition servers Sql2000 Sp3 enterprise edition servers when we try to access a table in sql2000 from sql2005 using linked server, the query also uses inner joins and max() it gives the follwoing error " Msg 8180, Level 16, State 1, Line 1 Statement(s) could not be prepared. Msg 207, Level 16, State 3, Line 1 Invalid column name 'Col1017'." The query looks something like this select * FROM [X.X.X.X.] . HRDE . dbo . PS_HX_LVE_FRM_SRCH A , [X.X.X.X.] . HRDE . dbo . PS_NAMES B WHERE A . EMPLID = B . EMPLID AND A . HX_LEAVE_STATUS = 'PND' AND B . EFFDT IN ( SELECT MAX ( EFFDT ) FROM [ X.X.X.X.] . HRDE . db ...Show All

• Windows Forms string input via forms

  How do I input strings using a form ...Show All

• SQL Server cannot convert between unicode and non-unicode

  I keep getting the error message below when attempting to import a text file (flat file) to an SQL Server Destination using SSIS. This database has recently been migrated from SQL Server 2000 (where I used a DTS Package that worked fine). I plan on doing further manipulation to the file after importing but have so far tried to keep one step at a time. I have tried using a smaller files and different tables but still get a similar response. I believe that the encoding of the text file is ANSI. If it is relevant the database collation is Latin1_General_CI_AS (the same as it was when 2000). Any help anyone can provide will be greatly appreciated!!! TITLE: Package Validation Error ------------------------------ Package Validation Error ...Show All