Henny's Q&A profile

• SQL Server Open File - Security Warning

  The publisher could not be verified. Are you sure you want to run this software This is my first SSIS package and the first for my employer. Under DTS we run some overnight tasks that bin with a .Net console application that downloads data. Several of these run in parallel. Looked to me that the Execute Process Task was a good fit for the requirements. When I executed the step, the program did begin to execute in that a DOS window opened. But when, I clicked the run button on the warning dialog, the task step ended. Questions: 1.- How to tell the Execute Process Task not to open the Security Warning dialog 2.- Have you any suggestions about my approach Thanks, IanO I have seen this occur also, but onl ...Show All

• SQL Server Script runs on vbc compiler but not on rs utility

  I am new to .NET framework. I tried running a .rss file which contained the following code. It ran and created a exe file when compiled using vbc compiler but when I gave the same file as input to the rs utility it gave some errors. -------------------------------------------------------- rss script --------------------------------------------------------- Imports System Imports System.Collections Imports System.Data Imports System.Data.SqlClient Imports System.IO Imports System.Text Imports System.Xml Namespace SampleRDLGenerator Class RdlGenerator Dim m_connection As SqlConnection Dim m_connectString As String Dim m_commandText As String Dim m_fields As ArrayList Public Shared Sub Main() Dim ...Show All

• Visual Basic why doesnt 16bit resolution show flat buttons without square?

  I have an application that has flat buttons on an image (so the buttons look like the image. Anyways, under a 16 bit resolution the buttons have boxes around them even though they are defined at 'transparent' un the properties. Under 32 bit everything looks as intended. Why is this Thansk for your help! The original post for this was because I had a test machine where I had 16 bit resolution running (no video driver installd). After I installed video drivers and ran a 32 bit resolution it worked fine. I have .Net v1.1 installed on test machine. On another box I tried it and it has a very expensive video card installed and all drivers are properly installed. The problem occcurs on this machine. Can anyo ...Show All

• .NET Development AcceptChanges

  I obviously misunderstand the functionality of AcceptChanges() as my Access 2003 database is not getting updated when I do the following: MyDataSet . MyTableRow row = MyDataSet.MyTable.FindById(id); row.BeginEdit(); row.Name = txtName.Text; row.Email = txtEmail.Text; row.EndEdit(); row.AcceptChanges(); The 'row' is found (using the id) and contains the correct data. I've also tried calling: MyTableAdapter.Update(row) But still the update is not commited to the database Can anyone sched some light I know how to do it the long way, but I am trying to use the inbuilt .NET 2.0 functionality. Thanks ...Show All

• Visual Studio Express Editions keyboard event

  If it's possible id like a "Do Until" loop so that it loops until a key is pressed, any key at all Hey man, I think this is for Runescape, isn't it... PLEASE CHECK IF YOUR QUESTION IS ALREADY ANSWERED IN ANOTHER POST NEXT TIME - THERE ARE MANY POSTS ON THIS TOPIC I can give you some good code that would specificly fit your needs. But i need more of a discription of what your want. You need to use a Keyboard Hook for this one. If you want say, timer1 to stop when say f12 is pressed, this is what you would write: ...Show All

• SQL Server Any way to create one subscription which delivers server email and file share at the same time??

  Hi, I need to know if it's possible to send out a notification email and deliver the report by file share with one subscription or at least send out a notification email depending on the event of a subscription which delivers the report file share. My goal is not to have 2 separate subscriptions. Thanks Hi Jens, thanks for you reply. If you don't mind, could you please explain your reply in details....I'm not sure about the delivery extension you mentioned. I'm not an expert as you. thanks again Bo ...Show All

• Internet Explorer Development IE7 RC1 and vbscript (InternetExplorer.Application)

  Hi, Has anyone had problems with existing vbscripts that output to IE and the IE7 RC1 release I have some vbscripts that use IE to display output and they work perfectly in IE6 but are broken with the RC1 release of IE7. Code like this below doesn't display anything in the browser window: Set objExplorer = CreateObject("InternetExplorer.Application") objExplorer.Navigate("about:blank") objExplorer.AddressBar = 1 objExplorer.Toolbar = 1 objExplorer.StatusBar = 1 objExplorer.Width = 600 objExplorer.Height = 400 objExplorer.Left = 300 objExplorer.Top = 150 Do Until (objExplorer.readyState = 4) wscript.sleep 100 Loop objExplorer.Visible = 1 Set objDocument = objExplorer.Document objDocument.Open objDocument.W ...Show All

• SQL Server I need a procedure for mi DB

  HI, i need i procedure for my DB that runs all the time and tell me if is someone connected to my DB or not. In the case that someone is connect the procedure has to execute procedure1, and if no one is connected the procedure has to execute other stored proc. Can anyone help me with this Regards. I like the idea of the job. It should work of the following way: - When NO ONE is logedon on the data base it should execute one procedure one time only. - When SOME ONE is Loged ON it shoud execute other pocedure onte time only. The JOB will need to run all the time and execute a procedure if someone is loged on, or if no one is loged into the DB. Can you give me a hand with this Regards. ...Show All

• Visual Studio Express Editions Stopping Service

  Hi, I am trying to stop a service through visual basic. When i try to an InvalidOperationException goes un-handled. Below is my code. Any help would be greatly appreciated. Thanks in advance Imports System.ServiceProcess Public Class Form1 Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim controller As New ServiceController controller.MachineName = "." controller.ServiceName = "AOL Connectivity Service" Dim status As String = controller.Status.ToString controller.Stop() MessageBox.Show( "Process Stopped" ) controller.Start() MessageBox.Show( "Process Started" ...Show All

• Visual Studio Team System PublishRun fails do to 260 character limit

  One of my automated builds using Team Foundation Build throws the following error. I'm unsure were to look or why this is occuring. I went to a dos prompt and recursively listed every file under the TestResults folder into a text file and then pumped that into sql server. The maximum length of any file/folder is 219 characters. So why is this happening Waiting to publish... Publishing results of test run Cart Tests (2007-02-15 16:08:48) to http://ausmstfsapp1pc1:8080/Build/v1.0/PublishTestResultsBuildService.asmx ... PublishRun: The specified path, file name, or both are too long. The fully qualified file name must be less than 260 characters, and the directory name must be less than 248 characters. MSBUILD : warning : P ...Show All

• Visual Studio Team System Setting location for a custom dll

  I've created a custom dll which contains all of my custom tasks which I've written for MSBuild. The only problem is that all of my builds need this task. I just copied this dll into the directory for each build, but when make changes to the dll I have to update it for every build. Is there a better place I can put this so that I don't have to do this whenever it is updated Thanks. I've created an installer for my custom task dlls. They get installed onto my build machines in "C:\Program Files\[Company]\MSBuild". When I update the assemblies, I can just redeploy to my two build servers and be done with it. Because there is a "well-known" path to the assemblies, I can set a consistent ...Show All

• Visual Studio Express Editions parsing negative number.

  Hello. The question is : how can I parse neagtive number (-3 f.e.) from text box object and then put it back or to other one Rest regards. Int16.Parse, Int32.Parse, Int64.Parse, Single.Parse, Double.Parse, Decimal.Parse, Convert.ToInt32 etc. Or TryParse methods. What suites your purpose best. int number = 0; try { number = Int32.Parse(textbox1.Text); textBox2.Text = number.ToString(); } catch(FormatException) { //Illegal integer, handle the error here } ...Show All

• Smart Device Development how can i make soft press key?

  I mean that i want to press some key p.e. Enter or TAB programmaticaly. Can i do that {WM2003. .NET FW 2.0} thank you ...Show All

• Windows Forms Invoke Design Time Editor from own code.

  How to show default property editor from your own code. Problem is IWindowsFormsEditorService is provided only by property grid, so is there any other solution then to override EditValue sub and show your own form. Ok, let's make it more clear. Let's concive we have a button (some element that can recieve events) in design time. When we press it we want to get standart (not overloaded) component editor being opened (in design time) for some component present on the current form. ...Show All

• .NET Development WSE versus SSL

  If I'm securing a web service using WSE, does that mean that SSL is redundant, or does having SSL as well give me some additional benefits What about performance - will using both make performance much worse than if I just used one Thanks. shellshock, whether using WSE and SSL is redundant depends on how are you using WSE. WSE can be used either for Message and Transport security. Message security represents the process of authenticate or authorize the client user.... so WSE provides you with 3 ways to send user credentials to web services: usernameToken, kerberosToken or digital certificates. Apart from that you can also use WSE to implement Transport security.... that means to encrypt the ...Show All