Michael Smit's Q&A profile

• SQL Server SQL 2000 Database through Access Linked Tables via ODBC

  I have a SQL server 2000 database that I am attempting to connect to through Access (97, 2003 - both with the same results) using Linked Tables via ODBC. When the link is established, it only brings in the first 52 fields of one table and 30 fields of another (most are varchar(50)). The tables have MANY more fields than this. I receive no error messages when I link the tables. It sounds like I may have reaching a limit with ODBC since CA-DATACOM was able to retrieve the same information from the mainframe. These are different issues, I know, but I am trying to re-use the existing Access database instead of developing a whole new applicati ...Show All

• Windows Forms pressing arrow keys as hot-keys changes control focus

  I want to define the Left and Right arrow keys as "hot keys" in my form. I've handled KeyDown, and I set the Handled property of the event, but if the current focus is on a button, radio, check box, etc, then the arrow keys cycle the input focus through controls on the form, or within the same group box. How can I disable this& ...Show All

• .NET Development Connection not Alive

  Sorry to post again, I think the other one has been forgotton I have a Windows Form, (Application). On that I have a TextBox called txtIdNum, a Button, and a TextBox called TxtNombre What i want to happen is when someone types into the txtbox txtIdNum, and press the button, the code will search the MSQL table, and select all the fields where FIELD IDNum is = txtIdNum.Text Straight forward, easy to say. My code is the following System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection("SERVER=localhost;DATABASE=test1;UID=sa"); System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.S ...Show All

• .NET Development .NET calling Delphi dll (functions which return VCL types)

  Hi, I have a .NET managed C# application that needs to call functions from a Delphi dll that return/have parameters VCL types e.g. void OpenForm (TPanel parent); The problem I'm having is that the call crashes inside the OpenForm function at Assigned(TView). I can not figure out if is possible to call Delphi dlls that use VCL from C#.NET Thanks Ada ...Show All

• Visual Studio Express Editions Paint Problem at MDIChild at Opening at Startup in Maximized State

  Hi guyz, I have one MDI form and one MDI Child. Both form's property windowsstate=maximized. When MDI form loads, its child forms load at the load event of MDI. But, It not paints that child form properly to maximized area. there is border appears of that child forms without title. Once we minimize that bad painted form and again maximize it. it works fine.. So, why its doing problem at startup in maximized mode I've just transfered my winapp from Vs2005 Beta to Vs2005 express can anyone tell me.. please   is it a BUG of VS2005 Express I'm not quite sure what you are asking. The default behavior is for the maximized child form ...Show All

• SQL Server SQL Workbench Object Scripting Broken

  It appears that there is no way to just click on a table or stored procedure in Workbench and script the object with the same options that existed in Enterprise Manager. The Script Stored Procedure/Table As Create/Alter/Drop does not provide the same functionality that existed in EM. It does not allow you to change the scripting options: -It prepends the use [database] to the beginning of the script. This is bad because this script is not portable from one environment to the next -It fails to generate the IF EXISTS drop clause This breaks a ton of deployment and patching scenarios -It does not have .prc or .tab as file ...Show All

• Visual Studio Express Editions Visible spaces

  This may seem like a really stupid question, but I was writing code with C# beta, and I somehow activated visible spaces (ie. spaces are now shown as dots in my code window) I have no idea how this happened, nor do I have any idea how to remove it Any idea where the toggle for this is found Thanks in advance AM milfora - Try doing Edit->Advanced->View White Space, or pressing ctrl-E, S. Thanks, Luke Hoban Visual C# IDE Program Manager ...Show All

• Visual Studio Team System Session Value in URL

  In a webtest I've recorded, a session value is present in the URL for some of the requests. When I replay the webtest, the test is marked as passed even though it does not complete the desired business scenario. I understand that when I replay the script this session value is no longer valid and in fact I can see a new value being returned in a response header (in the Location field). The session value in the very next request is replaced with the new value, but for all subsequent requests the session value is set to its initial value from recording and remains unchanged. I've tried to add an extraction rule (Extract Text / E ...Show All

• Visual C# dataGridView UserAddedRow event

  The UserAddedRow events occurs when the first character is added to a new row, Is there a similiar event that fires when the user has completed adding all of the information to the row I want to capture the contents of the new row and create a new object with the contents. The problem with RowsAdded is that it occurs everytime a row is added, not just when a USER adds a new row. So, if I initially add 3 rows from a data source it will fire 3 times. ...Show All

• Visual Studio Tools for Office Word Document Opens With No Errors, But VSTO Code Does Not Execute, if you leave Word open in Visual Studio after Publish Wi

  I have been wrestling with the issue, " Office Document Opens With No Errors, But Code Does Not Execute " I read the three suggestions in the above linked article, but none of them pertained to me. Notes: -I am using Word in my examples, and do a reboot before each test. -I am publishing to the file system, which should remove any of the complexities introduced by Internet Explorer Temporary Internet settings, caching, etc. -I have been working with VSTO for over a year and am fairly well versed in it. I have read the deployment and troubleshooting docs on MSDN. So, for me, I can reproduce my problem consistantly with th ...Show All

• .NET Development Permissions required to Use System.Diagnostiscs namespace

  Hi, In ASP.NET 1.1, we have developed a module which includes a call to GetProcessById() function of System.Diagnostics.Process. This works fine if the ASP.NET is running under System context or if the ASPNET user is an administrator. The problem is, in the user's machine, the user context under which the ASP.NET is going to run should not have adminstrative privileges. At that time, this shows an exception with the following message. "Cannot get process information from the remote machine". Can you please tell what are all the access the ASPNET user must have , to get the process id Our environment is ...Show All

• Visual Basic deploying .swf file

  my application has these 2 procedures: 1.     Private Sub btnHelp_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)         Help.ShowHelp(Me, "..\CYM HELP.chm")     End Sub 2.     Private Sub frmLogin_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load         Dim pro As New System.Diagnostics.Process         Dim proInfo As New System.Diagnostics.ProcessStartInfo("..\CYM.swf")         pro.StartInf ...Show All

• .NET Development Searching for Network Devices using VB .NET? PLEASE HELP!!!

  I am writing a change management app in VB .NET and I need to be able to scan a network for devices like switches and routers. I don't have a clue where to start! I there a way to be able to find these sorts of things by just searching snmp strings or do these devices have some special response when accessed via .NET I really need help! Thanks in advance. I dont think you can find it if a network device is a hub or a switch in .NET, but you can access network drives - not physical networking devices. you can look at the DriveType enumerator to determine the type of drive found but I think th ...Show All

• Visual Studio Express Editions help! can not create any project in visual c++ 2005 express edition

  when i try to generate any project in visual c++ 2005 express edition, it always told me that the operation could not be completed and can not find the required module! Lejing wrote: when i try to generate any project in visual c++ 2005 express edition, it always told me that the operation could not be completed and can not find the required module! Please. This is not enough information to visualize what is happening. What operation , please Are you using Menu selection New | Project | ... Or is it later - orcmid ...Show All

• Visual Studio Team System Work items seems to use sAMAccountName as key to the AssigneTo field.

  When assigning work items to people the dropdown list displays a list of sAMAccountName . In our case these are very none informative - they don't give a clue to the persons name as it consists of random letters and digits. Is it possible to get it displayed as givenName , middleName , sn or something other more readable When hovering over a user in the team project permission dialog a tool tip displays some other field from AD that is of some help to us in that case. Something similar would be nice for the AssignedTo field. Regards Christer There's been a recent development on this issue.  We have go ...Show All