S.S.P.'s Q&A profile

• SQL Server Migration from Cognos ...

  Hi, I've been asked to investigate for a client the migration from Cognos Decisionstream (7.1), PowerPlay and Impromptu (7.3) to SQL Server 2005.  Key driver (so far) is to reduce licensing costs.  I can't say I'm a Cognos guru.. so.. Has anyone done this / doing this / thinking about this What are the key benefits What does Cognos offer that we don't What are the biggest issues Did you have any problems What other items should I be considering Thanks www.SQLobSERVER.com I am not sure it is such a good idea to have that layer. First, you need to wait for Cognos to write a provider for each database version you need to support. Second, such a layer may introduce performance issues because it auto-generates queries fo ...Show All

• Visual Studio Team System Administration of user-defined error messages

  Hi, I am testing the DBPro (VSTEfDB) and I like it very much. Perhaps I missed it, but I cannot find anything about storing user-defined error messages. We usally store our user-defined TSQL error messages in the databases (for using them in procedures/functions). So we have to ship the messages with the DB and update them with each new version. Is this possible with DBPro If not please add support for user defined error messages. Bye, Thomas The scope of DB Pro is a single database. Since user-defined error messages are outside of a database (they are server-scoped) we have no direct support for them. However, you can create your calls to sp_addmessage in the pre-deployment script C ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XBox 360 Wireless Controller on a PC

  I've downloaded the drivers for the XBox 360 controller from the MS hardware website, yet when I connect my wireless controller via the USB cable, the "Found New Hardware" wizard fails to recognize it (and continues to prompt for the drivers). What am I missing here Thanks, -dn for those of us in canada, futureshop has this product listed on the their website, as available Feb 6th/07 http://www.futureshop.ca/catalog/proddetail.asp logon=&langid=EN&sku_id=0665000FS10084538&catid=&test%5Fcookie=1 same at bestbuy http://www.bestbuy.ca/catalog/proddetail.asp logon=&langid=EN&sku_id=0926INGFS10084538&catid=23563 I'm glad i didnt go buy a wired controller! ...Show All

• Visual Basic Sharing data between processes

  I need a easy way to communicate data between two exe programs that are both written in VB.net. The two programs will be running on a single system. I can make the process method work within VB.net but how can I communicate information between the two programs. The type of information that needs to be shared is about 50 string variables that each process would be modifying over a very short amount of time and sending to back and forth between each of the processes. I cannot use the client / server format with streams due to a DLL problem from a third party vendor that must be included within one of the processes. Any help would be appriciated. You should take a look at .NET Remoting. T ...Show All

• Visual C# Class names not being highlighted.

  This is probably a fairly easy question, and it might belong in a VS forum somewhere but I couldn't find a VS - General forum here. So since I'm coding in C#, I'll try here. I opened VS today and one of my files no longer has the class names highlighted in light blue. It still builds, the site works and everything, but VS doesn't seem to recognize any of the classes or references on that one page. It was fine yesterday, and other files in the web project work. Other files in the same folder work. It's just this one file. Any ideas I can specify in more detail if you need, but I didn't know if this was an easy fix or not. I've seen this problem happen when the application is not in a compilable s ...Show All

• Visual Studio Team System Recreate TFS site

  We were having troubles adding components to an existing TFS project so I thought I could delete the site and recreate it to the basic template. Is there a way to recreate the sharepoint / WSS again based on an existing TFS site We have files in source control so it will be difficult to create a new team project and migrate to the new project. Does anyone have any suggestions Thanks On the WSS site you have an option to save the current site as a template. You would need to save the site template then you need to modify the template to use that template rather than the default one. You will find the template in the Windows Sharepoint Services directory in the process template directories. If you have not ...Show All

• SQL Server Is this possible without using cursors?

  Hi! I have 2 tables: Person and Address Person (   PersonID int PK ) Adress (   AddresID int PK,   PersonID int FK,   Default  -- 1 if address is default for person ) so when I join those table it yelds (for example): p1  a1  1 p1  a2  0 p1  a3  0 p2  a4  1 p3  a5  0 p3  a6  0 Person may: - have one default addres and some non-default; - haven't default address; - have only default adres So proper result is: p1  a1          p1  a1 p2  a4    OR    p2  a4 p3  a5          p3  a6 I ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. About "discard" keyword

  I found the sample code in D3D 10 using "discard", seem to just use the current pixel in framebuffer without any change in PS. And searched in the D3D 9 reference found that there was the "discard" too but without any explanation. So far as I know some function PS can't implement are Alpha blending and alpha test in D3D 9. So with "discard", it seems that we can implement Alpha Test. What about Alpha blending Can we get the current pixel in frame buffer in PS D3D9's Blending and D3D10's "Output Merger" are still fixed function - there is no programmable blending yet (I saw a news item saying this might feature in OpenGL 3.0). What you can do is programmably determine the inputs into these fi ...Show All

• Windows Live Developer Forums findnearby and schools

  Hi, Long time lurker, first time poster. I'm using findnearby to plot schools in VE. Right now I'm using the list of filters that comes up on local live when I search for a specific school (Junior High & Middle Schools, Senior High & Preparatory Schools, Elementary Schools, General Interest Schools and Education) to plot local schools on the map. I have two questions. 1. Is there a better method to find schools 2. What is the mechinism to report schools that don't show up that should Thanks. Hahahahahaha, no, dude, but i can do the job for you, you only need to pay my gas, my food in form of burgers, and of course a 7 star hotel in every city i have to stay over night ;) Then i dri ...Show All

• .NET Development How to Prefix an XML document?

  How to add prefix to all of the nodes in an XML document Following is my xml. < xml version="1.0" encoding="utf-16" > - < XYZ123 :NameRequester xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" d1p1:SID="20" d1p1:HID="21" d1p1:RID="22" xmlns:d1p1="http://tempuri.net/" xmlns="http://tempuri.net" xmlns:XYZ123="http://tempuri.net"> - <d1p1:NameBlock> - <d1p1:Test1> <d1p1:Name>Bob</d1p1:Name> <d1p1:HisName>Tom</d1p1:HisName> <d1p1:HerName>Marie</d1p1:HerName> </d1p1:Test1> <d1p1:OtherName>Sally</d1p1:OtherName> ...Show All

• Windows Forms Inheritance..Urgent please...

  Hi, I want to design a base class in such a way using that i can define only one derived class. if i define another class it should give an error. ...Show All

• .NET Development Reading any file format with FileStream

  I want to be able to send ANY type of file (Text, .Doc, .Zip,. Etc.) with sockets. Everything seems to be going as planned, except when I read the file, the bytes are little bit different. How can I correctly read (ANY) file, for transferring over sockets Real Line 1 of File: +o[C€‥46( § cgZ C)E xn[y"QO Cp After reading with code below: +o[C (46( ,' cgZ6C)K xn["QS Cp It seems I am reading the file wrong. Only a few characters are not being read correctly. Here is the basic code for reading the file: fs = File.OpenRead(@"c:\mailroot\MENU.pdf"); br = new BinaryReader(fs); byte [] currentBuffer = new byte [1019]; currentBuffer = br.ReadBytes(currentBuffer.Length-5); Logger.Log(Encoding.ASCII.GetS ...Show All

• Visual Studio Team System How to make the webtest use unique values in different runs from data source

  Hi, I have a web test and it pulls data from a table. My requirement is that the web test should use each of the rows in the table only once. i.e if I execute the webtest once, it pulls the first row. When I execute the web test again, it should use the second rwo but not the first. Is there any mechanism to achieve this Please read http://msdn2.microsoft.com/en-us/library/ms182546.aspx , section To Configure data binding in the Web test. It describes how to configure web test to run under setting "One run per dada source row". Thanks. ...Show All

• Visual Studio Express Editions unprogramed sound

  I have programed a game that uses three short sound recordings and there is another sound in it ! !  It sounds like interference almost or sort of static.  I think it may just be that it tries to play to many sounds at once but it used to work.  If anyone has had the same problem then PLEASE tell me! The code that I used: My .Computer.Audio.Play( My .Resources.bleep1, _ AudioPlayMode.Background) It is the same thing for all three of my sounds.  could may well be intereference, I'm guessing you are using onboard audio Even though you shouldnt but no harm, tried rebooting the machine to refresh it Where is this "bleep1" Have you tried to play u ...Show All

• Windows Forms select gridview row with right click

  i want a right click on a gridview to both select a row and bring up a context menu configured for that row. there doesn't seem to be a way to do this. any ideas thanks I use the following approach (with MultiSelect=True), which allows the row to be selected during the right click if it is not already selected (if it is already selected, then other rows may be selected as well and I want to leave the selected rows as is). This does not bring up the context menu but does get the selection correct (for me) BEFORE the context menu does appear: Private Sub dgvResults_MouseDown( ByVal sender As Object , ByVal e As System.Windows.Forms.MouseEventArgs) Handles dgvResults.MouseDown If e.Button = Windows.For ...Show All