darklightred's Q&A profile

• .NET Development Failed to convert parameter value from a SqlParameter to a String.

  hi i m using a stroed procedure and my and that strod prcedure is updating 3 tables i m passing 9 parameters to that procedure. when i set all parameters in my coding work of vb.net and call executenonquery it gives me following error "Failed to convert parameter value from a SqlParameter to a String." code is as folllows...please help mee in this regard strRowCount = CInt (strRowCount) + CInt ( "1" ) cmd = dbComely.GetStoredProcCommand( "sp_UpdateAndInsertStock " ) strStockTakingId.ParameterName = "@strTakingID" strStockTakingId.SqlDbType = SqlDbType.VarChar strStockTakingId.Direction = ParameterDirection.Input strStockTakingId.Value = Me .txtStockTakingId.Tex ...Show All

• Visual Studio Team System Complications with installing TFS on untrsuted domain

  Hi, I saw the a post put up a little while ago mentioning problems with users on trusted domains. I have a question which is rather broad: We are thinking of installing TFS on a separate (untrusted) domain from which the users are on. I have seen that we will need to use the TFSecurity tool to add users to TFS. What we are looking at doing is eventually getting a CI build and automated deployment going. I was wondering if other users here had any experience/ideas of the possible complications here since we are talking on untrusted domains. Any thoughts would be much appreciated! Based on the link below it seems that such a configuration is not supported: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=436653&SiteID=1 The ...Show All

• SQL Server Install problem

  I am having a problem installing SQL express. I have 2.0 framework installed as well as the other express software. I also have Visual Studio 2003 installed. Do I need to uninstall other version of Visual Studio Do I need to uninstall other versions of SQL. I get an error but it does not tell me what the problem is. Thank you Dee this is from the core file Microsoft SQL Server 2005 Setup beginning at Wed Aug 16 18:14:14 2006 Process ID : 4668 c:\8c27e35b5d509dc8609c33e266\setup.exe Version: 2005.90.2047.0 Running: LoadResourcesAction at: 2006/7/16 18:14:13 Complete: LoadResourcesAction at: 2006/7/16 18:14:13, returned true Running: ParseBootstrapOptionsAction at: 2006/7/16 18:14:14 Loade ...Show All

• SQL Server sa real login name

  Greetings, I have a SQL Server 2000 database using Integrated Security. Users are added directly to the database from their domain name. In the Login section of the Security node in Enterprise Manager they show up as DomainName\UserName. I have four users that have the System Administrator database role. When I use the user function to get their user name they show up as dbo. Is there a way to get their actual domain user name Thanks. The builtins user & user_name() will return the DB primary identity name. You are seeing the results you described because member of the sysadmin role are always mapped to DBO on any database. You can use suser_sname() to get the login token primary identity name. For example: S ...Show All

• Windows Search Technologies WDS 3.0 Install mode and SDK

  So far I was using WDS 2.6.5. I had created VB.NET application and used SDK to get search result programatically. Can anyone answer following questions so that I can start my experiments on WDS 3.0. 1. Is there any SDK avialable for WDS 3.0 if not when can be expected if yes please send me the Link 2. Is WDS 3.0 is also getting installed in per-user basis Some body told that it will be installed in per-system basis. if so search index created by one user can be used by another user, is it right Paul, any updates on SDK for WDS 3.0 . I heard that WDS 3.0 SDK is integrated in Windows vista SDK RC1. is it true If so WDS 3.0 will work only with .NET Framework 3.0. ...Show All

• Smart Device Development resource assembly error - System_SR_ENU_wm.cab installed.

  I know this has been posted before but can anyone offer any advice on the ' An error message cannot be displayed because an optional resource assembly cannot be found' error other than installing 'System_SR_ENU_wm.cab' All advice I've seen is to install 'System_SR_ENU_wm.cab' but this is definately installed and I'm still getting the error (or rather lack of). I know the exception is a web exception but need to see the details to sort out the problem I have with my mobile application (WM5 on UK english device). The error is raised when the device calls a method on a web service. It works when the device is cradled but when not it starts the GPRS connection as it should but then errors. So I'm mainly after advice on how to get err ...Show All

• Windows Forms Textbox scrolling

  When I use textbox.appendtext(buff), buff is successfully appended to the textbox and the textbox automatically scrolls. However, there seems to be a limit... the scrolling stops (as does the data being appended) after a certain amount of data is appended. I have the maxlength set to 0 and have also tried setting it to 1,000,000. I have resorted to: textbox.text+=buff textbox.selectionstart=txtbox..text.length textbox.scrolltocaret() Unfortunately, that scrolls the text all the way to the beginning and then back to the end everytime which causes undesirable flashing. Does anyone know why the appendtext method is limited I have only encountered a limit problem when using the appendtext me ...Show All

• Visual Studio VS Popup windows.

  Is there a setting in VS that when turned on remembers the sizes and locations of popup windows I'm trying to get into using more of the point/click aspects of the IDE (QueryBuilder and such) but resizing the querybuilder window every time it opens is starting to get to me. It's not like it's even remotely functional in it's tiny default size, which is then divided into 4 parts. The query builder window is a document window and hence can't be a popup window. Can you please give us more precisions on exactly what you're trying to accomplish Thanks Patrice ...Show All

• Visual Studio 2008 (Pre-release) How To Get ParserContext?

  Currently I am writing a custom MarkupExtension, and I am running into an issue that I want to access all xml namespaces to clr namespaces mapping dictionary under ParserContext.XmlnsDictionary property, in the ProvideValue method I do something like this: ParserContext context = serviceProvider.GetService( typeof ( ParserContext )) as ParserContext ; if (context == null ) { throw new InvalidOperationException ( "ParserContext is null" ); } the code always run into an exception, so how can I reference the ParserContext within a MarkupExtension should I manually parse those mapping info myself Sheva Cool idea, by the way. In fact, I played with it a bit more to create some markup extensions for the basic collec ...Show All

• Visual Studio Team System Unable to write results of Load Test

  I am performing a simple LoadTest using Visual Studio Team Edition for Testers. The LoadTest consists of a simple test that makes one SOAP call and validates the results. I am running this with 20 threads for 5 minutes. For some reason, the test seems to take an indefinate amount of time to "Write Results to Repository..." I have waited for this to complete for about an hour on multiple configurations. I have tried multiple configurations pointing to XML, Database and None however none of these seem to work. I have set up the database according to the instructions here: http://msdn2.microsoft.com/en-us/library/ms182600(VS.80).aspx . When it tries to complete, it spikes the memory to about 600M (on a 1G box). The only way that ...Show All

• SQL Server Disconnect All Ussers But Me

  I have setup a small SSIS package that will regularly delete my log files by detaching the database, removing the file and then reattaching it. Problem I'm having is that there is almost always at least one other connection to the database and I have to kill it for this to work. Is there any TSQL command that allows me to shut down all open connections except the one the command is coming from   just to add what Umachander has already told..  read about Alter Database and Singler_User in BOL first   ALTER DATABASE SomeDatabase SET S iNGLE_USER WITH ROLLBACK IMMEDIATE ;   and ofcourse answer the abovementioned questions also...  ve ...Show All

• SQL Server Multiple services on same Queue or not ?

  Hi There I am guessing defining multiple services on the same queue is basically for providing different services to outside sources while using 1 queue, obviously as long as the contracts and activated sp logic applies to all services defined on that queue. I am defining a queue per service, is this right or wrong or irrelevant It just works better for me in terms of manageability. I just want to make sure there is no "best practice" reason for doing either or Is it just a matter of preference Any comments Thanx For almost all cases we recommend using one queue per service. Having multiple services backed by a queue is specifically for the scenario you described, i.e. having mult ...Show All

• Visual Studio Team System Migrating - TFS beta 2 to TFS: How to go about

  Hi, We have been using TFS beta 2 till now and would like to migrate to the latest TFS release. I have seen few posts in this forum saying that no official migration support is available prior to beta 3. Please suggest how should we go about upgrading from beta 2. What are the steps to follow and things to keep in mind while doing this. Any input in this regard would be a great help for us! Regards, Ajay That's correct -- there's no upgrade script to go from beta 2 to anything newer. You'll need to take the latest versions of all of the files in version control and check them into v1 server. The work item data can be exported, mostly, to Excel and imported into the v1 server. If you look th ...Show All

• Visual C# very general Deserialize performance question

  i was surprised how long it takes to Deserialize an array on bytes into an object [ok, into a graph of nested objects] "TransactionClient - 8268295 byte(s) of data deserialized in 16663.9616 ms." that's only about 500KB a second i do understand this is a very general remark but maybe somebody has some hints for me right now deserialing takes about the same amount of time as transferring over a network, that's very weird for me. here is my code: private static object DeserializeObject( byte [] dataSerialized) { object origData; DateTime startTime = DateTime .Now; using ( MemoryStream memoryStreamSerialized = new MemoryStream (dataSerialized) ) { BinaryFormatter bina ...Show All

• .NET Development The remote server returned an error: (403) Forbidden with HttpWebRequest put method

  Hi all: I have a problem to upload file to the server form win form. I am using VS2005, the server is Windows 2003. In IIS I have assign everyone full permition to that virtual directoty and also anonymous access is enabled. But I still get error as "The remote server returned an error: (403) Forbidden". However, I can download file from that directoy and I can access http://server1/webservice1/upload by IE My code is as following: Please help. HttpWebRequest req = (HttpWebRequest)WebRequest.Create " http://server1/webservice1/Service.asmx/upload "); req.Method = "PUT"; req.AllowWriteStreamBuffering = true; req.Credentials = CredentialCache.DefaultCredentials; //// Retri ...Show All