ricky rich's Q&A profile

• SQL Server Wildcard characters in MDX?

  Is it possible to use wildcards in MDX I am getting null values when I use the syntex [Product].[%Cola%] in an attempt to bring back all products that have the word 'cola' in the name. I can't find any reference to wildcard characters for mdx in Books on Line, any help is greatly appreciated. Wino MDX does not have the concept of wildcard characters in the same way that SQL does. You either have to use the filter() function in combination with the instr() function to search the name property of a set of members. eg. FILTER([Product].Members,Instr([Product].CurrentMember.Name,"Cola",1) >= 1)) (If you are using AS2k, this is your only real option.) Or, if you are using SSAS 2 ...Show All

• Visual Basic How do i import special text characters from a text file?

  hi, i was wanting to import special charcters from a text file, and using the following code, visual basic ignores charcters such as e and . All other characters are imported fine. Dim TextFileStream As System.IO.TextReader ' Load the textfile into the stream TextFileStream = System.IO.File.OpenText(txtTempLocation.Text) ' Where txtTempLocation.text is the file location ' Read to the end of the file into a String variable. Dim MyFileContents As String = TextFileStream.ReadToEnd strFileContents = MyFileContents ' Close the Stream object TextFileStream.Close() --Can someone please help. in need this 2 work.-- 1noob System.IO.File.OpenText assumes that the t ...Show All

• .NET Development I'm Dying Here! ;o): The proxy settings on this computer are not configured correctly for Web discovery

  I'm having this issue on WinXP box that is stand alone and is not connected to a network of any type. The web service i am tyring to consume is not .NET however it is running on the local machine. I am able to access the wsdl directly through IE but when i try to add it as a web reference i get this error: "The proxy settings on this computer are not configured correctly for web discovery. Click the Help button for more information." another thing to note is if i do hook the computer up to the interent and try to access an external web service like https://adwords.google.com/api/adwords/v2/CampaignService wsdl it works fine. Is it possible that i'd only have an issue when accessing a local web service I've tried all the settings possible ...Show All

• Windows Forms How can I get the event when a Form is loaded and shown on the screen?

  I have a form that takes a long time to load due to some data that is being loaded on the OnLoad event. This makes the application unresponsive when the form is being opened. So what I want to do is to display a panel on top of the form that shows "LOADING..." until the form is finished loadong. The problem is that I want to start the time consuming function only after the form has been loaded and shown on the screen but I have no event for that.. Ways to solve the problem: 1. Call a BackgroundWorker thread for the time consuming function. The problem is that if the time consuming function is updating the GUI then i need to create a delegate for every change that it wants to perform on the GUI and it might also make the GUI lo ...Show All

• Visual FoxPro Memo field conversion

  I am using a Microsoft ODBC Driver to connect to 4 DBF files . One of them has Memo Fields in it and I am not able to see this particular table when I try to import it in Access. All the others I am able to see and they do not have memo fields. Any idea guys How I can fix this The thing is I am no FoxPro Expert , I get DBF files from some one and my requirement is to import these in Oracle Tables through an ETL tool. But before doing that I am trying to pull these files in Access and while doing so I am not able to see the Table with Memo Fields. I asked the user to change these fields to fixed length. They resent me the new table (no memo fields) and now access recognizes the table. So I was wonde ...Show All

• SQL Server Interactive Sort (problem/bug)

  Hi Header image (setup as external) disappear when interactive sort is used (interactive sort is set in the body of the report), works fine if the image is embedded. any help is appreciated. Thank you Veneto ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Manipulating Surface or Texture2D

  Hi, I doubtlessly need some help manipulating a Surface. I tried around with SetData(), but I just managed to get from "The size of the data passed in is too large or too small for this resource." to "Eine externe Komponente hat eine Ausnahme ausgelost." (External Component caused an exception). Thanks in advance! Hajo using System; using System.Collections.Generic; using Microsoft.Xna.Framework; using Microsoft.Xna.Framework.Audio; using Microsoft.Xna.Framework.Components; using Microsoft.Xna.Framework.Graphics; using Microsoft.Xna.Framework.Input; using Microsoft.Xna.Framework.Storage; namespace WindowsGame1 { /// <summary> /// This is the main type for your game /// < ...Show All

• Visual Studio Team System Visual Studio 2005 Professional Edtion use Team Foundation Server

  Hello Everyone, I already have an MSDN subscription and so does my other developer. So we each have Visual Studio 2005, we were conteplating purchasing Team Foundation Server and 2 CALS for it. Will our Visual Studio 2005 Professional work with it. Or do we have to change that version also. TJ Havens Yes, the client piece (Team Explorer) will work with Visual Studio 2005 Professional. Here's another thread on the topic. ...Show All

• Visual C++ Error C2065 in vc6

  hi i m using this code i on windows XP and visual studio 6,i receive error mentioned above i had include these two lines as well,in stdaxh.h #define _WIN32_WINNT 0x0500 #include <windows.h> the code is below MENUITEMINFO mii; memset(&mii, 0, sizeof(MENUITEMINFO)); mii.cbSize = sizeof(MENUITEMINFO); mii.fMask = MIIM_ID| MIIM_BITMAP |MIIM_DAMFT_BITMAPTA; error is describled as below D:\_RCProj\_VC6\live desktop\Source code\WinScreenAnotator.cpp(684) : error C2065: 'MIIM_BITMAP' : undeclared identifier D:\_RCProj\_VC6\live desktop\Source code\WinScreenAnotator.cpp(684) : error C2065: 'MIIM_DAMFT_BITMAPTA' : undeclared identifier Error executing cl.exe. Creating browse info file... WinScreenAnnotatorVC6.exe - 2 error(s), 0 warning ...Show All

• .NET Development Cannot Add Web reference

  Hi, When ever I try to add the following web reference in my application http://www.messagevista.com/subscribers/gatewayApi.asmx It will be given following Error message The server committed a protocol violation. Section=ResponseHeader Detail=CR must be followed by LF Please help....... Regards, Dmp Hi I am technical support agent of MessageVista Communication. I ran into your concern on this forum. We have never had such a problem in our .NET applications. Could you please contact us at support[at]messagevista.com and let us know how you ran into this problem thanks. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Struggling with 3D sound - Anyone got this working?

  I'm getting IndexOutOfRange exception on the " engine.Calculate3DAudio(listener, emitter)" line below. Anyone managed to do anything like this I want my sound to come from a particular point. I understand with my code below that as theplayer moves, the listener isn't updating position (so sounds already started will be wrong), but I need to get the sound playing first! public class Sound { private static AudioEngine engine; private static WaveBank wavebank; private static SoundBank soundbank; private static Audio3DEmitter emitter; private static Audio3DListener listener; public static Cue Play( string name, Vector3 playerLocation, Vector3 soundLocation) ...Show All

• .NET Development VB.Net Cleaning up after DataReader

  Hi, I am getting a warning message with the following (trivial) code example: Private Sub Form1_Load( ByVal sender As Object , ByVal e As System.EventArgs) Handles Me .Load Dim connString As String = _ "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=C:\Program Files\Microsoft Office\Office11\Samples\Northwind.mdb;" Dim connection As New OleDbConnection(connString) Dim sql As String = "SELECT FirstName, LastName FROM Employees" Dim command As New OleDbCommand(sql, connection) Dim rdr As OleDbDataReader Try connection.Open() rdr = command.ExecuteReader() While rdr.Read lbEmployees.Items.Add( CType ...Show All

• Smart Device Development UPnP Programming

  Hi all! I'm working on programming a UPnP software and I'm facing a problem about invoking UPnP devices actions. I use the UPnP API that the Microsoft Platform SDK provides. It's the use of the IUPnPService::InvokeAction which fails. Here is the definition of the fonction : H InvokeAction(BSTR bstrActionName, VARIANT varInActionArgs, VARIANT* pvarOutActionArgs, VARIANT* pvarRetVal); where : * bstrActionName : Specifies the method to invoke * varInActionArgs : Specifies an array of input arguments to the method * pvarOutActionArgs : contains a reference to an empty array * pvarRetVal : contains a reference to an empty array You can search more information about this if I've not explained very well the definition. After execution, the functi ...Show All

• Visual C# linux application

  Hi to all, is it possible with visula studio to develop a compatible linux application and if i have to use DirectX sdk library wich is the best solution thanks Teo Hi, adding some words to Mark's post to say that the .Net 1.1 is fully supported under Mono and some of the 2.0 version is also supported. Version 3.0 is also being developed. There's also a project for cross platform managed graphics, but it's for the XNA framework. I don't know many details about this project but you can check it here: http://www.taoframework.com/Mono.Xna ...Show All

• Visual C# Pass parameter from one program to another

  I have 2 programs that I used clickonce with so it created a .application vs an exe. I was wanting to pass parameters from one program to another. Ever since I did this the command I use to grab that parameter from the first program does not work. It gives an error. Basically I need to have the first program pass a variable to the newly open application. How do I do this since it is an .application file If I kept everything an .exe it works great so the code seems to be ok. I am just thinking that you cannot pass parameters when it is an .application. If this is true i then need to know how to go about so. I would love to see what you guys have in mind. As for the query parameter I think see ...Show All