Prabs's Q&A profile

• SQL Server High load SqlServer failes throwing error 3926 - what is that?

  It manisfests itself in our SqlClient use (i.e. .NET 2.0) on one client side only... with dozens of messages like: ASP.global_asax - System.Data.SqlClient.SqlException : Server failed to resume the transaction, desc: 3500000c5b. The transaction active in this session has been committed or aborted by another session. That poins to SQL Server error 3926. But I have NO clue how that comes. Anyone an idea The code works flawless under dozens of other systems. This looks like a exception throwed by SQL engine. Guess what - it is SQL Error 3926 indicated by SQL Server. I already found that out and I already said so. F ...Show All

• Visual Studio Team System Error during test run (during build)

  I recieved the following error and I'm not sure what to do about it. Has anyone run into this problem Run has the following issue(s): C:\Program Files\MSBuild\Microsoft\VisualStudio\v8.0\TeamBuild\Microsoft.TeamFoundation.Build.targets : warning : Cannot initialize the ASP.NET project 'http://localhost/EffortTrackingService/'. C:\Program Files\MSBuild\Microsoft\VisualStudio\v8.0\TeamBuild\Microsoft.TeamFoundation.Build.targets : warning : Exception was thrown: The web site could not be configured correctly; getting ASP.NET process information failed. Requesting 'http://localhost/EffortTrackingService/VSEnterpriseHelper.axd' returned ...Show All

• SQL Server Looping through an excel spreadsheet

  Being new to SSIS I wish to loop through a series of excel spreadsheets and within each workbook loop through each sheet. I am aware of the For Each container but how can the each sheet in the workbook be referenced Steve Thanks Jamie, my problem is for each spreadsheet I loop through how do I reference each sheet / tab within the spreadsheets returned by the For EachLoop. Thanks Steve ...Show All

• Windows Forms Developing a Keyboard component

  I've developed a little HTML keyboard for typing Greek in Unicode (<A href=http://dev.basictheology.com/greekkeyboard.aspx>http://dev.basictheology.com/greekkeyboard.aspx</a>) and I'd like convert this to a WindowForms app.  I don't really know where to start on drawing out the keyboard and creating dynamic buttons.  I understand how to code the underlying parts, but I'd appreciate so ...Show All

• Windows Forms Trouble drawing theme elements transparently

  I'm trying to draw a windows theme element (the window close button, specifically) to an image, and whenever I do, the image has ragged non-transparent bits. I got this code from a sample that didn't do this (it was all owner-drawn, mine draws to an image.) Any idea why it won't draw with full transparency Bitmap output = new Bitmap(closeButton.Width, closeButton.Height, System.Drawing.Imaging.PixelFormat.Format32bppArgb); Graphics fx = Graphics.FromImage(output);        IntPtr hTheme = OpenThemeData (Handle, "Window");           Rectangle rClose = new Rectang ...Show All

• Microsoft ISV Community Center Forums Needing extract elements XML to a listcolumn in a Get method(HttpRequest)

  And going on .. Does anyone know how to extract the elements in na XML obtained through a Get method I've been trying to use VBA Excel to connect Web Services. What have I got 'till then It brings me just an XML in a cell. I tried many ways to put this datas in a listcolumns, no success. Any help is appreciate. See my code, Dim oHttp As New WinHttpRequest Dim wks As Worksheet Dim amzURI As String Dim objSelected As Object Set wks = ActiveWorkbook.Worksheets("ConsultaTit") Application.Cursor = xlWait amzURI = "http://xml.amazon.com/onc ...Show All

• Software Development for Windows Vista TransactionService sample problem

  Hi, I am getting the following error when running TransactionalService sample: "Connection currently has transaction enlisted. Finish current transaction and retry." The error occurs in the following function internal void CreditAmountInAccount(System.Transactions. Transaction transaction, Int32 amount) { SqlCommand command = new SqlCommand (); command.CommandType = CommandType .StoredProcedure; command.CommandText = "dbo.CreditAmount" ; command.Connection = new SqlConnection (connectionStringValue); command.Connection.Open(); command.Connection.EnlistTransaction(transaction); // *** ERROR HER ...Show All

• Visual Basic HTMLDocument

  I'm having an issue parsing a string, in the line "If DocStr.Contains("<td>" & CStr(FirstCardNum) & ".</td>") Then" below, it returns zero, the issue is that I put a breakpoint there and looked at the string in QuickWatch and it was in there, i've narrowed down that its not the String.Contains function because it works elsewhere, even with identical data. That leads me to believe that it has something to do with the HTML.Document . Can anybody help Private Function GetCardList() As Boolean         Dim FirstCardNum As Integer = 1         Dim ListDoc As ...Show All

• Windows Forms letter/Mail generation application

  Hi, I want to make an application that generates a letter. I want to make the header section of the letter customizable, so that I can get the customer name, address and other information from database and add to the letter header section. Then I want to make the body of the letter from a template word file may be. and the footer of the& ...Show All

• Visual Basic How to retreive user who created a file from .NET?

  Hi, I have a VB.NET winform application which detects when a file is dropped into a shared drive, snatched up the file, parses it and does some other processing. At this point I need to grab the username of the user who created the file...... how is this possible in VB.NET I have googled and cannot find any help on this. If I am at a command prompt, I can do"dir FILENAME /q", and it will tell me the username as the third column in the result it prints...... but how do I get this programatically I suppose I could do Process.Start("dir " + filename + " /q"), and then parse the results... but is there something bet ...Show All

• SQL Server About Login Account

  Hi everyone, I have a simple question for you which is too important for me. My question is about logins in my own(local) server. I know that my local server(my computer's server) has to default login account which are called sa and BUILTIN/ADMINISTRATOR. While I am using my own server, I do not know which default login account is used by my Server since I use windows authentication while connecting to the Server. Another question is that while adding new login account for my own Server, I noticed that there is a choice which is comprised of Grant and Deny for the Security. What is the meaning and usage of this Thanks and Regards I s ...Show All

• Visual Studio Tools for Office Save a new File with a VSTO Solution

  Hi everybody, I have a problem with my VSTO solution, but it's not easy to describe it. A VSTO solution is always connect to one word file (doc or dot). New the user works with this file and makes some changes to the file and stuff. Now he want's to save the file. But I don't want him to overwrite the document he is working on. So he needs to save it as a new file. This isn't realy the problem. But when you start the new createt file it trys also to load the atached dll. But it should only be a simple word document without an actionspane or anything else. So how can I save a normal word file form a VSTO project. So when star ...Show All

• Visual C# Confusion with Clear() method of ArrayList

  Hi, Check out the following lines. ArrayList list1,list2; list1.Clear(); list1 = list2; Now, my question is, does calling the Clear() method matter here It shouldn't isn't it because in the next line we are assigning another list2 to list1 (this is by reference isn't it). So the presence or absence of Clear() method should affect list1. But that is not the case for me. If I call Clear() the contents are getting erased even after I assigned list2 to list1. What is wrong here Thank you. Hi, I didn't quite understand what is your problem. I'll give a s ...Show All

• Visual Studio object DataSources at design time

  object datasources can be attached to a SSRS report at runtime but was wondering if there was design time IDE support we would like to expose our Business objects not the database at design time I must be missing something but I can easyily use an xml file as input to  reporting Services and it will happily cosume it at design time but I can not see an easy way to do the same at DESIGN time in VS Reporting . There must be an easy way to create a DataSet from an xml file and the xml tree appear in the data source window. It is too bad that the DatasetDataSource Control was removed from the Beta as it seems to do what we want. ...Show All

• SQL Server Permissions Hierarchy - GRANT on logins/users/roles

  A question on the permissions hierarchy: Since logins, database users, and database roles are both principals and securables - what does it mean to GRANT permission on a login/user/role to another principal Does it mean that for a login - you can GRANT permission to EXECUTE AS that login or modify it, for example Thanks! ...Show All