Ajeet Kumar Gupt's Q&A profile

• Visual Studio Tools for Office Call VSTO Addin functions from external application?

  Hi all, Please pardon me if this is not the right place. I'm looking for a way to call functions in a VSTO Addin from an external application. In VS2003 and Shared Addins, I used to be able to do this using this code in the external app: lole_object = iole_outlook.COMAddIns.Item("OutlookIntegrator.Connect").Object -- synchroniseAppointments() is a publically declared function in the Addin lole_object.synchroniseAppointments(ls_diarynoteIDs) However, when trying this using a VSTO addin, it did not work. From what I can gather after some research, this seems to be just the way VSTO addins are s ...Show All

• SQL Server Replication Error

  I found a problem in replication which we have 3 tables, namely tab A, tab B and tab C replication will apply on tab A and tab B and there is a trigger on tab A and tab B, whenever insert/update on tab A it fires trigger to update tab b whenever insert/update on tab B it fires trigger to update tab C And I found the replication error from tab A on updating tab C. If I manually insert the row, it works fine..... Any advise Thanks in advance! Error Code 515: Cannot insert the value NULL into column 'amount_id', table 'dev.dbo.tab_c'; column does not allow nulls. INSERT fails. Thanks ...Show All

• SQL Server A call to SQL Server Reconciler failed. Sql Mobile, BusinessLogicModule

  I got a merge replication published by my SQL Server 2005 and subscribed by my Pocket PC emulator having SQL Mobile. This works fine. I've now developed my own class to handle my business logic according to MS specifications. Inherits from BusinessLogicModule in Microsoft.SqlServer.Replication.BusinessLogicSupport. I had by using the sp_registercustomresolver and sp_changemergearticle. When I now try to synchronize from the emulator I get the error Message: "A call to SQL Server Reconciler failed." Native Error: 29006 Source: Microsoft SQL Server 2005 Mobile Edition Any ideas what has happened I also try ...Show All

• Visual Studio #Error and null values

  Hi all, i have a problem with null value in field. If field containts null value - i get displayed an #Error where value should be. Checking for nothing or IsNothing doesn't seem to help Any suggestions where to look I'm having the same problem and am desperate for an answer. If the IIF function wasn't short-circuited we'd be OK but since it evaluates everything we're stuck. Someone missed the boat on designing this function. Since .Net now has nullable types it's usefullness is very limited. I looked into implementing the IReportViewerMessages interface to provide text for this that I could use inste ...Show All

• Windows Forms Getting a CSV file into a dataset-ADO.NETor TextReader?

  Hi I would like to get a CSV file into a dataset, using the following arguments: Text Delimeter (normally a comma, but not always) Text qualifier (String, normally a double quote, but not always). First row is column headings (boolean) 'Consecutive Delimeter Counts as One' (boolean) So I am trying to do essentially what Excel does when you import a text file.  Is the ...Show All

• Visual Studio Team System RootNode.Icons property

  The RootNode.Icons property holds icons to display in the Team Explorer tree. In my custom Team Explorer plugin I have run in to a strange problem regarding this property. When my plugin is initialized and icons are added to the imagelist, and nodes have their IconIndex set, the icons are correctly shown in the explorer tool window. When I later add a new node, and in some cases also a new icon the the imagelist, the new node just displays a red x, instead of the new icon. If the new node uses an existing icon, it displays correctly. I have verified that the added icon does infact get added correctly to the imagelist, and that the c ...Show All

• Visual C++ MFC portability

  I wrote a program and compiled it on my laptop(WinXP Home) using MFC in VS 2003.NET and took it to school and tried to run it on one of their computers(WinXP Pro) and I it said it couldn't run because it couldn't find "MFC71.DLL". Are MFC programs not portable and if not is there a way to write a program in Visual C++ so it is Nathan87 wrote: I wrote a program and compiled it on my laptop(WinXP Home) using MFC in VS 2003.NET and took it to school and tried to run it on one of their computers(WinXP Pro) and I it said it couldn't run because it couldn't find "MFC71.DLL". Are ...Show All

• SQL Server Questions about sp_addlinkedsrvlogin

  1. Is there any command in SQL Server that can tell me which remote login on the linked server have I mapped my local login 2. If I use below command to map a local user: Locallogin to the domain administrator sp_addlinkedsrvlogin 'mainsql', 'false', 'Locallogin', 'Administrator', 'pwd' What will happen if the domain administrator's password may change in the future Should I execute sp_addlinkedsrvlogin with new rmtpassword again If this is SQL SERVER 2005 you can use the catalog view sys.linked_logins. This when joined with catalog view sys.servers should give you the information you need. I am ...Show All

• .NET Development How to transfer file

  I need transfer .net assembly and run it on remote machine. How can i do it Can i use only remoting methods or i have to use sockets.   You can use either method. The remoting way is much easier to develop, configure and test, and it's performance is very nearly on a par with an asynchronous socket server. ...Show All

• Visual C++ Error C2440: cannot convert from type to type

  Yesterday I got this error in a new C++/CLI project:   Error 1 error C2440: 'return' : cannot convert from 'ZXNewtonCP::LayoutManager' to 'ZXNewtonCP::LayoutManager' d:\proyectos\rfog\zxnewtoncp\zxnewtoncp\Config.h 17 LayoutManager is a managed class, and is instantiated in class config as a stack type, not a reference or pointer. My intention was to return a reference, but I mistake the typing and got that error. I don’t know if system can return a complete class instead a reference, but the error sounds cryptic and obscure.   Public ref class LayoutManager {…}   Public ref class Config { LayoutManager lay ...Show All

• Smart Device Development Checking Version of a file

  Hi, I would like to know if it's possible to get the Version of a file (dll, exe..) directly from the desktop side. I'm using OPENNETCF with DeviceFileExists to know if the file exists or not, but I did'nt find a way to get the version number. I know that if I would I could write a device application and get the dll version number by using : System . Reflection . Assembly ; But I would like to do everything on the desktop side and to not launch the dll. But if it's not possible I could only write on the device side using the CF 1.1. Thanks, No, there's no way for you to do that without either running code on device or coping file t ...Show All

• SQL Server rs drops first column in data set

  I started having this problem some time ago when trying to build a report using a stored procedure.  Existing reports work fine, it is only new reports that result in this error: The data set ‘WeeklyManagement’ contains a definition for the field ‘BrewNumber’. This field is missing from the returned result set from the data source. I get this error when I try to preview the report.  The missing field is always the first column in the dataset.  I have tried everything I can think of, including repeating the column, rewriting the sproc, rewriting the report, everything.  I cannot find any reason why this should be happen ...Show All

• Visual Studio Report previews fine but prints blank

  I have designed a pretty simple report that has a bunch of database fields and one group on it.  Everything was going just fine and then I broke something.  When I click the 'Main Report Preview' button the report looks perfect, it even has my SQL data. However, when I run the application and load the reportviewer on my form all of the database fields are blank.  The text fields are there, but obviously some databinding propert is set wrong.  I just can't find which one. The report and .cs file can be viewed here:  http://www.rootsec.net/downloads/report.zip This is how I am loading my report on the form.  The ...Show All

• Visual Studio Team System Auto-Save of Manual Test Results in Beta2?

  I am using VSTT Beta2 and I have couple of Manual Tests defined. When I run the tests they run alright, but after I close the project I do not see any auto-saved *.trx files. Although the documentation from [ ms-help://MS.MSDNQTR.v80.en/MS.MSDN.v80/MS.VSENT.v80.en/dv_vsetlt01/html/043df693-8af2-4a85-b4ba-876446057a82.htm ] states "Visual Studio Team Test automatically saves test results to your computer's hard disk when you run tests. " So where do the test results get saved Or is that a missing feature in Beta2 PS: I know I can manually export it out. I am looking for the auto-save functionality. Regards, Saurabh Nandu www.MasterCSharp.co ...Show All

• SQL Server Error on SQL cluster install

  I am trying to install SQL 2005 in a 2-node Windows 2003 cluster. I set the cluster up through Virtual Server 2005 with 2 virtual nodes and one virtual domain.  The nodes can connect to each other as well as the physical machine.  When I try to install a fresh copy of SQL 2005 on my cluster, I get an error every time. The error stops the installation while checking system configuration after installing prerequisites. The log file entry is as follows: ******************************************* Setup Consistency Check Report for Machine: --SERVERNAME-- ************* ...Show All