TheFreeman's Q&A profile

• SQL Server Cube Design - Number Max of Dimensions

  Hi all, Some cubes into my project have been designed containing 11 dimensions Is there a number max of dimensions The performances look fine so far but I was wondering if it will be a good idea to split these cubes to have a limited number of dimension per cube. Thanks a lot for your support Juan Sorry for my english... I meant 'browse' the cube thanks to Excel (Add_in). My tests of performance have been done to measure : - performance to process cubes - performance to access cubes with Excel If I understood well, the design has a direct impact in the processing of the cube but not in the browsing of the cube. Hope to be clearer... Cheers Juan ...Show All

• Visual Studio Application without instalation

  Can I run a application without instalation. ( like a Macromedia Flash apresentantion EXE or AutoExtract WinRAR file ). Wait for help. Tkz you can however the computer must have the appropriate .NET Framework version installed on the computer in order to run your application. You must also supply any dll's your app maybe using outside of the .NET Framework. ...Show All

• Windows Forms Reordering tab control

  I have a requirement to simulate reordring of tabs(along with controls in it) just as a user would do in excel sheet (user can reorder the sheets in a excel workbook while working on it using the tab kind of interface provided at the bottom of workbook). I tried to do it using tab control, but couldnot figure out how any pointers on this or any other control which would make it possible. Thanks Dinesh All you need to do is to find the right event for you (in your case I suppose you should aim at something in DragDrop) and add something along the lines of the following: TabPage TPTemp = this .TabControl1.TabPages[0]; this .TabControl1.TabPages[0] = this .TabControl1.TabPages[1]; ...Show All

• Visual Studio Team System Always getting "The internal state of the database project..yada yada..."

  That quite annoying as I don’t want to always kill the project from source source and get the latest correct build from the deployment database and build everything on top what was done in the meanwhile. Any suggestion or solution for that in the meantime -Jens. --- http://www.sqlserver2005.de --- Can you provide repro steps so that we can test this internally to fix the issue mairead PM, TS Data ...Show All

• Visual Basic Checking if drive exist

  I got a few questions, maybe you might be able to help. I am needing to design a program that will check for a problem with another pc in my local network. We are not running a server type enviroment, but just a simple peer to peer platform. Any how on to the problem, We use one pc to act as a server, and the hard drives use a raid controller using 1(mirror). We ran into a snaffou yesterday, because no one in that building monitors thier pc's, they just use them, anyhow the raid broke and created 2 independent drives with the same shared folders, and the drive windows decided was bad wasnt the right drive, it renamed the volume and took everyone back to fridays data that resided on the drive that windows thought was bad. Anyhow ...Show All

• SQL Server Accessing a "Lookup Table" from inside a Transform Script Component

  I have a requirement to access a lookup table from within an SSIS Transform Script Component The aim is to eliminate error characters from within the firstname, lastname, address etc. fields by doing a lookup of an ASCII code reference table and making an InStr() type comparison. I cannot find a way of opening the reference data set from withing the transform. Regards Tim One cannot, in a script transform, access the privately managed lookup cache that Microsoft uses to implement the stock lookup transform. Accessing a "lookup table" from inside a transform script component is quite do-able though. To roll your own lookup, perhaps because of a desire for a cross transform shar ...Show All

• Visual Studio 2008 (Pre-release) VMR9 and MediaElement

  I am trying to use a DirectShow filter in MediaElement, and although it works in WMP it does not work in a MediaElement. The author has suggested that maybe MediaElement requires the VMR9 in renderless mode with a custom allocator-presenter but I didn't know so I am asking :) Also what are my debugging options I have hooked up the relevant error event but nothing fails, it all seems to work, I just see a blank area instead of the expected video. I don't know if it is relevant but this filter is for DVB-T and as I mentioned works (very) well in WMP. Any help appreciated. A couple things to check: Does it work in graphedit (via render file) What are the media types the filter is using Do you get a ...Show All

• Smart Device Development Sending an XML request to a web service from a smart device application (c++)

  hi all,   i have a requirement of sending a request to a web service from my smart device application. i need to do this using XML the response of which will also be XML. could anyone get me started on this. i have a sample application using the following functions 1. InternetOpen 2. InternetCrackUrl - (to this the url along with the request was being passed) 3. InternetConnect 4. HttpOpenRequest 5. HttpSendRequest 6. InternetReadFile in that order. but i need to send the request in XML format and need to do it through a "post". i'm not sure if the functions mentioned above do it through a "get" or a "post". any sample application doing this would be of great help. cheers tha ...Show All

• Windows Forms How consume & ignore ItemCheck event?

  Hi. I have an event handler for a checked list box. When user clicks a check box, the list order rearranges. - simple. Problem is: VisualStudio's ItemCheck handler is invoked BEFORE the checkbox is changed. My ItemCheck handler re-orders the list and exits, and THEN Visual Studio's ItemCheck handler proceeds to check/uncheck the e.Index list item. As a result of the re-arranged list order though, the wrong item gets checked. From within my ItemCheck handler, how can I force Visual Studio's ItemCheck handler to complete, BEFORE my ItemCheck event handler proceeds Thanks much. Quoting the Remarks section of the CheckedListBox.ItemCheck event: "The check state is not upd ...Show All

• SQL Server Nested dataregions

  Hi! I'm having some problems with a basic thing I guess. I have a table of visits as the whole Dataset. Let's call it group A. I then group the visits per customer, let's call that group B. After that i filter out some unwanted visits and call that group C. The hiarchy then looks like this, A contains B that contains C. The problem is that I want to know the number of rows in C above the actual table. Something like CustomerName (John Doe) Number of visits (54 from group C but printed out while in group B) Visit 1 blablabal Visit 2 blablabla ... and so on ... As far as I understand the aggregate functions, you can only use them on the current group or a group above, never below. I tried to make an invisible tex ...Show All

• SQL Server Execute javascript in a seperate frame from a hyperlink in a report

  Hi I have a asp.net webform with a reportviewer control on it. I am using local processing mode. My site is made up of a main frame and then a child frames for navigation tabs and another child frame for the individual pages of the site. I am trying to execute a javascript function from the page inside the navigation tabs frame. I can get a reference to the navigation tabs frame from inside the report, but when I call the my javascript function AddTab, nothing happens. I have tried setting the location of the webform to something to test that I can call javascript on the navigation tabs page and that works fine. I am using the following javascript on a hyperlink in a report. = window.parent.parent.parent.parent.TabsFrame.self.AddTab();&quo ...Show All

• SQL Server Can't get IntegratedSecurity with JDBC driver

  Hi; I used SQLServerDatabaseMetaData (which requires a connection to return this data which seems unnecessary) to get: name: Microsoft SQL Server 2005 JDBC Driver version: 1.1.1501.101 Passing a url of: jdbc:sqlserver://localhost:1433;DatabaseName=Northwind;IntegratedSecurity=true I get the error: Oct 7, 2006 3:46:09 PM com.microsoft.sqlserver.jdbc.AuthenticationJNI <clinit> WARNING: Failed to load the sqljdbc_auth.dll Exception in thread "main" com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. I copied over x86\sqljdbc_auth.dll and then it worked. I assume this is required with the jar file. This leads to a couple of questions: What are the files ...Show All

• SQL Server Why for SQL 2000 max row size can not be more than 8060 characters (Japanese) nvarchar(4000)

  I want the reason for the above statement where I user nvarchar(4000) to insert the japanese text it give the same error , why we cannot have maximum size if we can have maximum size than 8060 what is the setting Please help me .. Thanks in anticipation Ashish Tahasildar Hi, NVARCHAR (which is Unicode) uses two bytes per character, therefore you are only able to store additional 60 bytes (to be safe, although you might do not occupy the full 4000 chars) HTH, jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Free Development help for your XNA Project

  If you have an XNA related project that you need help with or would like to help out with existing XNA projects, checkout   http://www.thexnaexchange.com . It's an open community with no fees to post projects or join as a freelancer.  Thanks, email support@thexnaexchange.com  with any questions. That's cool and all, but I'd prefer setting up a team to do a project over irc or something similar. Also, I don't really want to give out my address and phone number and all that jazz. ...Show All

• SQL Server How to get thru security of Sql server http endpoint?

  I have write the coding to create http endpoint in the sql server 2005, but if i type my pc ownself ip address (ex, 192.168.0.110) to connect to the sql server http endpoint, it prompt me for Username and Password. I didn't set any username and password before, what should i type Or what should i do to pass thru this authentication Thanks in advance. Cheers, Winson Hi Winson, For security reasons, the SQL Server 2005 http endpoints for Native XML Web Services require the client application to send user credentials. By default, the user account who created the HTTP endpoint will have access to connect to the endpoint. Users of the sysadmin role will also have access to the endpoint. All ot ...Show All