AmauryR's Q&A profile

• SQL Server System.Transactions issues

  Hi Is it necessary to have the connection open code inside the transaction scope to be able to use transaction features. I wrote a code which has the connection.open outside the transaction scope and it wasn’t working correctly. When i moved the connection.open inside the transaction scope it started working fine. Apart from this is there any special setting i need to do (DTC related) while working with System.Transaction and SQL Server 2000. Are there any special settings need to be done when using DTC with multi process machine (hosting SQL server 2000). Thanks Hi Ams, It is necessary to open the connection inside the Transaction ...Show All

• Visual C++ A plea to MS to improve compiler warning message C4244

  I am currently increasing the warning level on a number of C++ projects from 3 to 4 in order to pick up (amongst other things) lossy implicit type conversions. These are reported with messages such as: warning C4244: 'argument' : conversion from 'double' to 'long', possible loss of data Please can you improve the message to say WHICH ARGUMENT of WHICH FUNCTION. When the line number identifies a function call with 12 arguments, some of which are themeselves function calls, it can take a lot of detective work to find which one is the culprit. Other error messages such as C2664 already include this information, so it shouldn't be too difficult ...Show All

• SQL Server Auhtentification problem with Remote Data Access

  Hello I try to make a pull operation from an SQL SERVER 2005 database to a SQL Mobile 2005. I set Integrated authentification on IIS and SQL SEvrer authentification in the database. It passes the IIS authentification, but not the sql Server one. In addition, I tried to connect directlly to the sql with the same connection string anf it works. Can you help me with this  Do i have to extra configure that dll(the agent) in the virtual directory, or sometihng llike that   This is my code: // Connection String to the SQL Server // string rdaOleDbConnectString = "Data Source=Sql07;Initial Catalog=AdventureWorks; " + "Us ...Show All

• Windows Forms Identity problem in inserting data into master and detail tables

  I'm using the TableAdapters to insert rows into the master and detail tables. I would like to know what's the best practise to handle the identity column which is a auto-generate number. As I'm required to insert all rows in a single transaction, I don't have the id no in the master table when I'm inserting data into the detail table. What's the simpliest way, or the best way, to insert these rows into the tables I've already setup the relation between these tables but the insert process seems separate and can't match the id. column automatically. Not sure if this answers you question, but here is an example on creating master-detai ...Show All

• SQL Server Printing Issue

  I have to print a report like X + Y = Z Where X, Y are database fields + and = are string literals and Z is a calculated field I am using a table control with five columns for X, +,Y,= and Z Trouble is how do i print "=" in column four since = is reserved character Is there a way to print = in a cloumn Thanks ...Show All

• Visual Studio Team System Team Foundation Server (TFS) Installation

  Hi TFS users, I have couple of queries on TFS installation and usage !! 1. Can we install Team foundation Server on Windows XP with Service pack 2 installed I know the client can be installed on Windows XP, but i have specific reasons for installing TFS too on windows XP!! If yes, does the installation steps hold same as installation on windows server 2003 2. Can we integrate clearcase with TFS Please let me know if any one knows the related links (I know there is lot of information in the msdn blogs..but i couldn't find exact answers to above queries.) Regards Ravikanth 1 - no, the server needs windo ...Show All

• Visual Basic Problem using 3 timers at the same time.

  'Declarations---   Private WithEvents TT1 As System.Windows.Forms.Timer = Nothing Private WithEvents TJump As System.Windows.Forms.Timer = Nothing Private WithEvents TExplode As System.Windows.Forms.Timer = Nothing   TT1 = New System.Windows.Forms.Timer TJump = New System.Windows.Forms.Timer TExplode = New System.Windows.Forms.Timer   TT1.Interval = 1000 TT1.Start() TJump.Interval = 20 TJump.Enabled = False TExplode.Interval = 20 TExplode.Enabled = False   'Codes to handle Events when pressing spacebar--- TJump.Interval = 20 TJump.Enabled = True Tjump.Start()   'Codes to handle Explosion events--- TExplode. ...Show All

• Visual C# Csharp

  could u pls tell me about c # assemblers The assembly that is created by any .NET language, so C# included is MSIL. Here is a little list of resources: MSIL Tutorials Introduction to MSIL Rewrite MSIL Code on the Fly with the .NET Framework Profiling API Check under the MSIL hood to see how the CLR is running Mandelbrot set in MSIL ...Show All

• .NET Development Problem downloading Framework 2.0

  Hello all, I'm having this problem and I found this forum title is most closely related to it so I thought I try here, hope you don't mind if the problem is misplaced. I'm downloading the .NET framework 2.0 setup and, everytime, it just hang (seems to be forever) at a point Registering System.EnterprisingServices.dll which Executing: "C:\WINDOW\Microsoft.NET\Framework\v2.0.50727\RegSvcs.exe" /bootstrapi Has anyone else been throught this before Or anyone that might know how to get pass this.... I welcome all of your inputs and thank you. Thank you Mark, and may I correct one thing ... ...Show All

• Visual Studio Express Editions VB programms without 2.0 framework?

  Is it possible I would like to create portable applications and not have to take the 2.0 framework with me to.   Thx  for any help Unfortunately, no. Any application create with Visual Basic 2005 requires the 2.0 framework in order to run, just as any VB 6 app required the VB 6 runtime. Steve Hoag Visual Basic Express ...Show All

• Visual C++ Compiling VS 2005 Beta2 to a mounted network share

  Hi, I tried to do the following.  Create a simple c++ hello world app over on a mounted network share (lives on a netapp box).  Created the project just fine, but when doing a compile, it fails.  Here is the build log file.  Any idea what is wrong   Clearly I have write permissions to the files. Ok, in writing this query, I decided to try it to a network share on another windows box (our server).  Again mounted as a drive.  It works fine there. So, this sounds like some kind of weirdness on the netapp box with permissions or something. If anyone has any insight, please let me know. Thanks. Bob. Build ...Show All

• .NET Development got System.Security.SecurityException

  I have a situation... I have a program and it works just fine, but when I copy it to a net work drive it suddenly gets System.Security.SecurityException exception. Now, I know I can config the framework to trust that assembly manualy, but what happens if i need to to it to about 300 or 500 computers who needs touse that program is there any way to solve it programatically or maybe exe that configs the framework to trust the other assembly Have a look at the following post: http://forums.microsoft.com/msdn/ShowPost.aspx PostID=17584 . ...Show All

• SQL Server Error in X-Path Query

    I am new to XML in SQL Server and X-Path Query Recently I have done the following virtual lab in techNet site SQL Server 2005 XML Capabilities The following query is worked fine in the lab SELECT TOP 10 Demographics . query ( 'declare default element namespace= "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/IndividualSurvey" /IndividualSurvey/YearlyIncome' ) FROM Sales . Individual But later I installed SQL Server Express in my system and also the Express Manager CTP but i am getting the following error if I execute the above query in my system Msg 9317, Level 16, State 1, Line 1 ...Show All

• SQL Server Profiling SSIS Package

  I am trying to start performance tuning a package that is taking awhile to run.  I want to know if there is a way to figure out how long each task and/or data flow takes to execute so that I can start figuring out how to tune the slower ones. Thanks, Chris   ChrisKinsman wrote: I am trying to start performance tuning a package that is taking awhile to run.  I want to know if there is a way to figure out how long each task and/or data flow takes to execute so that I can start figuring out how to tune the slower ones. Thanks, Chris There exists a variable on each container (including TaskHost container) called Syst ...Show All

• Visual C++ Can C++ develop web-based applications?

  Hi, All New to C++ programming. and have put resource in C++ and VC books and time learning it. But now I was told that C++ can not develop web based apllications. Is this true or some extensions of C++ can go around this limit I need develop a web-based database, so the users can input company names, location, phone numbers. etc. and the users can have a full text search on this database. Do I have to learn C# and and SQL to do this Thanks. You need to learn SQL no matter what. You can write web apps using VBscript and C++, that's call ASP. It really sucks. You should learn C# and ASP. ...Show All