JRMcFetridge's Q&A profile

• SQL Server Save SQL Query to XML

  What's the best way to run a SQL query and save it to an XML file Use the For Xml clause in your Sql Query, and then route it to a Flat File destination. For more information on For Xml: http://msdn2.microsoft.com/en-us/library/ms188273.aspx ...Show All

• Visual Studio Team System Pre-build events on the test project - do they work?

  Hi. have A pre-build event for my test project as the same events exist for the real projects. This event supposed to copy some config files to the bin folder. Here is the event script: copy $(ProjectDir)ConfigStorage\*.config $(TargetDir) When I compile the test project, everything works fine and files are being copied to the bin\Debug folder, but when I run tests - it doesn happen. This stupid test run creates folder with a time stam and a two folders underneath - In and Out. All ddls are placed in the Out folder but not the config files! Do those events run at all How can I set manage so all those foldersare not being created automatically So instead of new timestamped folder for every test run it always copied dlls to the predictable ...Show All

• Visual Basic former issues, revisited: FileSystemWatcher

  My understanding of the FileSystemWatcher is that it can only watch a single directory, and either one file type or all file types (nothing in between). If that is true, I am looking at a different approach, if it is not true, perhaps someone could expand my limited knowledge. In short, here is what I want to accomplish. I have big files being uploaded to our FTP server (located in our office), by various speed IP’s (including dial-up) to over 30 unique folders, and I want them swept into a central location. Obviously I have to be concerned about whether the files have completed their upload before they are moved. I was thinking about an app that has a timed event to check all of the files in each named directory for the “da ...Show All

• SQL Server msdtssrvr.ini.xml FileSystemFolder type - ConfiguraStorePath and StorePath on a SAN

  Hi, We have configured the ServiceConfigFile registry entry to point to an additional SSIS configuration file, which is stored on a SAN, our packages are also stored on this SAN (Storage Area Network). When I restart the SSIS Service, MSDB and any FileSystemFolder are totally gone... Does the location of the configuration and / or the FileSystemFolder Folder's need to be on the local machine or can you use file share's If so, How would you reccommend deploying to the file system where SSIS is configured as a clustered service We have attempted using the SAN as well as creating file shares on the SAN with no success. Thanks in advance, Garnet Solved :) the problem was that the user ...Show All

• SQL Server Granting a user permissions to create and Drop a table

  How do I allow a user (or group of users) permission to create/drop a table I have found the 'GRANT CREATE TABLE TO username' command, which will (I assume) allow a user to create a table, but how to I allow a user to 'DROP' the created table as well 'GRANT DROP TABLE TO username' doesn't work and I want the users to be able to DROP/DELETE this table (temporary table created just for printing purposes) as well. thanks What I want to know as well is, if the table is DROPPED, do I have to re-set all permissions on it again after it is re-created If so, what is the best way to achieve all this/ Thanks ...Show All

• Visual Basic Selecting a TreeNode by RIGHT CLICKING on it, I m using VB.Net, VS2003

  causing the AfterSelect() TreeView event by right CLICKING the TreeNode I m using VB.Net, VS2003 The AfterSelect event [say, Private Sub TreeView _AfterSelect() ] is called when we first time LEFT CLICKS a tree node in the treeView, right clicking the node doesn't selects the desired node. How can we cause the system to select the desired node when we RIGHT CLICK on it Also can we create a Node_Click event for treenodes / treeview in VB.Net [like there was one in VB6]   Also if this post is not relevant to the thread topic, please guide me where should i ask questions about configuring various controls You will have to to it yourself: Private Sub TreeView1_MouseDown( ByVal sender As Objec ...Show All

• Visual Basic Strange Problems with VS2005

  Hello All, I'm trying to figure out why VS2005 is acting strange and if anyone else has seen these problems.... Sometimes when I run a solution using the Debuger the system will not step into a function. it just steps over it as if it has executed it. I have checked to see if there is a unhandled exception causing the problem but there is not I have even added a breakpoint to every line in the function including the function header and it still will not recongnize the breakpoint. Then as quickly as the problem has started it will stop and I will be able to step into the function. Additionly The VS environments seems very unstable I report at least 2 compiler errors a day requireing me to restart. Lasty I'm not sure if this is just an ...Show All

• SQL Server creating a new database in SQL 2005

  I have been trying to create a new database in SQL 2005 and each time I do so, it brings tables in from other locations. Any suggestions Dave The Model database is one of the SQL Server system databases.  It's used as the basis for creation of any new database on the server -- if you have a table (or any other object) in Model, it will be created in a new database as well.  You can find it if you navigate under the Databases tab, to the System Databases.   -- Adam Machanic Pro SQL Server 2005, available now http://www..apress.com/book/bookDisplay.html bID=457 --     <Dave U.@discussions.microsoft.com > wrote in message news:8cf6fea0-b89a-4c46- ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA Beta 2 announced (date 'in a couple of weeks')

  http://blogs.msdn.com/xna/archive/2006/10/23/announcing-xna-game-studio-express-beta-2.aspx I made myself a template for VS2005 Pro, and use that. If you want, I can send you the template(just a small ZIP file). Works perfectly fine. THe other benefit of that is that you can just go into the solution file, change one line, and now the solution file loads in the the express edition and works just fine - i do that ocassionally to test whether it will compile in EE. So, need that template ...Show All

• SQL Server How can VB look something up in an SQL Table?

  How can a Visual Basic Application Lookup information from an SQL table database (all of this in the Code Window, not with the Application User seeing this). e.g.: Making a VB Application verify that the text in a TextBox is the same as the text in an SQL Table/Row (Like when verifying a password.) hi, ok... the provided trivial sample can do that... put a button on the form and execute the provided code... if you get "1" the entered text is present in your table.. regards ...Show All

• Software Development for Windows Vista IDMOWrapperFilter::Init alternatives?

  Do DMOs really have to be registered in order to be used with the DMO Wrapper Filter I suspect the answer is "yes" based on IDMOWrapperFilter::Init. It would be nice if IDMOWrapperFilter::Init could take a pointer to an IMediaObject - that way the DMO could be "compiled into" our executable, it wouldn't have to be registered, and our proprietary algorithms in the DMO wouldn't be available for use outside of our application. (We compile many of our DirectShow filters into our application in this manner and it has worked great, not to mention it makes the installation a lot easier - almost an xcopy!) Are there any alternatives to the DMO Wrapper Filter that could wrap an IMediaObject in this manner I have done a ...Show All

• Windows Forms How to add a checkbox control in a column

  how to add a check box control in a column of a Data Table.. Hi, You don't add a CheckBox control to a DataTable. You add it either to a DataGrid or DataGridView depending on what framework version you use. If you use 2.0, then you can add a DataGridViewCheckBoxColumn to your DataGridView, and bind it to a column of a type containing boolean data. Hope this helps. Luc ...Show All

• SQL Server OLE DB & SQL

  Does anyone know why SQL doesn't work properly in my OLE DB component Underlying DB: DB2 Provider: IBM DB2 UDB for iSeries IBMDA400 OLE DB Provider If I insert some SQL I get get a preview of the data but it errors when I run it. [OLE DB Source [1]] Error: An OLE DB error has occurred. Error code: 0x80040E00. [DTS.Pipeline] Error: The PrimeOutput method on component "OLE DB Source" (1) returned error code 0xC0202009. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. [DTS.Pipeline] Error: Thread "SourceThread0" has exited with error code 0xC0047038. ...Show All

• Visual Studio Send value from ASPX to a textbox in RDLC file.

  Dear Friend, I have e report file and an aspx file. I have a textbox created inside the report file, and I want to send the value of this textbox from the aspx page. How can I do it And how can I format a field in EURO Thanks!! Dear friend, Thanks for the support. But do you have an example to invoke the report parameter I have created the parameter inside the report, but how can I invoke it from ASPX page Thanks! ...Show All

• Visual Studio Express Editions [HELP]how can i avoid Null Reference exceptions in the IO.Stream.Compression

  Hi iam making a program for encrypting files and i want to use the namespace system.io.compression for compessing the ressults of my crypt routine and then save the to file. BUT EVERY ime i use it i got a null refernce exception. how can i make not to be null when its called. any help appreciated. ...Show All