Fang Wang - MSFT's Q&A profile

• SQL Server Unattended installation woes

  Hi, I have tried to do a new SQL 2005 install via an unattended install script. I have tried both a modified version of the template.ini and just from the command line. The installation starts and successfully installs some of the components I have selected through the ADDLOCAL option. Unfortunately it then reports an execution error and exits. The errors I find in the install log files are as follows... SQLSetup..._Core.log: Erro ...Show All

• Visual Studio Team System TF42056: The build service could not connect .... TF30063: You are not authorized....

  This message is displayed on a client box (running VS 2005 architect) when we attempt to execute a build type. The build type is referenceing the build service on a different server. TFS is running great and check in / check out, etc works fine. However, I do not have a domain in place since this is all installed on virtual instances. All logins are local and everything works great except for this. My problem is that since the build service acco ...Show All

• SQL Server How to Update or Delete records with a SqlServer Destination

  I'm a novice to SSIS (and we've never used DTS). Writing a Control flow that inserts records worked fine, using lookups and all, but i can't find somewhere an example on how to update records of even delete records. Any suggestions .... Thx Harry Leboeuf Are you referring to the control flow If so, you can do this inside the Execute SQL task. The OLE DB Command transform is how you can play with tha ...Show All

• SQL Server JDBC: DatabaseMetaData.getURL() returns jdbc:sqljdbc://

  Hi, I'm using: Microsoft SQL Server 9.00.1399 Microsoft SQL Server 2005 JDBC Driver 1.0.809.102 Executing the DatabaseMetaData.getURL() method when database is connected returns "jdbc:sqljdbc://". The documentation for getURL() specifies that this URL is returned only when accessing pre SQL Server 2005 versions while when connected to 2005 it should return the correct URL (ex: jdbc:sqlserver://192.168.1.105:1223;databaseName=test) My question is ...Show All

• Visual Studio Tools for Office Word automation from a Web Service

  With current (i.e. pre Word 2007) versions of MSWord, there are problems attempting to use WORD automation on an unattended server. The main ones are: WORD is not thread safe. Trying to start more than one instance can crash you. This results in very limited throughput if you are trying to do higher volume WORD can open "pop-up" error dialogues at any time, effectively hanging the app until some form of intervention occurs. ...Show All

• Visual Basic Field names

  hi all. i want to know what code to use to change the name of a field (of say a checkbox) if a condition is met while the program is running. is it therefore possible to name 5 checkboxes: P1, P2, P3...P5, and then use a variable, (eg : choice) to assign functions to the fields. eg: P(choice).value = True thank-you for your help. You can't rename a control on run time. But you can change other properties. Best re ...Show All

• Software Development for Windows Vista CreateWorkflow with xml reader is giving validation exception

  I have a base workflow that I've registered as a TypeProvider Service. I want to use an xoml file to define the structure. I'm getting this validation exception with no more details. System.Workflow.ComponentModel.Compiler.WorkflowValidationFailedException' occurred in System.Workflow.Runtime.dll how can determine what is wrong here is my xoml contents. < SequentialWorkflowActivity x:Class = " BDW.Workflow.Driver. BasePipel ...Show All

• SQL Server Can I install the db In a different location rather than default?

  Hi, When creating a new database I would like this db to be created on my D drive rather than the default place.How do you do this in sql server 2005 I could not find a dialog box or something similar to point to a folder for the data and log file. Any suggestions Good that this helped, could you please mark the post as solved then Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Studio using configuration file for trace switches

  hi, i created an application and i added a configuration file in its bin folder.  this configuration file will configure the trace switch of the application. my problem is, everytime i try to run the program,   it will just be delete the .exe.config file (i named it exactly the same with the application), switch name are the same and i'm pretty sure that i'm not missing any code.  please help! thanks :) ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How do I uninstall DirectX 9c

  I am having problem with a game and their tech support needs me to uninstall DirectX 9c and Reinstall it. I have asked EA tech support on this on an earlier occasion and this was the reply I got. 1. Forget about it. 2. Find a new hobby. 3. Microsoft sucks so dont try to fix their stuff. 4. The only problem is your brain, if you try to forget about it and find a new interest in life that does not involve this stupid DirectX, you will be OK. ...Show All

• Windows Forms ClickOnce Fails with "Value does not fall within the expected range."

  I have a ClickOnce-deployed application installed in offline mode across a range of Windows 2000/XP machines on my network. I now receive an 'Application cannot be started. Contact the application vendor.' error message when I attempt to run the application on my development machine. (It works still on the production machines.) I've run mage -cc, and renamed the '2.0' directory to '2.0x' to ignore its presence. Add/Remove Programs still shows it ...Show All

• Visual Studio Winforms ReportViewer control does not work with ClickOnce

  I have a major problem.  I want to use ClickOnce to deploy a business app that uses reporting services (with the new reportviewer control for winforms).  However, the majority (not all) the machines that I try to install the app on complain about a missing assembly "ADODB 7.0.3300" that must be installed in the GAC.   When I reference the Microsoft.ReportViewer.ClickOnce assembly I get a new dependency in my clickonce manifes ...Show All

• Visual Basic Simple method problems

  I was wondering if someone could give me a fuction pointer about how to complete this   Sub Mult (ByVal num1 As Integer) Dim a As Integer a = num1 * 2 Console.Write(a)   its suppose to take my numbers and multply it by two but its not getting me the right  number any help Sub Mult (ByVal num1 As Integer) Dim a As Integer = num1 * 2 Console.Write(cstr(a)) end Subroutine   or ...Show All

• Visual Studio Team System CurrentUIThread with ToString() and Parse() et al.

  A topic came up on one of the lists today regarding when/where to use CurrentUICulture over CurrentCulture. One of things that came out of that was what to use where IFormatProvider is required. The FxCop help for SpecifyIFormatProvider ( http://tinyurl.com/n6kp6 [1]) does point out that CurrentCulture should be used in this circumstance (haven't seen this recommendation in any other place). But, FxCop does not provide any warning for the ...Show All

• SQL Server Max Worker Threads and User Connections

  Hi we run SQL 2005 Enterprise on W2003 Enterprise 32 bit on 8 dual core Xeon 7020 with 32Gb RAM. The max worker thread settings is 0 now. But 3d party consultancy which monitors our servers on the POP is suggesting to make this figure to be 1200. They said - there are 1000 connections at peak time. I am going to check if it is correct... But my question is - is it proper thing to do to set worker thread number that high (BOL says - MS ...Show All