Pascal Frey's Q&A profile

• Visual Studio Team System Problem with the TFS - MS Project integraton.

  We have a problem with the integration of TFS and MS Project 2003. I manage to set the connection and import the Work Items. Publishing/refreshing also works well but when I save the .mpp-file and close MS Project, the connection is lost. If I compare with Excel, the connection information is stored in Propertes/Custom when importing the Work Items and more connection information is stored when the file is saved. The same goes for MS Project when importing Work Items and saving it but without closing the MS Project-file. However, the connection is lost and the information in Propertes/Custom is erased as soon as the file is closed. I can se from microsoft forums that this is a well knows problem but I have not seen a soluti ...Show All

• .NET Development Binary Serialization of CollectionBase

  I have just hit a brick wall whilst building custom binary serialization for my object graph. The issue I am having relates to the Deserialization of a collection. The "Designs" collection inherits from CollectionBase. The items stored in the Collection of the type "Design" The class "Design" Inhertis "PhysicalJobEntity" which Inherits "JobEntity" I inherit the class "Design" to create any type of object whether it be a truck, house or can of drink. So to paint a clear picture I will use an example. I create three classes "Truck", "House" and "Drink". All of these inherit from design. I run the app and create 1 instance of each of these cl ...Show All

• Visual Studio 2008 (Pre-release) September CTP VPC on Virtual Server R2

  Hi, i successfully installed the base CTP. But now im trying to set the virtual machine up for the september CTP. Im using Virtual Server R2 not VPC so it doesnt prompt me for the base but just throws an error saying The parent virtual hard disk "E:\VPC\TimeBombedBase\Base01.vhd" for the differencing virtual hard disk "D:\VMachines\Orcas\VSSep2006CTP.vhd" does not exist. Please reconnect the differencing virtual hard disk to the correct parent virtual hard disk Does anyone know what the deal is in the VMC file theres no mention of the base and theres also some hardcoded pointers to some VMClean.exe. TIA, Benjy  Folks, As a followup to my previous post (using the ...Show All

• SQL Server How SQL Server deals with on the occasion if I imput unicode characters into a varchar column?

  Hi all, I want to know how SQL Server deals with it if I imput unicode characters into a varchar column Will it truncate or do something else Thanks! Hi Robert, SQL Server implictly converts the unicode character to the Varchar type,If the unicode character is same as the (say English) the SQL Server installed Language ( say Language) and there will not be any data loss.If the unicode character is some other language there are chances of Data Loss Regards, Samsudeen B ...Show All

• .NET Development get columnscollection from table

  Is there an easy, memory efficient, way to retrieve a columnscollection object from a specified table The regular way would be just to do: SqlConnection con = new SqlConnection("..."); con.Open(); SqlDataAdapter adapter = new SqlDataAdapter("...", con); DataTable table = new DataTable(); adapter.Fill(table); But for my current project I do not have control over the query string and the query string could also be a stored procedure, which would then be passed as a SqlCommand object. So I am forced to use an SqlDataReader when doing what I need to do. So is there a way to get column information from an SqlDataReader that includes Default Values, Data Types, etc... for each column   Preferably I would like to get a pointer to the actual ...Show All

• SQL Server Association Rules algorithm [support,confidence]

  In assotiation rules each rule has a [support, confidence] part. In Microsoft Association Rules there is a [probability,importance] measure in each rule and importance can be greater that 1. I found the following in msdn but i'm not sure if i understood correctly. MINIMUM_PROBABILITY: Specifies the minimum probability that a rule is true. For example, setting this value to 0.5 specifies that no rule with less than fifty percent probability is generated. The default is 0.4. MAXIMUM_SUPPORT: Specifies the maximum number of cases in which an itemset can have support. If this value is less than 1, the value represents a percentage of the total cases. Values greater than 1 represent the absolute number of cases that can contain the items ...Show All

• Windows Search Technologies Windows 2000 - vantagens

  Ola! Gostaria de saber que vantagens o Windows 2000 trouxe em relacao as versoes anteriores. ...Show All

• Visual Studio Express Editions How to get Function codes list for CTL_CODE

  Hi, I wish to get the Function codes list for CTL_CODE, but I don't have any idea where to download it. Can somebody help me For example: #define CTL_CODE ( DeviceType, Function, Method, Access) Function <-- 0x0 - 0x2047 are reserved for Microsoft Thanks Check the following headers: <wdm.h> <ntddk.h> Also check these pages: http://msdn2.microsoft.com/en-gb/library/ms904001.aspx http://www.osronline.com/DDKx/kmarch/irps_7j53.htm ...Show All

• Microsoft ISV Community Center Forums Capture Hyperlink values on open MS Access VBA

  Hi All, I've been doing some VBA stuff for a while and have run into a problem and I'm not sure if there is a simple answer, maybe I'm just going blind on this. I have a database system that logs a serires of quality assesments, and so far all is good, but the problem I have is with the automated link geraneration response capture. To explain; The system held in Access XP will automatically score each record on a set of rules, and is they fail the pass mark, the person checking the scoring will click the button to send an email to the person whom will need to deal with this. There are two disticnt way I can deal with this, the first is to create a shortcut, embed this in the email along with /CMD open arguments, though the cre ...Show All

• .NET Development Problem with SQL Server 2005 and IIS 6.0

  Hello, I am having problems with my system configuration. I am trying to access a SQL Server 2005 database from a C# .NET web page, but I keep getting this error, " Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'". I am using windows authentication. The SQL Server resides on one server and my web server is on a different server. If I run the both the web server and SQL Database from within the same server it works fine, the problem comes when I separate the servers. I am running Windows Server 2003 on both servers, MS SQL Server 2005, MS Visual Studios 2005, and IIS 6.0. Here is my Web.Config file: < xml version = " 1.0 " > < configuration xmlns = " http://schemas.microsoft.com ...Show All

• SQL Server SQL Server 7.0 shows a suspect database after attaching it in SSME?

  Hello, I have a database that resides in SQL Server 7.0 that I can attach in Microsoft's SQL Server Management Studio Express and I can see all the tables from the database in that program. My problem is that when ever I re open SQL Server Enterprise manager, the database that I attached to SSME, shows up as Database(Suspect). Now I am unable to view my tables in that database. Can anyone tell me what causes this, and how I can resolve that issue I need to have my sql server database, and sql server express edition database present in SSME because I am doing an import of data from SQL Server 7.0 to SQL server express. Also, if there is another easier way to import data from SQL Server 7.0 to SQL Express edition, I would like to ...Show All

• Visual Studio Express Editions mfc42d.lib(MFC42D.dll) : fatal error LNK1112: module machine type 'x64' conflicts with target machine type 'X86'

  Hi everyone, I'm trying to rebuild a project, which was constructed in the VC6++ IDE. Now I get this error: mfc42d.lib(MFC42D.dll) : fatal error LNK1112: module machine type 'x64' conflicts with target machine type 'X86' Could anyone help me to get rid of this error Many thanks! Express doesn't come with MFC. Are you using MFC that came with the Platform SDK It can only be used on 64-bit builds and OS... ...Show All

• Visual Basic Retrieving Large Amounts of Data From a Dataset and Writing to a File

  I have written a small application that takes a large amount of data from a ADO.NET dataset and writes it away to a text file (comma delimited). Right now I just go through the dataset and write each row away to the text file. As you can imagine, this takes an awfully long time. Can anyone recommend a better way of writing a huge amount of data stored in a dataset, into a text file (has to be comma delimited). Thanks in advance. ADO.Net provides the functionallity to connect directly to textfiles: www.connectionstrings.com OLE DB Delimited columns Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = c:\txtFilesFolder\ ; Extended Properties = &qu ...Show All

• SQL Server SQL Statements with inner join too slow in 2005 runs faster in 2000

  Hi all, I'm desperately looking for answers to following issue that we are currently experiencing on our test server. We inheritted one of our business app from another company. We replicated exact same hardware environment. The only difference is we are using Windows 2003 server and SQL Server 2005 whereas the other company who wrote this app is using Windows 2000 server and SQL Server 2000. We are experiencing huge performance problems running few types of queries. The Stored Procedure that takes 7 minutes to run, exact same code with same data takes about 45 minutes to complete on our end. I have narrowed it down to one view that is called in a trigger that inserts rows into a specific table. Below is the trigger code and the vie ...Show All

• Software Development for Windows Vista Problem with IShellFolder::GetAttributesOf

  Hi, In vista RC1 I'm seeing a really odd problem with IShellFolder I have some fairly simple code which does something like: sfg = SFGAO_FOLDER|SFGAO_FILESYSTEM|SFGAO_BROWSABLE; pShellFolder->GetAttributesOf(1,&idl,&sfg); if(!(sfg&SFGAO_FILESYSTEM)) { continue; } What I'm observing is that in RC1 SFGAO_FILESYSYSTEM is only ever set for shared folders! On all other OS's it works as expected (and documented). I'm guessing this is an RC1 bug - where can I report this to make sure it's fixed for the release Tony This appears to still be happening - just tested on the final production Vsita build. I don't have time to do any further debugging until ...Show All