D.R.B.'s Q&A profile

• .NET Development C# Lookup Local & Network Servers (Oracle & MySQL)

  Hi All! I'm creating a server connection box in C# which can obtain a list of servers on the Local Network (MSSQL, Oracle and MySQL). I've successfully got MSSQL covered, but am still in need of assistance creating lists of the available Oracle/MySQL servers on the network, and have not been able to figure this out thus far. If you're aware of any methods to go about this, I'd sure appreciate your advice! Kind regards Ben In ADO.Net v2.0, we introduced an enumeration class (DbDataSourceEnumerator) that could be obtained from the DbProviderFactory (CreateDataSourceEnumerator method). Unfortunately, the only provider I know of that currently supports this is SqlClient. If you have third-party ...Show All

• .NET Development Memory Issues

  Hello all, I've been trying to profile my ASP.NET application on my application server. I set up 2 counters for aspnet_wp process namely '#bytes in all heaps' and 'process:private bytes'. According to a documentation that i read, '#bytes in all heaps' should be less that 'process: private bytes'. However the '#bytes in all heaps' was far greater than that of the 'process: private bytes'. I'm lead to believe that this indicates a memory leak somewhere. Now, the problem is that i've got 15 ASP.NET applications running on that server and i need to find which application(s) are causing the problem. Please i'll need help on which counters to set up that will enable me pin point the rouge application. Thanks Emeka. ...Show All

• Visual Studio Team System Error when creating coverage info: Module App_Code.dll version mismatch

  Hi all, I have a solution that contains multiple webservices. I have code coverage turned on and everything works great when building local. When building with team build we get the following error. The Code Coverage Analysis Service could not analyze the code coverage data for build IBS 1.1 Master Build_1.1.0.34 (Mixed Platforms/Debug). This is frequently caused by publishing different versions of the same binary to a particular build. Processing of code coverage data from run tfsservice@CTSHELNT04 2007-01-05 10:59:47_Mixed Platforms_Debug caused the following exception to be thrown: Error when creating coverage info: Module App_Code.dll version mismatch when aggregating coverage data. Check for out of date copies of this ...Show All

• SQL Server Automated Batch Job Over Numerous Data Files, How?

  Hello, Everyone: Greetings! I am new to Sql Server [Express version] and am not even sure I'm making the right choice. So here I am, seeking advice. My database needs are nothing sophisticated. They just involve: (a) create tens of thousands of separate data files each under a unique file name of up to 8 characters, with file names read in from a pre-determined file name list. (b) store/insert VOLUMINOUS numerical data into each of the data files, with the data indexed by date&time, plus maybe one or two additional character or string fields. (c) for each data file, retrieve a subset of its data, perform extensive numerical calculations, and then store the results in one or more separate corresponding files, e.g. if a file name in (b) ...Show All

• Visual Studio Team System Error TF50632 Removing User

  Hi! While removing a user from the group of valid tfs users I get the Error: TF50632 : An error occurred removing the group member. There is no group member with the security identifier (SID) The problem is that the user is a regular domain user and should be fine. I can remove other users without problem. Thanks for any help Uli D:\>Tfssecurity /server:http://ettfs1:8080 /im "Lizenzierte Team Foundation-Benu tzer" TFSSecurity - Team Foundation Server Security Tool (C) Copyright 2006 Microsoft Corporation. All rights reserved. The target Team Foundation Server is HTTP://ETTFS1:8080 . Resolving identity "Lizenzierte Team Foundation-Benutzer"... SID: S-1-9-1551374245-1204400969-24 ...Show All

• Windows Forms DataGridView and Update/Insert/Delete data in MS Access

  Hello, I have an application (Windows Forms) that populates a table from an *.mdb file to a DataGridView . Is there any tutorial available which shows how to implement Update/Delete of current data, or Adding(Insert) new data using the DataGridView   Thank you in advaned. take a look at these: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=839711&SiteID=1 http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=857672&SiteID=1 http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=843020&SiteID=1 http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=530275&SiteID=1 http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=661685&SiteID ...Show All

• .NET Development WHERE Statement Fails. WHY!

  Private Function Check() 'CheckX10Alerts(ByVal X10_RecvCMD As String, ByVal sndDeviceAddress As String, ByVal typEvent As String) 'Prepare to look for matching alert database Dim int As Int32 bolAlertsEnabled = True If bolAlertsEnabled = True Then Using connection As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\Dot_Net_Projects\Visual_Basic\aiHome\Website\App_Data\aiHome.mdb;") Dim command As New OleDbCommand("SELECT strMedium, sndDeviceAddress, typEvent FROM x10_Triggers WHERE strMedium = AND sndDeviceAddress = AND typEvent = ", connection) command.Parameters.Add(strName, OleDbType.Char, 150).Value = "Movement - Front Porch" command.Paramet ...Show All

• SQL Server custom code in report

  hi friends i wrote following custom code in report to hide/unhide a textbox in report Public Function CheckVisibility(ByVal value As String) As Boolean If value.tostring().length > 0 Return False Else Return True End if End Function but i dont see this function when type in "code." in expression box am using VS2005 standard edition, is it a restriction for this version Custom code is not compiled until the report is published, so the ReportDesigner does not know about any custom functions you create. The error you are getting is probably caused by the value of the field returning Nothing. Make sure that the value passed into the function is not Nothing before using it. Or you can use the Len VB function, which ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. making easy multiplayer game

  hi, I would like to create as feature a mulitplayer game and I was wondering how. I have the latest directx, directx SDK, C#, all frameworks,... and a server anybody can help me to good tutorial and tell if I need to use directx SDK for this Anything is possible if you've got the creativity to imagine it and the time to make it work! Since I believe the DirectPlay architecture is deprecated, this is a question that should probably be asked in either a .NET forum or the winsock forum. ...Show All

• SQL Server Understanding ROLAP

  We are looking at adding a real-time aspect to our SSAS cube set, to allow reporting against a relatively small but constantly changing data Our initial thought was to use ROLAP partitions and dimensions - we were under the impression that the queries would always be satisfied from the underlying relational tables. However, in our explorations we are finding that understanding to be incorrect - SSAS is in fact caching data, so it ends up returning stale data. We've configured our paritions and dimensions for ROLAP and disabled all proactive caching (we would like this solution to work with SSAS Standard Edition, which precludes the use of proactive caching). Is there something else we need to figure Are are we headed down the wrong path h ...Show All

• Visual FoxPro Will VFP6 work with Windows Vista

  My company operates a series of VFP6 runtime databases successfully in the Windows XP environment. We currenly have one PC loaded with Windows Vista. When the runtime setup is run it does not install the runtime files onto the Vista PC. Can VFP6 work in the Windows Vista environment How can this problem be overcome Many thanks in anticipation. Very hard to say. You may try to put runtime files in application path, be sure you don't have runtime files in other location and if is not running you should register dlls and try again. It worked for me but with version 7. ...Show All

• Software Development for Windows Vista Where do I get mt.exe?

  Where do I get mt.exe to join EXE and MANIFEST I have looked in my C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin directory and found nothing... Its present at multiple location C:\Program Files\Microsoft Visual Studio 8\VC\bin C:\Program Files\Microsoft Visual Studio 8\Common7\Tools\Bin C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin Surprisingly you are not finding at your mentioned location.. Regards, Vikash ...Show All

• Visual C# Import Excel Spreadsheet Data into SQL Server Database Table

  Hi All, I am trying to import data from an Excel spreadsheet into a SQL server db table though having some issues. This is the code I'm using: private void Button1_Click( object sender, System.EventArgs e) { // Connection String to Excel Workbook string excelConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Book1.xls;Extended Properties=""Excel 8.0;HDR=YES;"""; // Create Connection to Excel Workbook using (OleDbConnection connection = new OleDbConnection(excelConnectionString)) { //OleDbCommand command = new OleDbCommand ("Select ID,Data FROM [Data$]", connection); connection.Open(); OleDbCommand command = new OleDbCommand ("Select ID,Data FROM [Data$]& ...Show All

• SQL Server Granting a user permissions to create and Drop a table

  How do I allow a user (or group of users) permission to create/drop a table I have found the 'GRANT CREATE TABLE TO username' command, which will (I assume) allow a user to create a table, but how to I allow a user to 'DROP' the created table as well 'GRANT DROP TABLE TO username' doesn't work and I want the users to be able to DROP/DELETE this table (temporary table created just for printing purposes) as well. thanks See permission section of the DROP TABLE article in BOL. Permissions would have to be reassigned - they are dropped when the table is dropped. You should script all your database operations and manage script files with a source code control product. Thanks Laurentiu ...Show All

• SQL Server OLE DB Source Adapter & variables.

  Hi All, Using a data access mode of SQL Command, I have a stmt that returns one date ( e.g select max(LastChangedDate) from TblA ). I want to store the result in a variable. How do I do this Cheers, Tamim. That's much clearer Darren, thanks. The issue in running them in parallel is just about saving time - nothing else. Therefore if this isn't (entirely) realised/actualised, it's no biggy. You've captured this maxim well: '... you can force serial, but not ensure parallel...' Understood. The 4 Exec SQL Tasks each followed by a Data Flow Task seems a good way to go. Many thanks to you & everyone else for their input here, Tamim. P.S. Am enjoying 'Professional SQL Server 2005 Integration Services' - ...Show All