Ready4u's Q&A profile

• Visual C# Performance Monitor Counters and Windows Vista

  I am trying to connect to a Windows Vista machine from my Windows XP SP2 machine to read the performance counter data using C#, but I am unable to connect. Even using "perfmon" in windows won't connect, but I can connect to file shares on the Vista machine just fine. Has Vista changed something in this regard so remote computers can connect to collect performance data, or am I doing something wrong in my code or in perfmon The error I receive when I try to connect is "cannot connect to machine" - not very helpful. Thanks, Jon I have the firewall service disabled for testing, and I am still unable to connect. I have tried connecting from a Windows XP SP2 PC and a Windows Vista PC, but both of them won't connect. Does anyone have an id ...Show All

• SQL Server parameter passing with blanks - help required

  Hi, I am having a curious problem with parameter passing between reports. I have 2 reports the first report gives employee name, Department and in the second report I have employee details. If the user clicks on the Employee name in the First report it should go to the second report and display the details. My problem comes if suppose the employee name is “Don King” when the parameter gets passed it does not recognize the space between the name and throws an error saying King not recognized. Would appreciate if anybody could suggest as to how I can pass the name with spaces in the report parameters. Thanks and regards PMNJ I reiterate Brad's question. How are ...Show All

• SQL Server Setting up Query Notification and Performance issue

  We are in development stage of an application which uses Query Notification feature of SQL Server 2005. When the development started what the development team did was, they just Enabled broker on the database by SET ENABLE_Broker statement and they started using Query Notification. Now the application is in testing phase and when we test with many user, the performance is really slow. What i want to know is , when we use Query Notification what all are the setting to be done at the database level. Is this setting enough. And also how can i tune this system. any useful link is appreciated. thanks in advance Madhu     I will describe the whole scenario. (a) Application is developed in ASP .net 2.0 /C# and cache ...Show All

• Visual FoxPro Using Visual FoxPro functions

  I'm working with Visual FoxPro 6.01 odbc driver in c++, trying to use function such as "USE" or "SYS" etc... I dont understand how to use those functions should it be used as a paramter to the function s QLExecDirect or some other function Or is it a normal function and if so what .h file i should include thanks ishay USE is not a function but a command in VFP, which you may not call from an ODBC link. You may call a series of functions (but not all) via ODBC. I don't think sys() would be a supported function through ODBC and that makes sense to me. ODBC driver is also limited accessing say stored procedures. Use VFPOLEDB driver instead. Check supported/unsupported command/funct ...Show All

• SQL Server Table Usage Monitoring

  Is there a way to track tables/indexes/stored procedures that are being used I know that the Profiler can do this but I am looking for a way to query a system table to get this information. Oracle has a way to turn on/off monitorint for tables and indexes so I was wondering if this info is avaialble and if so if something needs to be done to activate the collection of the info. Thanks No, this information can only be collected by profiler or by the logic that you implemented in your stored procedure as somebody accesses them. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual C++ XP-style CPropertySheet/CPropertyPage weirdness

  XP-style property sheets/pages have a graduated tint to their background, the shading going from lighter at the top to darker at the bottom. If I have a property page more than ~600 pixels high then ~600 pixels down it the shading resets to the lightest colour (and continues in that colour to the bottom of the page). Is there a fix or workaround for this Mike Hello Re: XP-style CPropertySheet/CPropertyPage weirdness Such questions are outside the scope of this forum - for the scope of the Visual C++ General forum please look at: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=19445&SiteID=1 The more appropriate place for your question is probably the MFC ...Show All

• SQL Server An error was encountered in the transport layer

  I am fairly new to SSAS 2005. I have just created one cube. I was able to create an Excel pivot table that connected to this cube and had all the funtionality that I expected. I then published the pivot table as a web page. When I view the web page on the server where SQL 2005 is loaded the web page comes up with all of the expected functionality. But when I try to view the web page from another computer on my network I gett the error The query could not be processed: An error was encounted in the transport layer The peer prematurely closed the connection. Any suggestions on how to proceed. Even though this is a web page, the page actually contains an ActiveX pi ...Show All

• SQL Server Database Attachment Security!

  Hello I'm using sql server 2005 express edition. I had so security problems that i got helps from this forum. Now i have another one : In my system i'm using a database with sa password, it means to login and work with database structure and data user should enter sa password. But when i deAttach db and transfer it to another computer, I can easily attach db to customers sql server without knowing sa password. I want to say : Everybody can attach my db to their system without knowing sa password and without need to create user, I need security in customer side not at mine. Please help me what's wrong I know there is a solution that i don't know! Thank you for helping me. The way to avoid ...Show All

• Visual C# Changing default application

  Hello, Can anyone give me some information on how to make a program created in C# the default application for a certain file type e.g. jpeg. And how to detect if the program is being opened by double clicking a file. Thanks, Rob OK been following this and this is my code I have in Program.cs When I double click a wav file it launches the application, but it only executes the messagebox when closing the application, how can I get this code to execute on startup using System; using System.Collections.Generic; using System.Windows.Forms; using Microsoft.Win32; namespace WindowsApplication1 { static class Program { /// <summary> /// The main e ...Show All

• Smart Device Development TAPI

  Does anyone know how to access TAPI for a smartphone or CF. I want to make a program to fax something from my Q. Use Process Invocation ("P/Invoke") techniques on native API. TAPI has been described at: http://msdn2.microsoft.com/en-us/library/ms835755.aspx so, you can go from there. Be careful with Marshalling. ...Show All

• SQL Server Forien Key back to Same Table, fails.

  USE [db] GO /****** Object: Table [dbo].[TABLE] Script Date: 06/27/2006 09:30:14 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo] . [TABLE] ( [INDEXID] [int] IDENTITY ( 1 , 1 ) NOT NULL, [OWNERINDEXID] [int] NULL, [CAPTION] [varchar] ( 254 ) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, CONSTRAINT [PK_TABLE] PRIMARY KEY CLUSTERED ( [INDEXID] ASC ) WITH ( PAD_INDEX = OFF , IGNORE_DUP_KEY = OFF ) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO ALTER TABLE TABLE   ADD CONSTRAINT FK_TABLE_TABLE FOREIGN KEY (OWNERINDEXID) REFERENCES TABLE(INDEXID) GO ...Show All

• Windows Forms Add a DataGridViewComboBoxCell to the Insertion Row only

  I can add a DataGridViewComboBoxCell to a row in my DataGridView. I want this only to be added to the Insertion Row.. New Row.. Row with a star in front of it, whatever you call it. I do not want any rows above this Insertion row to display the ComboBox, but I do want the value to still be there. Any help Thanks. Hi, I'm thinking that it might be possible to change the style of the ComboBox so that the dropdown arrow doesn't show, and also make it read-only for all rows except the new row. I don't know if it'll work, but try setting those properties in the CellFormatting event of the DataGridView. You have access to the column and row indices from the arguments. Luc ...Show All

• SQL Server Replicating Schema Changes

  Hi there, I'm using Sql 2005 merge replication and I have noticed something, I'm not sure if this is true or not:... My publication is set to replicate schema changes (replicate_ddl = 1). Now, I have noticed that schema changes are only replicated if the current snapshot is valid. Is this right If so why My next question carries on from the first. If I'm about to run a TSQL script on my publisher that will add a column or two to a published table, how do I ensure my snapshot is valid inorder for the ddl changes to be replcated Should I be using: EXEC sp_mergearticlecolumn @publication = <publicationname> , @article = <article name> , @force_invalidate_snapshot = 1 , @force_reinit_subscriptio ...Show All

• .NET Development PROBLEM WITH SPECIAL CHARACTERS

  question...i have a string value in a textbox inputted by the user that contains ' character... and i think that's the reason why i am receiving an error...my procedure is like this "INSERT INTO TABLE(REMARKS) VALUES(' " & TEXTBOX1.TEXT & " ')" please tell me what to do so that my sql statement would accept strings with special characters like the word ADD'L I believe you also need to specify type and size of the parameter. Your parameter instantiation should look like (check size) Dim theParam as new SqlParameter("@param1", SqlType.VarChar, 20) theParam.Value=Me.TextBox1.Text theSQLCommand.Parameters.Add(theParam) ....... ...Show All

• Visual Studio Will be a servicepack for VSS 2005 released?

  Any planes to release a SP1 fir VSS 2005 In the beta of the SP1 the updates should be included, but I still had the old files. Andre According to http://support.microsoft.com/kb/918526/ several fixes for Visual Source Safe 2005 are included in Sp1 for VS 2005. so, this topic could be closed. ...Show All