David McGraw's Q&A profile

• SQL Server Getting Access Denied To FileName Error When Using the Execute Sql Task (With File Connection) into a Foreach Loop Container.

  Hi ALL, Getting Access Denied To FileName Error When Using the Execute Sql Task (With File Connection) into a Foreach Loop Container. Please Note : I have a folder containing .sql files. I have to dynamically loop through the files and send them as a File connection Folder to the Execute Sql Task. When I run this Package I am getting the follwoing error : [Execute SQL Task] Error: An error occurred with the following error message: "Access to the path 'C:\Projects\Fuzzy Lookup DataFlow Example\Scripts' is denied.". Also I have logged in to the machine as Administrator and to Sql Server with sa. Please help. Thanks. Regards, Salil How are you executing the package . the error is clear, the a ...Show All

• Visual Studio Tools for Office VSTO Excel add-in only working in development machine

  Hi, I am creating a Excel 2007 VSTO COM Add-In using VSTO 2005 SE . It runs perfectly fine when I build it and run the in development computer having VS 2005 . However, when I try to install the setup.exe or .msi file for the same addin in the client machine or Virtual PC having the following installed: 1. VSTO Runtime - Shipped with VSTO 2005SE 2. Office 2007 3. .NET 2.0 Framework it does not seems to load . I have done : 1. caspol settings to make it Fully Trusted . 2. set vsto_suppressdisplayalert=0 and run excel.exe from cmd ......Same Results .... I get the following error " Not Loaded. A runtime error occurred during the loading of the COM Add-in." It has been over a week now that I am str ...Show All

• Visual Studio 2008 (Pre-release) debugging WCF service in IIS 7

  How do you debug a WCF service hosted in IIS 7 in Vista I turned on Windows Authentication under IIS/WWW Services/Security, and have set the service up for Windows Authentication in the IIS manager. I can attach to the w3wp.exe after hitting the service in a browser ( https://ferrari/CommerceServices/TestService.svc ) but I get "The breakpoint will currently not be hit. No symbols have been loaded for this document." Am I attaching to the right process On a side note, is there any way to get F5 debugging support working for IIS7 hosted services Thanks Hello, You're attaching to the right process, so it seems that the problem is just a debugger configuration issue: symbols path. Try ...Show All

• SQL Server SQL 2005, SSL - certificate request, ports

  I would like to use SSL on SQL Server 2005. With SSL, is all traffic from the client to the database on port 443 Or are other ports needed With Windows Certificate Management Snap-in, a request for a certificate assumes that there is a local Certificate Authority. I don't have one and it is my understanding that I should buy a third party certificate to avoid a man in the middle attack. With IIS there is a certificate request process. Is there something similar I should use with SQL Thank you. You don’t need to change the port used by SQL Server. SQL Server and your client will negotiate the usage of encryption during the handshake steps of the communication (before authenticating the cli ...Show All

• Visual Studio Team System ManualTest.mht - where is it?

  I'm a sw developer who needs to document some manual tests. Where is the manualtest.mht file located I've looked in my TeamExplorer\Documents\Test folder, but I only have the TestApproach.doc available. Thanks - Jennifer Hi Jennifer Yes, if you want manual tests (and other test types such as generic tests, and load tests), you need either the Tester version of VS, or Visual Studio Team Suite, which includes everything. Thanks, David Gorena Elizondo [MSFT] VSTS ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Audio hoax

  I was just wondering whether the XNA framework somewhat more than using its internal icky audio engine based on prefabbed XACT packages, like writing PCM data directly to a buffer I'm not very far into game programming as of yet, but to me the use of XACT seems like a superfluous step in the work flow of a creating a game, or just an additional level to a game. Correct if I'm wrong, I've just read the documentation. First of all, wave banks, cues etc. can only be created within the XACT authoring tool, hence no possibility for integration other than using what's created in the tool. Second, apparently no reflection or discovery can be made on XACT packages in your client code to discover cues. Scenario: A level editor in which you ...Show All

• .NET Development Tell if network is encrypted?

  How can I tell if the current network is encrypted Thanks, You need to be more explicit. What do you mean tell if the network is encrypted Are you referring to a specific connection being enrypted via SSL or If IPSec is enabled or . Some more detail in the question would help. ...Show All

• Visual Studio Accessing Crystal reports without .net being installed

  Hi all, I have developed a windows application using vb.net which displays crystal reports. Now I have to run this .exe in another system which does not have .net installed. Is this possible ..If 's' what are the files that have to be exported to that system.... Please can anybody help me out .It's very urgent....... plzzzzzz....... Hi all, I got the crystal reports working in my client m/c without .net and crystal reports being installed. Thanks a lot Regards, Metilda ...Show All

• Windows Forms DataGridView - Replace column with my DateTimePickerColumn

  Hi I have a database with one table containing: - id (int) - name (string) - date (DateTime) Now I fill a DataSet with the data in the database using OleDbDataAdapter . Then I connect the DataTable (inside the DataSet) to my DataGridView: - datagrid.DataSource = dataset.Tables[0]; I then created a DateTimePickerColumn (inherits from DataGridViewColumn ). (The control works fine) Now to my question. How do I replace the "date" column to be a DateTimePickerColumn Do I have to: 1. Hide the "date" column. 2. Add a new column (DateTimePickerColumn) 3. Implement code for copying data between 1. and 2. I want DataSet.Update() to work with DateTimePickerColumn . Anyone :) / K ...Show All

• Visual Studio How to run a msbuild project file from a batch(.cmd) file?

  I am new to batch files and Ms Build. I want to run a msbuild project file from a batch(.cmd) file. Please suggest the code I should write in .cmd file to invoke msbuild. Please reply to praveenmodi[at]yahoo.com. Many Thanks. praveen It is pretty simple. If MSBuild is on your path you can call it directly on the project: msbuild a.proj If it is not on the path you'll have to provide full path to MSBuild.exe \WINDOWS\Microsoft.NET\Framework\v2.0.50727\msbuild.exe Thanks, Vladimir ...Show All

• Visual C++ a sample program which use res protocol?

  I need a sample program which use res protocol, I hope that one expert can give me one example which use res: protocol, I appreciate your help. Hello Re: a sample program which use res protocol As I have said before ( http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=986755&SiteID=1 , http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=986762&SiteID=1 ) such questions are outside the scope of this forum - for the scope of the VC General forum please look at: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=19445&SiteID=1 For such issues please use the newsgroups at http://msdn.microsoft.com/newsgroups . OTP Thanks Damien ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. No ID3DX10Line?

  I do not see any documentation for a D3D 10 version of ID3DXLine. Granted the DX9 ID3DXLine interface is a complete joke -- both in performance and quality, at least there is a way to get a few stylized lines in the 3D view. While games don't use stylized wireframe, this is a cornerstone for profession graphics packages (e.g., modelling and drafting). Current hardware supports accurately rendered, deterministic zbuffered, accelerated lines with widths up to 5 pixels wide. Common screen space dash patterns are sufficient for 90% of all display purposes. There are also several hidden line algorithms that only function correctly if the wide lines are rendered with correctly depth buffered Bressenham step patterns. Until Direct3D provides acce ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Ummmm...

  Well, I'm new to the gaming thing, and I was wondering, is XNA just code, or is there actual graphics design. can somebody help me Nicholas, XNA actually covers a variety of products but if you are asking whether XNA has any graphical design tools for images or 3D models then no we don't. The XNA Game Studio Express toolset is based around a programming framework, programming tools and a content pipeline designed to make it simple for people to integrate game content into their game. Content creation tools (images, models, sounds etc) are not included in XNA Game Studio Express. Joe ...Show All

• Windows Forms OnPaint Override Problem with UserControl that contains Panel and ListBox Controls

  I am attempting to creat a custom user control.  It contains a Panel and a ListBox control that I use to change view modes of the control.  When I attempt to paint on the user control itself nothing is painted.  If I respond to the OnPaint event of the Panel control and paint there then the drawing shows.  If I respond to the OnPaint event of the ListBox control and paint there then nothing shows. I am attempting to implement a drag and drop ghost image when I paint on the UserControl.  I assume it is possible that when I try to paint to the UserControl that it is somehow painting to the background of the UserControl and is not painting over the ListBox and Panel Controls contained therein.  Is th ...Show All

• SQL Server dbcc checkprimaryfile

  Hello All, I am going crazy tring to find out why I keep getting this error when I execute a simple dbcc checkprimaryfile (N'C:\backup\databasename.mdf', 0) from ADO.Net. This works just fine from Query analyzer. By the way, I am running SQL Server 2005 and .Net 2.0. Here the complete error: CREATE FILE encountered operating system error5 (Access is denied) while attempting to open or create the physical file 'C:\backup\databasename.mdf. Note that the database file is not in use as I have detached it. Any help would be greatly appreciated! Thanks! Amine Are you using the same connection string So arr you connecting to the same server with the same credentials Seems that the ...Show All