SweptSquash's Q&A profile

• SQL Server Is capturesql the only way to script a drop using smo?

  Is capturesql the only way to script a drop using smo You can set the ScriptingOptions.ScriptDrops to true and then pass it to Script(ScriptingOptions). This will return you the script to drop the object. Thanks, Kuntal ...Show All

• Visual Studio Team System Cannot start build

  When I try to start a build on our server, the response back is 'Failed to retrieve data from the server. Please verify the network connection and try again'. I tried reinstalling the TFS build software and that did not help. I also checked the event logs for any errors, but there were no events from the build. There were no changes made to the server that I am aware of that would have caused this to start happening. This happens both in Visual Studio and with the TFBuild command line on either the build server or my local PC. Are there any logs I can look at or tracing that can be done to figure out what is happening or has anyone else seen this problem Thanks in advance, Joe G. See the post by Patrick ...Show All

• Visual Studio Express Editions Issue with Option Strict and use of Exponent

  New to the World of Programming in general, and new to VB. With thta stated I am having a bit of an issue with VB, since I am new to this I am not sure why the following code has issues: Public Class Form1 Public Sub Form1_Load( ByVal sender As Object , _ ByVal e As System.EventArgs) Handles Me .Load Dim Base, Power As String Dim Result As Integer Base = InputBox( "Enter a Base Number" ) Power = InputBox( "Enter Power Number" ) lblBaseNum.Text = Base lblPowerNum.Text = Power Result = CInt (Base) ^ CInt (Power) lblPowerResult.Text = Result.ToString End Sub End Class Speci ...Show All

• Windows Forms alert a user "To Save changes or ignore changes" when editing records in VB 2005

  How can i alert a user "To Save changes or ignore changes" when editing records in VB 2005. I need to display a Message Box saying" Do you want to save changes or ignore changes --------YES NO...............buttons I am using DATASETS, TABLEADAPTERS Alex im not sure as I can't see a "global" variable which would indicate this. I guess you can set a bool value some place to check if the records have been changed The cellvaluechanged event will fire if a cell value has been changed, so you could implement this, then set the bool value to true to indicate if the data has been changed, then according to this, show your messagebox http://msdn2.microsoft.com/ ...Show All

• Windows Search Technologies Where is Microsofts form fill and password tool?

  Where is the form fill tool by Microsoft If anyone has upgraded to the latest version of Windows Desktop Search tool you will notice that the form fill and password saver tool is GONE! Don’t get me wrong this is the best desktop search I have ever seen but I need a good password saver. I don’t want any of the tools suggested on the IE7 add-ons page. All of the suggestions are either overkill or just plain weak. Microsoft - Please build a tool for Desktop search, you have sold us all on the new sexy look of the LIVE user interface don’t make us settle for some 3rd party cheesy apps. Loyal Microsoft fan & Director of IT for Mid sized a company SgtMauler if you are still using Googles search tool check this out! ...Show All

• Software Development for Windows Vista MFC CSocket problem in Vista

  Dear Newsgroup, I've got the problem, that CSocket::Create gets the error 0000273F (german error text: "Es wurde eine Adresse verwendet, die mit dem angeforderten Protokoll nicht kompatibel ist.") if the program uses MFC DLL in a shared library with Vista Beta2 (Build 5384). To reproduce the behaviour: - create MFC project (I've done it with VC6) - use MFC in a shared library (_AFXDLL defined!) - activate Windows Sockets Put the following code into a function: ----------------------------------------------------------------- CSocket *s = new CSocket (); if ( 0 == s->Create ( )) { LPVOID lpMsgBuf; DWORD dwErrorNo = GetLastError(); if ( 0 == dwErrorNo) return; FormatMessage ( FORM ...Show All

• Visual Studio 2008 (Pre-release) Cannot run August CTP Samples

  I installed the August CTP, after the LINQ Preview. Everything installs correctly. I opened the solution in VS2005 and built it, everything compiled. I mapped a virtual directory to the installation folder of the webapp sample (on my machine - 'C:\Program Files\Microsoft SDKs\ADO.NET vNext CTP\Samples\CSharp\WebAppSample') The first time I try to access the sample it takes a long time, then errors out to this : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) Descr ...Show All

• Visual C++ VC++ 6.0 & VC++.Net

  I have been programming in VC++ 6.0 for some time. I recently migrated to .NET platform with C#2.0 & VB.NET 2.0.... What I want to know is that : 1) Will VC++6.0's MFC code will run as it is in VC++.NET 2.0. 2) Also, are VC++6.0 MFC's classes and VC++.NET 2.0 MFC's classes same, or have they evolved in the .NET version in any way.... Also, have any new classes been added to the .NET MFC's library That was absolutely new for me, and have raised a few more queries... 1) I have heard of both Managed C++ & VC++.NET... Are they really the same thing, or are they two diferent flavours of the language (I thought them to be synonyms ) 2) Now, when you talk about C++ (the C99 standard based) & C++/CL ...Show All

• SQL Server Is ProcessAdd done within a transaction mode?

  Is ProcessAdd done within a transaction mode This question is very basic. When you do a ProcessAdd, is it within a transaciton mode I mean, if the ProcessAdd fault and stop when it meets a mistake, the records before the midstake will still be in the cube or not. Thanks. I think you need to implement custom script task, and insert a piece of AMO code which starts transaction using Server.BeginTransaction method (see http://msdn2.microsoft.com/en-us/library/microsoft.analysisservices.server.begintransaction.aspx for documentation). Then, when you are ready to do processing, you will need to use AMO again in order to rejoin the same transaction. I ...Show All

• SQL Server DataBase Connection for VS2005 C++ for Devices

  Dear all: Is there a way to connect to a SQL Server mobile using native code C++ I don't want to use the Compact Framework to access Data. Does anybody knows how to connect to an SQLite database from VS2005 c++ for devices Thanks. Alfredo Mendiola Loyola Lima Peru Yes you can connect to SQL Server Mobile database in C++ using OLEDB API. If you are using VS 2005, then there is a Northwind OLEDB Sample that can help you on how to program in C++ using OLEDB. Please note that Northwind OLEDB sample would be installed in %ProgramFiles%\Microsoft SQL Server 2005 Mobile Edition\Samples Thanks, Laxmi Narsimha Rao ORUGANTI, SQL Server Everywhere, Microsoft Corporation ...Show All

• Visual Studio Express Editions Totaling a table

  I want to be able to have the program calculate the total of a column of values in a table. How would I go about doing this I played around with this for a while, and cannot see a way to do this... Any help would be greatly appreciated. Thanks, -Matt Thank you for your help. This is probably a stupid question, but I have the table built and everything, but how do I make a query I clicked on the appropriate TableAdapter, and there is an "Add Query" option, but when I open that window I'm not sure what I'm looking at. As you can see this is very new to me. Thanks again for all the help, I greatly appreciate it. -Matt ...Show All

• Visual Basic how can i do with " in vb

  how can I do with " in vb , I want replace " to & email:huangzhixing@hteb.com well i obviously know that :) but besides gaining you a millesecond on processing time or what-not, what is the actual upgrade to this function, why is is better to use. you gotta remember, being a coder means sometimes laziness is the name of the game, and replace takes less effort to write :) ...Show All

• Visual Studio Team System TFS and Active Directory

  Does anyone know why TFS cannot be installed together with AD Here's a thread from earlier this year on the topic- http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=287650&SiteID=1 Cheers, Adam ...Show All

• Smart Device Development Treo 700wx Application Development in Visual Studio 2005 Visual Basic

  Hello, Ok I have written a lot of PPC apps with visual studio 2005. Now I am looking to format my apps to fit the Treo 700 wx screen 240x240. If I do Smartphone app it is about right size but lack A LOT of tools. If you use Windows Mobile 5.0 Pocket PC the form size is 240 x 268 not including menu bar. I have a few apps I am going to sell on Handango and sites like that for the Treo once I convert from Windows Mobile 5.0 Pocket PC to fit Treo screen size. Does anyone have any advice, links or samples that could help me out Any suggestions are always appreciated. Thanks in advance. I'm not sure what exactly you are looking for - but this link might help - http://msdn2.microsoft.com/en-us/library/ms229649.aspx ...Show All

• SQL Server x64\ Win XP (32 bit) edition -> can't install sql 2005 client

  One user has an HP x64 Athalon box and IS installed Windows XP, 32 bit edition, on it.  Today I installed the sql 2005 x86 client on this box, but the install came back saying that the "minimum hardware requirments" were not met.  I need to know exactly what has not been met. Where can I look TIA,   Barkingdog P.S. When I tried to install the sql 2005 x64 clinet on the same box the OS replied "not a valid 32 bit app". Well, duh!     You can find the minimum hardware/software requirements for SQL Server 2005 at http://msdn2.microsoft.com/en-us/library/ms143506.aspx . 64-bit SQL Server 2005 requires 64-bit OS. In ...Show All