VBProEd's Q&A profile

• Visual Studio Team System Project Creation Problem: Unable to connect to the Windows SharePoint Services

  After installing TFS Beta 3, everything seems ok. Can connect to it, manage it, etc. However I cannot create projects sucessfully. When I try to I get this (excerpt from log): Event Description: TF30162: Task "SharePointPortal" from Group "Portal" failed Exception Type: Microsoft.TeamFoundation.Client.PcwException Exception Message: Unable to connect to the Windows SharePoint Services at TEAMSYS1 Exception Details: The Project Creation Wizard was not able to connect to the Windows SharePoint Services at TEAMSYS1. The reason for the failed connection cannot be determined at this time. Because the connection failed, the wizard was not able to ...Show All

• SQL Server Stored proc, strange error

  Hi There I have the following stored procedure. CREATE PROC [dbo] . [CREATE_MERGE_XREF] @srcBu varchar ( 5 ), @destBu varchar ( 5 ), @operatorId varchar ( 30 ) AS SET IMPLICIT_TRANSACTIONS OFF SET TRANSACTION ISOLATION LEVEL SERIALIZABLE BEGIN TRANSACTION SET NOCOUNT ON ; DECLARE @SqlCommand nvarchar ( 500 ); DECLARE @vcNewOrderNo varchar ( 15 ), @vcOrderNo varchar ( 15 ), @vcDatetime varchar ( 26 ); DECLARE @orderNo decimal ( 15 ), @numNewOrders decimal ( 15 ), @newOrderNo decimal ( 15 ); SET @SqlCommand = 'CREATE TABLE TMP_DBTR_MIGRATE (SRC_BU VARCHAR(5),DEST_BU VARCHAR(5),CUST_ID VARCHAR(15),ORDER_NO ...Show All

• .NET Development SqlDataAdapter

  Hello I've got a static class DB. In a constructor I create SQLCONNECTION object - called 'connection' with specified CONNECTION_STRING. In this class i have got 3 methods(among others): GetData GetData is firing in some other class in a loop. DataTable getData() { ..... connection.Open() SqlCommand command = new SqlCommand( procName, connection ); SqlDataAdapter dataAdapter = new SqlDataAdapter( command ); .................. connection.Close() } Is it efficiently way What is the better solution for that Thanks Assuming you have not disabled connection pooling in your connection st ...Show All

• SQL Server Webapplication problems with MiningModelViewerControl

  hi, all When I want to add Microsoft.AnalysisServices.Viewers.MiningModelViewerControl to my web application, the following error appears: cannot convert from 'Microsoft.AnalysisServices.Viewers.MiningModelViewerControl' to 'System.Web.UI.Control' I want to use the MiningModelViewer in my web application. Is there any solution to this problem I wonder is there any other web application controls for the MiningModleViewer And where can I find the related documents I can not find any resource about this problem anywhere. Thanks. [copying BogdanC's response from the newsgroup] The viewers you are trying to ...Show All

• SQL Server Data Comparison Question

  I am not sure if this is the correct forum for my question but I will give it a shot. I want to be able to create a dataset from an ODBC datasource and compare it to existing data in my SQL DB. If there are changes (inserts/updates/deletes) I want to raise seperate events for each row state. Is this possible to do with SSIS/DTS or am I on the wrong track with what I am trying to do Have a look at this and see if its any help: http://www.sqlis.com/default.aspx 311 -Jamie ...Show All

• SQL Server Working with data in a mobile solution

  Im doing a project using VS2k5 and sql server2k5. Its a mobile project and this is my first time working with SQL and Visual Basic. I need to know how to add data to my database from the windows form.I have however been able to use the tableadapters and some sql statements to read data from the database in my forms. Can anyone here help me The concept I think you are chasing down is called Data Binding in the Microsoft .NET world. The technical coverage of Data Binding in the .NET Compact Framework can be found here: http://msdn2.microsoft.com/en-us/library/9k8yax26(VS.80).aspx Many controls in the . ...Show All

• Visual Studio Express Editions PSDK install fails

  Error 1329. A file that is required cannot be installed because the cabinet file C:\Windows\Installer\MSI504.tmp is not digitally signed. This may indicate that the cabinet file is corrupt. (C:\Windows\Installer - not a valid directory btw, must be part of the PSDK install ) This was the march 06 x86 build. Running xp sp2 build 2600. error was thrown while installing this file... C:\Program Files\Microsoft Platform SDK for Windows Server 2003 R2\src\atl\atl.cpp This was the web download, so after the installer rolled-back the entire install all I was left with was the 300k installer file. 300+megs of download *poof* gone. Tried the down ...Show All

• SQL Server append data from a text file

  How can I append data to an existing SQL Express table from a text file The file contains over 50MBs of data. This will be a recurring task so naturally I would like to automate this. I am familiar with programming VC++ and VB but am not sure where to begin. Since it's a larger file, you could use the BULK INSERT command: http://msdn.microsoft.com/library/default.asp url=/library/en-us/tsqlref/ts_ba-bz_4fec.asp Or you could use bcp from a command line: http://msdn.microsoft.com/library/default.asp url=/library/en-us/coprompt/cp_bcp_61et.asp Hope this helps, Josh Lindenmuth ...Show All

• SQL Server Adding Drop Down List in Report

  I am using Visual Studio 2005 to create a report from a OLAP cube. I am building a drop down list for user to select the desired branch. My mdx query as follow: with       member [Measures].[ParameterCaption] AS '[Company].[Branch].Currentmember.Member_Caption'       member [Measures].[ParameterValue] AS '[Company].[Branch].Currentmember.Uniquename' select      {[Measures].[ParameterCaption], [Measures].[ParameterValue]} on columns,     {[Company].[Branch].ALLMEMBERS} on rows from [Profit And Loss] I would like to add a blank row in the result set, such ...Show All

• Visual Studio 2008 (Pre-release) Use IndigoListener.exe in Non-Vista OS?

  In the SDK Documentation, in section "How To: Host a WCF Service in WAS", it is said "The WCF mechanism for receiving requests over non-HTTP protocols is hosted inside of IndigoListener.exe." Is it supposed to use IndigoListener.exe in Non-Vista Operating System If I want to build a windows service to activate services in diferente protocols (including non-http) what is the best approach for non-vista Thanks in advance Sorry that the SDK documentation isn't really clear on this point. Bear with us, we're working on that. SMSvcHost.exe (formerly IndigoListener.exe) is t ...Show All

• Visual Studio 2008 (Pre-release) How to make an interoperable peer to peer appliation ?

  Hi, I would like that an java app communicate with an windows app via indigo p2p. But, I see on PDC05 Sildes that netPeerTcpBinding is not interoperable. Should i use WSDualHttpBinding instead I dont know if it's the solution... Currently, im based on the P2P Drawing exemple. I really need help !!! Thanks The P2P binding is not interoperable as you say (and we said). The P2P binding sits on the PeerChannel and that contains all the networking magic, so choosing another binding will not help. ...Show All

• Windows Forms Drage and drop image into imagebox.

  hey, can anyone tell me how to make it so I can drage a image into a image box What I want is so once you click on the image it stays there but creates it self to be dragged in to imagebox59 and it will center it automaticly to make it fit perfectly... It is a program that will let you make emotion icons, and I need it so you can do this stuff...so thanks   I using Visual Basic 2005 express I found a example made by microsoft so I have that now, but I dont know how to make it so that if you right click the image box then it will delete the newest layer in the image, this is a emotion icon maker so, it will over lap ...Show All

• Windows Forms Click event in child controls

  Hi everyone, I have a User Control and of course it has child controls on it. Most of them are created dynamically. I need my user control to handle situation when i click on it (no matter where i clicked or which control was under the mouse). What can i do   PS: handling user control's "child control added" event is a bad idea in&n ...Show All

• SQL Server Encrypted password in DB and reused later

    Hi guys... My question.... I built an vb.net app that set some parameters and runs a store proc. Besides, the vb.net app creates an user with admin rights, his credentials: username and password are stored in DB. I thouth to encrypt password with hash + salt method. The problem.... Hashing password means that they are not decrypted ...only compared ..and here the problem....I would like to reuse this password to be used in the addlinked server store proc and other sql statement. How can I Manage encrypted password to be used later... thank for any suggestion.... ...Show All

• Visual Studio Team System How to add new project alert types

  There are four project alert types defined in TFS: My Work Items are changed by others Anything is checked in A build quality changes A build completes How do I add new types for team members to select For example, it would be particuarly useful for the team lead to know if "Any work items are added or changed" Thanks Bob Check out this post: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=18434&SiteID=1 Hope this helps! ...Show All