Bill Reiss's Q&A profile

• SQL Server high Availability cubes: During Cube metadata updates + ProClarity

  Hi, This is a kind of solution design issue. Scenario: We have a web page that displays information from a Oracle data warehouse. We collect the required information in the page and have used AMO to create cubes and other related objects from this information. The source for the cubes in SSAS 2005 would point to Oracle. This is modelled as a web service and used within the web page. Once the Cube gets created in SSAS, we model ProClarity graphs on them. The problem: The users can invoke the AMO web service from the web page, to add a new MeasureGroup to an existing cube. Once this is done the Cube becomes non-browsable. because we are adding a new MeasureGroup and thus modifying the cube metadata. In detail, If the new MeasureG ...Show All

• SQL Server ForeachFile and ForeachItem

  Since I installed SP1, I do not see ForeachFile and ForEachItem anymore as possible collections in the Foreach package, What went wrong Thanks for any advice. That's weird. No errors come up It just crashes I had an issue with very large packages sometimes crashing. It didn't really crash the IDE, but I couldn't save any packages. I would get an Out of Memory error. That mysteriously disappeared though. Do you have SP1 ...Show All

• Windows Forms Problem with startup form.

  Hi, I have a problem in my project. ie.. In my project I've 4 forms And its a windows Appln. When i set Form 3 as startup form, And after clicking F5, It will shows me the 1st form as startup form. What could be the reson Please send me a solution. Im using Microsoft visualstudio 2005 VS 2005 ...Show All

• SQL Server Executing Dynamic SQL larger than 8000 characters

  Can anyone tell me if there is a way to get around the 8000 character limit for executing dynamic SQL statements   I have tried everything I can think of to get around this limitation but I can not figure out a way around this.  Here are a few of the things that I have tried that have not worked Using VARCHAR(MAX) instead on VARCHAR(8000) Using NVARCHAR(MAX) instead of NVARCHAR(4000) Using nTEXT (BLOBs are not support for variables) Executing the statement via .NET using the SqlCommand.CommandText (it accepts a data type of String which is limited to 8000 characters) I can't believe this is sooo hard to figure out.  I know somebody has run into this before.  All help would be greatly appreci ...Show All

• SQL Server GetDataDrivenSubscriptionProperties vs GetSubscriptionProperties

  Is there a similar method for Data Driven Subscriptions like there is for plain subscriptions ListSubscriptions. I would like to get SubscriptionID for use with the GetDataDrivenSubscriptionProperties just as I do for GetSubscriptionProperties. When I execute GetSubscriptionProperties for Data Driven Subscriptions there is no array of Subscriptions. Here is an examole of the code which I execute using rs.exe: Sub Main() 'Dim rs As New ReportingService() 'rs.Credentials = System.Net.CredentialCache.DefaultCredentials Dim DRPlan As DataRetrievalPlan Dim extSettings As ExtensionSettings Dim desc As String Dim active As ActiveState Dim status As String Dim eventType As String Dim matchData As Str ...Show All

• Visual Basic drawing bitmaps images

  I loaded a picture box with a bitmap image(.bmp) and read it byte by byte into 3 seperate arrays to get the values of rgb in to each array respectivley. I want to recreate the picture in a diffrenet picture box by drawing individual pixels. The only methos i know is the drawellipse method but i do not know to transfer the values of the 3 array to the pen object in order to create the colour i need. One you said by declaring a bitmap object i can do that but problem is the colours are much shaper than that of the picture and i have dark lines going every in the picture. I have attached the code of my work. Imports System.IO Imports System.Math Imports System.Drawing.Graphics /**************************************** ...Show All

• .NET Development Table Adapter - stop Auto generated files

  I am using a Table Adapter in my Data access layer, built as separate Project. I need the adapter to use the Connection string in the Web.config file of the solution where the DAL assembly will be used. How do I prevent the Settings.settings and Setting.Designer.cs files from being generated when I compile the DAL. If I include the DAL project in my Main solution then will I be able to specify the Web.config connection rather than the connection from the Settings.Designer.cs file! I seem to be confused between using the Settings.Designer.cs and the Web .Config for Table adapters. Where can I find a good resource for this . -Jawahar Hello Charles, How can u assign a new database Connection ...Show All

• Windows Forms Really stupid question from frustrated VB4 programmer

  I've been using VB4 for 10 years. My new PC won't run VB4 - too much RAM - so I'm trying to rewrite a VB4 program that pulls data off an Access database. In VB4 I could pull a single piece of data off my database with "string = Data1.Recordset(column number)". I could navigate with "Data1.Recordset.MoveNext" and similar. In VBS I have built a dataset and populated it. 'Me.ArchetypesTableAdapter.Fill(Me.Npc3DataSet.Archetypes)' I can navigate with "Archetypes.BindingSource.MoveNext", but when I try to pull data off the dataset I get a variety of errors. The information on VBS tells me a lot about how to bind data to appear on the form - but I don't want that. I just want to read the contents of a cell into a s ...Show All

• Visual Studio 2008 (Pre-release) Why doesn't this Code work?

  Hello, my Code: Public Class Class1 Dim frame As Frame Dim _name As String Public Sub New ( ByVal name As String ) _name = name Dim win As frmMain = Application.Current.MainWindow Dim g As Canvas = win.FindName( "can" ) frame = New Frame frame.Name = name g.Children.Add(frame) End Sub Public ReadOnly Property Name() As String Get Return _name End Get End Property Public Sub BlendIn() Dim ani As New Animation.DoubleAnimation ani.From = frame.Opacity ani.To = 1 Animation.Storyboard.SetTargetName(ani, Name) Animation.Storyboard.SetTargetProperty(ani, New PropertyPath(frame.OpacityProperty)) a ...Show All

• SQL Server error_number() won't return error code

  hi all, i have sql statement in ExecuteSQLTask, connecting to AdventureWorks BEGIN TRY insert into person.contacts(contactid) values (1); END TRY BEGIN CATCH SELECT ERROR_NUMBER() AS ErrorNumber; END CATCH; i purposely put a table that does not exist in the database to catch the error. however, the error number that is 208 won't appear, instead the whole error message will be displayed. if i change the query in try block to insert into person.contact(contactid) values (1); it'll return the error number 544, which is correct. what did i do wrong thanks! thanks jaegd for your reply.. it didn't say in BOL that try/catch doesn't catch all errors or maybe i left that out. anyhow, my ...Show All

• Visual Basic populating an Access database using visual basic 2005

  I am trying to create a new employee application that gets input from a user in text boxes and then take that information and populate a database in Access that will later be pulled to the Track IT! database on SQLserver2005. How do i do it Thank you. This helps... but i still dont fully understand it :(... I like the datagridview way better... but seeing as how many users will be using it i dont think that my boss will like it so much... unfortunately... I am going to do it both ways and see which he likes better... however, what i dont understand is: (i am only going to be asking questions from the insert into the database from textbox b/c i am pretty sure thats how he wants it) A) how does the O ...Show All

• SQL Server custom styles usage

  I am amazed that we cannot use our own styles . There is only a predefined set of styles in HTMViewer.css to which we cannot add our own style names and use it for a textbox Has anyone done this Thanks Using Custom Style Sheet in SQL Reporting Services 2000 Changing the style-sheet in SQL Reporting Services is one question that I have seen commonly asked in the forums. Well yes the answer is straight forward but at times some straight answers don’t work :) . Following is my finding on how to use your own style sheet in Reporting Services: Prerequisite : SP2 hot fix: http://support.microsoft.com/default.aspx scid=kb;en-us;901383 Following are the steps for using custom style sheet in Re ...Show All

• Visual J# draw a graph with J#

  Hello I want to draw a temperature graph on aWindow form with J# but I don`t know how can I draw something with J# on a Window Form. So could you help me please. Thanks Mayer Thomas Hi Thanks for your help but now I have an other problem. I want to draw the graph on a new Window Form. The new Form should be open when I click on a button of my first Form. But when I click on the button I got an Exception: InvalidOperationException The code: private void temp_vor_Click(Object sender, System.EventArgs e) { Application.Run(new Thermo_V1._0.Form2()); } Could anybody help me ____________________ Thanks Mayer Thomas ...Show All

• Smart Device Development How to get RSSI by using Bluetooth Stack on WinXP SP2??

  I've searched the internet for a whole day,trying to find a way to get RSSI of my cell phone . But unfortunatelly, according to MSDN documents, the Bluetooth Stack contained in WinXP SP2 doesn't expose the services of HCI layer or LMP.(except in WinCE SDK, but I need it on PC) . Does anyone know whether it is possible or not Thanks anyway!!! Pls check the following link for info on other Winc CE related forums http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=481505&SiteID=1 Srikanth ...Show All

• .NET Development Get AbsoluteRange of a NamedRange Using OLedb, Excel

  I am currently using OLEDB to read the data from excel using C#. I have a scenario in which i will pass a NamedRange and I need to get the data from the NamedRange and also I need to read the data from the cell adjacent to the NamedRange. What I was planning to do is to get all the data in a dataset and then if I have the absolute range information of a NamedRange, i can filter the dataset based on that and i can read the cell adjacent to it from the dataset. But now am not able to find any way to get the absolute range of a named range. I have tried using " GetOleDbSchemaTable", but it will provide the absolute range information only if there are header information in Excel.Else it will return default values F1, F2..etc. ...Show All