Toni Chaffin's Q&A profile

• Visual Studio How do you Edit text while parsing?

  Hi. I'm working on a custom language-editor by extending the LanguageService-class in the MPF. I'm currently trying to edit the text while parsing. As an example, I want to add a closing brace if one is not present while trying to match bracers: public override AuthoringScope ParseSource( ParseRequest req) { if (req.Sink.Reason == ParseReason .HighlightBraces) { m_parser.setup(req); m_parser.parse(); if (m_parser.noMatchingBracerFound) { if (m_parser.triggeringChar = '"' ) { //add a closing doublequote in front of the one that triggered the bracemathcing //highlight new matching doublequotes } //.... } //highlight bracers } //.... I ...Show All

• SQL Server Oracle 9i -> SQL Server 2005: Violation of PRIMARY KEY constraint

  Hi there, When the distribution agent runs trying to apply the snapshot at the subscriber I get the following error message Message 2006-06-24 12:41:59.216 Category:NULL Source: Microsoft SQL Native Client Number: Message: Batch send failed 2006-06-24 12:41:59.216 Category:NULL Source: Microsoft SQL Native Client Number: 2627 Message: Violation of PRIMARY KEY constraint 'MSHREPL_1_PK'. Cannot insert duplicate key in object 'dbo.ITEMTRANSLATION'. 2006-06-24 12:41:59.216 Category:NULL Source: Number: 20253 What could possibly cause this error And how can I possibly fix it Best regards, JB i have the same problem with with Oracle 10g -> SQL Server 2005 (see Link ). I use replication (merge ...Show All

• Windows Forms Datagrid Paging

  Hi all, I had a problem with DataGrid Paging. My asp page can only show the first page of data of 20 records as I set the Page size to 20. When I click on next page, there will be no data even though the total number of records is more than 20. Please help. Thanks ...Show All

• Visual Studio Team System Numerous errors in the Application Event Log when TFS host is rebooted

  I'm not sure that there's anything "wrong" here, but it seems worth asking about - I noticed in the event log for my TFS host that quite a number of errors and warnings were logged within the first 15-20 seconds of operation following a reboot. Subsequent to that, everything's working just fine. Off hand, it looks like most of the issues stem from Tfs services spinning up and attempting to (directly or indirectly) use SQL Server before it's ready to accept connections, but that's really just a guess, not the result of any detailed analysis. Of course, in the long run, I'd like to see a reboot that doesn't log bogus exceptions from services stumbling over each other at startup, but for 1.0, is this expected/typical behavior ...Show All

• SQL Server Way to manually create Aggregation?

  Hi all! I am Looking for a way to manualy create an aggregation in SSAS2005 (like the "Partition Aggregation Utiliy" in SSAS2000) By the way - I cannot find a representation of the aggregations in the cube XML in BI Development Studio - is this possible Thanks HANNES Hi, Thanks, I have found the aggregations in BI project. On the other hand - sorry, but I am not a member of SQL PASS! Do you know a website where such information is available public THANKS, HANNES ...Show All

• Windows Forms How can I AUTO-HIDE a toolbar?

  How can I AUTO-HIDE a toolbar for a program like Internet Explorer (like the favorites menu Thanks, I suppose you need additional controls as these here: http://divil.co.uk/net/controls/sandbar/ http://www.telerik.com/ http://www.infragistics.com/ hope this helps ...Show All

• SQL Server DBCC CHECKDB error

  I am recieving the following error when I run the command DBCC CHECKDB WITH NO_INFOMSGS Msg 64, Level 20, State 0, Line 0 A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) This does not seem like an error related to sql server. Does anybody know how to fix it so I can run the DBCC CHECKDB command Hi Gess, This is prorbably network/tcpip issue. Get your networking guys to put a network trace to see if any packets are being dropped or if there any other problems on the network. Is your server running Windows 2000 cheers Jag ...Show All

• SQL Server Unistall unsuccessful and can not see Microsoft SQL Server 2005 in installed programs list

  I went through the install of the MS SQL Server 2005 Std Edt only to find that I can not open up the "SQL Server Business Intelligence Development Studio" since I was missing the exe to run it that should have been located at "C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\devenv.exe".  Due to this happening it seemed to me that some of the install failed, so I went about trying to uninstall the SQL Server setup.  Within the "Add or Remove Programs" tool I selected the "Microsoft SQL Server 2005" from the list and clicked on the button that said "Remove".  This did not seem to do anything except for remove the "Microsoft SQL Server 2005" selection from that tool selection list.  It went way to quick an ...Show All

• Smart Device Development WebException: "Could not establish connection to network."

  Hi, My Windows Mobile 5.0 smartphone app throw this exception "Could not establish connection to network." when it try to talk to another local http server on my laptop. I have spent many hours going through online help to find a solution for this problem without success. I have installed the loopback adaptor as suggested and also configured the smartphone emulator through vs 2005 Tools->Options->Devices ... to select the NE2000 loopback adaptor. I have also tries configuring the loopback adaptor for static ip as well as dynamically assigned by server without success. I also have vs.2003 installed on the same laptop. There used to be a beta 2 version of vs2005 which was uninstalled and now I have a official release ve ...Show All

• Windows Search Technologies WDS 3.0 and MS Outlook

  I just reinstalled my computer and unfortunatly before i installed WDS i didn't install MS Outlook and now i don't have that need "search toolbar" up there with my other toolbars. Now i was wondering if it is possible to have that done manualy Please help if you can! Are you running Outlook 2003 w/ Live Toolbar installed If you do, click on Toolbar's options from your IE and go to Install button. ...Show All

• SQL Server Sql 2k5 INSTALLED ON THE SERVER

  Hi All, My program is written in VB.NET and the DB is SQL 2005 Ex Ed. I have installed both, the SQL SERVER 2005 and my program on the SERVER. But when I try to run my program I get the following error mssg: The application attempted to perform an operation not allowed by the security policy. The operation required the SecurityExceptio. To grant this application the required permission please contact your Systems administrator, or use the Microsoft .Net security policy administration tool. If you click continue...... Request for the permission of type System.Data.SqlClient.SqlClientPermission. System Data, Version = 1.0.5000.0 = neutral. PublicKey Token = b77a5c561934e089 failed. My Systems administrator says I have got full control of the ...Show All

• Visual Basic Limits on Memory Use?

  Hi all, I was testing the VB2005 Express and decided to create a large array in the IDE. My 32bit XP Pro machine has 3.5GB available and I thought I'd check to see how much I could use with VB. I understand that there is a 2GB process limit, but I thought I just check that out. My code: Class Form1 Private Sub CreateArrayToolStripMenuItem_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CreateDataTableToolStripMenuItem.Click Dim bigarray(1000000, 250) As Single End Sub Private Sub ExitToolStripMenuItem_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ExitToolStripMenuItem.Click End End Sub Private Sub Form1_L ...Show All

• SQL Server Is this SQL requirement possible?

  I need a script that enumerates the the databases in a given instance of sql server. Then it needs to output the account with permissions on that server. Finally it then needs to search stored procedured for reference to specific file and account names loaded from a csv file. The results should be output to a text file or displayed in an exportable window format. Thanks a lot Yes I agree this... So tried to change the logic with following query... Create Table #ServerLoginDetails ( DataBaseName Varchar(1000) ,LoginName Varchar(1000) ,MemberOf Varchar(1000) ) Go Declare @DB Table (Query varchar(8000)); Declare @Query as Varchar(5000); Declare @Count as int; Select @Query = 'Insert Into #ServerLoginDetails Select '' '',U ...Show All

• SQL Server query cube using MDX in excel 2003

  hi all, i'm wondering if i can use MDX statement to query cube in excel 2003 or excel 2007 like editing the query using T-sql or by using VBA.. i've been searching online and kinda blur if this can be done. i've read somewhere that says we can write DMX statement, but not MDX statement in vba... can someone point to a resource that can get me started thanks a lot! ...Show All

• Windows Forms Best Approach to Preventing Windows from dragging underneath an Always on Top, TopMost Window

  If you've downloaded the Google Sidebar then you will notice that windows can be dragged beyond the Sidebar or place partically underneath it. I have a bar as well and could not find any way to prevent other windows from dragging into the windows area. I've looked into trying to find a way to create a second monitor that is a virtual and visible one that can attach to the primary desktop and lock itself in place and then all other windows go to in the primary which has to be resized to fit the rest of the screen after the virtual monitor and communicate messages. Everything I've find says it's not possible, but Linux has a feature were you can section the desktop into multiple dektops and run applications in seperate desktops as u ...Show All