asowerby's Q&A profile

• SQL Server What events trigger the MDX scripts to execute?

  In ssas2005 what events cause the MDX Scripts to execute Mosha has a good article on what happens during OLAP processing. http://www.mosha.com/msolap/articles/cubeinit.htm ...Show All

• Visual Studio Visual Studio 2005 Database tools problem with Fox pro 9.0 sp1 ole db provider

  I have MicrosoftR Visual FoxProR OLE DB Provider 9.0.0.3504 installed. In the visual database tool, when I run "SELECT DATE() FROM MYTABLE", visual studio will give me the follow error: Error in SELECT clause: expression near ')'. Error in SELECT clause: expression near 'FROM'. Missing FROM clause. Unable to parse query text. However in visual studio 2003 on another machine, everything works fine. I tried to reinstall visual studio 2005 and the fox pro ole db provider many times. I still get the errors. Also, I remember it works on my friend's visual studio 2005. Can someone give me some help to fix this Thanks in advance. Also, "Verify SQL Syntax" returns "This command is not supported by this provider". ...Show All

• Visual Studio Just in time debugger registry key setting

  I had the Visual Studio Express edition installed and uninstalled it to put on the full version of VS. I have a web email page that when I click a necessary button I get the following error message and after clicking ok Internet Explorer shuts down. “An unhandled win32 exception occurred in iexplore.exe[3096]. Just-In-Time debugging this exception failed with the following error: No installed debugger has Just-In_Time debugging enabled. In Visual Studio, Just-In_Time debugging can be enabled from Tool/Options/Debugging/Just-In-Time.” I really need to have my web email work so I disabled the debugger tool and I still ran into the same error. I have uninstalled Visual Studio but I still get this error ...Show All

• Visual Studio Express Editions USB port

  Hey guys, I've been searching for a while now about how can i connect to the USB port using C# but i found nothing so if any one here knows how can i do it can he share it with us. Hi, If your cell phone has intalled windows CE, you can use Microsoft ActiveSync. Otherwise, you must contact your cell phone provider with this issue. Thank you ...Show All

• SQL Server How should I name my history tables ?

  Hi, I want to backup an important table every week in creating some history tables. I would like to create a Dts job or script to create every week a table with the day and month in its name. ( like : [important_table_09-07] , [important_table_09-14],... ) Any idea Thanks. I would only use the convention TableName_YYYYMMDD. As I guess that they will be not used that often, you should consider creating them on another filegroup and even schema (if you use SQL 2k5) than the productiv one to ease up the Backup of the objects. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Windows Forms Scroll listboxes together

  Hi, I'm trying to get two list boxes to scroll simultaniously (when I scroll one, the other one follows exactly), I'm looking for a scroll event but I can't find one. Is there a way to do this Thanks, Weiran. I had solved this problem earlier where 2 listboxes had to be sync'ed while scrolling horizontally.So,here it is- http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=474291&SiteID=1 ...Show All

• Visual Basic How to Calculate number of weekend days between the two dates?

  If start date is 08/17/2006 (17th august) and end date is 08/29/2006 the total number of weekend days are 4 Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim BeginDate As D ate = New Date (2006, 8, 16) Dim EndDate As Date = New Date (2006, 8, 28) MsgBox("Weekend days:" & CountWeekEnds(BeginDate, EndDate).ToString) End Sub Private Function CountWeekEnds( ByVal BeginDate As Date , ByVal EndDate As Date ) As Integer Dim Days As Integer Do While BeginDate < EndDate If BeginDate.DayOfWeek = DayOfWeek.Saturday OrElse BeginDate.DayOfWeek = Day ...Show All

• SQL Server Questions on translation and naming attribute

  Hello I have a few questions regarding the translations. 1. Is it possible to create this neat auto-generated date dimension in any other languages than english 2. When I use the Currency format string on my autogenerated measure groups they all turn out as $, but when I use it on a calculated member it chooses the correct currency. How can I change this for the auto generated measures 3. After creating the member, how do you define the deafult member show from the dimension. Say for example that I have DimEmpl(Code, Name). I would like the Name attribute to be the attribute showing by default. I know this is possible while creating the dimension, but what if I want to change it later Thanks // Richard ...Show All

• .NET Development Error in Web Service

  hello , I have a Web service retrive  dataset and some methods  my application connect to Web Service and  retrive the data From Web Service  But after  5 minutes  the application raise exception and if I call my Web Service again from internet explorer  it  gives me this Execption   System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - Shared Memory Provider: )    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception ...Show All

• Windows Forms How to get that the main form is going to be minimized

  Hi, Is there any way (like an event) to get that user is pressing MinimizeBox I totally want to know how to get that the user wants to minimize the main from. In this case i want to send my applicatin to notification tray when user minimizes application's main from. With thanks. Here's an example in VB.NET: Public Class Form1 Dim WithEvents ntfy As New NotifyIcon Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load ntfy.Icon = My.Resources.Icon1 End Sub Private Sub Form1_SizeChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.SizeChanged Me.ShowInTaskbar = Me.WindowState <> FormWindowState.Minimized 'Me.Visible ...Show All

• SQL Server Cube Design Question

  Hi I am currently redesigning my WH in AS2005 and would like some advice. We currently have an aggregated WH due to volumes : 180m+ atomic rows per month. The problem is that some of the data is not additive. Most of the messures are normal additive or count measures, but a couple are not. And as we are not storing the atomic data we need to pre-aggregate the data to the levels that we require and try to represent it that way. We currently have a work around in the cubes but it is not a good solution as it only allows us to see the top and bottom levels of the data. As far as I can see there are two options: Option 1 Create a Parent Child Relationship of the Dimension that we are grouping on and have all the levels of Aggregations in one ...Show All

• .NET Development asp.net 2 assign queryresultset to array

  I have a query that returns all values from one field for the req_id specified I need to put the result into an array so that I can then assign individual values to textboxes. There will never be more than 8 values. Tried using dbreader but that would only take one value from field. I tried something similar to what you suggest which works to a point. the query returns 8 values I have tested it on server. However  the first value for the field is not displayed on the page, txtreq0.Text = CStr(Request(0))------> holds value 1 not 0 Using myConnection As New SqlConnection(conn2) Dim myCommand2 As New SqlCommand(Sql2, myConnection) myConnection.Open() myCommand2.ExecuteNonQuery() Dim inde ...Show All

• .NET Development How do i keep Instance of current dataset???

  I have a Datagrid.DataSource = mydataset.....when i add new rows to it and close out the form and then i try to open that form back up...the form is blank...why is that Depends... when you add values to the dataset... are you saving the dataset anywhere else or applying those same changes (later) to a data store like a database Where does your app initially get the data for the dataset Worst case you could simply use the WriteXml() and ReadXml() to dump an xml version of the dataset to disk and then load it later (if you are not already storing your data elsewhere). ...Show All

• Visual Studio Team System Installing problem when My Documents is moved to a network

  I have an application that creates a folder below My Documents and adds files. After installing the app using a PC that has My Documents moved to a network location, the app installs and runs fine (when logged in with the network connected). However, the app fails to run and complains about an invalid path when launching after logging in without a network. The invalid path is related to the original network path to My Documents. Is there a way to have My Documents created locally if it can't be found on the network Hi Tony, This forum is for questions related to Team Foundation Server. It sounds like a more general VS forum would be more helpful to you. Check out one of the language specific ...Show All

• SharePoint Products and Technologies HTTP 403 error when displaying custom webpart on sharepoint 2007

  I have a major problem with a custom webpart on sharepoint 2007. I created two connected webparts, one is used to define a searchfilter for another webpart. The part that shows a list of values works just fine, but the filter part doesn't work and causes the site to display HTTP 403 error. this only happens when I'm not logged on as administrator. The webpart does nothing special, it has a connection with another webpart and sends a fieldname and fieldvalue as strings to the other webpart. Anybody have an idea as to what might be going on. Have you looked into the security settings for the filter   You can adjust permissions for web parts.  Perhaps the account you're using doesn't have rights to use the web part ...Show All