Mathew1972's Q&A profile

• SQL Server Reduction in Rendering Time of Reports

  I am using SQL server reporting services 2005 to display reports (rdl files). The reports are displayed in the reporting viewer in the exe created using vb.net (visual studio 2005). The data for the report is computed and stored in a physcal table, the rdl file fetches the data from the physical table. The operation of querying and computing the data and storing the same in the physical table takes 5 seconds but the renedering of the RDL in the report viewer takes very long time (approx 5 minutes to display 150 pages). Tools Used: Front end: EXE, created using vb.net and visual studio 2005. Back end: SQL Server 2005 Reporting tool: SQL server reporting sevices. Note: In order to set the font, font size, background color and alignm ...Show All

• Visual Basic DMI (Desktop Management Interface) Question

  I have a complex problem. I want to obtain the following DMI information from the bios. Manufacturer Name Model Code Serial Number But for some reasons, I must not use WMI to obtain them. What should I do ...Show All

• Software Development for Windows Vista Rasing integrity level from a low level integrity process

  From IE7 (Protected mode) on Vista, i am launching a process (A) which has low level integrity since IE7 runs as low level. Can i launch a process(B) from A with high or medium integrity level I tried launching Notepad (Process B) form Process A as below. ::ShellExecute(0, // owner window L"runas", L"C:\\Windows\\Notepad.exe", 0, // params 0, // directory SW_SHOWNORMAL); But under Guest account on Vista, it asks for admin credentials..How do i avoid Admin credentials ...Show All

• SQL Server SQLDependency Disconnects for Web application

  Hi, On my ASP.NET 2.0 application and SQL 2005 database server, i am using SQLDependency API to recieve notifications on the dataset changes from SQL 2005 server. I get the notification sucessfully (irrelevant of number of attempts). So here's the problem, i wait for 3-4 mins and make sure that there is no activity on my web server. Now if the data changes the service broker fires the event (i validated through trace). But the notification is never received by my web application. It gets lost in between. I read about this 'Abrupt client disconnects' problem in the article http://blogs.msdn.com/remusrusanu/archive/2006/06/17/635608.aspx but this didn't help much. Also i sometimes see following messages in the profiler <qnev:QNEv ...Show All

• Windows Forms Can i use ClickOnce

  hi all. I have created a windows app that i want to distribute to my users for installation. I am testing out the clickonce technologi, but there is something i can't figure out. When i publish my app, i publish to a public server. All users can click to install. So far so good. But where is this program installed on client computers. If i search my computer i can't find the installation folder or icons. I have a icon in my start-menu which starts my application, but i also use settingsfile in my app. Where can i find this I am beginning to belive that i can't use click once and that i have to create a normal setup project . My application is beeing further developed so i need the "new version available". Can i ...Show All

• SQL Server Using SSIS packages to process SQL Server 2000 OLAP Objects

  Can a SSIS server, i.e. staging server be used to create packages that update SQL Server 2000 Analysis services objects on another server running SQL server 2000 OLAP   It appears that the OLAP connection manager ion SSIS supports only connections (and thus updates) to 2005 OLAP objects.  I work for a company that has a huge investment in a 3rd party DW that uses Analysis Services 2000.  the DW tool vendor will not support an upgrade to SSAS 2005.  We wish to extend the DW from other data sources.  My thought was to use a staging server with SSIS, used solely as the ETL tool for all new development (thus no more DTS development), and to update the sql server 2000 operational data st ...Show All

• SQL Server Why the report parameter dose not take effect?

  Hi, all experts here, Thank you very much for your kind attention. I am encountering a problem with reports built on my SQL Server 2005 Reporting Services Server. The reports parameters do not take effect at all I chose the value from the report parameter list, but the result returned the whole report data. Why is that And how can I solve this problem Really need help. Thanks a lot in advance for any guidance and help. With best regards, Yours sincerely, Hi, This information might help you. There are two ways of setting parameters. 1. Hardcoded text parameters in the parameters list. (Non query) 2. Data Set populated. (Query) Before going in details. we had to under stand label and value pair concept. Ei ...Show All

• Visual C# .NET and .NET API from OPC Foundation

  I hope that's the right forum for my question. I have to communicate via .NET API from the OPC Foundation with a Siemens OPC Server to get and set data. I want to use OPCDA and C#. Unfortunatly the documentation is poor, I didn't find useful samples or better description. For example I do not know how to get to a server object. I find no documentation about what exactly is url.Path, what for do I need connectData Opc. Factory f = new Opc. Factory ( typeof (Opc.Da. Server ), true ); Opc. URL url = new Opc. URL (); url.Scheme = Opc. UrlScheme .DA; url.HostName = "ATHEAUGW0476" ; url.Path = "OPCDaten" ; f.CreateInstance(url, null ); Does any one know a ressource to get samples, documentation or any h ...Show All

• Windows Search Technologies WDS closes

  I'm not a developer, but couldn't find another forum to post a question. here's what happens: I type in search words in the WDS deskbar search box. A list of choices appear I click on a file or on "more" WDS application opens Then immediately closes. I have completely uninstalled and re-installed 2 times, following all the instructions I could find on this forum. Here are a few of my "specs": Windows Deskbar Search--02.06.5000.5378 XP Pro 2002 SP2 IE V6 Hello Seprice, From the information given, there are a few potential issues. 1. Do you have any anti-virus or anti-spyware programs on your PC If you do, I would check these to make sure that t ...Show All

• Windows Forms Executer une requete SQL qui retourne un seul enregistrement

  Bonjour, j'utilise la version 2003 de .net. Je travaille avec une base de donnees Sql qui est charge dans un datagrid. Je voudrais pouvoir lorsque je fais la selection de certaines lignes, pouvoir les afficher dans mon datagrid. J'ai aussi ce code qui me genere une erreure lorsque je veux pouvoir executer une requete sql me permettant de retourner une seul enregistrement : public static Dictionary< string , string > ObtenirEnregistrement( string requete) { return ObtenirEnregistrement(requete, ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()); } Comment modifier cette methode afin qu'elle puisse fonctionnee correctement Merci d'avance... Hi! I am using the ...Show All

• Windows Networking Development How to mesure bandwidth with QoS ?

  Hi all, sory if I do something wrong, this is my first time here. I want to know, can I measure end-to-end bandwidth between two computers in LAN by using QoS API I dont need high-precision values, I just want to know which path is more efficient for the time being. I know that qWave gives such ability by "QOSQueryFlow" function and "QOS_FLOW_FUNDAMENTALS" structure. But I want implement the measurement on Windows XP. Can I do this using QOS API Thanx. Yes, qWAVE is designed to allow the caller to obtain real-time bandwidth estimates (precise) between the sender and receiver. qWAVE is only available on Windows Vista (not XP), so Vista must be used to call into th ...Show All

• SQL Server Sorting or Ranking a DRILLTHROUGH query

  Hi, I have an Excel application that is being used to DRILLTHROUGH into a SQL Server 2005 Analysis Services cube. I want to give users the option to just see the top 20 results from the drillthrough. To do this I have identified 3 options: 1. By adding some type of rank or sort clause within the DRILLTHROUGH MDX query. 2. By sorting the ADO recordset that is returned, and only outputting the first 20 records. 3. By outputting the entire recordset into Excel, then sorting the values with VBA code. Currently I am using solution 3, which is the worst solution (very slow). I do not know how to sort/rank within a DRILLTHROUGH MDX, or if it is possible at all, and I am having trouble using the ADO Recor ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Form file not found ?

  I'm writing a game with MDX 1.1 and VS's 2003 and 2005 On my computer i have 2 OSes I've started developing on Vista RTM with VS 2005 Game worked normally on my computer But when I uploaded it to a forum its members reported that it gives a system.iofilenotfound exception (don't yhink about missing data files, they're all at the right place and paths are not ablosute) Then i have switched to XP and ran EXE compiled on Vista with debug. This exception happens when dim frm as new GameForm or frm=new GameForm in sub Main() Frameworks 1.1 and 2.0 and DX are installed on my and members' computers. I have trie all combinations of VS 2003/2005 and Vista/XP I have no idea Help me, please For an "expirement&q ...Show All

• Visual Studio Team System Using VSTS for version controlling non-VS code

  I'm looking for guidance or pointers on best practices for using VSTS to version control non-Visual Studio code files. The company I work for is moving to VSTS for *all* of our code base. In particular, I need to find the best approach to version controlling a folder that contains many files, but only promote (branch / merge) selected files within that folder forward as needed. For example if I have a folder F1 with objects O1, O2, O3, ... O99. When we make a change, only objects O3, O9, and O72 might change and be checked in as a new changeset, and those 3 objects are *all* we want to promote forward. I am looking for the easiest way to label and promote (merge) those three objects from our development branch to a QA branch, and ev ...Show All

• SQL Server Persistant variables

  Greetings SSIS friends. Is it possible to create a persistant variable in an SSIS package dreameR.78 wrote: Greetings SSIS friends. Is it possible to create a persistant variable in an SSIS package Meaning what, exactly ...Show All