smitra's Q&A profile

• Microsoft ISV Community Center Forums Displaying modeless userform while other workbooks are opened and closed

  I tried using the following code to display a modeless userform with a "Please Wait.  Do not Interrupt" message while a set of workbooks are initialized. Private Sub btnInitToolset_Click() Dim Answer As String Answer = MsgBox(prompt:="Are you sure you want to Initialize the Toolset " & vbNewLine & "All data will be lost.", Buttons:=vbYesNo + vbQuestion, Title:="Warning!") If Answer = vbNo Then Exit Sub     InitWaitForm.Show vbModeless     '\ Initialize the Toolset     Call initToolset     Unload InitWaitForm     MsgBox "Toolset has been initializ ...Show All

• SQL Server Query Results Truncated in SSMS

       I'm running a query in SSMS that returns a large result set.  The query runs fine without error.  However, in the results pane the query results are truncated.  I've tried adjusting every option I can find.       I think I'm running into a limit on the number of characters displayed in a column in the results pane.  I've already bumped up the amount to the max (8192) setting in the option settings.  This is not enough.  What are my options   I've already tried "sqlcmd".  It can't handle the results returned either (same truncation effect, only ...Show All

• SQL Server Unexpected behavior when setting a script task breakpoint in package w/ multiple script tasks

  I ran into a variety of problems trying to set a script task breakpoint in a package containing multiple script tasks. The debugger apparently treats the breakpoint as if it were set in ALL tasks in the package, not just the one in which it is actually set. At best this results in hitting breakpoints in scripts where they are not set and at worst the debugger brings up the "Send error report" dialog and quits (while the package continues to run). The latter seems to happen most often when the script with the breakpoint has more lines than an earlier script and the breakpoint is set at a line number that exceeds the number of lin ...Show All

• Visual C++ Linking-Error with VSC++ 8.0

  hey ho, I just updated my project from VSC++ 7.1 to VSC++ 8.0 Express Edition. Unfortunately, i get a linker error every time i compile my project: 1>msvcprt.lib(MSVCP80.dll) : error LNK2005: "class std::basic_ostream<char,struct std::char_traits<char> > & __cdecl std::operator<<<struct std::char_traits<char> >(class std::basic_ostream<char,struct std::char_traits<char> > &,char const *)" ( $ 6U $char_traits@D@std@@@std@@YAAAV $basic_ostream@DU $char_traits@D@std@@@0@AAV10@PBD@Z) already defined in main.obj 1>Release/test.exe : fatal error LNK1169: one or more multiply defined symbols ...Show All

• SQL Server sql server 2005 trial version

  where is the import and export data function in sql server 2005 express i have a data in ms access which i want to import to sql server 2005 express.. thank you   erd wrote: do you have to uninstall the existing sql server 2000 enterprise edition to install the sql server 2005 trial version does it have to be clean install Hi erd, you don't necessary have to. However to do an 'upgrade' you have to ensure that your system has the meet sql 2005's minimum requirement stated in the sql2005 details website as well as doing some preparation work before performing the upgrade. Its adviseable to foll ...Show All

• Visual C++ VC2005 Beta2 Crashes

  Hello, I'm running beta 2 on a W2k SP6 machine. I have a large solution converted from VS2003 that is all native C++ code. The development environment is having persistent crashes. A crash happens every minute or so and I get a group of dialog boxes that say something to the effect "unknown software exception 0xc000000d at location 0x7c3b3984, ok to terminate, cancel to debug"). I can choose 'ok' and continue running the program(!). I usually end up moving the message dialog mostly off screen and continue working (modeless dialog). Is this a known issue Another problem - when I change a project's properties (say disable warning 4996) and ...Show All

• Visual Studio Copy build files

  Hi, I need copy all my build files in a result folder. I use this task but don't work... Can you help me Thanks <Target Name="AfterBuild"> <Copy SourceFiles="@(TargetDir)" DestinationFolder="c:\foocopy" /> </Target> Not sure if you've redefined TargetDir, but looks to me like it would resolve to a path, where what you want is a list of files...since you can't use wildcards in the SourceFiles parameter (you don't get an error but it doesn't work) you need to create an item group <CreateItem Include="$(TargetDir)**\*.*"> <Output Task ...Show All

• .NET Development .Net CLR 2.0 and Visual Studio 2003

  In VS 2003, can you reference the .Net 2.0 library and access some of the new classes Sadly no. For many reasons (aside from just incompatible classes), the metadata structure of 2.0 assemblies had to be changed in such a way that makes accessing them from the 1.0/1.1 CLR impossible. You can however go the other way around and access 1.0/1.1 assemblies from a 2.0 app. If you do want to get into some 2.0 development and don’t want to spend a lot (or anything for that matter), you may want to look at the free Visual Studio Express Editions . ...Show All

• .NET Development Error when compiling a class that uses web services in release mode

  Here's the case (simple scenario to make things short): I have a web service that has 2 dataSets defined in it, both of them contains dataTables with the same names (myDataSet contains myDT and myDataSet2 ontains another myDT). when I create a project the references this web service, I have no problem compiling it in debug mode, but when I compile it in release mode I get the following error: Error: The top XML element 'myDTDataTable' from namespace '' references distinct types ClassLibrary1.myWS.myDataSet.myDTDataTable and ClassLibrary1.myWS.myDataSet2.myDTDataTable. Use XML attributes to specify another XML name or namespace for the elemen ...Show All

• Visual Studio Team System Testing webservice for XML with MTOM Element

  Hi,   Does anyone have ideas about testing a webservice which accepts xml data with MTOM element in it The service generates two id's(guids) one for the header and one for the message body for each message sent.   Thanks, The best way is to use a unit test that calls the web service. Then the .NET framework and WSE will handle this for you. You can get WSE 3.0 here: http://www.microsoft.com/downloads/details.aspx FamilyId=018A09FD-3A74-43C5-8EC1-8D789091255D&displaylang=en Ed.   ...Show All

• Windows Forms raise events for control collection

  This might be disturbingly simple, I have 225 buttons on a windows form application that all need to run the same code, I can put them all in a Panel or group them in a ControlCollection Object, I just need to know how to Raise Click Events for this 'group' of controls, VB studio 2005, using Visual Basic. I found an example in help, for .Net 2003, but it doesn't work. Any help or links would be appreciated. Ben thanks much New to using VB Studio, Much easier than solution i found that didn't work. Lol ...Show All

• .NET Development How to Modify Codebase Path for New AppDomain

  I would like to know if there is a way to change the probing directory used by the Loader to locate assembly dependencies. What I am interested in is a way to create a new Appdomain, and modify the path used by the loader to locate assembly dependencies (I would be satisfied if I could do this in the default AppDomain). The final result would be an application that hosts an appdomain (named NewAppDomain for the purpose of the illustration). The assemblies loaded in NewAppDomain would have their dependencies searched for in a specified directory, NOT the directory of the hosting application/AppDomain. I understand there may be CAS issu ...Show All

• SQL Server QueryLog to a file

  Hi I am trying to generate a query log to log to a file but the file never gets created. Just to confirm. Is just setting the server parameter Log \ Query Log \ QueryLogFileName sufficient given that the other parameters are at their defaults Thanks Make sure you give your QueryLog file an extention .trc You might need to restart Analysis Server after you change "QueryLogFileName" server property. Edward. -- This posting is provided "AS IS" with no warranties, and confers no rights. ...Show All

• Windows Forms WebBrowser to view documents like word docs

  I have being using the WebBrowser control to show documents like office files and pdfs, i am now changing my EXE to an ActiveX to use in my new web application only now i get an exception saying "Adding a WebBrowser control in Internet Explorer is not supported" at System.windows.forms.webbrowser.CheckIfCreatedInIE Due to the encryption and way my program must work it must be ActiveX so does anyone know how to get around this or raise events back to the parent Internet Explorer (which does not apear as my controls parent) Thanks in advance, Paul As far a I know, you cannot embed an active ...Show All

• SQL Server SqlServer2005 can support merge replication with SqlCe2.0??

  Hi guys, Correct me if I'm wrong. That's wat I was doing.. Try to perform a merge replication between the 2. But the following errors are wat I've got during the syncronization: Error Code: 80004005 Message : Run Minor Err.: 28557 Source : Microsoft SQL Server 2000 Windows CE Edition Err. Par. : ssce:database;password=mypassword;data source=Program Files\helloWorld\database.sdf; Error Code: 80040E14 Message : The OLE DB Execute method failed. The SQL statement is not valid. [,,,SQL statement,,] Minor Err.: 28560 Source : Microsoft SQL Server 2000 Windows CE Edition Error Code: 80040E14 Message : There was an error parsing the query. [Toke ...Show All