PETER SCHWINN's Q&A profile

• SQL Server SSAS2000 cube. Number of rows processed is equal to 0

  I created a copy of the cube in the same database. Then substituted fact table with different table that have same structure as old one. New table contains 1000 rows. New cube processes with no errors but number of rows processed is equal to 0. If I browse to the fact table in Cube Editor I can see that the table is not empty. Why cube does not pick up any rows Check the log file and get the SQL or while processing cube get the SQL from "Process" window and run that sql in Query Analyzer to check are you getting data ...Show All

• Internet Explorer Development Grabbing the current URL and maybe the current page from outside of IE?

  What I'm looking to do is open a webpage in IE and be able to grab the current URL of that page with another application. What would be great is if I could grab the entire page too. Here is why I need this. My program needs a SID that the website provides to IE. This is provided be the website and with it I can then enter data with my local app because I can pass that SID. The SID is in the URL and even better in that current page. If this is not possible then how hard would it be to create an extention for IE to write the SID it has recieved someplace local If this is possible then I could just grab it and do the same work. Thank you Ok I did some more searching and I see the a BHO will do this for ...Show All

• SQL Server SQLRUN_SQL.MSI is not valid for Service pack 1 SQL 2005 command line REINSTALL

  Hello, I have recently tried to run this command line utility for SQL Server 2005 - "start /wait \sqlfoder\setup.exe /qb INSTANCENAME=myinstance REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=[password] SQLCOLLATION=SQL_Latin1_General_CP1_CI_AI" Unfortunately I recived an error stating the "Installation package for the product SQL Server 2005 (64bit) cannto be found. Please locate a valid SQLRUN_SQL.MSI". Which I couldn't find anywhere., so.... I created a fresh instance on my 2005 server, held back on installing SP1, and ran the command line again. This time it worked. My best guess is that the installation scripts check the version header on the MSI file during install and display a compatibilty error t ...Show All

• Visual Studio 2008 (Pre-release) Opacity 0 = Hidden?

  Hello. If I set the Opacity of a control to 0 cero... does the framework render the control any way I mean is this optimized TIA Wow, you are right. I had to try it, because I thought you were crazy... Use Visibility="Hidden" or Visibility="Collapsed" or IsHitTestable="False" on a button to make it not "clickable" W1.xaml: < Page x:Class = " w1 " xmlns = " http://schemas.microsoft.com/winfx/2006/xaml/presentation " xmlns:x = " http://schemas.microsoft.com/winfx/2006/xaml " Background = " #00C0C0 " Canvas.Left = " 92 " Canvas.Top = " 92 " Width = " 440 &quo ...Show All

• Visual Studio 2008 (Pre-release) Videostream

  Hi all. Been looking around with the aim of writing an app that can both preview and stream webcam video, but appear to have fallen at the first hurdle. All the information I can find seems to be older, using either native calls or DirectShow to perform this, but I've been told that the framework now supports using a WebCam. Anyone got any information on how to use a webcam preview, and maybe how to go about streaming it over a network Thanks! So doing a little more diving into the DirectShow API, I believe it is possible to grab a preview stream and get the frames without relying on an HWND to display them. I've got some old code that wraps directshow (needs to be translated to C#) that I think can form ...Show All

• Visual Basic Office component?

  Imports Excel = Microsoft.Office.Interop.Excel i have add the reference but its still cannot work.meanwhile i try another developer pc but its work the error is invalid namespace, it is mean the sys lack of some kind of office component im using vs 2003 enterprise developer and micosoft office 2003 standard edition Looks like you might be running into a known issue with the office interop libraries. Try reading the following article and see if it helps you with your problem. http://support.microsoft.com/ scid=kb;en-us;827476&spid=2488&sid=50 ...Show All

• Visual Basic How to insert data (probably simple question)

  I am quite newbie and I have one, probably simple question. I try to insert data into my database (SQL Server 2005) with this code (VS .NET 2003): Friend Sub Datainsert(ByVal Name As String, ByVal Surname As String, ByVal DateOfGame As Date) Dim ConnectMe As New Odbc.OdbcConnection ConnectMe.ConnectionString = "Driver={SQL Native Client};Server=localhost;Database=ProjektKoncowy;Trusted_Connection=yes;" Dim Writeit As New Odbc.OdbcCommand("INSERT INTO ProjektKoncowy.dbo.Wyniki (Name, Surname, Points, Status, DateOfGame, KindOfGame, Autor) VALUES (Name, Surname , ' 3 ', ' 1 ', DateOfGame ,' 4 ','John Smith')", ConnectMe) Writeit.Connection.Open() Writeit.ExecuteNonQuery() ConnectMe.Close() End Su ...Show All

• SQL Server DImension depends on other dimesion

  I have a parent child hierarchy in a table. Due to some requirements we need to create the same hierarchies for different years with different primary keys. i have data for 2005 and 2006 when i create a new parent chile dimension I am getting all 2005 and 2006 hierarchies. I have one more dimension where I list only years. Now I want to fileter the first diemsion depending on second dimension. I tried "depends on Dimension" property. it is not allowing me to save the dimesion at all. It is saying invalid parent child relationship if i remove the "depends on Dimension" then every thing is working fine except filtering. I need filtering of One dimesion from other. Pleas help!!!! Thanks ...Show All

• SQL Server how to include the nulls??

  Hi, I have the following query stored: SELECT dbo.OrderDetails_Retail.ProductID, dbo.OrderDetails_Retail.ProductName, SUM(dbo.OrderDetails_Retail.Quantity) AS ProdQtyPerWeek, DATEPART(wk, dbo.Orders_Retail.OrderDate) AS SalesWeek, YEAR(dbo.Orders_Retail.OrderDate) AS SalesYear FROM dbo.OrderDetails_Retail INNER JOIN dbo.Orders_Retail ON dbo.OrderDetails_Retail.OrderID = dbo.Orders_Retail.OrderID WHERE (dbo.Orders_Retail.account = @Account) AND (dbo.Orders_Retail.OrderStatus <> 'Deleted') AND (dbo.Orders_Retail.PayStatus <> 'Pending') AND (dbo.Orders_Retail.OrderStatus <> 'Refunded') AND (DATEDIFF(d, dbo.Orders_Retail.OrderDate, @StartDate) <= 0) AND (DATEDIFF(d, db ...Show All

• .NET Development OLEDBException: Timeout Expired error

  Hello there, I'm getting this error "Timeout expired" with Gridview control connection to an SQL2000 DB. I drag & drop a gridview control and configure the connection string to the database and one table. If I preview it, I can retrieve all the data. But if I run the the application, I am getting this error. I didn't do any coding in here. I am using Visual Studio 2005 (VB.NET) in Windows XP Professional OS. I want to develop a Windows application. Please help. Thanks very much. A Set you command object's commandtimeout property to zero. That would bring in data to grid with unconditional wait for getting data. That usually happens when network is down. Thanks ...Show All

• Visual Basic AddHandler Error (need help)

  Hey i keep getting a error where its says AddHandler instance.NewWindow, handler [code] Public Event NewWindow As System.ComponentModel.CancelEventHandler Dim instance As WebBrowser Dim handler As System.ComponentModel.CancelEventHandler AddHandler instance.NewWindow, handler Custom Event [/code] my visual basic says its a syntax error so can anyone help me please i've looked every where to try find out how to fix this but i'm a nooby at the program etc.. but i'm learning quick so if any one nows please can they help me thanks. Ok well so far it looks like this [code] Private Sub wb_NewWindow( ByVal sender As Object , ByVal e As System.ComponentModel.CancelEventArgs) _ ...Show All

• Visual C# Trying to do a report viewer in the c# windows app PLEASE HELP ASAP.

  I have a report with a text box and a report viewer. The text box tells the report how many reports passing a parameter. The problem is when I try to print the report it does not report the whole thing. It prints fine when i click on the tolbar and click the report layout and print it from that look. Why is that Can I write code to make the report load with the Print Layout look The following code sample may help you to print a report utilizing a print preview dialog. Please note that I have used to print a hard-coded string; you may wish to construct the same string from reading a database table to temporarily save into a file for print preview purpose (you may then delete the temp file after the us ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Using additive blender on the fly in a SpriteBatch (possible bug)

  Hello, I'm trying to draw some sprites of a 2D sidescroller with an additive blender, like the "burn" effect of a rocket. However the SpriteBatch.Begin() method takes a single blending effect and has no way of changing it "on the fly" during the batch. So how can I procede to achive the desired effect Ending/Beginning the batches everytime I need the additive effect is not practical at all... I've searched on this forum and I've found this topic about the subject: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=976132&SiteID=1 Which suggest the use of graphics.GraphicsDevice .RenderState.SourceBlend = Blend .SourceAlpha; graphics.GraphicsDevice .RenderState.DestinationBlend = Blend .One; with a SpriteSo ...Show All

• SQL Server SDF database - Create table error

  Hi, I have connected sdf database through SQL server management studio. I want to execute a simple query as, CREATE TABLE [dbo].[user]( [user_id] [int] NOT NULL) While executing the same through Query pane, it gives error as, <> Major Error 0x80040E14, Minor Error 26100 > CREATE TABLE [dbo].[user]( [user_id] [int] NOT NULL) The table name is not valid. [ Token line number (if known) = 1,Token line offset (if known) = 22,Table name = user ] <> Any pointers   Thanks, Shailesh. Hi Joao, Your statement is valid. However, I am trying to execute a script generated by SQL server 2005 and i need to create a schema from ...Show All

• Visual C++ Updating parameters used in the addrinfo struct.

  Is there any SDK or service pack for VC 7 so that I can install to update the parameters used for the addrinfo struct. My copy of VC7 only supports the following: AI_PASSIVE AI_CANONNAME AI_NUMERICHOST However, I need to use AI_ADDRCONFIG in the hints ai_flags parameter for invoking getaddrinfo(). Thanks in advance. According to documentation ( http://msdn2.microsoft.com/en-us/library/ms738520.aspx ) the AI_ADDRCONFIG flag is supported on Windows Vista or later. Therefore I don't think you can use it under other versions of Windows. You should have newer Operating System with appropriate SDK.   ...Show All