Manivannan.D.Sekaran's Q&A profile

• SQL Server Agent cannot run SSIS package anymore - URGENT!

  I desperately need help with this problem. I've spent an entire week, tried another server, new install of SQL Server, you name it.  I think it is permissions but I can't be sure and am lost on what to try anymore, I feel I've tried everything: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=189199&SiteID=1 nothing has changed, I don't know why any agents I create or even recreate the package won't run this package or a ...Show All

• .NET Development About vb.net 2005 to connect MySQL

  Hi , i don't know how to connect the vb.net 2005 to MySQL. use ODBC Oledb Can give me the sample statement to connect mysql In the vb.net 2005 , i use the create database, but it just can select access or SQL Server. how can select MySQL i want to select the data directly to DataGridView Component, how to do Please help ! ...Show All

• Visual Studio Express Editions Can't enter project settings

  I can't enter my project settings, in both beta1 and beta2-applications. How can I fix this BTW, my Beta1-projects don't work either. There seems to be problems in the MyApplication.vb... Ok thanks...got it working now..these were the steps and scenario that I have and did... xp pro Uninstalled - Visual Studio.NET Standard Edition (2002 Version I think) Uninstalled everything the list said to...(the list that was on the download section of ...Show All

• Windows Forms Setting DateTimePicker to empty

  Hi, Does anyone know how to set the default value of a DateTimePicker to empty (or null) Thanks Ray There is a property on the control to se it to null. if (drTransPort[field] != DBNull.Value) {    datePicker.Checked = true;    datePicker.V ...Show All

• .NET Development Passing excel and word files to web services.

  We need to pass excel and word files to a web service in our application. File sizes range up to 4mb. What is the best way to pass these files to the web service I am aware of the following options. 1. Pass the files as binary data embeded in the xml 2.Use DIME/MTOM support for this. For the file sizes up to 4mb which of the above options works fine. A code snippet on how to convert the excel files to binary data and converting bi ...Show All

• Visual Studio Tools for Office UDF in Excel XP with C#

  HI All I'd like to write UDF in Excel XP using Visual C# Express Edition just downloaded. I'm quite new to C# so I searched on the web for some examples, and I found this http://blogs.msdn.com/eric_carter/archive/2004/12/01/273127.aspx . I followed all the steps suggested (I do not post the code because it's exactly the same you can find in the article above), added the Automation Add In to the Excel Add In list. Then I put into a cell ...Show All

• Windows Forms Error installing: "cannot download the application" - help?

  I've compiled my windows forms application (a product called "dropshark") and published it. In the release directory that I created, I see the setup.exe, two .application files (one named dropshark.application and one named dropshark_2_5_0_3.application - and both appear to be identical), and a directory called DropShark_2_5_0_3 that appears to have all of the files (with .deploy extensions). Hitting the default.htm (I renamed it, in the se ...Show All

• SQL Server Date field cannot be null!

  Visual Basic 2005 Professional Edition: I have an SQL database table that includes a BirthDate field. I would like to have this field as optional when adding a record, but, SQL insists on throwing an exception if the field is null. With this it looks like your table design has the field set not to allow nulls. You will have to alter the table definition to allow nulls for that field. This can be done in ...Show All

• SQL Server Which version of VS?

  Hi all! I'm learning about SSIS, and now I want to develop my own custom components. After looking in Internet, I have all the information that I need except one thing: which version of Visual Studio must I use Can I use Visual Studio Express Editions  Have I to download the "normal" edition Thanks in advance. I did not try, but I think Express editions should be enough for this. During the beta testin ...Show All

• Windows Forms VB.NET2003 - Items in ListBox are invisible

  Probably a simple answer, but I just loaded VS.NET2003, and opened a sample applicaiton with 3 items in a preloaded in dropdown combo list box. when I click on the dropdown, the preloaded entries are invisible when I click on one it displays in the selected box   I tried a simple list box with 5 preloaded values and I can tell they are entries but are invisible.... I even checked to see if the background foreground colors got change to t ...Show All

• Visual C++ separate class files for namespaces

  I'm writing some C++ library classes that I plan to use in my applications. Making a DLL. I write the classes in my_class.h, my_class.cpp file pairs. If I wish to organize these classes into namespaces, how do I do it without cutting & pasting the code text into a suingle translation unit Should I be using a MFC library object or a .NET class library Could you clarify your question What do you mean by "sin ...Show All

• Windows Forms Web Browser URL Help

  Trying to get the Web Broswer i inserted into my project to go too a different Website when its typed into the toolStripComboBox, here is the code i'm working with...Not sure if its complete if not can someone help me to fill in the blanks...Thxs in Advance private void webBrowser1_DocumentCompleted( object sender, WebBrowserDocumentCompletedEventArgs e) { String sURL = ( String )e.Url; int index = toolStripComboBox1.FindSt ...Show All

• SQL Server Cannot Enable Remote Connections for AS 2005 on clustered instance

  Hello SQL pros - I am having a problem with enabling the remote connections for Analysis Services 2005, Here's the gist.... --Error Information-- "To configure Analysis Services for Remote Connections, you must be an adminsitrator for Analysis Services Windows Service (SQLSAC). Additonal Info A connection cannot be made. Ensure that service is running (Microsoft.AnalysisServices) No connection could be made because the target ma ...Show All

• Visual Studio Cast error when pass a parameter in localreport and reportviewer

  hello friends, i have a problem with my report when pass a pamameter in vb.net and VS 2005 The code is: Dim objParameter As ReportParameter objParameter = New ReportParameter( "Name" , "test" ) Me .ReportViewer1.LocalReport.SetParameters(objParameter) the error is: System.InvalidCastException was unhandled   Message="Unable to cast object of type 'Microsoft.Reporting.WinForms.ReportParameter' to type 'System.Collections.Generic. ...Show All

• Visual C# Richtextbox spell check

  Does anyone know of a cheap commerical component that offers spell checking for the richtextbox control I understand how to use the office interop which allows access to the MS Word spell checker. Yes, it's easy to get the mis spelled words and suggestions using interop, but I want the spell as you type option with suggestions when you right click... perhaps there is a free component floating around with these options Any help Always app ...Show All