JDCAMP's Q&A profile

• SQL Server Server Time Fact Table Join

  Hi, I've created a server time dimension and am trying to get it to deploy with a granularity of "date" and related to a datetime field in my fact table. It complains like so: Warning 1 Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_fact_ALI, Column: bid_date, Value: 7/1/2006. Warning 2 Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: Date of Dimension: Dim Time from Database: ALI DM 3, Cube: ALI DM 3, Measure Group: Fact ALI, Partition: Fact ALI, Record: 1. I'm assuming that this has to do with a datetime field having the time component ( ), but I'm not sure what to do about it. This is th ...Show All

• Visual Basic Multi Text Boxes Validation and error provider

  Dear all, I don't know what is the problem with following code I'm using for validation. can any one solve this please It works for txtProdName only. Private Sub txtProdName_Validated( ByVal sender As Object , ByVal e As System.EventArgs) Handles _ txtProdName.Validated,txtPrice.Validated,txtSize.Validated If txtProdName.Text.Length = 0 Then erpProductDataForm.SetError(txtProdName, "Required Field") ElseIf txtProdName.Text.Length > 0 Then erpProductDataForm.SetError(txtProdName, "") ElseIf txtPrice.Text.Length = 0 Then erpProductDataForm.SetError(txtPrice, "RequiredField") ElseIf txtPrice.Text.Length > 0 Then erpProductDataForm.SetErro ...Show All

• Visual Studio Team System TF30162: Fails portal creation when creating Team Project

  Attempting to create a new Team Project gives the following error. We're using the release version of TFS and MSF for Agile template. Following the instructions in another thread: https://forums.microsoft.com/MSDN/ShowPost.aspx PostID=150809&SiteID=1&mode=1 I think I've been able to find the issue. When I try to add a top level site to the "Default Web Site", I get an error that says: "The virtual server that is referenced here is not in the config database." Anyone have an idea what I'm missing here I do find the server in the STS_CONFIG_TFS database in Servers and VirtualServers. 2007-02-19 08:32:58Z | Module: Internal | Team Foundation Server proxy retrieved | Completion time: 0 seconds 2007-02-19 08:32:59 ...Show All

• Software Development for Windows Vista passing parameters to a xoml workflow

    I've been toying with xoml files for a while and I like that they're serializable so that I can decouple quite a bit. I have one issue though,... I don't know how to pass that dictionary of string object to a xoml file. When I do it complains about not having the specified property, which is true since I don't know how to add it to the xoml in xoml-speak. How can I define a Property of a certain type in xoml Also, is it possible to call an external method from within a custom activity without having to create a callexternalactivity and invoking it Thanks You generally do not define the property in xaml (although that is possible if you are going to compile xaml). The general way to do this is to define a new ...Show All

• Windows Forms Sample Code: DataGridView progress bar column

  I have a column that has integer data in it, I want to display it as a progress bar in the column so the user can quickly identify lagging processes.   I just started with 2005 and it looks great but does anyone know a quick way to do this I would also like to change the color of the progress bar based on the cells value. I found in the data sources toolbox where I can change the column to progress bar but that does not pass through to the grid.   Thanks for ANY help with this Hi Mark, I know that source code is provided "as-is", but do you have any input for me on the C++/CLR version I translated If you could just point me in the right direction I would be gratefull. ...Show All

• Visual C# Exposing soap functionality to c++ using c# via com...

  I have some legacy apps in c++ that need to make soap calls. Finding info on the best way to go about doing this is really tough. Moving the vc6 c++ code into VS2005 was not a big deal... but adding the web reference to the project just did not fly. The service I am trying to hit is an https... which seems to not be do-able as far a sproxy is concerned. After some examination I come to find out adding the web reference in C# seems to work fine. The proxy generation engine for the c# side clearly works better and there is the implcation it can handle and https call. ( not confirmed ) So I figure... ok... just make a com object in C# and call it from c++... however the learning curve on this little task is a bit steep... ( an un ...Show All

• SQL Server Newbie: How to fires a WMI event alert?

  hi everyone, I've made a WMI event alert with this query: SELECT * FROM DDL_DATABASE_LEVEL_EVENTS WHERE DatabaseName = 'AdventureWorks' In Response tab I've defined my email as destination. Thanks a lot for any link or thought about this, ...Show All

• Windows Forms Autocomplete

  I have this function, i try to have an autocomplete function, where when the user types a number it will go to the database and pulls the right Login. I am new and first of all get an overload on the SQL statement. Thank you in advance for your help Al private string GetOptions(string match) { this._retStr = ""; string strConnection; strConnection = "Data Source=source;Initial Catalog=APR;User ID=test;Password=test"; SqlConnection sqlConn = new SqlConnection(); SqlDataReader sqlDr = null; try { SqlCommand sSql = new SqlCommand("SELECT userLogin FROM Admin WHERE userLogin = '", match, ";", sqlConn); sSql.Open(); sqlDr = sSql.ExecuteReader(); } ...Show All

• SQL Server A WTF moment with SSRS....

  ...no, 'WTF' does not stand for 'Windows Transaction Framework,' LOL. I am writing to complain about what I believe is the annoying behavior of SSRS 2005 SP1. Specifically, I am trying to invoke a very simple MS SQL Server 2005 stored procedure as the data source of a report. This stored proc has an input parameter of type bit . The corresponding report parameter is type Boolean . When prompted for an input value when running the report, I enter a 0 or a 1. Much to my dismay, the SSRS IDE raises an error along the lines of '...error encountered when converting string value to Boolean.' For sake of argument, let's say that my stored proc's parameter were of the int type. I would then be prompted for a whole number parameter value, which I w ...Show All

• Visual C# How to convert string in ABCD format in to Unique integer

  hi Is there any way to convert string in this format ABCD into a unique integer like 1234 Example: GWRS = 5232 SRWG = 7845 WTMS = 15 YOMS = 142 int X = ConvertMyString("GWRS"); private int ConvertMyString(string sTring) { } and so on ...... Thanks ... I don't care about getting large numbers. But there is an error in your code Error 1 'System.BitConverter' is a 'type' but is used like a 'variable' ...Show All

• SQL Server SSIS and multi-Instance

  I have figured out that SSIS installs once for as many instances of SQL Server 2005 as there are on the machine. I also figured out that even if there is only a named instance on the machine, it will always install under the "Default" machine named instance. I also figured out that you can change the instance viewed by modifying C:\Program Files\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvr.ini.xml What I am unclear about is that in SQL Server 2000, each Instance had an MSDB db which stored all of the jobs. In SQL Server 2005, each instance still has an MSDB DB but theSSIS also has a MSDB DB or is this pointing to the MSDB for the instance specified in the xml file There is not much info out on this at all and would be ...Show All

• Visual C++ 'Parameter #2": Pointers cannot reference marshaled structures, Use ByRef instead - Help!!

  I am using a third party API and I need to register a callback function that is embedded in an unmanaged structure. The callback function looks like this: typedef int(__stdcall *EventDetectedFunction) (long callback_parameter, const char* eventXML); The structure looks like this: struct Callbacks { EventDetectedFunction EventDetected_; long callback_parameter_; }; And the DLL function that sends the callback structure looks like this: int SetCallbacks( Hwnd handle, Callbacks* pCallbacks ); I am attempting to use this API in a windows form so that I can ultimately get the eventXML to display in a textbox. I can’t find an interop example that ...Show All

• Windows Forms Forms inheritance CreateInstanceImpl

  I have some chain of inheritance forms (one form inherited from other) and I have change their constructors to have parameters and I got the following error in the design view while the project compiled. I have found out that all forms should have a default (parameter less constructor) and that fixes the problem. Does any body know how to handle this problem without changing the constructor My ancestor form holds some objects that all other forms uses. For that inheritance was made isn’t it at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes) at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, B ...Show All

• Visual Studio Tools for Office Setting the default tab in Word?

  Hi there I've created a custom ribbon tab in Word 2007 - is there any way I can make this custom tab the default tab at startup Thanks Ken Hi Ken Unfortunately, the Ribbon model doesn't expose any way to set the default tab or, indeed, activate any particular tab. Closest you can get is to assign a keyboard shortcut, then use something like "SendKeys" to emulate a user's keypress. But the approach is definitely not 100% reliable, as your chosen key combination could conflict with something else... ...Show All

• SQL Server SMO in VBScript

  I've been building some applets in VB.Net and wanted to try and do some similar things in VBScript. (I like to have a collection of scripts to do repetitive tasks.) Anyway, I'm getting an error when I try to set the connection info and am at a bit of a loss to get around the problem. Note that most examples of using VBScript and SMO together only connect to a local instance of SQL Server, so I've struggled with the method to define the server I'm attempting to manage. This method works in VB.Net, but returns the error 'Object required' when I set the object parameters to their desired values. Dim srvMgmtServer Dim srvConn Set srvMgmtServer = CreateObject("Microsoft.SQLServer.Management.SMO.Server") srvConn = srvMgmtServer.Co ...Show All