donkaiser's Q&A profile

• SQL Server Formatting dates on a chart when sourced from SSAS2k5

  I am creating a few charts in SSRS that are sourced from a cube in AS. On the x-axis is time, which is what I assume a date-like field in the cube. On the y-axis is the measure. My problem is that I cannot seem to get the dates to format on the chart - regardless of the format code I use, the dates appear in long format, like "Thursday, November 23 2006". Are the dates from SSAS just string values That's what I feared...thanks for the confirmation. Hopefully something to look forward to in Katmai [better integration between SSAS and SSRS, that is] ...Show All

• .NET Development serialport

  I create a serialport and i add Datareceived event. When a call is coming i use readline function. I see only RING RING RING... I want to get the caller id. When i use HyperTerminal i write at,then at+vcid=1 and the number is displaed when a call is incomning. Also i receve OK when i write this strings in HyperTerminal. In my program i use the functions write and writeline whith the strings AT, AT+VCID=1 but i dont see any "OK" just the strings i wrote. I dont know if i use properly the "write" function to send strings to the com port or is something else that i do wrong. Can you help me with the caller id This is the code in c++ . No problem if you show me something in basic p ...Show All

• Visual Basic Simple Grid View Problem :)

  Hi, At the moment I am opening a file which contains a list of numbers and converting the list of numbers into an array, my question is how do I load the list of values into a grid view table THIS IS MY CODE FOR OPENING THE TEXT FILE INTO AN ARRAY: - Dim lines As New ArrayList Dim count As Integer     OpenFileDialog.Title = "Load File"     OpenFileDialog.Filter = "Text Files (*.txt)|*.txt|All Files (*.*)|*.*"     OpenFileDialog.FileName = ""     OpenFileDialog.FilterIndex = 1     OpenFileDialog.InitialDirectory = "MyDocuments"     OpenFileDi ...Show All

• Visual Studio Team System unable to connect to this team foundation server

  I've installed the db professional edition of VSTS and am getting "unable to connect to this team foundation server" error messages. I've checked security. I'm a domain admin on the tfs server. Would it help to reinstall the team explorer client Reinstalling the TFS client Is that the same as installing the Team Explorer from the TFS install disc I can connect to the TFS server from a different machine via VS Team Suite. DB Pro is not on that machine. ...Show All

• .NET Development I am misunderstanding one step for signing an assembly using the Assembly Linker:

  I have only a single file assembly MyAssembly.dll that I am preparing to be in the GAC. so I do this: I create a key using : SN –k myKey.snk Then how do I sign myassembly.dll with the key in mykey.snk using AL.exe (I don t want it to be automatic using VS2003) In Microsoft Doc, they say we should use: - Al /out:myassembly.dll Mymodule.netmodule /keyfile:mykey.snk The pb I don t have Mymodule.netmodule and I don t know what it refers to. What if I have no netmodule, does that make sense. Am I in the right place to ask these kinds of questions Thank you What you describe is often an option, and may well be preferable in some circumstances. But here's one reason you might want to delay-sign. Suppose tha ...Show All

• SQL Server Connect vb express to SQL2005 Developer ed?

  Excuse the cross post (to VBexpress fourum) but maybe someone here will have a different take have searched all around can't seem to see how to configure a SQL2005 developer ed so I can use vb express to develop a local front end. keep getting "the user instance login flag is not supported on this version of sql server" I have configured the .net framework via aspnet_regsql.exe. Also I configured the "Machine.config" file. but so far no luck. Selecting sql2005 as the server thru the add new database connection in advanced area yields the error message surely there is away. So far still no joy, While Scotty indicates that the connection to SQL2005 is intentionally hampered other posters indicate that ...Show All

• SQL Server export OLAP in SSAS 2005 to excel pivot table

  Hi genius, Nice to meet you here! When developing BI programs with SQL Server 2005, I got this problem: Users want the report should be exported in office excel 2003 format, and stored in PIVOT TABLE. We have decided to use OLAP tech in SSAS(SQL Server2005 Analysis Services) to generate cubes. If we just use excel as a client tool, and create a pivot table which connects to the cube database, it's ok. But, the users want to download the excel file from a web page, further more , they want to filter the data through the web page. How can I do Is there any other component needed Help inline. Thank you! Thank you very much. You really point out a way for me:) Another question: If I u ...Show All

• Windows Forms ComboBox and TextBox in DataGridView

  Hi All Please advice, how I can display the data in a DATA_GRID_VIEW TextBox when I select an Item from The Same Grid. Thankx using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; namespace Sample2 { public partial class DgvCombo : Form { public DgvCombo() { InitializeComponent(); } private void DgvCombo_Load( object sender, EventArgs e) { DataTable dt = new DataTable (); dt.Columns.Add( "id" , typeof ( int )); dt.Columns.Add( "name" ); for ( int ...Show All

• Visual Studio Express Editions Missing odbc32.lib

  I have set up VSC++ Express Edition. It works well with exercises from VC++ Programming but when I try debugging a project from another book I get the file not found message on odbc32.lib  I have just spent hours searching the web for a download but The links go up in a puff of smoke. I have SDK and have included and libbed the new folders but the file isnt in those folders either. Can anyone advise me I had only installed the SDK not the latest PSDK which I am downloading at the moment. Hopefully when I install the PSDK the problem will be solved. It will take a while though as I am using dialup. I hadn't realised that there was a difference between SDK and PSDK. but apparently there ...Show All

• Visual Basic Browse Network place only, howto?

  How can I set my openfiledialog just to open My Network Places(shared) Local Directory not included. If you have the sample code it'll be nice thanks Sorry, I'm not experienced with SmartDevice application development. The part of the code that uses the DriveInfo class is only to handle mapped network drives. If there won't be any mapped drives then you can just skip the part of the code that is failing. ...Show All

• Visual Studio Team System Is this Is right Way to Share Code in TF

  Hi, Currently we are in a process of migrating our source from PVCS,CVS to Team System. We are planning to creat Team Projects based on our Product s so that they can have there own Development Cycle . Each product depends on specific version of Shared module , where shared module has its own development cycle (i.e, Products are not always depened on Greatest and Latest version of shared module.) At present we are experimenting following steps, Please let me know is this the right way to do 1 .Shared code are stored as part of individual Team System project so that they can have there own Development life Cycle $/SharedModule/Trunk /src /include ...Show All

• Visual Studio Menu item in Debug menu?

  Hi, I've looked in all the ctc files of the inc folder but I cannot find the correct group id for the debug/window menu. Thanks for your help, Charles Hi Cverdon, The guid:id pair for that particular context menu is: C9DD4A58-47FB-11d2-83E7-00C04F9902C1:1026 If you are a participant in the Visual Studio 2005 Service Pack 1 beta, and you add the following registry key value: [HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\8.0\General] "EnableVSIPLogging"=dword:00000001 Then, when you hold down the ctrl+shift key and invoke a dropdown or context menu, a messagebox will display with the pertinent guid and menu ID info. Now that SP1 (the beta) is public, we'll get this info u ...Show All

• SQL Server Partition sizes

  We're looking at partitioning strategies for our cube set. The standard recommendation that I've seen in various places is to limit partitions to 20M rows or so. Can any one tell me (or point me to info about) where that number comes from For example, is that dictated primarily by the time to process the partition Query performance Disk storage efficiency Other factors I ask because we're looking at how to handle older partitions over time. Can we merge them into larger historical partitions if we know that reprocessing them would be rare (that is, if processing performance is the main concern) Would that kill query performance Or is SSAS just not designed to handle partitions that large, and it would just be a bad idea in general ...Show All

• Visual Studio 2008 (Pre-release) Grid and StackPanel Layout Mystery (bug? nuance? feature?)

  Drop this into XAMLPad and it will produce just what I would expect: · A yellow textbox of height 200 stacked on top of the white textbox taking up the bottom of the screen. · When the app (DockPanel) is resized, the yellow textbox (hosted in the grid) does not change size. The remaining space allocated to the white textbox changes size the DockPanel is set to LastChildFill. <DockPanel LastChildFill="True" Background="Red" Height="Auto" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"> <Grid Height="Auto" DockPanel.Dock="Top" Background="B ...Show All

• Visual Studio In 'Show History' From and To fields does not work with the L (label) option

  I am using Vss version 6.0d client with same database. In the database i have several projects. When selecting a project and select Show History, I am searching for sources with a specific label. Therefore I enter the Llabel in the To and/or From fields in de dialog box but I always get the error that NO ITEMS IN THE LIST. I have verified that the label I have entered does exist on several sources. I also tried case sensitive, -L, command line arguments but nothing seems to work. Can anyone please help me out Many thanks in advance. Rob Sorry for the stupid questions. I'm not sure what might be wrong with your DB. If you run the Analyze tool from VSS 8 does it report any problems ...Show All