Steve Abney's Q&A profile

• SQL Server Works fine inside BI Dev. Studio, but fails when scheduling it in SQL server 2005.

  Hi! We are currently developing a project in SQLIS using the BI dev. studio. The package executes with no problems in the development environment, but when I try to deploy it and execute it using the SQL Server Agent, the package fails. "Work flow" ----------- 01. Build a package deployment utility (Rebuild all). 02. Runs the deplotment utility. 03. Checks that the latest package has been installed. 04. Creates a new job in SQL Server, using the SQL Server Agent.  05. Adds a new step to the job. 06. Sets that it is a DTS package that should be run ("file-based") 07. Sets the location of the package. 08. Saves the job. 09. Starts t ...Show All

• Visual C++ Creating views for static splitter

  I have a working shell namespace extension with a listview in the shellview window in the windows explorer. Now, I want to make a static 2 row,1 col splitter in the shellview with the previous list in a top row and another CWnd derived class in the lower. The problem occurs later, read on. Here's what I have in the CreateViewWindow: STDMETHODIMP CIsdShellView::CreateViewWindow(LPSHELLVIEW pPrevView,                                                 LP ...Show All

• Windows Forms menustrip scrolls out of window

  I'm a novice VB user and am having a problem using a menustrip. As a simple illustration of the problem: 1. Create a new VB project using the Windows Application template. 2. Drag a menustrip onto the form and dock it to top. Insert the standard items 3. Set the autoscroll property of the form to True 4. Drag some control onto the form and place it near the bottom (for instance, a MonthCalendar). 5. Run the program. 6. When the windows opens, resize it smaller in height. The scrollbars appear and the menu disappears off the top of the window. So, what I'd like to know, is how to make the menu stick at the top and not ...Show All

• Visual Studio PowerToys for the Visual Studio 2005 Class Designer and Distributed System Designers

  We’ve published a set of set of add-ins which augments existing functionality in the Visual Studio 2005 Class Designer and the Distributed Systems Designers. The Design Tools Enhancements add-in provides a common set of features that can be used by both the Class Designer and the Distributed System Designers , such as pan/zoom window and rich formatting commands. The Class Designer Enhancements add-in provides additional functionality for the Visual Studio 2005 Class Designer, such as HTML export and nested type creation commands. This download includes all necessary source code and a Visual Studio project template for creating your own a ...Show All

• Visual C# dataList not working with Image Button

  hi all. i have the following data list and inside it are image buttons that are thumbnails. When clicked they assign another image a value and thats it. It works only once though, then subsequent clicks on the images do nothing, they don't even trigger the event Whats wrong with this thanks! here is how the data list looks: [php] <tr> <td><asp:DataList ID="dlThumbs" Runat="server" RepeatDirection="Horizontal"> <ItemTemplate> <asp:ImageButton ID="gallery" OnCommand="ImageButton_Command" CommandName="<%# Container.DataItem %>" C ...Show All

• Visual Studio Express Editions Directory listing

  I am currently working on an archiving project. I have got it to work to some degree. It uses a folderBrowserDialog box to locate the directory to zip. Parses the string and creates the save location. It then zips and compresses the files by recursing through the directories and obtaining a list of files to be added to the zip file. Now here is my question. How could I select multiple folders in one pass And also is it possible do delete folders through C# you can use GetDirectories from System.IO to recursively obtain all the sub folders in one pass. see below string[] dirList = Directory.GetDirectories(@& ...Show All

• SQL Server C# code to attach database to sql express

  i need this help , i am trying but its not getting attached in command lprompt its working good but comming to c# code its not working first i am copying database and log file to data folder then i used this code string AttachCommand = @"CREATE DATABASE myrokero ON ( FILENAME = N '" +sqlPath+ "myrokero.mdf' ),( FILENAME = N'" +sqlPath+ "myrokero.ldf' ) FOR ATTACH " ; processStart = new ProcessStartInfo ( "sqlcmd.exe " , " -E -q " + AttachCommand.ToString()); processStart.UseShellExecute = false ; processStart.RedirectStandardOutput = true ; proces ...Show All

• .NET Development Help : "error: 40 - Could not open a connection to SQL Server"

  I'm using VS2005 and SQL2000. I created a database name "myDatabase" in SQL Server 2000 and built a website that connet to this database. When I'm running this website in VS2005 IDE (press F5 or Ctrl-F5), everything is OK. I publiced this site. When I connect to database on my computer, everything is OK also, but when I connect to database on another computer, an error occurred like this : "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, ...Show All

• SQL Server Schema and principals (Sql Server 2005)

  Hello Everyone, There is something we don't understand on SQL Server 2005. We want to grant acces to the login MyUser in the existing database MyDb. We want this login to be known as MyUser in MyDB and being the owner of a new schema named MyUser. Here are the commands we are using: use MyDb go create user MyUser for login MyUser with default_schema = MyUser go create schema MyUser go grant Take ownership on schema::MyUser to MyUser go After that we would have tought that Myuser is the owner of the MyUser schema. But it is not the case: Here is a select on sys.schemas: Select * from sys.schemas name     ...Show All

• Visual C# Designer.cs error

    I am getting the following error on a build: Warning 1 The name "Description" is already in use by another component. K:\fms\admin.Designer.cs 2151 0    ok, so I check around in the Designer.cs file and see the following: this .descriptionDataGridViewTextBoxColumn1.Name = "Description" ; // this is the only other line using "Description" this .descriptionDataGridViewTextBoxColumn.Name = "Description" ;  /// this is the line erroring out   This stuff is all genereated by VS 2005 (C#)....so why the error The textbox columns are different names used in different gr ...Show All

• Visual Studio Express Editions updating a database

  I have tried very hard to get my database updated when I use the update/insert commands. I am running VB 2005 express edition beta 2. I read somewhere that VB does not allow modifying a database as opposed to Visual Studio where you can update a database. is this true and how can i fix the problem. more explicitly: Visual Studio.Net allows modifying whereas Visual Basic.Net standard edition supports only connecting and viewing a database. Thanks Thank you a ton for that link, I worked on figuring this out for two days and was completely confused. Barrett ...Show All

• Windows Forms How to make a Picturebox accept focus

  Hi I am currently creating a custom button control inheriting the picturebox control to allow me to customize the button's appearance based on the image loaded on the picturebox. Everything goes well until i realize that picturebox are not in the Tab Order sequence, hence, my button receives no focus when using the Tab key to navigate on the controls. Does anyon ...Show All

• Visual C# How does one turn OFF auto compile?

  It seems that the ide is doing some kind of auto compile during development time. IE, I will type in something and it automatically puts a red underline under some that is wrong. How can I turn this off. It makes the ide unusable on my system. thanks Ralph Ralph - I'm curious why this makes the ide unusable on your system To turn this off, go to Tools | Options | Text Editor | C# | Advanced | Editor Help and uncheck "Underline errors in the editor.". Thanks, Karen ...Show All

• Visual Studio VS2005 on XP 64 bit Itanium

  I am stuck here. I have a Windows Server 2003 Itanium server and a Windows XP 64 bit Itanium backup workstation. VS2005 requires SP1 before it will install. Windows Server 2003 SP1 is installed, so all OK. However, I cannot find the service pack for the workstation. Does anybody know where it is Thanks There's a workaround which you can do to update the setup data files to avoid the check.  Please send me mail from my blog http://blogs.msdn.com/quanto and I'll walk you through this offline. Note - moving forward, VS design time will not longer support the Itanium processors.  We will suppose ...Show All

• SQL Server Installing the SQL server 2005 beta tools problem

  Hi everyone,  I do not have any issues with the installation of the server itself, or reporting services etc... but im having trouble installing the tools like the management studio, etc... I get an error syaing tat I need to do this from the add/remove programs, but its not there. Its like it thinks that its installed but its not... Any ideas would be gratly appreciated Kramish Now there is another problem, the SQL Server Management Studio freezes whenever I load it up. I cant really say much more than that. I will post the error signature below, I hope someone can help: szAppName : SqlWb.exe &n ...Show All