Jan Thordsen's Q&A profile

• SQL Server Attaching a DB to a Network Folder

  I'm trying to attach a db to a network folder. I used the sproc sp_attach_db from master db to attach a test db to a local drive (c:\test) and works fine. EXEC sp_attach_db @dbname = N'myDatabase',  @filename1 = N'C:\Test\myDatabase.mdf' ---NO PROB. With this----------------------------------------- but when i try to attach a test td to a network drive, ( \\computer\test ) does not work. EXEC sp_attach_db @dbname = N'myDatabase',  @filename1 = N'\\computer\test\myDatabase.mdf' -----I get this error message ------------------------------------------- File '\\computer\test\myDatabase.mdf' is on a network device n ...Show All

• Software Development for Windows Vista How do you make IMemberCreationService available?

  I started a new C# console application, added the System.Workflow references and a Sequential Workflow (code) item. When I tried to open the workflow to add activities and I got this error message "The service 'System.Workflow.ComponentModel.Design.IMemberCreationService' must be installed for this operation to succeed. Ensure that this service is available." Confused, I added a WorkflowConsoleApplication project in the same solution and I could see the workflow diagram and add activities. So I checked that I have all the references tha tthe WorkflowConsoleApplication has and I'm added the System.Design, Transaction and Web namespac ...Show All

• Visual Basic getelementbyid .click and .value don't work in dot net

  I'm trying to navigate websites programmatically and have had success with VB6. In VB6 I use: webbrowser1.navigate("someurl") webbrowser1.document.getelementbyid("v1").value="Legal Eagles" 'Enters movie name into search field webbrowser1.document.getelementbyid("search_submit ").click 'Clicks the search button and navigates to next page My Problem is that when using VB.NET the intellisense doesn't offer me .value or .click Any help would be appreciated. ...Show All

• SQL Server Date time conversion problem

  Hi, I've run into a date conversion problem. When my package starts, I use a SQL Execute task to insert a record into a table. I set the SQLStatementSource value as follows: "INSERT INTO tblUploadHeader (ExecutionGUID, StartDateTime) VALUES ( '" + @[System::ExecutionInstanceGUID] + "', '" + (DT_WSTR, 20) @[System::StartTime] + "' )" which evaluates to INSERT INTO tblUploadHeader (ExecutionGUID, StartDateTime) VALUES ( '{C913A6EC-5DB9-405E-82DB-4F46DE454EEB}', '14/02/2006 11:53:32' ) StartDateTime is a column of type datetime. The INSERT results in the error: Msg 242, Level 16, State 3, Line 1 ...Show All

• Windows Forms How to make the installer leave the app.exe.config file after uninstallation.?

  Anyone know that I'm using VS2005 setup project. Okay, I understand what you mean by that they are in a single unit, you've simply added another project's output to the installation, which by default includes the both executable and the associated config file. You could possible manually include both the executable and configuration as separate units, however, you would lose the ability of the installer being able to pick the correct build configuration of the executable. Other than than, I'm not sure how you could go about this. ...Show All

• Windows Forms Where Do MSI maintain the Install Location

  Hi, In the registry in the following path the uninstall information is available under following path HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall. But InstallLocation entry for most of the installed application is not available. So can you please help me to get the Install location . Thanks & Regards, Pradeep Unfortunately Visual Studio setups do not do this - they do not set the ARPINSTALLOCATION property to TARGETDIR, as described here under InstallLocation: http://msdn.microsoft.com/library/default.asp url=/library/en-us/msi/setup/installer_productinfo.as ...Show All

• Visual Studio Team System Convert from ClearCase to VSTS?

  Hi, Will there be any Clearcase - VSTS importer/converter in the release of Team Foundation server I've checked earlier threads and found this ( http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=119343&SiteID=1 ), but I want to know if there are any later news about this   We don't have anything else to add publicly right now.  I think I can safely say that we won't have ClearCase conversion available when we release TFS however, it remains a priority for us. Brian ...Show All

• Smart Device Development NumericUpDown Select All? How can I do this?

  Is there a way I can select all in a numericupdown As in cause it all to be highlight/selected I'm assuming this is a PInvoke Thanks! Check out this link. This should help you out. ...Show All

• Visual Basic Using Progressbar inside of a Treeview

  Hi i have added a progressbar to a treeview in like this ListView1.Controls.Add( New ProgressBar) it works great but i just cant figure out how to call the progressbar if I for instance wants to change the value of the bar Can anyone help me i would appreciate it a lot TreeView or ListView ----------------- Dim bar As ProgressBar bar = New ProgressBar ListView1.Controls.Add( bar ) '' variable bar is your ProgressBar OR Inherit from ListView and do the same thing as above but now the progressbar will be easely accessible. Class ListViewEx Inherits ListView Public&nbs ...Show All

• SQL Server ODBC connection with stored procedure on iSeries as data source

  I have created a stored procedure on the iSeries that creates a cursor and opens it.  I am trying to write my report to use the stored procedure. I cannot get the data source to work.  How do I create my data source so that it uses the stored procedure   My SP has three parameters I am trying to pass from the report.  The parms are created in the layout. Thank you Figured it out. Had to use this syntax: Call procname ('parm1', parm2, 'parm3') ...Show All

• SQL Server Simulate ROW_NUMBER () in SQL 2000

  I would like to generate an incrementing column value to each row found in a query in SQL Server 2000.  My understanding of SQL Server 2005 is that you can accomplish this approximately along these lines:    insert into MyList (myNo, lName)    select ROW_NUMBER() myNo, lName    from Employee    select * from MyList    order by myNo    myNo         lName    -----         ------    1           ...Show All

• Visual Studio Call a recipe

  Is it possible to programatically execute a recipe If it is, how can i do it I need to execute a recipe defined in the config file from an action I implemented... Thanks in advance... There is a way to execute recipes programmatically, but not from within another recipe currently executing in the same guidance package (i.e. via an action). You can execute a recipe in another package, though. Would that work ...Show All

• Visual C# FileSystemWatcher hell... stops watching after event

  I created a FileSystemWatcher object to watch for newly created files. Once a file is created, the FileCreated() method is called through the FileWatcher event handler. Problem is, after this happens, FileWatcher doesnt seem to listen anymore. I have to create a new FileWatcher every time the event is fired and the method completes. Below is my code. This is a seperate class from the Main class. From the Main, I call this class to set up and create the FileWatcher. I have tried to put the new FileSystemWatcher() in the MAIN class, but it stil quits listening after event. I also caled this watcher.WaitForChanged( WatcherChangeTypes .Created) ...Show All

• SQL Server How to not send subscription report if no data

  I have a report that may or may not have data. I have a subscription setup for this report. The subscription has a defined To list. I would like to NOT send the report if there is no data on the report. I did this in SQL 2000 by raising an error from the stored procedure if there was no data. However, that approach does not seem to work with 2005. Is there another way to accomplish this It shouldn't have worked before... The best way to do this is via data driven subscriptions. You can return no rows in the subscription query, which will result in no reports being sent. ...Show All

• Visual C# C# Windows Control

  hey ppl, i am having a problem with a control, my control is a background with a label on it, then when i use my control on my form i use the on click event, and it only happens when u click the control itself and not the label, so i was wondering how can i do that no matter where u click inside the control , fires the click event. pls post me some code :( mig16 thx In your UserControl you are handling the Click event, but when you click on the label the click event is not getting fired because the label was clicked. You can do this: this.Click += new EventHandler(MyUserControl_Click); this.label1.Click += n ...Show All