Alex Banks's Q&A profile

• SQL Server osql batch command does not return any records when executed using Scheduled Tasks

  I've read a similar post but there was no solution It seems a bit weird.  I created a batch file which runs osql which runs a very simple SELECT statement - no parameters, simple WHERE clause, etc.  When I execute the batch file, it generates a file which contains the results of the query.  But when I run the same batch file using Scheduled Tasks, it does not return any record at all.  The account that I use to execute the batch file and execute the query is a member of the sysadmin role.  Am I missing something out ...Show All

• SQL Server [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.

  I am using PowerDesigner to reverse engineer a SQL 2000 database. I am getting the following error. I can't find out what this error means. Does anyone know Unable to list the users. [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. SQLSTATE =37000 This error is caused when the client is asking the server to prepare a statement which has errors. For example if there is a syntax error in the statement that is being attempted to be executed and SQLPrepare ODBC API is called on it, you will hit this problem. Do you know if the T-SQL you are trying to execute valid or not. To find out the exact problem try using SQL Profiler to see which statement failed to exec ...Show All

• Internet Explorer Development IE7 has still expired certificates

  Hi, Is it normal to still have the old Microsoft Certificates with IE7 Thanks in advance. Best Regards, Eric "Expired" certificates cannot be used to sign new content, but may still be useful thanks to timestamping. Code can be stamped with a "time-of-signing" which is evaluated against the validity period of the certificate. ...Show All

• SQL Server Doing a lookup on a reference table from script?

  Hi, I have a common requirement (when I'm processing data rows from an input file) to perform some data manipulation in script then look up a value from a reference table and perform some further data manipulation depending on whether a matching value was found in the lookup table or not. For example, say I'm processing Customer data rows and the first "word" (/token) of the FullName column might be a title or the title could be missing and it might be a forename or initial instead. I want to check the first word of this FullName column to see if it matches any valid title values in a ReferenceTitles lookup table. If I find a match I want to set my Title column to the value from the ReferenceTitles lookup table, otherwise I want ...Show All

• Visual C++ Visual Studio 2005 Service Pack 1 Beta - error C2244

  Hello, I installed SP1 Beta asap, because I am encountering the "Updating Intellisense ... 100% CPU load" problem. Intellisense problem seems to be resolved, but now I can't compile QT 4.1.4 here is compiler message: -----------------------------------------start c:\qt\4.1.4\include\qtcore\../../src/corelib/tools/qhash.h(805) : error C2244: 'QMultiHash<Key,T>::replace' : unable to match function definition to an existing declaration c:\qt\4.1.4\include\qtcore\../../src/corelib/tools/qhash.h(790) : see declaration of 'QMultiHash<Key,T>::replace' definition 'QHash<Key,T>::iterator QMultiHash<Key,T>::replace(const Key &,const T &)' existing declarations ...Show All

• Visual C# Screen Saver notifications

  I want to get notifications of various System Events in my C# app (Shut down, logoff, Session change, etc). So far I found that the SystemEvents class is very useful ( http://msdn2.microsoft.com/en-us/library/microsoft.win32.systemevents_members.aspx ) However it is missing the notifications for Screen Saver start and stop. Does anybody have an idea to subscribe to Screen Saver events Regards Thanks for the reply and hint. However, I need to trigger the event of a screen saver starts as soon it happens (by registering a delegate or to an event). I am doing a 3D preview that I want to stop as soon as the screen saver starts, and then resume the preview when the screen saver stops ...Show All

• Visual Studio Team System Random string for UserName.

  I would like to generate a random string for every new registration transaction on the site. After I record the test, I am able to generate code and add a random string function. But, is there a way I can do it with the .webtest file We really like the GUI part of the .webtest file. Unfortunately, you cannot sync up the .webtest with the generated code file. Any help will be appreciated. Thanks in advance. Ah ok, I see what you mean.  To do that all you need to do is add the context parameter "UserName" via the web test editor and leave it's value blank, or put in a default value.  Then set it like you have in your example above during the PreWebTest event.  In the web editor open up the Form Parameters node off of yo ...Show All

• Visual Studio Team System Build with tests fails with no indication of where

  I have setup two builds on my TFS project - one to run when code is checked in that only verifies that the code will build, and one to be run automatically that will run our tests. The first build appears to work correctly, but when I run the second (from my VS) it fails. When I look at the BuildLog.txt file, I can't see any failures, and the build results in VS show red "X"s next to the "Running tests" and "Running tests for Any CPU/Debug" entries. I have looked at this post: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=673795&SiteID=1 and based on that tried installing VS Test edition on the build machine, with no change in the results. I am running Team Suite on my machine. Can anyone ...Show All

• SQL Server File system task-deletion operation

  I am using file system task for deletion of text file from a specified folder. but i want that one text file with name ="ssis.txt" and "ssrs.txt "should not get delete. Is there any option or any expression that we can set and avoide the deletion of ssis.txt and ssrs.txt and still delete all the remaining all text file from a folder. I just wish to use the file system task and perform this. Cannt we use some expression infile system task and disable the deletion for say 2 files and let the deletion happen for other remaining files. Please suggest any method or expression by example. ...Show All

• .NET Development Beginner: Q on using XSL to convert from XML to XML

  My first time dealing with XML/XSLT I have to take a XML file(that is HUGE), and convert it into another XML format (the purpose being to get rid of most of the unwanted information and retaining just the ones our program needs) I was told that I can do this easily using XSL. I took some examples from the web and tried it on my machine. (I am using notepad and IE6.0) Here is the XML < xml version="1.0" encoding="utf-8" > <!-- Edited with XML Spy v4.2 --> < xml-stylesheet type="text/xsl" href="cdcatalog2.xsl" > <catalog> <cd> <title>Empire Burlesque</title> <artist>Bob Dylan</artist> <country>USA</country> <com ...Show All

• Visual C++ Managed C++ Copy Constructor

  I am porting managed C++ 2003 to managed C++ 2005. I have a copy contructor that is not building... error C3699: '&' : cannot use this indirection on type '...' public ref class App {... App( const App&); // C3699 ...}; Anyone know how to declare a copy constructor under managed C++ I would put the hat (^) as suggested in the message, but then according to C++ it will not be a copy constructor and therefore one will not be present and the compiler will/may generate one (if this were ISO C++). FYI... In this case I'm not actually using it. I've declared it private and did not implement it so as to prevent others from calling it unintentionally. As I port, I may see examples where I do need a copy constructo ...Show All

• Windows Forms Installer claims newer file already installed - file version info being ignored?

  I am trying to debug a C# custom action DLL within a Windows Installer project and I can launch the debugger just fine. I am trying to mimic the upgrade process by installing copies of past releases in the target folder. I also have to preserve any existing installed EXE file, so I install the new EXE in a subdirectory of the target directory (and the custom action is to decide what to do with the two EXE files). The EXE files all have valid version information. For example, I’ll make one build and run the setup program using version 3.70, and the custom action moves the EXE file from the subdirectory into the target directory. Then I’ll make another build and run the installer using version 3.80 (changing the instal ...Show All

• Windows Forms Windows installer launch condition

  Hi Guys, I am trying to create a setup and deployment project in VS 2005 for a windows form project. A couple of dependencies for my application are - 1) .NET framework 2) ActiveState Perl 5.8.8 I have been able to successfully add the .NET 2.0 framework check to the launch condition. I've also added the Active Perl check but its not working right. I mean, I get a "perl not found" error even on systems where the perl is installed. How should I correct this behavior Its probably something in the Condition check that I'm messing up. Here are the properties I have for perl launch check - (Name) ActiveState Perl Condition Installed InstalllUrl <url> Message Perl could not be found. Please install ...Show All

• Windows Forms File picker/file browser control

  I need to select a file location through a Windows Form and I was looking for a control similar to the asp.net file input control which allows you to browse the drives, files and folders on the users computer. I don't need to manipulate the file just store the location of the file or folder the user selects. Any help would be apprieciated. Is there a control which allows file choosing I don't want to pop up a dialog box. I want to put a control into a form which lets the user browse the disk and pick files. When they double click them, they'd be added to a listbox on the right side of the form. You can't derive from OpenFileDialog. ...Show All

• Windows Forms Master with multiple detail records displayed in form view

  I am using Visual Studio 2005 and can anyone help me jumpstart a development of a master detail form with detail records displayed in form view, instead of the datagrid view (like continuous form in MS Access form) without using third party activeX Control. Some refer to it as it data repeater. Some articles advise to use UserControl. But I am new to Visual Studio 2005 and would appreciate any assistance. you can instead of a grid create a form view by going to 'show datasources' select the table you want , a drop down will appear on the right of the table name, select details. on a form drag and drop the table. .. thats the start.. ...Show All