gary6769's Q&A profile

• Visual Basic cannot find file needed for lesson02

  Anyone who's gone through the video lessons, please tell me where the 'Lesson Resources' are located/downloaded from...I'm not sure whether they were supposed to be included with the initial download or if they're available elsewhere. Thanks for any help Hi, I'm quoting these from http://lab.msdn.microsoft.com/express/beginner/ Lesson 2: Creating a Windows Application User Interface This lessons walks through ...Show All

• SQL Server Running 2000 and 2005 Reporting services on a single server

  I've got SQL server 2000 running on a W2003 server and I want to install SQL Server 2005 and reporting services.  Is there a way to run both of then.  I'd like to have access to both for development purposes. Thanks, Just be sure to install in a different instance. I am running both on same server.  SQL 2005 instance is referenced by localhost\SQL2005 & http://localhost/reportserver$sql2005 ...Show All

• .NET Development Strange behaviour of JET Database Engine

  Hi, JET says, that my INSERT INTO-command, which has been generated by a CommandBuilder, has a syntax error. Is it possible to find out the SQL-command, which is sent to JET from a DataAdapter Thanks! The problem is that there isn't any checking for reserved words when the SQL statements are auto generated. Both Name and Password are Jet reserved words. You can rename them in your database table or enclose th ...Show All

• .NET Development Can't do a rollback after Update

  I'm using the August CTP of 2005, and ran into the following situation. I have the following code snippet to update some tables in a SQL Server database. SqlTransaction trans = nDestination.BeginTransaction(); try {   //Set the transaction for my data adapters   SetTransaction(trans);   daPDMSPatient.Update(dsDestination.PDMSPatient);   daProtocol.Update(dsDestination.PDMSProtocol);   daPatientProtocol.Update(d ...Show All

• Visual Studio Team System Team System - Website Under source control

  I have the Team Build Configured and I am also able to start the build from any of the client machines. The library, console, windows services and application are all compiling with out any errors but when it comes to compiling websites I am running into issues. All of these projects are under Team System source control. The website has Project references to other library projects within the same solution but the team build does not se ...Show All

• SQL Server Failed to acquire connection / The AcquireConnection method Failed

  I am running the Sept CTP.  I have created a SSIS package that pulls data from a text file and inserts into a database.  When I run the package on the DB server it runs fine.  I have moved the package the the web server (we are attempting to kick off the package from a web site) and we get connections errors. We are running the package using dtexec from the command line. The 1st time we got The AcquireConnection method call to ...Show All

• Visual Basic running cmd.exe using System.Diagnostics.Process

  Hi guys, I am running cmd.exe to start a executable from a web application.Howvever, i need to input 2 more parameters for the account and pwd as shown below. CMD.EXE c:\Documents and setting\desktop>perl scriptest.pl test.txt account(domain/user): xxx password:xxxx 'User enter perl scriptest.pl test.txt, then cmd.exe will prompt for account and password for user to enter.  How do i let the web application enter the account and pass ...Show All

• Software Development for Windows Vista Dec CTP SDK configuration error

  I have Win XP with SP2 on my system. I tried installing the Dec CTP of WCF. I have successfully installed WinFX runtime components. However, when I try to install the SDK, I get the following error: Windows SDK could not be configured, see the 'Installing the SDK' section of the Samples\Setup\HTML\ConfigDetails.htm document for more information. How do I get around this problem Hi Venkas, P ...Show All

• Visual Studio Tools for Office How to get/calculate the character width in MS Word?

  BEFORE a lot of text strings are written to a Word file using Office Automation, I need to know the width of each string. Is there any way to do it Please note that office automation cannot be used, because the Word file is NOT available yet. Thanks. It's not really a VSTO related question, but besides that I think you are not in a position where you can determine the width of the string before knowi ...Show All

• Software Development for Windows Vista Replication and correlation

  Can anyone tell me whether or not, in Beta 1.2, it is possible to use the replication shape to invoke a method that initialises a correlation set and then waits for the correlated event. There are lots of business scenarios that call for functionality like this - i.e voting scenarios, approval scenarios etc. You can obivously do something like this using the parallel shape but you need to know at design time the number of participants in the ...Show All

• SQL Server SP permissions under SQL Server 2005

  I am just migrating to SQL Server 2005 and I am having difficulty figuring out how to do some tasks that were easy under SQL Server 2000. Specifically, I am not sure about object permissions. (This is what I did for SQL Server 2000) For database access by my web application, I added a SQL login for the IIS_WPG group. I then added a database user (name ASPNET) associated with this database login and give it only datareader and datawriter ...Show All

• SQL Server sql auto format is annoying

  Sql auto format is annoying and even more annoying   From a data connection you can right click -> new query   diagram and criteria pane (pain) always come up.   I don’t want them or need them.   Make them go away.   Also when you run your sql it reformats the sql.   What’s up with this annoying feature.   I can’t stand editors that re-format your code for you.   Help me make it stop d ...Show All

• .NET Development Error starting new project in VS 2005 Beta 2

  When I try to create a new web site, I get this error the number separator information specified in the numberformatinfo in ambiguous for parsing and the project isn't created. I can create new single files but no project. Anyone knows why Thanks Please post a bug report on the Microsoft Product Feedback Center . ...Show All

• Visual Studio Express Editions Help with SaveFileDialog???

  Hi Ladies and Gents, Please can you help with the below The SaveFileDialog is appending to my text files and I can't find a way to get it to overwrite whatever existing text is in the save file. Please can someone advise me Private Sub SaveToolStripMenuItem_Click_1( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SaveToolStripMenuItem.Click Dim Save As New SaveFileDialog() Dim myStreamWriter As ...Show All

• .NET Development Easiest way to make a copy of a datatable

  I am using VS 2005 with SQL Server as the backend. I have a winform with a master and a related grid for a detail. The grid may contain 2 or three thousand records. The form contains Quotes for work done for us. The user wants to be able to copy a Quote and its details easily. Both the master and the detail have AutoIncement fields as their keys. What is the easiest way to copy a dataset, or a table in a dataset Getting the data out of th ...Show All