Sammy1971's Q&A profile

• SQL Server stored procedure execution problem

  hi guys I am having problems running a stored procedure where i am using two input parameters my stored procedure is as follows ALTER procedure [dbo] . [enterdhbnameDhbService] ( @dhb_service char, @dhbname char ) as SELECT dbo . DHBMappingTable . [DHB Name] , dbo . Agency . DHB_service , dbo . PurchaseUnitMappingTable . PU , SUM ( dbo . [NMDS Data for IDF Report] . [Number of caseweighted discharges] ) AS Expr1 , dbo . AdmissionMappingTable . Admission FROM dbo . DomicileCodes INNER JOIN dbo . [NMDS Data for IDF Report] ON dbo . DomicileCodes . [Domicile code] = dbo . [NMDS Data for IDF Report] . [Domicile Code] INNER JOIN dbo . PurchaseUnitMappingTable ON dbo . [NMDS ...Show All

• Visual Studio 2008 (Pre-release) HierarchicalDataTemplate and multiple ItemSources

  Hi I have a class structure conceptually similar to the following that I'd like to be able to display in a treeView using an ObjectDataProvider and HierarchicalDataTemplates public class MyContainer { private ObservableCollectionWithPropertyChanged<Person> m_Contributors = new ObservableCollectionWithPropertyChanged<Person>(); public ObservableCollectionWithPropertyChanged<Person> Contributors { get { return m_Contributors; } set { m_Contributors = value; } } private ObservableCollectionWithPropertyChanged<KeyQuestion> m_KeyQuestions = new ObservableCollectionWithPropertyChanged<KeyQuestion>(); public ObservableCollectionWithPropertyChanged<KeyQuestion> KeyQuestio ...Show All

• SQL Server run SSIS package with ODBC connection via SQL agent

  It seems there a lot of problems running SSIS packages under the sql agent. I have read the knowledgebase articles regarding permission issues etc but I still can't get my job to run. I can run any package as a job apart from a package that connects to an external database via an odbc connection. Has anyone had any luck with this and can let me in on the secret. Hi Andy, FYI: The problem was solved. What I did are list as below: A. We created a new web app pool and pointed the both web application and web service to this web app pool (which was configured not use default identity - Predefined: Network Service but use Configurable - created a new use name). B. Under SQL server , added this new use ...Show All

• SQL Server Replication

  When replication was taking place and when we tried to enter records in ERP Package i.e Navision we faced the following error. 231,”21s01”,[Microsoft][ODBC SQL Server Driver][SQL Server]Insert Error: Column name or number of supplied values does not match table definition. Can anybody help me in resolving this.Please mail to me at ranjit246@yahoo.co.in Merge replication requires every table article to contain a uniqueidentifier column with rowguid property set. If one doesn't exist, we add it. This column does have a DEFAULT constraint defined, so if you specify column list when doing your insert, this rowguid column will be transparent to your application. It's good practice to specify a column list for all inse ...Show All

• Visual C++ Convert managed type to unmanaged

  I'm using a copy of Visual Studio 2005 EE. I need to use a String^ value returned by Directory::GetDirectoryRoot() with a third-party unmanaged library that accepts char *. The compiler says that converting managed types to unmanaged type is not possible. Any suggestions would be appreciated. Couple of solutions: MSDN How to article (works in any situation): http://msdn2.microsoft.com/en-us/library/d1ae6tz5(vs.80).aspx Using PInvoke in C++ (works if the unmanaged library is in a dll): http://msdn2.microsoft.com/en-us/library/2x8kf7zx(VS.80).aspx Another solution similar to the one in the MSDN How to but shorter: using namespace System; using namespace System::Runti ...Show All

• Visual C# chellanging question regarding ports

  Dear All, When I execute command “netstat –na” I am getting following output Proto Local Address Foreign Address State TCP 0.0.0.0:135 0.0.0.0:0 LISTENING TCP 0.0.0.0:445 0.0.0.0:0 LISTENING TCP 0.0.0.0:1025 0.0.0.0:0 LISTENING TCP 192.168.1.116:1035 206.46.110.54:1863 ESTABLISHED TCP 192.168.1.116:2058 223.118.5.140:8080 ESTABLISHED TCP 192.168.1.116:2060 223.118.5.120:8080 CLOSE_WAIT How to know which Application opened which port. Thanks I wanted to read the output from "netstat -b ...Show All

• Visual Studio Express Editions Disable F1....F12 buttons in c# browser application.

  I am writting XAML web application, in which i want to capture all key events, I am able to capture all keys, but the problem is with function Keys, from F1 to F12, When i press such keys, it also takes action on browser, which i dont want,   Can any one help me for this problem. Thanks in advance. Nisarg In my code the webbrowser control name is Page1.xaml. and there is no such type of method named "WebBrowserShortcuts". I try to looking for this.page1 but i am not getting event Page1 after this.... ...Show All

• Visual Studio 2008 (Pre-release) Bottomless RichTextBox

  Anyone know how it might be possible to implement a "bottomless" (self-sizing to fit content) RichTextBox-based control. The old Win32 RichText control has the EM_REQUESTRESIZE message which one could hook, I haven't been able to figure out whether the equivalent exists in the WPF control. Thanks, Jeremy I need TextBox-style navigation and editing as well (caret, selection, etc). I don't think this is possible with FormattedText alone. ...Show All

• Internet Explorer Development Customize your settings window is blank

  Hi everyone has anyone has this problem. i was using IE 7 Beta with no problems and then was asked to upgrade when the version came out. upon updating i have the customise your settings page (http://runonce.msn.com/runonce2.aspx) coming up with a blue background and nothing else. I have done everything that microsoft sent me but no joy. It means my Homepage will not come up until this has been set. but as i can not see it i can not set it up . i can just type my website in and then it seems ok its just i can not use the homepage setting even though my home page is set as before. This is driving me to dispair and i am ready to dump the thing but then i remembered i need IE for my website and other websites to view HTML and normal view as mo ...Show All

• SQL Server SQL Server 2005 X64 Linked Server error

  We use Windows 2003 Server (64) on AMD64 and SQL Server 2005 Developer Edition x64 + SP1 P roblem: I can not execute any sql on a linked server using the native Provider (SQLCLNI) Example (create a linked server on the same machine, other database (msdb) and try to execute any simple select using OPENQUERY s p_addlinkedserver @server = 'ls' , @srvproduct = 'SQLNCLI' , @provider = 'SQLNCLI' , @provstr = 'Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=msdb;Data Source=localhost;' Select * from OPENQUERY ( ls , 'Select * from Sysobjects' ) Msg 7356, Level 16, State 1, Line 1 The OLE DB provider "SQLNCLI" for linked server "ls& ...Show All

• SQL Server Return a row with columns for each day in a date range

  Given in a record in from a Table called WorkSchedule: idWorkSchedul StartDate EndDate HoursWorked 1 1/1/2000 1/1/2006 8 I need to return for each record in the WorkSchedule Table 1/1/2000 1/2/2000 1/3/2000 1/4/2000..........1/1/2006 8 8 8 8..................8 Please help. Thank you. -Robert hi, Sql server has a limitation of 1024 columns your requirements exceeds that limitations regards joey   here's a tests script. its not finished becaused i encountered the limitation   use northwind create table dates ( dateid int identity(1,1), date1  datetime ) go decla ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Other benefits of the creator's club

  I was hoping that another benefit of the creators club would be automatic acceptance to the http://www.xbox.com/en-US/community/developer/default.htm xbox community developer program.  Is this a possibility   You can sign up for that now and its free, however they only except a small amount of people. They want quality of apps up so they are selective. To those who don’t know what the Community Developer Program is, it is a program that gives access to additional Xbox live user data, they have come up with thinks like Xbox 360 blogs and game score charts. ...Show All

• .NET Development HASHTABLE to store 2 different types in HASHTABLE collections

  I want to store each datarow in to each HashTable, how can I do that basically.>> datReader = sqlCmd.ExecuteReader(); int i = 0; System.Collections. Hashtable [] myHT = null ; while (datReader.Read()) { myHT = new System.Collections. Hashtable (); myHT .Add( "PKid" , datReader[ "SomeDataFromAColumn" ]); i+=1; } Also. Can I be able to store two diffent types (classes) into this Hashtable without GetHashCode(). like, Class1 object1 = new Class1(); Class2 object2 = new Class2(); myHT .Add( 1,object1); myHT .Add(2 ,object2); With generic Dictionary class or another generic class. Generic class is in System.Collections.Generics. For e ...Show All

• Visual C++ Replacement of CComModule in VS2005

  Hi, I'm porting one of the dll from vc6 to vc8. In doing so I have created a complete framework to create a dll and subseqently add atl objects. By default the framewaork adds the follwoing code in the main app file class MyClassModule : public CAtlDllModuleT< MyClassModule> { public : DECLARE_LIBID(LIBID_MyClassLib) DECLARE_REGISTRY_APPID_RESOURCEID(IDR_MYCLASS, "{7C00C752-3DA7-4CB9-B721-7F39F9FEDD2E}" ) }; In previos versions of ATL CComModule _Module was used which has been replaced by CAtlBaseModule. Problem: There was an extern declaration as extern CComModule _Module in stdafx.h and definition in main app file as CComModule _Module . How do I replicate the above behaviour in t ...Show All

• Visual Studio Team System Load Test Errors - 'Web Service' cannot be accessed on computer - Please.... HELP!!!!

  I'm very new to using VSTS. I've created three simple web tests. A login test and two separate search tests. I set up a load test. It runs through, but shows 3 threshold violations and 20 errors. Also, when reviewing the tests themselves, the only test being evaluated is the login test. The other two seem to be ignored. The 20 errors all show the same thing: Type Subtype Exception LoadTestCounterCategoryNotFoundException Count is 20. The message is "The performance counter category 'Web Service' cannot be accessed on computer 'DEBS' (The network path was not found) ; check that the category and computer names are correct.". I've been researching everywhere and I don't know how to approach this. ...Show All