Sapient's Q&A profile

• SQL Server ExecuteSQL Task with Parameters

  I have an insert statement that i am trying to parameterize based on a variable.  I have tried: INSERT MyTable(Col1, Col2, Col3) VALUES(1, @MyParam, 3) INSERT MyTable(Col1, Col2, Col3) VALUES(4, @MyParam, 6) as well as: INSERT MyTable(Col1, Col2, Col3) VALUES(1,  , 3) INSERT MyTable(Col1, Col2, Col3) VALUES(4,  , 6) The parameter is defined in the task.  It fails consistently.  The error in the output shows the SQL witho ...Show All

• SQL Server .NET2 SMO Components

    I am new in VS2005 and I start with sql2005 express. I plan to use SQL express 2005 manager. When I tries to install this program the system asks for MS Framework,net2 SMO Components. Where can I download these components Thank You Best regards Oyvind       All of the information needed to install and run Management Studio Express is at http://www.mic ...Show All

• Visual Basic ERP System Interface sample screen.

  Is there any websites that can provide sample screen of common ERP system You can register for Siebel product demos at: http://www.siebel.com/crm/demos/reg-solutions-demo.shtm These demos show several CRM/ERP sample screens. ...Show All

• Software Development for Windows Vista Unable To Debug WWF Projects

  For some reason when I try to debug a WWF project  (code debug) by using the start "Debugging -> Start Debugging" menu item, the project builds successfully but does not lauch the program into the debugger. If I run the project by using "Debugging->Start Without Debugging" the application runs fine. Any thoughts Pete If your host is asp.net, you need to attach to w3wp.exe (win2003) or aspnet_wp.exe (win xp) and select workflow d ...Show All

• SQL Server sql2005:Cannot use SAVE TRANSACTION within a distributed transaction

  Error returned when trying to commit the transaction to a database that is a replication distributor. (sql2005 ctp16) the error I am seeing: Msg 627, Level 16, State 0, Procedure sp_MSmerge_altertable, Line 305 Cannot use SAVE TRANSACTION within a distributed transaction. Anyone encounter transaction problem with replication Thanks. Hi Micky, thanks for your post, just wanted to let you know that you ...Show All

• Smart Device Development Trying to connect to SQL Server from

  I'm trying to connect to SQL server from my pocket pc on my home network. I generated the connection string and bound controls from VS 2005 so the connection string being used was generated at design time. The program fails when trying to initially fill the tables The same connection string works on a windows application. Is there a difference in the connection string or Hi,    It's kind of difficult ...Show All

• Software Development for Windows Vista TransactionInDoubtException

  Source: System.Transactions.TransactionInDoubtException: mscorlib Text: The transaction is in doubt I'm getting the following error is a very specific circumstance and I don't understand why. I've got a single unavoidably long running transaction (~90mins) that I run from a .net component against a SQL Server 2000 database. If I invoke my component from MMC.exe (COM based root) I'll often (eventually) get the above error message. However, i ...Show All

• Visual Studio 2008 (Pre-release) modifying xps document

  " To modify an XPS Document, an application must read in the current document, modify the contents, and write the modified version as a new document from the application." hi there, can some body explain me what this exaclty means, does it means that if we were to modify xps doc we need to create a new xps doc. " what kind of support do we have so that the the application can read the full formating of teh doc if it w ...Show All

• Visual Studio Express Editions how to update the GUI from a different class

  well! i have written a class which has some functions is there a way to update my GUI form that Class. I am assuming you want to draw on the form from a class. I would pass a graphics object to the subroutine or function that is doing the drawing. ...Show All

• Visual Studio Team System VS2005 RC to TFS Beta 2 connection Error

  Hi, I have installed Visual Studio 2005 RC and the Team Explorer that came with TFS beta 3. Everything is in its place in VS. I already have a TFS beta 2 up and running on a 2k3 server. I used to connect to it with VS 2005 beta 2. When I try to add the server in VS 2005 RC now, I get an error: "TF31002: Unable to connect to this Team Foundation Server: [server name]. Team Foundation Server Url: h t t p://[server name]:8080. Possible reasons ...Show All

• Visual C++ Static const C++/CLI class members

  Static const C++/CLI class members can be changed from C# client: public ref class Server { public: static const int someValue = 25; }; C# client code: Server.someValue = 50; // successfully compiled How can I prevent this Looks like a C# bug to me. It's ignoring the IsConst modopt. One reason they overlooked this may be because C# does not support static const members. ...Show All

• .NET Development Still little confusion

  Hi Friends    I have a question regarding Digital Certificate/SSL. How digital certificate actualy implemented in application. Suppose i want to secure my application with digital certificate/SSL I had purchased digital certificate from verified Certificate Authority (CA) Now do i need to make changes in my web application developed in Asp.Net Give me detail idea about it Thanking you in advance David ...Show All

• Visual C++ VC++/MFC 8 not stable

  Hey, I am affriad to say MFC 8 that comes with VS 2005 isnt stable at all. im working in a studio trying to work on a project, and i keep on wasting time on worthless issues. All of which have to do with pointers and the new operator. Latest issue is it will declare thepointer if i told it to load configuration from a file. but it wont declare it if i decide to load the configuration manually, i really dont know what difference does it make. im ...Show All

• Visual C++ Cannot find WINAPPC.H and WINCSV.H

  I am porting our application from VS6.0 to Visual Studio .Net 2003 in VC++. I do not find the following files in the installation on my machine in Visual Studio .Net 2003. "WINAPPC.H" and "WINCSV.H" Are those files not come with VS .Net 2003 If so, where can I find it Thank you very much. Check this: http://doc.ddart.net/msdn ...Show All

• Visual Studio How can I Organize templates in the "new project" dialog?

  Is there a way to group the available templates within a GAT package under custom headings (like the "Visual Studio installed templates" heading) Specifically, can I group some project templates under one heading and specify another heading for another set of project templates Nope, that's not supported right now. Just out of curiosity, how many project templates do you have If there are too many, ...Show All