Bluehunter's Q&A profile

• SQL Server Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

  I am receiving the following message when connecting via query analzyer to SQL server using windows authentication.(error 18452). I have a login created with the sys admin server role on the server. When I connect using SQL authentication it works. I added myself to the local admin group on the server, this allows it to work. The same situation is seen with another user. I am using windows 2000 sp4 server and SQL 2000 SP3, connecting from NT4. I get the same issue if I use TCP or named pipes. We have been using SQL security but are moving to windows authentication - but this issue is stopping us. I have checked and upgraded my version of MDAC to match the server version 2.7 (sp1) Any help would be much appreciated. Thanks ...Show All

• Visual Studio Express Editions newbie,update splitcontaner back color and save new color

  I have 2 forms. form1 is the main form and options form is the second form. i have a splitcontainer on form1 with a menu strip that opens options form. i have a usercontrol on each of the splitcontainer panels. i have a button on the options form to open a colordialog. what i would like to do is ,after pressing the ok button on the color dialog,the back color of usercontrol1 of the splitcontainer on form1 would update and save. after i close and reopen the aplication the last color that i picked would be active. please see code below it's not working. it gets as far as opening the color dialog. after i press ok once it does nothing if i press it again it errors out. Thanks public Class optionsform Pr ...Show All

• SQL Server How to Email to Microsoft?

  I find a bug in Reporting Services ,How to Email to Microsoft http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=604575&SiteID=1&mode=1 To submit bugs, you can contact Microsoft Connect, at https://connect.microsoft.com/SQLServer . ...Show All

• SQL Server Data Conversion Error on Excel Destination

  I am inserting rows using OLEDBDestination and want to redirect all error rows to EXCEL Destination. I have used Data Conversion Transformation to Convert all strings to Unicode string fields before sending it to Excel Destination. But its gives the following error. [Data Conversion [16]] Error: Data conversion failed while converting column 'A' (53) to column "Copy of A" (95). The conversion returned status value 8 and status text "DBSTATUS_UNAVAILABLE". [Data Conversion [16]] Error: The "output column "Copy of A" (95)" failed because error code 0xC020908E occurred, and the error row disposition on "output column "Copy of A" (95)" specifies failure on error. An error ...Show All

• Smart Device Development Mapi Message Date and Time

  Using mapi for window mobile 5.0, how do i obtain the display date and time of a message, preferably in cstring format Thanks You will likely find better support for MAPI on one of the Windows Mobile forums. Windows Mobile API : microsoft.public.pocketpc.developer microsoft.public.smartphone.developer Windows CE API : microsoft.public.windowsce.embedded General programming (not VisualStudio related) : microsoft.public.windowsce.app.development Native compilers : microsoft.public.windowsce.embedded.vc ActiveSync : microsoft.public.pocketpc.activesync ...Show All

• Visual Basic Common VB functions & Types 'not defined/declared' in new VS2005 install

  I recently upgraded to VS2005. The installation seems to have gone smoothly, but new and old projects opened under the new install report errors of "Name 'Mid' is not declared." and "Type 'ListControl' is not defined.", etc for common vb functions and ASP.net control types. Does anyone have any Idea what will cause this and what the fix would be The object browser shows the VisualBasic.dll's as present... Assembly Microsoft.VisualBasic C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Microsoft.VisualBasic.dll Thanks for the help. MLG There are breaking changes between VB6 and VB 2005. You should be able to find most of the functions like Mid in the Microsoft.Vis ...Show All

• Visual Studio Team System ... The may be a duplicate live [Domain]\[Account] in the constants table ...

  I saw one other posting for this error ... has anyone got a fix We have a new TFS install w/SP1 and this just started occuring after a few weeks of use. From a desktop computer with valid credentials ... it occurs upon trying to export/import a work item template via Process Editor or WIT*. It also occurs when we try to connect to MS Excel or MS Project. We have'nt altered any templates yet, but we'd like to. If you are on the TFS server (remote desktop) it works fine with the same credentials. If you attach with a desktop outside the domain it prompts you for valid ceredentials and works just fine. So I have a workaround to export all the data/templates. I did do a query against the constants table for duplicates on the Domain ...Show All

• Visual Studio Tools for Office Strange behavior: RichTextBox

  Hi, I am creating a .doc with VSTO2005. My document contains several Controls such as Buttons, RichTextBoxes, ComboBoxes, etc. which are generated at runtime. In some cases, I encounter the problem that a RichTextBox doesn't display the content (text) it should, but only displays a big red cross like this: \   /   \ /   \ When I click into the RichTextBox field (with the red cross in it), the following, weird message appears: “Windows Forms controls have been disabled because the document has been scaled. When zoom is returned to 100%, controls will reactivate.” But actually the zoom of the document hasn’t changed at all! Has anyone already encountered this problem Thanks fo ...Show All

• SQL Server Search Stored Proc

  Does anyone know a way to seach through all databases on a SQL 2000 server looking for a particular stored proc by name Yes, please don't use undocumented stored procedures. You assume the risk of breaking your code or modifying behavior due to either changes made to the stored procedures or removal of such SPs. We have done such changes in SQL Server 2005 to some undocumented SPs that affected users. For this problem, you shouldn't rely on the database metadata for tracking your schema objects. You should use a source code control system with appropriate versioning to figure out which databases have what version of the schema, objects and so on. This is the best and safe method. ...Show All

• Visual C# Returntype of Methods

  Hallo, May be it sounds like little over ambitious. Still i want to clear my doubt. Is it possible to determine the returntype of a method at runtime regards swingme Returning an Object as nobugz suggests is a workable solution, although it involves "turning off" many features that C# provides for you. IF you could provided a more specific example of what you want to do, we could provide a more appropriate response. ...Show All

• .NET Development Garbage Collector disposes wrong object?

  Application had been running for months without changes and without errors. Shortly after installing the June 2006 Microsoft patch, began receiving reports that application would display the message "Failed to load resource from resource file" and crash. Since then, I have been able to replicate the errors on 6 separate, differently configured systems. CONFIGURATION: Pentium III 800 MHz, 128 MB RAM, Windows 2000 SP4, .NET 1.4322 Pentium III 800 MHz, 256 MB RAM, Windows 2000 SP4, .NET 1.4322, Visual Studio 2003 Pentium III 700 MHz, 512 MB RAM, Windows 2000 SP4, .NET 1.4322 Pentium 4M 1.6 GHz, 1.0 GB RAM, Windows XP Pro SP2, .NET 1.4322, Office 2003 Pentium 4M 1.7 GHz, 1.0 GB RAM, Windows XP Pro SP2, .NET 1.4322, Office 2003 ...Show All

• SQL Server Converting Data Types

  I have a table with a field of Char(10) Data type this field contains records of work time Attendance in a decimal format Ex. I attend today for 8.30 this means eighthours and thirty mintutes the main problem faced me to make some calculations on those records (sum, subtract, etc) so I want to convert the data from char type to decimal or real using the next code but it doesn't work select (cast (satreg, decimal) + cast (satot, decimal)) from timecard can u please help me in the main issue how to sum char type records or at least how to convert them to decimal Regards this can help: it breaks your 8.30 to 8 and 30 SELECT substring ( test , 0 , ( patindex ( '%.%' , test ))), substring ( te ...Show All

• Commerce Server Error in Refresh Site Cache

  Hi, I have a problem whem I want to refresh a Site Cache from one of the business applications. The error I get is: System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.InvalidOperationException: There was an error generating the XML document. ---> System.InvalidOperationException: Instance validation error: '0' is not a valid value for System.Net.HttpStatusCode. Whats there the problem I've read that tehere was a Hotfix (http://support.microsoft.com/default.aspx/kb/922068) but i cantot download this Hotfix. When I open this link: SiteCacheRefresh.axd CacheToRefresh=CatalogCache for example, I get the problem that It d ...Show All

• SQL Server DB index performance

  I'm not an index expert, but I think I need help from one. I have a table with 4.9 million rows. Its PK is a composite key on 2 unique FLOAT columns. The floats are actually long ints; there are no decimals. The 2 fields are a LOW and a HIGH, and together they define a unique numeric range. Given a number input, I need to retrieve THE row where the input number falls within that row's LOW & HIGH range. Here's essentially what I'm doing: SELECT * FROM theTable WHERE @inputNumber BETWEEN RangeLow AND RangeHigh My question is on the best way to do the indexes -- right now I'm getting results, but the query takes a good 15 seconds. Isn't there a way to make such a search faster, even though there are tons of rows ...Show All

• Visual Basic visual studio 2005 is running slowly

  I am developing a windows application(converting vba to vb.net). some of the forms have ten or more tab controls. Each tab control has many text boxes,listboxes,radio buttons. when i change a name of the control it takes 30s ---2min. when i copy and paste some control from one form to another it takes 1--5minutes. this does not happen all the time. any solution/advice would be appreciated. navigationbar is disabled/wordwrap is disabled ms vs 2005 ver 2.0.50727 os-windows xp sp2 cpu-p4-3000mhz ram-2g machine-hp That doesnt sound very right.. As i recall, there were almost no delay when changing a name of a control in vb 6. Of course im no expert developer, but the studio must be ...Show All