Mahesh Gaware's Q&A profile

• SQL Server Data Transfer from Lotus Notes very slow compared to SQL 2000 DTS

  To extract data from an ODBC source, try the following: Add an ADO.Net Connection Manager. Edit the Connection Manager editor and select the ODBC Data Provider Configure the Connection Manager to use your DSN or connection string Add a Data Flow Task to your package. Add a Data Reader Source adapter to your data flow Edit the Data Reader source adapter to use the ADO.Net connection manager that you added. Edit the Data Reader source to query for the data you wish to extract. hth Donald Using the steps outlined above as described by Donald Farmer in another post on this forum, I have created an SSIS package which retrieves data from Lotus Notes 6.55. The DSN referenced by the ADO.Net Connection Manager conne ...Show All

• Visual Studio 2008 (Pre-release) Required or optional fields.

  I have a data contract that looks like: private string _BasketIDField; [ DataMember (IsRequired= true )] public string BasketID { get { return this ._BasketIDField; } set { this ._BasketIDField = value ; } } But when I generated the proxy for the client I see: [System.Runtime.Serialization. OptionalFieldAttribute ()] private string BasketIDField; [System.Runtime.Serialization. DataMemberAttribute ()] public string BasketID { get { return this .BasketIDField; } set { this .BasketIDField = value ; } It seems that the "IsRequired" on the property is getting ignored. One other indication is that I get an exception ...Show All

• Visual Studio How to get Output Window to show which AppDomains assemblies are loaded into?

  VS.NET 03's Output window showed which assemblies were loaded into which AppDomains. You could see, for example, that assembly X was loaded into the default AppDomain and also into a temporary AppDomain. But VS 05's Output window only seems to show which process assemblies are loaded into (e.g. 'AppDomainTest.vshost.exe'). If an assembly is loaded in >1 times (into separate AppDomains), it only seems to show the first time. Is there a good reason for this change Is there a way to get VS 05 to behave like VS.NET 03 did (which I find very useful when doing temporary AppDomain / plugin module work). TIA. Hello Andrew, Unfortunately right now this is a limitation of VS2005. We do realize t ...Show All

• Windows Forms EncoderParameters, rotating and flipping an image

  I'm trying to apply transformations to a JPEG image like so: bitmap.Save(destinationPath, imageCodecInfo, encoderParameters); Where I fill in imageCodecInfo and encoderParameters. But I would like to rotate AND flip the image, but it only applies the first transformation specified by the first index in encoderParameters. encoderParams = new EncoderParameters(2); encoderParam = new EncoderParameter(encoder, (long)EncoderValue.TransformRotate180); encoderParams.Param[0] = encoderParam; encoderParam = new EncoderParameter(encoder, (long)EncoderValue.TransformFlipHorizontal); encoderParams.Param[1] = encoderParam; This is the code I use to set the transformations, but only the rotate180 gets applied. Does anybody know how to apply them both ...Show All

• Visual Studio Tools for Office Outlook Addin On Windows 2000 Terminal Server

  I created an outlook 2003 addin and it works on my machine and other users machine. But when I tried to install it on the Windows 2000 Terminal server it is not working. Actually, addin is not loading. I do not see any registry entries as well as I do not see addin under add/remove programs. But the .msi says after installationi addin sucessfully installed. But I can see that the addin .dll is installed under local drive. The necessary prerequisites are installed on the machine. (1) .NET Framework 2.0 (2) VSTO 2005 Runtime I have used SetSecurity project as well as custom actions to make sure that addin has been granted full trust. The Custom action data has been changed to load addin for allUsers. Any idea why addin is not ...Show All

• SQL Server How run "DBCC CHECKDB" on all databases on a server?

  I can run that command easily for a single DB and then manually copy/paste that command (and change the database name each time) but does sql have a way to loop through all databses on a server TIA, barkingdog Both answers are great. But in the last one instead of While @dbid < @hidb I think it should be While @dbid < = @hidb Barkingdog ...Show All

• Visual Studio VS inproc compiler, MSBUILD and the obj subdir

  I've been toying with the new VS and MSBUILD for the last few days and I stumbled on a bit of a problem. I've been trying to move the bin and obj subdirs out of my c# sourcetree with mixed results. the bin subdir was easy, that can be set in the project settings. the obj subdir is slightly more problematic.  I've added these changes to the start of a test csproj file < PropertyGroup > < BaseIntermediateOutputPath > ..\..\obj\ </ BaseIntermediateOutputPath > < UseHostCompilerIfAvailable > false </ UseHostCompilerIfAvailable > </ PropertyGroup > now for the questions: 1) Is there a better way to move the obj path than redefining that property from Microsoft.common.targets 2) if I leave off t ...Show All

• Visual Studio Team System Cannot run Team Edition for Database Professionals if not local admin?

  Hi there, It's very annoying at our work, but we are not local admins on our machine while logged into the domain. We do have Administrator rights only when we log in as local Administrator to the machine. So when I install the CTP, I execute the setup under the local Admin account, and it installs fine, and runs fine when logged in locally. But, when logged into the domain, it does not show up as an installed product under Help -> About. I do not have this problem with any other product ie I have the BI studio, team edition developer, team edition tester, etc running fine. Any thoughts on how to get the ctp to install and run properly for me Will this work in the future Because if it doesn't we have to go buy a few licenses of ...Show All

• Visual Basic A Squigley

  Why is there a squigley under the Ex It's only under the first the message reads Unused Local Variable:'ex' Catch ex As Exception 'handles any errors MessageBox.Show(ex.Message, "PGS", _ MessageBoxButtons.OK, MessageBoxIcon.Information) Thanks Mac, That's sorted it, I had exit sub when I was testing and I wanted the stop the program at that point, I have now removed them and all is well. Graham ...Show All

• Visual Studio Building multiple solution

  Hello, I am new to msbuild and I have to automate a project. Here is the structure c:\mydir component1 Solution1 Solution1.sln ProjectA ProjectA.proj ProjectB ProjectB.proj component2 Solution2 Project C Solution3 ProjectD .... I would like to have a .proj file for each component and then a master .proj file that just call this sub .proj files. However, i need to know if a solution fail and need to do some action like send mail ,. Is this possible with msbuild . Also, I would need to copy the output for the indiviidual project to a common location . some sample code or some hints would be very helpful Thanks in advance ...Show All

• Visual Basic Help with Opening text files and pictures in the WebBrowser.

  I have been making a web browser. I made a menu, which has File > Open. It should open the Open Form form. In the Open Form from, there is a combo box and three buttons (ok, cancel, and browse). I would like to know HOW to get the URL in the combo box to load in the WebBrowser when I press Ok. I also need to know how to get a OpenFileDialog box to open when I press Browse, and then when I press the ok button (on the OpenFileDialog box), the combo box diplays the URL so that I can open it in the WebBrowser. I have tried DESPERATLY to find a solution!!!!! Any help is apreciated. THX, FSPILOT2006 Ok, so I did that, but it has an error. I need to OPEN a form and when I type a URL in the COMBOBOX ...Show All

• Visual Studio Tools for Office List Object in excel - how to stop user deleting rows

  how can i stop the user deleting rows from a data bound list object. There is no setter on the AllowDelete property of the BindingSource object, detecting when a row is deleted on the underlying dataset and rejecting the changes stops the row from being deleted from the dataset but it leaves an empty list row in the list. rebinding the BindingSource to the dataset has no effect either Ok, so I create my DataView by doing: DataView dv = new DataView(ds.Table); dv.AllowDelete = false; Globals.WorkSheet.tableBindingDataSource.DataSource = dv; I have also set on the worksheet class: tableBindingDataSource.DataSource = typeof(DataView); - this was previsouly a typed dataset The user can still delete rows from ...Show All

• Visual J# library.xml not created when called from MSBuild

  Hi; If we build out J# based DLL using VS 2005 or nant - it created WindwardReports.dll and WindwardReports.xml. If we build it using MSBuild, no WindwardReports.xml. We have a C# library also and it does have the .xml file built. Any ideas thanks - dave Hi, In C#, C# compiler generates the xml file and binaries both but J# implementation is different. In J# xml files are not generated by compiler but by the IDE Language services. When you build from IDE, IDE invokes the j# compiler (which only builds binaries) and parses the code files to generate the xml. When you build from MSbuild, Msbuild generates the binaries by invoking J# compiler but it has no clue how to generate xml file. Thanks. ...Show All

• SQL Server Failed to update database because the database is read-only.

  I am building a Windows Forms application in VS 2005, using C# and SQL Server 2005 Express as the backend. When I try to accessd data from the db, it works with no problems. When I try to insert/update/delete, I get the following error message Failed to update database "DBNAME" because the database is read-only. I am using a connection string with the following syntax: "Data Source=.\SQLEXPRESS;AttachDbFilename=c:\PATH_TO_DB\db.mdf;Database=MyDB;Integrated Security=False;User Instance=False;User ID=USR;Password=PWD;" I have made sure that the permissions on the DB are set (in Windows) so that all users can modify. The user that is logging in to the DB has status set to DBOWNER. I have ...Show All

• Visual Studio Express Editions Is it a good Idea to Access Database in the Constructor

  Hi All Is it a good Idea to access DB in the Constructor of object itself and populate the Fields of a object. Or Should I have a seperate method which will do this once I initaialize the object. Please let me know the Good practice and pros and Cons of each of the above method Thanks in advance Amol Wankhede I think it depends on what you are trying to do. As always there are trade-offs to consider and risks to evaluate. Of course, whenever you do database operations you must take care to trap potential database errors, whether it's in an object constructor or not, even whether it's in C# or some other language. I routinely initialize objects based on information stored in a database, for example, loading a particular ...Show All