razerredblue's Q&A profile

• Visual Studio Team System SELECT permission denied on object 'syscomments', database 'mssqlsystemresource',

  when I try to execute an schema comparision I am having this message, "Failed to retrieve schema information because of the the following error: SELECT permission denied on object 'syscomments', database 'mssqlsystemresource', schema 'sys'. why is this happening What kind of permmisions I am missing I already have permissions as dbo on master. I checked that database 'mssqlsystemresource' but it does not exists. This is caused by the fact you do not have the VIEW SERVER STATE permission. Despite the fact the SQL Server grants public access to the view syscomments in SQL Server 2005 does not mean you can read information from the meta data. Because syscomments is just a view over the new syst ...Show All

• .NET Development Adding New row to DataTable is very slow

  DataRow drNew = dsTranscript.Tables[ "TABLE1" ].NewRow(); drNew.BeginEdit(); drNew[ "col1" ] = "a"; drNew[ "col2" ] = "b"; drNew[ "col3" ] = "c"; drNew[ "col4" ] = "d"; drNew[ "col5" ] = "e"; drNew[ "col6" ] = "f"; drNew[ "col7" ] = "g"; drNew[ "col8" ] = "h"; drNew[ "col9" ] = "i"; drNew[ "col10" ] = "j"; drNew.EndEdit(); Tried both of these methods ... dsTranscript.Tables[ "TABLE1" ].BeginLoadData(); dsTranscript.Tables[" TABLE1 "].Rows.Add(drNew); and dsTranscript.Tables[ "TABLE1" ].Rows.InsertAt(drNew, dsTranscript.Tables[ "TRANSCRIPT_DATABASE_TABLE" ].Rows.Count); dsTranscript.Tables[ "TABLE1" ].EndLoadData(); The DataTable has about 15,000 rows.. but that ...Show All

• Visual Studio Team System What is the procedure for upgrading from beta 3 to rtm of tfs?

  I have beta 3 installed and I believe I now have a install disk for rtm. Do I just uninstall the beta 3 and then install the new one Or is there a more complex upgrade procedure I do not need to keep any data from my old install. See upgrade guide which you can find here and some troubleshooting info here if you need it ...Show All

• Visual Studio Tools for Office Word 2007 Content Control in a Text Box

  Has anyone tried to access Word 2007 content control while it is in a text box It seems that content controls aren't enumerated when they are in text boxes, but when I convert text box to frame everything works OK. I've tried plain and rich text content controls. Document doc = Globals.ThisAddIn.Application.ActiveDocument; foreach (Word.ContentControl myControl in doc.ContentControls) { string myStr = myControl.Tag; MessageBox.Show(myStr); } Word 2007 B2TR, VSTO 2005 SE final By "text box" I assume you mean a "drawing object". The problem with putting anything in a drawing object is that it's not really part of Word. The Drawing tools are something supplied by ...Show All

• Visual FoxPro Accessing VFP 8 through C# and ODBC

  Our company has an online product ordering program that accesses our VFP 8 accounting package through an ODBC connection on our server. Occasionally, our system error log table will trap the following error: "ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]This file is incompatible with the current version of Visual FoxPro. Run 30UPDATE.PRG to update the file to the current version. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr)." All the offending lines are doing are forming a SELECT statement: OdbcConnection ODBCConn = null ; O ...Show All

• Software Development for Windows Vista Workflow sample "NumberGeneratingWorkflow"

  Hi, The workflow sample named "NumberGeneratingWorkflow" that Mike Tautly have used in Nuggets - Workflow Persistence....do anyone have it to mail me it or do you you know where can i download it Thanks Filipe Hi, Sorry for the slow response - I posted the sample that you're looking for to; http://mtaulty.com/downloads/NumberGeneratingWorkflow.zip NB: I'm in the middle of upgrading to RC1 so haven't had a chance to check this as to whether it still works or not. Thanks, Mike [MSFT] ...Show All

• Smart Device Development Compact Framework - Function Keys

  I am trying to create an Application for Pocket PC 5.0. (Windows Mobile 5.0). My application relies on Function Keys (F1, F2 ... F10). These functions are preassigned to set functions in Windows Mobile 5.0 (E.g. F6 - Volume UP, F7 - Volume Down, etc.) So when the user presses these keys the form which i have created does not get KeyDown Event. I am able to access F3, F4, F5, F8, F9, F10. All other keys F1, F2, F6, F7, F11, F12 are not resulting in the event. I was wondering if there is a solution for this problem Thanks for your time. Parsh Sorry, but this is off-topic for the Device Emulator General forum. I recommend posting to the microsoft.public.pocketpc.developer newsgroup instead. Barry ...Show All

• .NET Development OleDbDataAdapter.UpdateCommand without CommandBuilder

  Hello, I just tried to create a UpdateCommand for a table that has no primary key by myself. This is not as easy as it sounds, because I only know the name of one column that is used to identify the rows that have to be updated. All other columns (the columns that might have been changed) can be very different in name and number from case to case. Here my unfinished code: dataAdapter.UpdateCommand = new OleDbCommand( "UPDATE tMyTable SET ", connection); foreach (DataColumn column in m_tMyTable.Columns) { // dont update Nr-column because its used to identify the rows if( column.ColumnName == "Nr" ) continue; dataAdapter.UpdateCommand.CommandText += column.ColumnName + "= "; dataAdapter.Upd ...Show All

• SQL Server Database logon info to reporting services at runtime

  In our asp.net application I want to Incorporate SQL Server Reporting Services. In that I should be able to switch database info at runtime. how to pass Database logon info to reporting services at runtime in VB.NET. To understand it better we have this function for crystal where we can pass the database connection info at runtime, please find the attached text file. We would like to achieve some thing like that in reporting services. code used in crystal: Private Function SetReportConnection(ByRef aReport As CrystalDecisions.CrystalReports.Engine.ReportDocument, ByVal server$, ByVal database$, ByVal ID$, ByVal password$) As CrystalDecisions.Shared.TableLogOnInfo         Dim logonInfo ...Show All

• Windows Live Developer Forums Use local.live.com

  Hi, Is it possible to use local.live.com in its entirety on my own site and add my own custom stuff to it We want almost all the functionality that local.live.com (Print, DD, etc.) and add some custom stuff to it. Is that viable If yes, how If no, what are my other options Thanks, Sanjeev It is quite possible, but you cannot just copy the script from the WLL interface. The new SDK has new and better features like driving directions, but you have to implement the rest yourself. It is possible. For example, see what the guys at FreshLogicStudios did: atlas.freshlogicstudios.com They have made something like the WLL interface but more custom and they added more features! I have to ...Show All

• Windows Forms Is it just me :o(

  Hi, I have been trying to find an answer, even a hint, but despite posting the following question on various forums i haven't even had a single reply for nearly two weeks :o(. "Why do treeview tooltips flash if the main form has its transparencykey set " Could a couple of people please try this (its a 67 second job) just so i know it isn't just my PC :o) You can replicate this behaviour really easily by (c# VS2003) 1) creating a new c# windows application 2) set Form1.TransparencyKey to the same as Form1.BackColor 3) Add a treeview to the form 4) Add a node to TreeView1 whose text is too long to display (i used 'whyisthishappeningwhyisthishappeningwhyisthishappeningwhywhywhy') 5) run the application and hover your ...Show All

• SQL Server Error -133 on installing Service Pack 4 for SQL7

  Hallo, my problem is to upgrade instance of SQL7 to SQL7 SP4. Server is WIN2K SP4 + MDAC 2.8 SP1 Installing the SQL7 Server from CD is OK. When i try to apply the SQL7 SP4 the first fase, when SP4 checks all conditions to start is OK, when start to copy file i receive an error -113 like this -------------------------------------------------------------- Error occurred during the move data process: -113 Component Server: base server \ base server files File Group: Base Server Files File: C:\70SP4\X86\Setup.....\SQLIMAGE.DLL -------------------------------------------------------------- On server is installed the library SQLDMO.DLL for SQL2000 but only the library used by an application VB6. In need to in ...Show All

• .NET Development need help in updating records SQLException (.net1.1)

  can anyone plz solve this probelm I'm getting this sqlexception at the point where I've written this in comments. I just dont understand. I'm giving this value in the parameters as u can see, its getting the rt value as well. plz help me out with this... thanks /* system.data.sqlclient.sqlException: procedure BillUpdateCommand expects parametre "@Original_BookNo" which was not * supplied. * bla bla blah *line 995 t CREATE PROCEDURE dbo.BankUpdateCommand ( @BankName varchar(50), @Original_BankID numeric, @Original_BankName varchar(50), @BankID numeric ) AS SET NOCOUNT OFF; UPDATE Bank SET BankName = @BankName WHERE (BankID = @Original_BankID) AND (BankName = @Original_BankName); SELECT BankID, BankName FROM B ...Show All

• Windows Forms Catch a click outside the form

  The form has no focus (in fact it doesn't get focus). The form has to know if a click happens outside the form. I'm developing a drop-down/pull-down button with a custom dialog-box as the drop object. I got all things figured out except for this one. Maybe you can investigate the Hooking of mouse messages. But it may not work if the messages are not sent to your app, that is, if you form can not get messages because of no focus, I'm not sure how to work out it. ...Show All

• Internet Explorer Development Just got ie7 and ...

  I put off getting ie7 forever... got bored the other day so I downloaded it. I'm getting used to it, but I cannot figure out how to save web pages to the desktop. I saw another thread about icons, I had a similar issue, but saw nothing on this. Anyone Thanks. You should be able to click on Page (in the upper right hand corner ) then Save As... Also, if you press ALT, it brings up the menus so you can go to File->Save As... there as well. Not sure about the icons, can you explain what problem you are having -Reza ...Show All