TrevorW's Q&A profile

• SQL Server ADO Connection problem when using ImpersonateLoggedOnUser: Object was open

  Hi, When I try to open connection (ADODB.Connection) using: strConnect.Format(_T("Data Source=%s;Provider=%s;Initial Catalog=%s;"),strServer, strProvider, strDatabase); m_pConnection->Open((LPCTSTR)strConnect,lpszUser,lpszPassword,NULL); I received an error: Object was open. I need to open 3 connections to the same server but diferent databases. Every connection has it's own thread and every thread is impersonated immediately before connection instance is created (CreateInstance("ADODB.Connection")). First thread is connected OK, but second one fall to the error: Object was open. But I check activity on SQL server 2000 (Enterprise manager) the connection is open. This is very strange for me. Any ...Show All

• Visual Studio 2008 (Pre-release) TCP Streaming - Performance Issue (RTM)

  We have been testing a simple scenario with different WCF bindings to see the performance benefits. The scenario is that client makes a call to a web service with numer of customer objects to return in an array. The service simply creates as many objects as required by the client and send them to client. The customer object is a simple class with 2 public properties, firstname and last name. Each of these names is set to a distinct value in each of the customer objects before returning to client. We set maximum times for send and receive timeouts. We also made sure that there are no message size, maximum depth related problems etc. We used a System.Diagnostics.StopWatch class to measure the time from the time client initiates the reques ...Show All

• .NET Development Oracle and VB.Net

  Hello, I'm new in VB, and I'm doing my first application. I want to publish my application in a file server. The Database is an Oracle 9i, the DataBase is in a different machine than the file server, do I need to install the Oracle Client in the file sever Because, when I try to execute the application in a client machine, I got this error message: Unable to Load DLL 'OraOps9.dll' ************** Exception Text ************** System.DllNotFoundException: Unable to load DLL 'OraOps9.dll': No se puede encontrar el modulo especificado. (Exception from HRESULT: 0x8007007E) at Oracle.DataAccess.Client.OpsTrace.GetRegTraceInfo(UInt32& TrcLevel) at Oracle.DataAccess.Client.OraTrace.GetRegistryTraceInfo() at Oracle.DataAccess.Client.OracleCo ...Show All

• .NET Development insert row into table with autoincrement primary key

  I have a table in a dataset with a column being autoincrement and primary key. My question is: How do i insert rows into this table been using DataRow Row = Table.NewRow(); and then setting fields and Table.Rows.Add(Row); But if i don't set a value for the id column it won't let me insert the row. Shouldn't the id column be updated automatically It's weird because when i create the database using access i define a primary key and auto increment columns, but when i try to programmatically edit these values i must first manually define a primary key and an autoincrement column. When i defined these before i insert a row everything works fine. ...Show All

• Visual Studio Team System Filename Collision nightmare

  Here's my situation: Trunk |__ Branch A |__Branch B Branch A was baseless merged in to B Branch A was merged into trunk. Trunk was merged into B resulting in hundreds of filename collisions because the files were created from Branch A via baselss merge and then when merged in via the trunk, TFS doesn't recognize them as the same file and so now my only option when checking in the file is to undo local changes or ignore, neither of which is what I want to happen. I want the changes from the trunk to establish the merge relationship of those files that were baseless merged in from A. However, the only way I can see to do this is to undo the changes on each file force a baseless merge from trunk to B, then resolve the conflict.. ...Show All

• Visual Studio Team System Is there a way to see when and how many times a particular test was run

  Is there a way to see when and how many times a particular test was run (accross multiple builds) I know I can look into the test runs but it would be time consuming as I would have to look in all the test runs. I looked at the TFSwarehouse using excel pivot table, I think I have found the appropriate dimensions (build Type, Test, test Results) but I cannot find any measure that gives me a count. The Total Test and Failed Test dimensions return no value for any combination I try. I consulted datawarehouse structure documented on MSDN : http://msdn2.microsoft.com/en-us/library/ms244679(VS.80).aspx  but this does not document what I am seeing Thanks   hi there, have you publis ...Show All

• SQL Server Error when using a stored procedure in OLE DB source

  I am trying to use a stored procedure in the OLE DB source, I am using the SQL Command for the Data Access mode. It returns values when using the preview but when I test the package I receive the error, "A rowset based on the SQL command was not returned by the OLE DB provider." DustinT wrote: ConnectionManagerType = OLEDB Data Source = ABCSERVER;Initial Catalog=ABCDATABASE;Provider=SQLNCLI.1;OLE DB Services=-13;Integrated Security=SSPI;Auto Translate=True; DataSourceID = DelayValidation = False Description = RetainSameConnection = False SupportsDTCTransactions = True if i'm not mistaken, the sql native client provider (SQLNCLI.1) only works with sql server 2005. if you are using a di ...Show All

• Visual Studio Express Editions Platform sDK missing files ...?

  Hello, Im new to VS EE (Visual Studio Express Edition) i started to learn C++ but once i installed Platform SDK for windows server 2003 r2 i started to get the following ERROR while trying to create a Windows aplication: ------ Build started: Project: test, Configuration: Debug Win32 ------ Compiling... stdafx.cpp c:\program files\microsoft platform sdk for windows server 2003 r2\include\windows.h(157) : fatal error C1083: Cannot open include file: 'excpt.h': No such file or directory Build log was saved at "file://c:\Documents and Settings\User\Desktop\test\test\Debug\BuildLog.htm" test - 1 error(s), 0 warning(s) ========== Build: 0 succeeded, 1 failed, 0 up-to-date, 0 skipped ========== As you can ...Show All

• Visual Studio Team System Edit reports from Agile process template?

  Hi, We are running our project based on a custom process template and evertything works fine except one thing. I am not able to edit existing reports - and with existing reports I mean reports that came with the Agile process originally. I can run them and use them perfectly but when I try to open an existing reports from the report server inside Microsoft Report Builder I get the error: "Server data sources do not match RDL" Anyone who knows what i can do to fix this Kind Regards Thomas Hi Tia, You can follow the following steps in order to download an already deployed report, customizing it and re-uploading it to the server: - Browse to you reportserver at http://AppTierName/reports/Proj ...Show All

• SQL Server Locking Issue

  Hello everyone, We have an unexplainable problem concernaing locking in SQL Server 2000 sp3a. Here is what we can see using Enterprise Manager: Process ID Lock Type   Mode  Satus  Owner  Index  Resource ---------- ----------  ----- ------ ------ ------ ---------- 112        KEY         U     GRANT  Xact   idx1   (fd0066dd24ee) 112        PAG         IU    GRANT  Xact   idx1    1:215772 112        ...Show All

• Smart Device Development how to input special characters.

  Hi expert, I am using VS 2005 to develop a SMS sending application. But i am facing a problem to detect special characters such as "o, E, Σ, €, Π......" that supported by GSM standard. How can i insert this kind of characters since we are unable to input them via keyboard Thanks in advance. Thanks for replying, but can u further explain on unicode escape sequence that u have mentioned. Can you provide me a table that shows what code represent what character. Thanks in advance. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. CreateFromAxisAngle???

  I'm trying to get a sprite to rotate around a point, but it's moving in a straight line instead of an arc. My code looks something like this: Vector3 n = Vector3.Normalize(new Vector3( originX, originY, 0.0f)); Matrix rotationMatrix = Matrix.CreateFromAxisAngle(n, degrees); Vector3 rotatedPointV1 = Vector3.Transform(v1, rotationMatrix); where (originX, originY) is the point I'm rotating around and degrees is my angle of rotation. I'd like to move the sprite to rotatedPointV1. What am I doing wrong If you want to rotate a sprite around a point in the sprite's local coordinate system (for example, to get the sprite to rotate around it's center point instead of it's upper ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA sprite behavior -- weird side effect

  Hello, I'm new to XNA as well as DirectX and am experiencing some weird side effects when drawing a sprite that I can't account for. I have a 3D ship that I can fly around using the Xbox360 controller (completed the XNA tutorials 1-3) and decided to see if I could implement pausing. Well, i got everything working how I want it and even made a 2d sprite that loads a texture asset and draws it to the screen when the player pauses (just a blue rectangle with the word "Paused..." written on it). That works great too, except by drawing the sprite to the screen my 3d model suddenly becomes semi-transparent! Even when the sprite is no longer being drawn the model remains semi-transparent until I restart the game. I am developing i ...Show All

• Windows Forms Accessing objects on a form via a class

  I have a form with a text box and I need to access the textbox and some other events within the form class from a seperate class. How can I get access to that textbox The form is making a call to a method within the class class.getCommand(command); and then the getCommand method needs to be able to modify the textbox within the form. Any suggestions would be great! Thanks! Scionwest Hi, I am not really following what you are trying to achieve. When the user clicks a button you call getCommand, where does the command parameter come from Your business objects should not know about GUI classes, your getCommand method can return a string which the form can then use to change the bu ...Show All

• Visual Studio VB.net 2005 provider connection error

  I made a vb.net project on a device and it worked fine woth no errors at all but when moving the project to another PC with same software installed(vb.net2005) i get the following error message: "there was a failure while initializing the microsoft visual source safe control provider. You cannot use this provider to perform source control operations" could any one please help me on this error Do both machines have the same source control provider software installed It would appear that the project was checked into Visual SourceSafe on the first PC. Does the second PC have the necessary Visual SourceSafe client software and access to the SourceSafe database where the project was stor ...Show All