Gary DeReese's Q&A profile

• Game Technologies: DirectX, XNA, XACT, etc. Getting cue duration

  Hi Is there any way to get CUE (IXACTCue) duration in ms I do not see any API function for this. -- mx Currently, there is no way to query for this information at run-time on Windows. But please check back! We do have plans to add some API's to allow a programmer more visibility into XACT content. (sorry I can't be more precise than that at this time). ALso, realize that it can be difficult in a system like XACT to determine the duration of a cue-- a cue can have several sound variations, and the sounds can have several wave variations which could all be totally different lengths. Also, the tracks, can have pitch variations, which will also affect the duration of the sound. -Brian ...Show All

• SQL Server Connection Timeout when processing cube

  I am getting a connection timeout error when processing a cube with measure group containing 4mil rows or so. It errors after 5 mins and after about 3mil rows have been read so it's probably not the ExternalCommandTimeout issue. The Fact table for the measure group is created using a named query. I would appreciate any insight into why the error is thrown after 5 mins. Here's part of the error: =================================== The connection was lost. Close all processing dialog boxes and try processing the object again. (Microsoft Visual Studio) =================================== The connection either timed out or was lost. (Microsoft.AnalysisServices) ------------------------------ Program Location: at Microsoft.An ...Show All

• SQL Server SQL Statment

  Hello All, I imported a excel file from SSIS and created a table called Lockbox. To avoid the user from having to change the excel file -it is being imported as is. I only need 4 fields: [Contract ID] , [Check Number], [Owner ID], [Site ID] The table I need to import to Transaction has Diffrent Column Names -ex-CustomerID, ResortID. The columns are in diffrent order. And I need to add more information into them like UserID = 'Hwells', Trantype = 'MF' and convert to a diffrent data type [Site ID] to text. Is their a sql statment that can do this SQL2005 Thanks for your time ...Show All

• SQL Server Design Aggregation Problem

  I have some problem. design aggregation cannot be made on several cubes that have a lot of data, and have a lot of measures and dimension (the number of fields in the table more or less 150 fields). They return 0% optimization level when we run design aggregation. This link have been published a few posts down but I repeat it here again. This is a good guide of how to create good aggregations: http://cwebbbi.spaces.live.com/blog/cns!7B84B0F2C239489A!907.entry HTH Thomas Ivarsson ...Show All

• Visual Studio Express Editions How to show the result to listbox and keep 10 records?

  In VB I have a form with a button,textbox, etc. After I click the button (caluclation behind), I want to show the result to listbox and keep 10 records. How to do that By the way, I want my result only with 1 decimal digit. How to do that Thank you Public Class Form1 ' Click the button more than 10 times to see ' the resultant action Private Sub Button1_Click( ByVal sender As System.Object, _ ByVal e As System.EventArgs) Handles Button1.Click Static x As Integer = 1 Dim singStr As String = _ Format((12 / 3.4) + x, "#########.#" ) If ListBox1.Items.Count <> 10 Then ListBox1.Items.Ad ...Show All

• SQL Server My .Net applicable unable to access my DB after SQL Report Service

  Hi, when I am using the Report Manger to open a report, I am unable to acess the Database from my .Net application and vice versa - error report from MS Visual Web developer - "Operating system error 32: "32(The process cannot access the file because it is being used by another process.)". Hi, you cannot create two user instances from one file because you cannot open a file with two processes. To do that you would have to create a server attached SQL Server Express database. This is capable for concurrent connections to a single database like any other SQL Sercer database. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Studio Express Editions Registration Benifits Problem

  When I try to download the e-book, all I get is an aspx file. How do I download those benefits If your trying to use a browser other than Internet Explorer - such as firefox you may get this. Use Internet Explorer and you should be ok. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XBox 360 controllers for the PC

  Hi, I had a question about controllers that plug into the PC. I understand that only XBox 360 controllers are supported by XNA. I also understand (I think) that wired only controllers work as they need to be plugged into the USB port on the PC. Actually the last point is now not valid since I discovered the wireless controller for Windows and 360. But this isn't available until 2007. Does anyone know if this wireless controller is an actual controller or just a receiver for an existing wireless controller Cheers, Steve ... another quick question for the those that have tried... are the PC drivers for the wired controller compatible with Vista   I just checked the 'for windows Vista' pag ...Show All

• .NET Development Running a Macro in a Password Protected Access Databse

  I have this problem that I can run the macro but since the database is protected it always prompts me for the the password. I cannot have the users have access to the database since this will make it possible for the data to be changed manually. The code I use is as follows Shell( "C:\Program Files\Microsoft Office\Office\Msaccess.exe DatabasePath /x JobCardPacks /pwd Password" ) I have checked the help in access and it says to use "/pwd" with the password. This still prompts for the password though. Please help Shot o lot. Works like a charm Automation is definitely better than the Shell command I used. This project was converted from VB6 though ...Show All

• SQL Server Flat File, Fixed Width import with Nulls always fails

  More SSIS woes. DTS was so much easier. I have a flat file. It's fixed-with with CRLF record delimiters (a.k.a. Ragged Right format). Some fields are null, and represented by the text NULL . I'm trying to import the file into SQL via an OLE DB connection. The target table is a SQL 2000 data table. Two of the fields in the target database are of type smallint. When I run PREVIEW on the data source (Flat File), everything looks good & correct. I added the convert columns task to convert my strings to smallint. This is where things go haywire. After linking everything up, the conversion gives me a "Cannot convert because of a possible loss of data." All of my numbers are < 50, so I know this isn't the case. Ano ...Show All

• Windows Forms Opening Microsoft Office Outlook !!!

  Hi everybody, I have Email Addresses in a column of one of my DataGridViews. I need to open Microsoft Office Outlook, whenever users click on these Email Addresses, and have a new Email opened and ready on the screen with these Email Addresse in front of TO: section. I have already tried the following code in the Click Event of this column: Process .Start( name@yahoo.com ) ; , but didn't work. Does anybody have any idea !!! Thanks so much, Mathew Thanks so much Paul, You are almost done with my assignment :). Just two more things to complete it: 1) How can i create lines (Carriage Return) in the Body of my Emails 2) How can i send them Thanks in advance. Mathew ...Show All

• Smart Device Development problems with VS2005 and IE7

  Hi, if running VS2005 with IE7 (the beta, the final or the WinVista RC1 included one) it is not possible to create a new C++ "Smart Device" project. If I choose to create a "Win32 Smart Device Project" with Visual C++, enter a name for the project in the "New Project" dialog i'll get the "blub" sound, wich also appears if internet explorer blocks a pop up or an addon, and Visual Studio falls back to the "New Project" dialog instead of showing the details for creating the new application. i guess this has something to do with the internet explorer security settings and so I tried to disable them all or setting them to the lowest possible level... has anybody an idea how to get VS ...Show All

• SQL Server can't connect to the ODBC database named aspol54

  can any one provide any suggestions to help this error i installed automation studion 5.4 and the program will not run on my laptop. i traced the data below when i try to start the program. AsProjet db0-b5c ENTER SQLAllocEnv HENV * 015CF6B0 AsProjet db0-b5c EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS) HENV * 0x015CF6B0 ( 0x015e1540) AsProjet db0-b5c ENTER SQLGetEnvAttr SQLHENV 015E1540 SQLINTEGER 201 <unknown> SQLPOINTER [Unknown attribute 201] SQLINTEGER 4 SQLINTEGER * 0x0013E380 AsProjet db0-b5c EXIT SQLGetEnvAttr with return code 0 (SQL_SUCCESS) SQLHENV 015E1540 SQLINTEGER 201 <unknown> SQLPOINTER [Unknown attri ...Show All

• Visual Studio Express Editions how to use a custom cursor (.cur)

  I have made a .cur file and have embeded it in my.resources so I can easily acess it from in my code but I don't know the correct syntax. Whatever I try never works. Can someone please tell me the few lines of code I need to use my cursor Thanks for the help! I will definantly try this code. Although I am Guessing I should change the ( "c:\windows\cursors\pen_rm.cur" ) to (my.resources.MyCursor.cur) because it is embedded. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. can xna compile a program for 360

  hay guys , can i write a program for xbox 360 using xna i know its for games , but its a cool thing if programing a software for 360 is available i was thinking about writing a small client program for 360 for networking , u know like pc cyber cafeh program , i think it will boost 360 in network cafes if something like that is done , so player can use like a username and a password and inter thier profile , and all the data is stored in a pc .. its an easy thing to devolop i hope i can do that or someone do it.. You could (and it would probably take 10 minutes), but of what use would it be I think he meant things like true business applications and such. ...Show All