Tony B's Q&A profile
SQL Server Report server performance
Hi All We have an issue on the client site , where the Reports on Production(Live) server have been performing very slowly. We have the Analysis server, panorama server and the reporting server, all set-up on the same machine. The MRS Reports have been going slow for quite some time, and although from the look of the Production Machine set-up, it might look to be an issue with the memory usage and all that, the main problem I think, lies somewhere else. I tried deploying one of the reports on 3 different servers ( including one on production server). All three instances of the reports are looking at the same datasource( the analysis server on the production machine). The reports deployed on the 2 servers other than the produ ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Scaling my Skybox
Hi guys i hope you can help me with my simple problem. I use the following code to draw my skybox: public void Draw() { Matrix[] transforms = new Matrix[myMesh.Bones.Count]; myMesh.CopyAbsoluteBoneTransformsTo(transforms); foreach (ModelMesh mesh in myMesh.Meshes) { foreach (BasicEffect effect in mesh.Effects) { effect.EnableDefaultLighting(); effect.View = View; effect.Projection = Projection; effect.World = mesh.ParentBone.Transform * Matrix.CreateTranslation(Position); } mesh.Draw(); } } Whats my problem My problem is that my skybox is too small. So how can I scale my skybox or in common how c ...Show All
SQL Server Problem for Calling A Stored Procedure, Please help.
I am writing a Stored Procedure for other server (using C++ to receive the output values) as below, where @Total ， @balance， @A are output values create proc [MaxTime] @number varchar(30), @numbera varchar(30), @numberb varchar(30) as begin declare @balancefloat declare @table varchar(20) declare @freetotal varchar(20) declare @SQL nvarchar(4000) declare @A float declare @Total float select @balance = balance, @table = table, @freetotal = freetotal from info where number = @number SELECT @SQL = 'select @A = A FROM' + @table + ' WHERE LEFT(code, 1) = ' + LEFT(@incomingcode, 1) + ' AND CHARINDEX(LTRIM(RTRIM(code)), ' + @incomingcode+ ') = 1' + ' ORDER BY LEN(code) DESC' exec sp_executesql ...Show All
Visual Basic Wait a moment!
In VB6 there was a wait command that would halt the program untill a button was pressed, or some other type of event would restart the programme. Is this still available in VB.Net Thanks Moayad, I remember now that it was Sleep and not Wait! But what I,m after is a way to put the program to sleep untill a button is clicked then it will start again. Graham ...Show All
Windows Live Developer Forums VE Winforms Asset Management System
Some time ago, I wrote an asset management system in VB.NET, using Virtual Earth with a MapCruncher Mashup of my company's multi-floor floor plan. I use this for my helpdesk work. When someone calls in, I can pull up a map of that computer's exact location. However, it's becoming more difficult to maintain with the many updates to the VE API as well as mapcruncher. However, the speed is more of an issue. I have so much data in this system, and the fact that it has to fetch the VE data from the Web, it is so slow. I put the data in the system by visually locating a PC in the general location on the map. I click the Map to pull the Lat and Long of that location; which I then store in a SQL server. So when I search for a pc name, it locate ...Show All
Windows Forms Create Trace in my application
Hi to all, i like to create a application, that will allow user to trace through out code runtime like f11, i will use reflection to open the methods in the user dll. how create a trace in a new window...... please help me........... is it possible, any ideas, i like to do that application in c#. Hi Ritchie, THANKS For ur nice Work.. but i didnt get the exact application u said, can u please provide the exact link, please with regards -Amjath ...Show All
Microsoft ISV Community Center Forums Record, playback, macros
What's the keyboard shortcut to record a macro What's the keyboard shortcut to then play it back ADG wrote: I don't think that there is a keyboard shortcut for recording. To record a macro use Tools - Macro - Record New Macro. Whne the dialogue comes up you can assign a keyboard short cut for replaying. Damn, wrong group. i meant to ask this in the C# forum. i'll mark the answer as helpful - even though it wasn't - because maybe it'll help someone else. ...Show All
Visual C++ native WIFI -- wlanapi
Hello there, I am trying to write a small software that manipulate the wlan configuration in windows XP. I download the beta version of Wireless LAN API for Windows XP SP2. While I am trying to give it a shot, I read somewhere that WPA (Wi-Fi Protected Access) is not supported in this API. Since I am not 100% sure, can anyone give me any information about it Thanks a lot. I have forward this my question to this email address. Thank you a lot! Math23: Will let you know if I get an answer. ...Show All
.NET Development How to use IDataAdapter ??
DataSet ds = new DataSet (); try { IDbCommand fieldCheck = connection.CreateCommand(); fieldCheck.CommandText = "DatabaseFieldCheck" ; fieldCheck.CommandType = CommandType .StoredProcedure; //Add Parameters //Table Name IDataParameter tableN = fieldCheck.CreateParameter(); tableN.ParameterName = "@tableName" ; tableN.DbType = DbType .String; tableN.Value = tableName; fieldCheck.Parameters.Add(tableN); //Table Field IDataParameter tableF = fieldCheck.CreateParameter(); tableF.ParameterName = "@fieldName" ; tableF.DbType = DbType .String; tableF.Value = tableField; fieldCheck.Parameters.Add(tableF); //Pass the value IDat ...Show All
Visual C# Problem regarding displaying the £ sign in a win32 console application
Hi, I'm trying to write what is really a very simple program, and am running into a stumbling block in regards to character output. when I type theline: 'cout << "￡";' it displays in the console window after compilation as: 'u' I was hoping someone could perhaps tell me why this happens, and suggest a solution I've been scouting around online, and to my surprise found really very little information on how to do deal with this issue. Thx Try to go into your project settings and look for encoding or format or charset or something like that and try changing it. Are you using a culture diffe ...Show All
Visual Basic compile both dll and exe
how can i set up vb.net to create both a dll AND exe on the same compile and then also have the install project recognize both dll and exe and register (with COM) the dll on install at the users computer not only is it a pain to continually switch between the two types of projects for each update, but also a pain to maintain two install packages. thanks thanks for all your responses, but i guess i am not explaining myself correctly. i want to have ONE set of source files compiled into a dll and exe at the same time. if i have two projects, then i have two copies of the SAME source code. this is not what i want. i only want ONE copy of the source code, that is compiled into an exe and dll. i have ...Show All
Visual Studio 2008 (Pre-release) FaultException not handled correctly in custom transport
Hi I'm throwing a FaultException in my custom transport, but it doesn't seem to propagate as it should. In my Service, if I throw one, the program stops and I get a " FaultException'1 was unhandled by user code " (sic) What I was hoping for was that a SOAP fault would be returned to the Client. Not stopped at the service. Well... the funny thing is that if i do a Continue (F5) a SOAP fault is actually sent, saying " unspecified ServiceModel Fault " with my custom Fault type added in < Detail >. So, I get something like this: < Fault > < Code > < Value > Sender </ Value > < Reason > Unspecified ServiceModel Fault </ Reason > < Detail >< z:anyType i:type =& ...Show All
Visual C# Remove all functions assigned to an event
Is there any way to clear an event instead of having to do all ths: myevent -= blablalba1 myevent -= blablalba2 myevent -= blablalba3 myevent -= blablalba3 I have a program where events are assigned dynamicly and i don't know which events that has been asigned and there are pretty many so removing them one by one would be many lines of code. possible yes. should you do that no! you'll have to use reflection to set the delegate behind the event directly = to null for the instance of the object who's event you want to kill. ...Show All
SQL Server Current Security Context Not Trusted When Using Linked Server From SAP
Hello, I am experiencing a head-scratcher of a problem when trying to use a Linked Server connection to query a remote SQL Server database from our SAP R/3 system. We have had this working just fine for some time, but after migrating to new hardware and upgrading OS, DBMS, and R/3, now we are running into problems. The target database is a named instance on SQL Server 2000 SP3, Windows 2000 Server. The original source R/3 system was also on SQL Server 2000 (SP4), Windows 2000 Server. I had been using a Linked Server defined via SQL Enterprise Manager (actually defined when the source was on SQL Server 7), which called an alias defined with the Client Network Utility that pointed to the remote named instance. This alias and Linked Server wo ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Animation sample?
Great work on XNA GSE 1.0! I downloaded it today and signed up for the 360 Creator's Club. Getting the basic engine code I've been working on under Windows for the past few weeks compiling and running on 360 was far easier than I was expecting (though it would be nice if the IDE had better support for projects that target both platforms). One aspect of the engine I've been avoiding for a while is mesh animation, as there has been talk around here for weeks that a sample would be released and I'd much rather start from a sample, even if it is very simplistic, than dig though the documentation enough to figure out how all the classes fit together. So my simple question is.. any updates on this sample Has it been made available and I'm j ...Show All