JVH's Q&A profile

• SQL Server Replication to IP addressed server

  we have an outside company that replicates to us and we are known to them via an IP address.   We get an error now...Sql Server 2005 now does not support a server Alias, IP address, or any other alternate name are not supports.  Specify the actual Server Name I tried putting in the hosts file on their server 168.168.110.2       SQL2005 able to connect to our server through Studio Manager...no ...Show All

• Windows Forms automatically sending an email

  Hi I have put this here as i'm not sure specifically where it should go: I am trying to create an addition to an application that i have already deployed. The addition sends a weekly email to certain users and is ran as a scheduled task on the server.. it is an exe... when i run it as an executable on the development server it works no problem, however on the deployment server it gives me the following error: i have included the ...Show All

• Visual Studio VS Web Site Project

  Hi Kevin, Sorry for your frustration.  Building web sites is a bit tricky because they don't support the same set of platforms as normal client projects.  After talking to the Team Build folks, it appears that what you have to do is ... open up the .PROJ file (e.g., TFSBuild.proj) that gets created when you create a new Build Type.  Look for the property called "PlatformToBuild".  It probably has the default value of AnyCPU.& ...Show All

• 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, usi ...Show All

• Windows Forms Orientation of TabPage when TabControl.Alignment = Bottom?

  Hi, I have a TabControl with some TabPages. I have set TabControl.Alignment= Bottom. But then my TabPages look silly, as they do not rotate 180 degrees when Alignment = Bottom. Also, I can't find any Orientation-property on the TabPage. Any idea how I can rotate the TabPage to make this look better (If I can't, then what is the idea of the Alignment-property... ) Thanks! PS! It is the tab "tip" I want to rotate, not the content ...Show All

• Visual Studio Documentation or more info on these parameters?

  Hello, I was looking at the ASP.NET trace of my web application that hosts a VS2005 .NET ReportViewer control and saw some URLs in GET requests that troubled me....  In particular stuff like: http://localhost/WebSite3/Reserved.ReportViewerWebControl.axd OpType=DocMapReport&ClientController=ClientControllerReportViewer1&ReportUrl=%2fWebSite3%2fReserved.ReportViewerWebControl.axd%3fReportSession%3dlno2sd2lxxqlnd45vesswg55%26Cont ...Show All

• Windows Forms Canceling the "close" event prevents Windows from shutting down

  This is some interesting behavior that I hadn't really considered... I have an application that "closes" to the system tray, rather than exiting, when the form is closed. (E.g. if the user clicks the X in the upper right corner.)   I  ...Show All

• SQL Server How to pass .net application's parameter to a TRIGGER?

  How can i pass my .net application's Userid to the trigger I have a audit trail trigger on myTable.  I dont know how to pass the userid (not the sql server user) to the trigger when a user delete a record from the application(.NET Application). The trigger saves the modifications on the table including the userid of one who does the changes. There is no way to send a value to a trigger directly other than in the inserted table ...Show All

• SQL Server Introduction to Data Types??

  Does anyone know of a good place to get an introduction to the Data Types in SQL Server I come from and Access background, so I'm used to auto-number, text, etc. I just need to figure out which types I need to be using for my data.... Any help is appreciated. The best thing to start from is BOL. Look at ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/a54f7373-b247-4d61-8fb8-7f2ec7a8d0a4.htm ...Show All

• Visual Studio Express Editions VWD requires SQL Server Express 2005 ?

  Please correct me if I'm wrong, but it seems that VWD Express can connect to SQL Server Express, but not to SQL Server 2000 This is rather surprising, as I've always seen that new IDE products *expand* on the database providers available, not provide *less* connectivity. Going the other way, i.e., *requiring* SQL Server Express in order to connect to data, will make VWD's usefulness very low for many developers. Can anybody explain this to ...Show All

• SQL Server Running a package in C#

  Hello all. I am trying to run a package in C# and have come accross the help file of how to do it in Visual Basic ('Running an Existing Package using Visual Basic'). However, I cannot find a reference to anything relating to DTS in my reference dialog. In the help file it says to add a reference to Micorsoft.SQLServer.ManagedDTS.DLL, however, I cannot find this reference anywhere. Am I missing something Thanks, Mike   Tazzmann wr ...Show All

• SQL Server RS utility parameters

  I'm trying to use the rs utility on the command line, but all the examples I've found use only 1 parameter. I want to use multiple parameters and have not been able to get it working. Can anyone advise if this is possible, and if so, how to do it. Thanks in advance Jez Hi, following the script (rss) file definition that accepts the datasource from the rs command line stmt. myfile.rss Dim d ...Show All

• Visual Studio Team System Event log errors RTM Workgroup edition

  I have just installed the workgroup edition on a fresh installation of Windows Server 2003 R2. I'm getting the following errors in the application event log on boot: 1) MS SQL Server - Failure Audit - Event ID 18456 "Login failed for user 'domain\tfsservice'. User: TFSSERVICE Followed by 2) Windows SharePoint Services 2.0 - Error - Event ID 1000 #50070: Unable to connect to the database STS_Config_TFS on THUNDER. Check the ...Show All

• Visual Studio Express Editions New Project Pane

  I'm not sure if this is a problem or not. I've seen several references to a 'New Project Pane' but I don't have it. I'm not sure if this is a holdover from a prev beta or what. I'm using Beta2. When I look up documentation on writing ASP.Net code on the web it says to open a new project and select the new Web Forms from the New Projects pane. I also ran into this problem when researching how to deploy an app which is in the current documentation ...Show All

• .NET Development how to "UPDATE a VIEW"

  anyone could tell how i can update a view in vs my dataset has tables and views but views doesn't show any update method please help me ! There are AddNew and Delete methods on DataViews, and you can change the existing data view the DataRowView methods. http://msdn2.microsoft.com/en-us/library/system.data.dataview.addnew.aspx http://msdn2.microsoft.com/en-us/library/system.data.dataview.delete.aspx ...Show All