Gary Russo's Q&A profile

• SQL Server Tool from SQL 2000, Missing in SQL 2005?

  My favorite tool ever in SQL 2000 was a little utility, a front end if you will for querying the system tables. It was under the tools menu and if you typed say 'account', you could find all objects containing the name 'account'- stored procs, tables, columns, etc. A GREAT little tool that few people seemed to use. Now I have 2K5, can't remember its proper name to google it by, and can't seem to find it anywhere, though I suspect it is burried somewhere. Anyone seen this one in SQL 2K and remember its name, or better yet, seen it in 2K5 and can point me there Thanks in advance, Jeff I don't know th ...Show All

• Visual Studio Team System Report Server Windows Service login failed

  Hello all, I am trying to install TFS application tier and it keeps failing because of "cannot connect to report server database" I have dual server setup and TFS database installed fine on sql server. I tried couple of times with different accounts and it still keeps failing and saying that it cannot connect to report server database. During the installation setup I get the following error message: Error 29105. Team Foundation Report Server Configuration: The Report Server databases were not created. Common reasons for this are that the current user does not have permission to create the databases on the Tea, Foundation ...Show All

• Smart Device Development Connecting to a Web Method

    Ilya Tumanov wrote: Yes, but it makes no sense. To accomplish that you would have to purchase SQL 2000/2005 and pay CALs per device (or per CPU license). If that’s acceptable, simply get rid of Access and use much more powerful SQL you've paid for. Alternative solution is to use Web Service to talk to Access database. Create couple WEB methods to talk to access and call them from device. Something like this should do: DataSet GetAccessData(String command, …) { // Connect to Access DB here, execute command and populate data set with returned data. return dataSet ...Show All

• Windows Forms What's the story on UseCompatibleTextRendering

  So I rebuilt my app using VS2005 and it worked beautifully except for my labels being moved down a few pixels.  I came across the property UseCompatibleTextRendering and if I change it to true then my app works fine.  I can find almost no documentation on what are the impacts of changing this property.  Why is the default behaviour not compatible with previous versions of winforms and what is the difference I also read that there exists a compiler switch that allows you to change this globally, but I can find no documentation! Darrel I found this thread while I searching for a discussion of UseCompatibleTextRendering, a ...Show All

• Visual Basic Deploying by CD to Win98 with ClickOnce

  As the title says, when I run the install of the ClickOnce CD, which includes Net Framework 2.0, on a Windows 98 system, the installation fails in the Net Framework part. The only clue I can find in the log is "Process exited with a code 1603." Would Net Framework care about Unicode during its install It seems that would be more of a factor in the application. ...Show All

• Software Development for Windows Vista How to store application specific data using WF SqlTracking Services

  Hi, Can anybody tell me how to store application specific data like userId, etc., using WF SqlTracking Services If any sample available, please share with me. Thanks in advance. Chandru. Chandru - what you need to do is put a tracking profile for your workflow type into the SqlTrackingServices' table. The easiest way to do this I've found is to use the Tracking Profile Editor sample which gives you a GUI - but you can do it any way you'd like. You just have to create a TrackingProfile for that workflow type that has an DataExtract in it for the data you'd like. ...Show All

• Windows Forms How do I use PointToScreen on multiple screens - it seems to bugger up.

  I developing a .net application in VB.net 2005 (.Net Framework V2). My workstation has 2 screens and I have noticed that the return value of control:PointToScreen is unpredictable when the point to be converted is not on the primary screen. Does anyone know to deal with this condition I have already discovered the screen shared methods which allow me to identify the screen the target point is on but that does not seem to get me anywhere. Much thanks in advance if anyone can help me with this. Ted Do you have any sample code that shows this bugginess Are you using some 3rd party application that ...Show All

• Visual Basic reading bytes in reverse order

  I need to read three bytes at the following offsets: 13583, 13584, 13585. Except, I need to read them in reverse order (13585, 13584, 13583) Say the bytes in those offsets are so: 13583 = 0E 13584 = 45 13585 = 1F Now in normal reading order it would be 0E451F which would be 935199 in decimal. But, in reverse order (the order i need) it would be 1F450E or 2049294 decimal. I have no clue how I can do this. I spent about 45 minutes looking through the object editor and found nothing that would help me. Any ideas         Dim hi, mid, lo As Byte         Dim i As I ...Show All

• Visual Studio problem in opening project from VSS

  Hi guys, Iam using Visual Studio Dot net 2002 version and when Im trying to open a project from source control to my local machine its giving "The project you are attempting to open is a source controlled FrontPage Web and cannot be opened directly from source control. Please use the Open Project From Web command instead." I tried many ways but still its giving the problem. If any one got to know the solution. Do let me know. Thanks and in advance. Vijay Hi alfredo mendez, Thanks for your response. Do you mean to say should I have directory browsing facility of the virtual directory that contains the a ...Show All

• SQL Server Problem installing some components SQL 2005

  Hi, I'm having trouble installing SQL2005 completely. I get a message: " A component that you have specified in the ADD_LOCAL property is already installed. To upgrade the existing component, refer to the template.ini and set the UPGRADE property to the name of the component." It concerns "Integration services", "Notification services" and "Workstation Components, Books Online and Development Tools" What should I do Regards, Ronald Here is the complete listing of summary.txt: Microsoft SQL Server 2005 9.00.1399.06 ============================== OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600) Time : Sat Nov 12 ...Show All

• Visual Studio Sample Code: A basic WinForms app that uses ReportViewer

  using System; using System.Data; using System.Windows.Forms; using Microsoft.Reporting.WinForms; public class Demo : Form {     private DataTable LoadSalesData()     {         // Load data from XML file         DataSet dataSet = new DataSet();         dataSet.ReadXml("data.xml");         return dataSet.Tables[0];     }     public Demo()     {         this.Text = "Report Control Demo";   ...Show All

• Visual Studio Team System Web Test: error 400 Bad Request?

  I am connected through our internal network to the server hosting the webservice. If I remote into the Server and bring up web service asmx page, I have the option of entering values and invoking the specific method. I copy n' paste appropriate values in the textbox, click Invoke, and it's successful. If I use the very same data on my machine, then run the webtest, it fails with error 400 Bad Request. Are there any issues with the webtest running over a internal network Any settings I am missing Hello Yes, most asmx pages don't allow a none soap request from a remote client. Please take a look at ...Show All

• Windows Forms ToolStrip Disappears

  In Visual Studio 2005 during design time my toolstrip disappears when I click any part of the form. Selecting the control in the properties window combo brings the control back onto the screen. At run time the toolbar is no where to be seen. Can anyone help me with this thanks OK I sorted this out, It appears that some joker changed the visible property to false which gives rise to the strange design time behaviour. nice ...Show All

• Visual C# having trouble with PictureBoxes

  I am trying to make a tetris-like game. In the form, I added a panel the size of the form, inside that I added a smaller panel, for the gameboard. Within the gameboard panel I created an array of PictureBoxes to display the blocks (picBlock[1-120]). Then I simply set the image of each block to the one above it, and set the one above to null, to simulate falling. This all works as expected. I want to animate the removal of a full row, thats where the problem comes in. I've tried 2 ways to accomplish this, and they both have a different (bad) results. I created a second array of PictureBoxes, picAnim[1-10], with Visible=false until neede ...Show All

• .NET Development SslStream and SSL protocol not recognized (i think)

  i wrote this simple apps to connect to an IRC server but it doesn't work :( using System; using System.Collections.Generic; using System.Text; using System.Net; using System.IO; using System.Net.Security; using System.Net.Sockets; using System.Security.Cryptography.X509Certificates; namespace provaSSL { class Program { static void Main( string [] args) { try { string certName = "" ; TcpClient sslClient = new TcpClient (); sslClient.Connect( "irc.discostars.de" , 7000); SslStream sslStream = new SslStream (sslClient.GetStream(), false , CertificateValidationCallback); ss ...Show All