Troy Lundin's Q&A profile

• SQL Server Extremely slow Excel MDX

  Using Excel as a client is most of the time exceedingly slow. For example writing a simple query of the type: SELECT [Measures].[Some Measure] ON 0, [Product].[Product-Version].[Product] ON 1 FROM [Cubename] in Management studio is in Excel transformed to: SELECT NON EMPTY HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({[Product].[Product-Version].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON COLUMNS  FROM [Cubename] WHERE ([Measures].[Some Measure]) which takes several times longer to execute. As one starts drilling down it becomes increasingly worse with excel producing MDX that takes 100:s of times longer to execute then if I handwrite the mdx. This is with a very simple cube where Some Measure is no ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. moving camera around the world.. like a 3D shoter first person look

  Hi I`m a new it direct x and struguling to learn it in managed code..c#... i have a box at 0,0,0 i want to move camera foreward.. backword lef right ... the camera... and rotate around with mouse i had looked at c-unit.com... and other sites.. but some of them do operations in math that i dont understand.. like the do.. cos of an angle.. or sin.. of mouse posion or 0.01f.. things like tthat Of course first error obtained was: "Error : Your mathemathic does not support Direct X 9.0c, please upgrade or contact your brains" Can anyone explain simply.. i know that i have to rotate on x axis to obtain the up and down look or rotate on y axis to obtatin left right views... but dost work vwery vell Btw.. my english is already bad.. and they use ...Show All

• Windows Forms renaming a picture to a file

  i need to change the format of an image from jpg to dll so i can use it as an icon. im using this vb code to handle the conversion theBitmapSize.Save(savefiledialog1, System.Drawing.Imaging.ImageFormat.dll) i can't get it to accept the dll part can someone help The reason you got errors when trying to save it as ImageFormat dll is because dll is not an image format. At all. Gqlu's method works good except that when you go to view your icon via Windows Explorer, it will not show its picture in certain views. You will have to use the GetThumbnail function to fix this I believe. ...Show All

• Visual C# Generic Application

  Hi, Is it possible to build generic application for more than one DataBase. I want to use MySQL5.x and MS SQL Server with application. One DataBase at one time. Yes Jafar it is possible to write data access code which is totally provider independent. All this can be achieved by using DbProviderFactory calss. For more help check the following links http://msdn2.microsoft.com/en-us/library/t9f29wbk(VS.80).aspx http://www.codeguru.com/columns/dotnet/article.php/c9783/ http://www.devcity.net/PrintArticle.aspx ArticleID=279 Also you can fire a search in some search engine to find the "DbProviderFactory samples". ...Show All

• Visual J# A few questions about TimeZone class

  1. I've got a problem with creating default TimeZone object on my local machine: import java.util.*; ... TimeZone tz = TimeZone.getDefault(); this code gets the default time zone. With help of debugger i notice that tz.__id == " ". what can be a reason for this 2. I have to create a list of full time zones names with out any abbreviations. In Java it can be created with help of "String[] zones = TimeZone.getAvailableIDs();" how can i do it in J# >Could you please show us what you are trying to do I'm trying to get a list of time zone names. Your sample works greate: ->GMT ->UTC ->ECT ->EET ->ART ... , but I need to get a list of full names ( Africa/Abidjan, Africa/Accra, Afri ...Show All

• Visual Studio Express Editions Using DLL's from Native Code

  People, I'm writing a native code C++ application that needs to access the interfaces, methods, and properties that are available in a DLL. This would be very easy if the application is compiled using the /clr option, but I'm not using that option and all the features of .NET. Any idea of how I can get this working You can use the /LD option to create to create dlls. You need to export the functions from your dll to be able to use them by other applications. Read more about such issues at http://msdn2.microsoft.com/en-us/library/3y1sfaz2.aspx Hoep this helps! Thanks, Ayman Shoukry VC++ Team ...Show All

• Software Development for Windows Vista Possible Solution

  I'm having a problem with Windows Vista Ultimate 64 bit edtion on my HP laptop, when i close the lid but i have set up what windows does when i close the laptop to do nothing, but when i close the lid, and re open it, the screen is off/black, cant shutdown it properly and must do hard reboot. Laptop is HP Pavillion dv9000nr AMD Turion 64x2 Nvidia GeForce GO 6150 1gb memory Exact same problem with a Sony Vaio VGN-FE590P. How in the world did such a widespread bug make it through Microsoft's 'extensive' testing over the last year I installed Vista and noticed this on day two. Also using new nvidia drivers. I've also noticed if I put the notebook in standby the screen doesn't come back on un ...Show All

• Visual Basic How do I set the row number of a DataGridView?

  psuedo code... set DataGridView1.row = i 'where i = 0 to DataGridView1.Rowcount Me .DataGridViewAnalog.CurrentCell = Me .DataGridViewAnalog(COL_NUMBER, ROW_NUMBER) I guess I can't just set the row.... DataGridView.CurrentRow is Read Only... meant to be used to retrieve the current row, but not set it.... ...Show All

• Microsoft ISV Community Center Forums Run time error '1004' ?

  Hi, How to fix this problem when i run the below code in Access 2003 that prompt the error message as Run time error '1004' Application-defined or object defined error Thanks! Perry   Dim cnnConn As ADODB.Connection Dim rstRecordset As ADODB.Recordset Dim cmdCommand As ADODB.Command Dim strSQL As String Dim xls As New Excel.Application Dim MasterRng As Excel.Range Dim objPivotCache As Excel.PivotCache ' Open the connection. Set cnnConn = New ADODB.Connection Set cnnConn = Application.CurrentProject.Connection strSQL = "SELECT  * FROM [TAB];" ' Set the command text. Set cmdCommand = New ADODB.Command Set cmdCommand.ActiveConnection = cnnConn With cmdCommand     .Comman ...Show All

• Visual Studio Team System Visual FoxPro 9 SP1 and TFS using MSSCCI provider

  Please help. Opening projects in FoxPro takes very long time. The reason is - during opening local project is udated from remote TFS, but updating speed is about 6 Kb/sec only. I have DSL 256K. Can it be set up somehow yes you are right. Speed depends on number of files in project. So conclusion is - it is how fox pro operates with provider during opening project and there is no way out to speed up ...Show All

• SQL Server Convert from Number to Text- Exporting to Excel from SQL Reporting services 2000

  I was trying to export a report which contains a number format. When I do that, all the numbers in excel will have a green small tag beside it saying "Convert from Number to Text". Is there anyway that I can change the format to a number when I export it to excel blocked !!! i Used FormatCurrency function in SSRS report. when i export into excel it again converted into text. But if suppose i didn't used FormatCurrency so it's work !!! Any solution for this!!! Thanks ...Show All

• Windows Forms Icons Curruption

  Hi.. I am developing an application using .net 2.0 and tree control. I have some icons which are put into resource files... I put them into Imagelist on application launching. and from the i use them into the tree-icons. After everything works fine in Debug mode. When i switch to the release mode.. icons suddenly disappears. Also after deploying the application are not seen as well. Any one aware of this kind of situations A temporary fix i did was b4 rleaseing.. i copied the resources-dll from Obj/Debug folder to Obj/Release folder and then i made the builded the application into the release mode... After that i deployed the application. For the first launch of the application it worked smoothly... the icons disappeared from the ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Recommended way to load a mesh?

  Ok, so I'm aware of the sad fact that the coveted Content Pipeline isn't included in Beta 1. So, with that not being an option, what is the recommended way of loading a 3d mesh, say, a .x file I would try to jump in this thread to keep this from getting into to many topics... http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=683102&SiteID=1 Thanks! ...Show All

• Visual Studio Team System SP1, TF30059, TF53018, inconsistent tiers

  Hi, this is the second system that got knocked out by SP1. The SP1 really raises my blood pressure. The SP1 installation went through smoothly. No error messages. Client Side Symptoms On the client side I can access work items, reports, documents and team builds as always but get an error message when trying to access source control. The error message says: http code 503: TF30059: Fatal error while initializing web service Client Side Analysis All web services are up and running. Server Side Symptoms The app tier’s event log shows the following error entry: Event Type: Error Event Source: TFS Version Control Event Category: None Event ID: 3014 Date:  29.01.2007 Time:  10:44:19 User: ...Show All

• Visual Studio Express Editions Can i use the .NET fw like this?

  Is there a way I can compile code without the visual studio, that is, writing code, then just using some kind of compiler (a bit like the compiler for java--"javac.exe") I am ok with non-object oriented programming. You can browse the MSDN library to find help on the command line compiler: http://msdn2.microsoft.com/en-us/library/25fz1td5.aspx ...Show All