simon_'s Q&A profile

• SQL Server HOW DO I ACCESS SQL SERVER TO USE NORTHWIND DB

  I am attempting to access the SQL server in order to use the Northwind database. Typing in via the command prompt the following: osql –E -1 “EXEC sp_attach_db N’Northwind’,N’c:\SQL Server 2000 Sample Databases\northwind.mdf’” The command prompt response: [SQL Native Client] "An error has occurred while establishing a connection to the server when connecting to the SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connects." Also, I loaded SQL Server Management Studio Express and not sure if I even need this. I click on the Icon but I’m not sure what I need to do to establish a logon and connect. Any help will b ...Show All

• .NET Development IPC remoting exception with events

  I get an exception thrown when a remoted object tries to fire an event. ExceptionText = "This remoting proxy has no channel sink which means either the server has no registered server channels that are listening, or this application has no suitable client channel to talk to the server." From what I've read so far, I'm doing something wrong in the configuration, but I obviously don't know what I'm doing wrong. I saw a message about setting port=0 for TCP, but I'm using IpcChannel. Even so, I tried it and it didn't seem to work. Is there a magic value equivalent for IpcChannel that I'm supposed to use I've tried "" and null, too. Anyways, I am programmatically setting the configuration on both sides. -begin se ...Show All

• Software Development for Windows Vista Workflow Design Error

  I have the required extensions installed and succesfully created a project. But when I try to open up the Workflow1.cs file it throws me the following error: ------------------------ (ERROR LOADING WORKFLOW The designer cannot process the code at line 44!) ------------------------ Which is: ------------------------ this.onWorkflowActivated1.SetBinding(Microsoft.SharePoint.WorkflowActions.OnWorkflowActivated.WorkflowIdProperty, ((System.Workflow.ComponentModel.ActivityBind)(activitybind1))); this.onWorkflowActivated1.SetBinding(Microsoft.SharePoint.WorkflowActions.OnWorkflowActivated.WorkflowPropertiesProperty, ((System.Workflow.ComponentModel.ActivityBind)(activitybind2))); ------------------------ It also says: ------------------- ...Show All

• Visual Studio Express Editions Backgroundworker copyfiles with progressbar

  with reference to ahmedilyas code below to copy specific file types with progressbar... how can I run this code with progressbar in a backgroundworker and trigger the progressbar progress http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=833129&SiteID=1 Dim theExtentions() As String = { "*.jpg" , "*.bmp" } For Each currentExt As String In theExtentions Me .ProgressBar1.Minimum = 1 Dim theFiles() As String = Directory.GetFiles(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments), currentExt, SearchOption.AllDirectories) Me .ProgressBar1.Maximum = theFiles.Length Me .ProgressBar1.Value = 1 Me .ProgressBar1.Step = 1 For Each currentFile ...Show All

• SQL Server How to optimize the sql below?

  I have a sql such sa below: select coalesce(T1.LocalNetID, T2.LocalNetID)as LocalNetID,coalesce(T1.BSCID, T2.BSCID)as BSCID,coalesce(T1.SiteID, T2.SiteID)as SiteID, coalesce(T1.CellID, T2.CellID)as CellID, coalesce(T1.StrTime, T2.StrTime) as StrTime, C10701 as '10701',C11601 as '11601'from ( --Start for Opt_Cell_pBasicM of inner table-- ( select LocalNetID,BSCID,SiteID, CellID, StrTime,RecordDataTime, C11601 from Opt_Cell_pBasicM where ((LocalNetID = 13 and BSCID = 2)) and ((RecordDataTime between '2006-01-01 00:01:00' and '2006-01-01 12:00:00')) and (GranularityPeriod <= 12) ) --End for Opt_Cell_pBasicM of inner table-- as T1 full outer join --Start for Opt_Cell_pCellRadioM of inner table-- ( select LocalNetID,BSCID, SiteID, CellID, ...Show All

• Visual Studio Team System Visual Studio 2005 Team Foundation Installation Guide

  It seems the link to the Visual Studio 2005 Team Foundation Installation Guide is broke http://www.microsoft.com/downloads/details.aspx familyid=e54bf6ff-026b-43a4-ade4-a690388f310e&displaylang=en File Name: TFSInstall-v61004.chm Version: 8.0.61004 Does anyone know of a link that works The URL above works fine for me, but the version is now 8.0.61230. Looking at Rob Caron's blog the guide was recently updated so I'm guessing you hit the site while they were doing the update. Give it a go now and see what happens. ...Show All

• SQL Server Transaction disappears performing updates

  OK, I actually have a solution for this, what I need to know is the why ... I have PowerBuilder code that starts a transaction then calls a stored procedure. That SP performs a bulk update on a table with a trigger. That trigger then loops through the updated rows, and performs individual updates on a second table. It then returns to the PowerBuilder code (with no errors), and I call commit. At this point, I get an error that the commit trans has no corresponding begin trans. (Checking the DB, no records have been updated, so apparently it rolled back the transaction on me). I can call the SP directly in Query Analyzer, and it runs without a problem. The bulk update in question updates about 10000 rows - I've found that if I cut that ...Show All

• Visual Studio Express Editions I have to run a run command

  first, with no relation to the question.....run a run command...that just aint right... anyways,i need to run a command usually run with run , the code is the following, Attrib +s "<Textbox1.text>" i have tried to use a bat file,written with a buttton,but the bat file has to write a " before the location and after,but " " " will not work if anyone can please make me a code that actually is done with code without opening bat or anything,just one code that can run Attrib +s " between goes the location localized at textbox1.text " it has to be written that way,obiously except the location which normally could be something like Attrib +s "C:\Documents and Settings\A ...Show All

• Visual C# Does anyone have an example of attaching a vscrollbar to a picturebox?

  I need to add a vertical scrollbar to a picturebox so I can make the image longer vertically than the picturebox real estate on the form. I added the scrollbar onto the form and placed it on the right edge of the picturebox, but don't know how to "attach" it to the picturebox so it actually scrolls the image. Does someone have an example using C# showing how to do this there is another way to implement it. drop a panel control into the form. and drop a pictruebox control into the panel. and set panel.AutoScroll = True. set picturebox.SizeMode = AutoSize and ... just load a image to the picturebox, you will find that you got it ...Show All

• Visual Studio Team System HOW: Authoring a Web Test project on a site with a masked URL

  Newbie question. How do I write/record a Web Test on a site that has an implementation of a masked URL I am recording on a QUAT environment in which I will also need to implement a Load Test project on so removing the mask is not an option at this environment. Masked URL = The full path of the pages are not exposed only a default page at all times. Example: http:\\somewhere.com\default.aspx Is this even possible If it is how Your help will be greatly appreciated...thanks. I made a simple recording of our site. This recording registers a user to our site. The user needs to fill a series of pages to complete his/her registration then provides him/her with a confirmation page after submitting the ...Show All

• Visual Studio Team System Can not install because TFS is already installed on server???

  We had asked a contractor to take the time to install the Workgroup edition of TFS on a department server for evaluation. The contractor ended up leaving and the state of the TFS installation was unclear so I simply uninstalled TFS and initiated a re-install myself. SQL and Sharepoint seem to be fine. At this point the installation for TFS gives me an error while it is checking for pre-requisites and states that it can't install TFS because TFS is already installed on the server. I of course had already successfully uninstalled it. It does not show up under Control Panel - Add, Remove Programs. Does anyone out there no how I can get past this Thanks, Dale FYI, the dep check looked fin ...Show All

• Visual Basic Running a bat file

  Hi Folks, I am trying to run a bat file from a VB.net app (VS2003). I have tried a number of things as shown below but none seem to work. Can someone please help shed some light. Dim Path = "C:\PConfiguration\Software\Ads.bat" ONE Dim xProcess As Process xProcess.StartInfo.FileName = "cmd.exe" xProcess.StartInfo.Arguments = " /c " & scriptName If you specify the following, the output of the script will be displayed in the current window. xProcess.StartInfo.UseShellExecute = False TWO Dim psInfo As New System.Diagnostics.ProcessStartInfo _ (Path) psInfo.WindowStyle = System.Diagnostics.ProcessWindowStyle.Normal Dim myProcess As Process = System.Diagnostics.Process.St ...Show All

• Visual C# Mixed languages in Visual Studio

  Can I use mixed languages in Visual Studio i.e. some source files in C# (.cs), others in C++ (.cpp) you can add several various .NET language projects in 1 solution yes, but in terms of C++ I'm not sure and don't quite think so, but do not quote me on this. if its a VC++.NET then perhaps so yes but either way you need a new project to include those supported language files in the project ...Show All

• Visual Studio Is Install of SP1 for VS2005 Worth It?

  After reading pages of horror-stories involving just installing SP1, I'm really wondering if it's worth even trying to install it. I thought the purpose of an SP was to fix at least some known bugs, this doesn't seem to be the case. I've just installed VS 2005 yesterday, and haven't even used it yet. I'm pretty leery of installing anything on top something I haven't even tried. Anyone want to weigh in If that is what you think, then I guess you have been seeing very limited use of VS. Although I was generalizing, this philosophy certainly refers to VS, as well. Let me give you just one example. Many productivity add-ons and functionality-enhancing plug-ins require a specific SP-level of VS. You get left behind an ...Show All

• SQL Server Dynamic Dataset for Chart in Report

  Is it possible to dynamically set the dataset for a chart on a report What I'm trying to do is generate a single chart on a report. Depending on what items a user selects as parameters would determine the dataset used. Unfortunately, one dataset comes from Oracle the other from SQLServer. Thanks! ...Show All