hengemd's Q&A profile
SQL Server Execute installation script.
Hello. I will export the database generated script for all objects, I want to make an installer that executes that script on the remote server, I think the installer must ask for sa password; anyway thats not the problem, How can I make with SMO execute an script file Thanks Public Shared Function RunScript(ByVal script As String, ByVal onServer As String) As Boolean Try Dim SMOServer As New Microsoft.SqlServer.Management. ...Show All
Windows Forms DataTableAdapter Update
Hi, I tried the following. I added a SQLExpress Datafile to my app. Therein a simple table and then I built (with the desinger) a DataSet. After draging one Edit to my form and databinding it I can change the values in the table of the dataset. With EndEdit() it marks the row as modifyed. Till now it works fine. Now to the update. I can iterate through the modifed rows and use the generated Update(Field1, Field2, OriginalKey, NewKey) method. The ...Show All
Windows Forms "Destination File" problem
I can't publish my project due to the following error, does anyone have any ideas of what the problem is "DestinationFiles" refers to 1 item(s), and "SourceFiles" refers to 2 item(s). They must have the same number of items. I&nbs ...Show All
SQL Server How can you change the isolation level for SSIS transactions
Hello, I have a transaction running over a data-flow. My source uses a proprietary OLE DB Provider and when I run the data-flow i get the following error: The SSIS Runtime has failed to enlist the OLE DB connection in a distributed transaction with error 0x8004D008 "The requested isolation level is not valid or supported.". What isolation level does SSIS use Is it possible to change it I had hoped the answer to these questions would be ...Show All
Visual C# Unable to map a network drive using C#
I tried to map a network drive using the code (at the end of this post) but I got a "Login Failed 1326" which occur because of a bad username or password. I'm sure that the username and password are correct, I tried to map a drive using the Windows (Tools->Map Drive) and it worked successfully using the same username and password. The shared drive is on a linux machine using SAMBA. The Code: using System.Runtime.Interop ...Show All
Visual Studio Express Editions C# express Fails to debug
My copy of C# express (.img version) on my windows xp sp2 pc debugs successfully but it will not launch the subsequent .exe. I have reinstalled twice and I still get the bug. I have also installed C# express on a windows 2000 computer in my store room (only a pentium 2!) and it didn't do the above either. I can do a normal F6 build and execute the file by double clicking on it's icon in explorer, but that's no fun. The only clue I have is that t ...Show All
.NET Development HTTP status 407: Proxy Authentication Required +ISA Server
Hi, We're getting the follow exception thrown when calling our web service: System.Net.WebException: The request failed with HTTP status 407: Proxy Authentication Required ( The ISA Server requires authorization to fulfill the request. Access to the Web Proxy service is denied. ). I've found this article, but the problem is we don't want to edit machine.config as a pre-req. http://support.microsoft.com/ id=307220 So does anyone know ...Show All
Windows Forms How can I use "Click Once" & "Windows Installer(.msi)" both in Visual Studio 2005, and what steps must I follow?
I want to use "Windows Installer" for user installation from a web site, and then I want to use "Click Once" for updates for the application. Could you help me what steps can I follow There is not model where a purely MSI installed applications can get updates using Clickonce. You could use a MSI package to required install components on the client machine and finally as a custom action install a ClickOnce Application that can then be upda ...Show All
Visual Studio Team System Problem configuring TFS for SSL access (have already followed advice in other posts)
Hello, I have partially succeeded in configuring access to TFS through SSL. The final problem I have is that the "Documents" node of Team Explorer does not work (it has the dreaded red cross next to it). I have searched the forums and followed the instructions here: http://forums.microsoft.com/msdn/showpost.aspx postid=103796&siteid=1 However, my problem is not resolved. I have a single tier installation of TFS, access ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Targeting older machines
Hi there. I guess part of this is more of an opinion question. I want to target older machines that may not have up-to-date graphics cards. Right now I am using a game engine that gives the developer the option of using DX8, DX9, or its own software driver. To compile the engine, I naturally need the DirectX SDK. Problem being that the latest realeases don't have DX8 support. So the question becomes: Is DX9 a 'safe' way to go f ...Show All
Visual Studio 2008 (Pre-release) Certificates for Infocard
How can I generate certificates for Infocard from Windows 2003 CA For what I know there isn't a template for certificate V3. I need to add the logotype extension. Thanks, Pierre Subject and issuer logos are not requirement for InfoCard, but it is recommended. More and more sites deploy cert with logo extensions; for example https://www.fidelity.com or https://www.etrade.com , etc. The samples in the WinFX SDK have a sample cert ...Show All
Visual FoxPro VFP 9.0 SQL worthless under a non client server network?
Hello everyone; I have posted this problem here and also on UT and no solution yet. I have a small network with a 2003 server, and XP pros. I am running vfp 9 select * from products where status = "S0000" takes apx 10 seconds when run over the network. When running this locally, it takes only a fraction of a second. The product table contains 100,000 records, and the result of the SQL command is just a few hundred rec ...Show All
Windows Forms Deriving from abstract UserControls
Can you use abstract UserControls I created a UserControl called Dad. Marked it as abstract. I created a class Son and changed it to: public class Son : Dad { public Son() : base() } If I 'View Designer' on Son it fails with a message saying ... The Designer must create an instance of type 'Windows.Application1.Dad' but it cannot as the type is declared as abstract. Is this just a weakness in the IDE ...Show All
.NET Development Web Service display
Hi All: Does .NET Framework 2.0 change the display mode for Web Services In Visual Studio 2005 Beta 2, I try to take a web reference of ReportService2005.asmx (typed as http://localhost/ReportServer/ReportService2005.asmx ), I got an compilation error said: CS0234: The type or namespace name 'Xml' does not exist in the namespace 'System' (are you missing an assembly reference ) But if I add " wsdl" (typed as http://localhost/ReportServer/Report ...Show All
Visual Basic Using the same structure in multiple objects
I have the same structure of data (customer name, location, status, etc.) that I want to use in multiple objects within an application (one to read the data from a file, one to display it, one to create a new or updated version, and one to save it), and I'm not sure what's the "correct" way from an object oriented point of view of how to define the same structure across all of the objects. Currently, I've got the structure defined ...Show All
