Nick.Muguira's Q&A profile

• Visual FoxPro Using VTable interface of Excel Component from FoxPro 8.0

  I am writing a FoxPro program that uses the Microsoft Excel component in order to generate a XLS file. However, FoxPro is evidently using the IDispatch form of the Excel interfaces instead of the VTable interface. How do I write the program so that FoxPro will use the VTable interface instead Sorry it took so long to acknowledge your reply.  The component is working fine using CREATEOBJECTEX().  We were importing and programatica ...Show All

• SQL Server The SQL Network Interface library was unable to register SPN. Error: 0x54b

  I am running SQLExpress 2005, on Win 2003. Occasionally in the event viewer I see the message: The SQL Network Interface library was unable to register SPN. Error: 0x54b When I click on the link on the event viewer for more info, there is no further details. Can someone clarify what this message means and should I be concerned Thanks Hi, Is your machine part of a domain or just workgroup This probably i ...Show All

• SQL Server send mail task error

  Hi All, I am trying to use Send Mail Task to send mails within my package and I get the following error. "The server response was: 5.7.1 Unable to relay for test@mail.com". Can anyone help me on this Thanks Talk to the person who manages you SMTP server. Simply put mail servers are secured and only accept messages for certain addresses. To relay a mail is to accept the mesage from a clien ...Show All

• SQL Server Accessing AS400 Data

  I've been trying to use the integrations services to access AS400 data with almost no success.   Any suggestions or help you can give me would be appreciated.  Some of the issues I can't make sense of are the following. 1.  When I set up an OLEDB data source for the AS400 (using IBM's Client Access provider) I always get a warning message about "Cannot retrieve the column code page information from the OLEDB provider". & ...Show All

• SQL Server Triggers that update a column name in the master table

  I would appreciate any insight. I'm new with SQL and am trying to get a trigger to function. Here is what I'm trying to accomplish. I have a table called Asset_master that contains assets that are available, with a column_id of status=available. Once a users selects the available asset from the form, I have it writing a new record to another table called asset_provisioned. I'm trying to use a trigger to change the status=available to status ...Show All

• Visual Studio Fileless editor

  I want to add an editor that works not with a single file but rather modifies elements in various files in the open solution. I can tell that I need to implement a custom editor which I have started doing (using the wizard, that is). I suppose that I will have to remove a number of persistence interfaces etc. for it to become fileless. But how do I instantiate it then I have called CreateEditorInstance, and it seems to work but nothing happens ...Show All

• Visual Basic Trouble reading bits.

  I am trying to read a byte from a certain address in a file. But, I am trying to read the byte in bit format (bits 0-7). I have tried to use the BitConverter and the BitArray classes but I cannot figure it out. I am pretty sure that BitArray is the one I need but there are no methods that look like they would do anything I want. Maybe I am just missing it. I checked the help section but the examples there were not what I am trying to do. Any ...Show All

• .NET Development How to get field value in attribute constructor?

  There is a StringValueAttribute attribute.  The user can use it to associate string values with an enumeration field. In the first constructor of StringValueAttribute, two string arguments are passed and can be used to explicitly assigned to _databaseValue and _resourceKey.  This is illustrated in MyEnum.EnumValue1. My question is in the second constructor with only one string argument.  Since the resource key string is not pass ...Show All

• .NET Development .NET client/server using SOAP/HTTP how to do so?

  I am in the process of designing a .NET application that will have a client/server and a web based module. However the database will be hosted on the Internet and I don’t want to give direct access to the database for security purposes. I am thinking in some kind of HTTP/SOAP/XML connection. I have been reading about performance issues... however is the way we need to follow. Could you give me some URLs for further reading on this ...Show All

• .NET Development HttpChannel or TcpChannel?

  Hi, I've been developing an application to transfer files between a client and a server. There is a remotable objected hosted in IIS on the server. The client portion uses a desktop application to transfer fiels between client and a server. To pass through firewalls, I decided to use HttpChannel but I found the following in MSDN: A HttpChannel opens only a specified number of connections at one time to a given server. The default is two ...Show All

• SQL Server "Group" property is not displayed.

  I've a simple question. I was trying to generate a List Report. I created a List Object on the pane and placed a database field something like " =Fields!ProductName.Value ". I want to display the report group by the database field selected above. and subsequntly use this feature to place some more fields. In the Properties window (select the database field object not the list object and use F4 key to display properties window), when I t ...Show All

• Visual C++ msoftconf

  Hi, I am a relatively new c++ user. I have created a project in Visual C++ Express Ed. and in one of my c++ files, I have #include "msoftcon.h" However, the compiler cannot find the file. I searched my computer for a file with that name but nothing there. Could anyone please tell me how I can get my app to work TIA Hi Guys, If any one of u need to download "msoftcon.h"...You can download it fro ...Show All

• Visual Basic NULL character in text box

  I want to display a string with a null charcter. sample : "TOTO<NULL>TITI" in the text box, only : "TOTO" Why Thank's Null is not valid for a string data type. You can use an empty string or an actual character value, but not Null. ...Show All

• Visual Studio Team System can not access database after generating code in web test.

  hi, there I created a web test using data source to repeat runs, it worked fine. But when i generated code and run this test i got following error message: Could not run web test 'xxx_Coded' on agent 'xxx': Could not access table 'xxx' in data source 'xxx' of test case '00000000-0000-0000-0000-000000000000': Login failed for user 'xxx'. i can run xxx_Coded without data source. and i don't change anything in xxx_Coded.cs. How can i ...Show All

• Windows Forms Full screen

  Hi, I am using window XP. I am making a full screen form. I maximize the form by: Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Width = Screen.GetBounds(Me).Width Height = Screen.GetBounds(Me).Height Left = 0 Top = 0 End Sub However, the title bar is still exist. How can I hide the title bar ...Show All