anand.r's Q&A profile

• Visual Studio Tools for Office Debugging Problem

  Did anyone encounter problems in Debugging a VSTO application I am working with Excel VSTO and everytime I start a debug session it only lasts for few seconds or several steps and the VS 2005 restarts. WEIRD...... Pls help..... We had this expierience when we have had various beta versions and previous versions of Visual Studio on the same machine, have you got VS 2003 I did a complete rebuild to fix this but did think was an issue that was stemmed from VS2003 and VS2005 tool set on the same machine. Regards ...Show All

• SQL Server SSIS AcquireConnection Error

  I have written an SSIS Package that connects to an Oracle database through SQL Authentication. Whenever I execute the package in BIDS it executes without a problem but when I try to schedule the package as a Job I recieve an AcquireConnection Error. Any help I have tried the solutions outlined in http://support.microsoft.com/kb/918760 and have read through the KB but have found few solutions that pertain to connecting to remote Oracle databases through SQL Authentication. Any help would be much appreicated. KirkHaselden wrote: So, you're using SQL Server authentication to try to access your Oracle server Yes Sir, In the connection manager I am using the 'Na tive OLE DB\Mircosoft OL ...Show All

• Windows Forms Copy data from Datagrid (VS .NET 2003)

  How do I copy a row of data (user selected) from a Datagrid control so that it can be pasted into an Excel document So far I could only find information on DataGridView and none for DataGrid. I could do it with ctrl+c without any coding, but I would like to have the right click -> Copy option for novice users. Thanks, JH Thanks bola shokry, but how exactly do I copy the data Do I use Clipboard.SetDataObject ...Show All

• SQL Server Connection to SQL Server

  I have installed MS SQL Server 2005 Express Edition with Advanced Services and MS SQL Server 2005 Express Edition Toolkit SP1. Everything istalled without any errors noted. When starting SQL Server Management Studio Express, accepting the server name MAYNARD-MAIN with authentication as windows authentication. I get the following message: Cannot connect to MAYNARD-MAIN Additional information: An error has occurred while establishing a connection to the server. Wehn connecting to SQL Server 2005, this failure may be caused by the fact that under the default setting SQL Server does not allow remote connections.(provider:Shared Memory Provider, error:36 - The Shared Memory dll used to connect to SQL Server was not found)(Microsoft ...Show All

• Visual Basic Raising events from .NET UserControl inside a VB6 MDI form(Interop Forms Toolkit)

  I have used the Interop Forms Toolkit example: http://blogs.msdn.com/vbteam/archive/2006/11/02/interop-roadmap-usercontrols-mdi-and-data.aspx , and am using the example InteropUserControl. I want to raise an event from my .NET UserControl which is hosted inside a VB6 VBControlExtender type: Private WithEvents moDynamic As VBControlExtender Set moDynamic = Controls.Add("InteropUserControl.InteropUserControl", "DynamicControl") The control loads fine. How do I raise an event from the .NET UserControl so it is trapped by the VBControlExtender Unfortunately you won't be able to use ObjectEvent to catch these events centrally for the time being. This wasn't a supported scenario when . ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How to record the High score of the game, must use database :,{ ?

  I wish to record the high score of the game player, can anyone tell me how can i make it I think i can not use only the variables to make it, because all the data will lost after i closed the game. If really need to use database, then can anyone give me some link of free tutorial. Thanks A database would be overkill for just a high score being stored on local computer. You can just save it to an XML file in your game folder if you just want a simple solution. Encrypt the file or the text however you want to if you do not want the user messing with it. So you do not need a database for saving a high score for a game being play locally. However if you are needing a central location to store all of the high scores for all the playe ...Show All

• Smart Device Development No sysmbols have been loaded. .NET 2.0 PPC

  Hi all. I am trying to debug a 2.0 .NET PPC Application. The problem is that when I try to debug the application it says : No Breakpoint will currently been hit. No symbols have been loaded for this document. This happens only when I try to debug the application, cause I deploy and debug it goes fine. The point is that when I deploy the application it copies the entire .NET libraries, even the not referenced ones. Any advice Sincerely yours, agerman77 MCP CSharp / VB.NET This happened to me once before. I think I solved the problem by deleting the debugger/compiler "bin\debug" folder which, I believe, forces the app to reload all of the symbols. ...Show All

• Visual C++ Creating and using Global variables...

  I want to have variables that I can access throughout my application. To do this how and where would I need to define them. Thanks.   Alexander Stoyan wrote: Anyway, the most right solution in this case should be incapsulation.   Which I pointed out in my first post :)   BTW. use of InterlockedIncrement (and the other interlocked calls) may cause the memory bus to be locked, so using it could cause unwanted overhead in a singlethreaded application with rapid calls. ...Show All

• .NET Development loading tables with relations to two combobox

  I have 2 Tables, Customer and Product they are related with a customer id field. I have a Customer Combo box and Product Combo box. I would when I select a customer the product combo box will be filed with all product of that customer. How can I achieve this try this one out Dim myConnection As New SqlConnection(<conection string in here>) myConnection.Open() Dim myCommand As New SqlCommand(" SELECT PRODUCTNAME FROM PRODUCT WHERE CUSTOMER_ID = CUSTOMER.CUSTOMER_ID" , myConnection) myCommand.ExecuteNonQuery() Dim myAdapter As New SqlDataAdapter(myCommand) Dim myDataset As New DataSet() myConnection.Close() myAdapter.Fill(myDataset) Dim  N As Integer Dim   ...Show All

• Commerce Server CS suitability to a generic customer portal

  Is COmmerce SErver suitable to be deployed as a generic customer portal . We may not have canned catalogs not need to collect credit card info and are mor ein the custom business. But we do have standard business flows, like quoting for custom job, ordering, invoices and company<->customer information flow. Yes Commerce Server is 5K and growing on CS200X. ATG has somewhere around 600 customers and IBM WebShpere has somewhere around 1200. You will need to confirm these numbers with some analyst's sites. -Max ...Show All

• SQL Server How disable IDENTITY on column

  Hello, I have big problem with IDENTITY column in table. I must disable this function in 500 tables in my system and i don`t know how do this :( is it such way in order to do this something to start with use northwind select IDENTITY(int, 1,1) AS ID_Num, name AS NAME into #alltables from sysobjects where xtype='u' BEGIN TRANSACTION declare @ctr int select @ctr=0 DECLARE @CMD NVARCHAR(200) while @CTR<>(SELECT MAX(ID_NUM) FROM #alltables ) BEGIN sELECT @CTR=@CTR+1 SELECT @CMD= 'SET IDENTITY_INSERT '+NAME + ' ON' FROM #ALLTABLES WHERE ID_NUM=@CTR EXEC (@CMD) END ROLLBACK TRANSACTION SELECT * FROM #ALLTABLES rollback transaction ...Show All

• SQL Server Missing ODBC drivers - please help!!

  Hi all For some reason, my Excel / Access drivers have disappeared from the list of available data sources when running the Import wizard or when trying to create a dts package. They are installed on the machine as I can see them through the ODBC Administrator. I have googled extensively, found some posts relating to TimeSlips (not relevant as not installed), re-installing MDAC. Having done all the relevant stuff (updating to latest MDAC), still not coming up. Installed SQL 2005 Management Studio thinking that may help. Still nothing.Can someone please give me some advice, APART FROM RE-INSTALLING OS. How does Import wizard pickup the available drivers, any registry settings... Currently running XP SP2 with all the latest updat ...Show All

• Visual Basic VB.net inserting variable into SQL table

  Dim Lastdate as Date Dim ID as Integer mySqlCommand = New System.Data.SqlClient.SqlCommand("INSERT INTO RHscheduledateid(Date, ID) Values (LastDate,ID)", SqlConnection) date column is in datetime format Id column is in integer format however when i run this the debugger show me that System.Data.SqlClient.SqlException: The name 'LastDate' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() same for ID, but i know they are just variables.. i set ID = 1 please help me fix this mySqlCommand = New System.Data.SqlClient.SqlCommand(" ...Show All

• Software Development for Windows Vista Creating Self-Issued Card backed by a Smartcard Certificate?

  Is it possible to create a self-issued card that's backed by a Certificate on a SmartCard Hello Francis. Backing a card means supplying a mean of authentication with the STS that is invoked for issuing you the token described by the card itself. So if you back a managed card with a smartcard the STS will authenticate you according to your usage of a private key, if you back a managed card with u/pwd the STS will perform a check on that, and so on for all the 4 supported authentication methods. A self-issued card obtains its associated token by contacting an internal STS, to which you're already authenticated from the sheer fact that you are using the UI on that machine. Hence, there's no need (or way) of "backing" a ...Show All

• Visual Studio Express Editions How to get the filename into the "Insert Pictures" dialogue??

  Our company written a marco that as same as the "insert -> picture -> from file" dialogue, but we want to enhance it to get the filename automatically when the dialogue box is opened. These forums are for VB.NET questions. VBA (Visual Basic for Applications) then this is a very different product from VB.NET and there are some other locations where you will get a quicker and better response to your VBA questions. You may find more assistance in following which specifically deals with MS Office development. Office Automation: office.developer.automation newsgroup http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.office.developer.automation&lang=en&cr=US Or the Offic ...Show All