ChrisMorley's Q&A profile

• SQL Server help on a business case related to status reporting

  Hello, I am a newbie in BI and would appreciate your help on the following case: I have a customer dimension being a slowly changing dimension and I have fact Subscriptions storing the subscriptions of customers. The customer dimension has - CustKey - CustAltKey (Being the Business Key of SCD) - CustName The subscription Fact has: - CustKey - Inception Date (linked to Time Dimension) - Expiry Date (linked to Time Di ...Show All

• .NET Development system.objectdisposedexception

  Hi, I have a multithreaded application that crashes with the following msg in event log ... EventType clr20r3, P1 smartserver2005.exe, P2 1.0.0.0, P3 43f6cc52, P4 system, P5 2.0.0.0, P6 4333ae87, P7 3ad8, P8 a5, P9 system.objectdisposedexception, P10 NIL. I have provided try catch block in all routines in the code & still the appl crashes with the above msg. Note that crash is not consistent for a particular se ...Show All

• .NET Development Access to the activated object from Main thread

  I am a Java developer switching over to C# and have run into some interesting design problems with .Net Remoting. I am hoping someone can help. When a client calls the server to get access to the remote object, server process activates an instance of the remote object (assume server acivated, singlton). The remote object is activated in the servers application domain and the client communicates with it through a proxy. All well and good. My g ...Show All

• .NET Development Where to start? confused....

  Newbie here... I have a split Access database, and want to use SQL Server for the Back-end (locally, for now), but can't get it to work. I've installed (without any problem) the June CTP SQL Server 2005 Express, along with the Express Manager.. I can get into the configuration manager fine, but don't know what to do once inside... When i start the express manager, it asks for the server name... i've tried every name i can think of, but none work ...Show All

• Windows Forms Double click on a row in datagrid, winapp .net

  I am using the Datagrid control. I am trying to capture the double click event on clicking a cell in a row of the datagrid. The double click event fires only upon clicking the row header. Double click event does not fire upon double clicking on a cell. What am i missing Need help urgently. Thanks. A few questions for you: 1. Is this DataGrid on a standard form (System.Windows.Forms.Form) 2. Have you specified a different st ...Show All

• SQL Server sysxlogins table and null names

  Hi all, running sql server 2000 sp4, viewing the sysxlogins table data, and am wondering about the three items listed with a <NULL> in the name column, all xstatus = 192, each has a unique srvid value of 0, 2 or 3. Looking in the MS tables reference book did not help they don't cover sysxlogins, googled around but no luck, searched this forum also. What are these entries Thx I only have one en ...Show All

• Visual Studio Express Editions modifying control properties !!

  when I create a simple form application project in vc++ express I have these two files created by default, form1.h & project_name.cpp now suppose i add a text box in form1 I'm not able to change the properties like text of this textbox from anywhere else other then form1.h (say if i want to change properties from this file project_name.cpp) its a very basic doubt but I've done evrything from making textbox public to anything wierd possible : ...Show All

• SQL Server Error trying to build and deploy for first time

  I'm getting a timeout error when trying to deploy my SSAS project for the first time - any suggestions on where to go from here Error 1 OLE DB error: OLE DB or ODBC error: Query timeout expired; HYT00. 0 0 Error 2 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Property Address', Name of 'Property Address' was being processed. 0 0 Error 3 Errors in the OLAP storage engine: An error occurred while ...Show All

• SQL Server Connectivity from Non Sql Servers

  How would I configure a DB2, SAP Or Teradata as source in SSIS How do you usually connect to them If you have an ODBC driver then you should be able to do it. I dare say there are issues aorund this but having never connected to these systems I can't tell you more than that. there are people on here that HAVE connected to these systems. -Jamie   ...Show All

• Visual Studio Team System Unit Testing and Threads

  Hi All: I am using MS VS2005 Team System (eval edition) I have a function which uses multiple threads to do some calculations. I wrote a unit test for the function, but when I try to run the test I get the following exception: Test method NearestNeighborsTest.NearestNeighborsTest.nearestTest threw exception: System.NotSupportedException: WaitAll for multiple handles on a STA thread is not supported.. Any thoughts on what is wrong I tried lookin ...Show All

• Visual FoxPro can i just use sql to get this?

  date           transfer 20050101    200.00 20050103   -100.00 20050530     95.30 ... SQL to get： date         transfer          balance 20050101   200.00         200.00 20050103   -100.00 &nbs ...Show All

• Windows Forms Pick List

  I have created three list boxes in which I use to drill down to a data grid.  I want to be able then to pick from an item in the data grid and put it into another data grid.  I want to then pick another item and&nb ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. D3DXAssembleShaderFromFile function question

  Hi I am looking for a discription about the shader error codes which are generated by this function: hrA = D3DXAssembleShaderFromFile( (LPCWSTR)TCFilename, NULL, NULL, 0, &pCode, &pDebug); As far as I know it is possible to get an error discription if there is any by using ( char *)pDebug->GetBufferPointer() this function. I tried to find more information about these error codes but couldnt find any in the forum a ...Show All

• Visual Basic Task Scheduler COM Object

  Hello, I need to use the Task Scheduler API in a Visual Basic .NET program I am writing and I can't find the COM Library in the Add Reference dialog. What is the Component Name of the library that houses the Task Scheduler API Thanks in Advance. I don't think there is built-in support for that in the .net framework. However, Eduardo Morcillo has made something for that: http://www.mvps.org/emorcillo/en/code/shel ...Show All

• Visual C# Sending Data

  I would like how to send files from the users computer to my server. Can someone explain to me how to do this Exactly -- what kind of environment are we working in, winform, webform, html, firewalls involved, etc I mean, a webform has the "UploadFile" control which you can drop on a webform and it'll do almost all of the heavy lifting for you -- its limited in size I believe [last time I checked] but that's the simple way. ...Show All