brian_tsim's Q&A profile
.NET Development Return argument has an invalid type - security issue?
Hi, We have a .NET remoting application server, which works great by itself. We are currently evaluating a commerical automated testing tool, that loads the application server's API assembly and simulates a client connection to the server. However, under this scenario the proxy object does not succeed in dealing with complex objects, and we get the "Return argument has an invalid type" error in return. We figured it has something to do with security issues but couldn't find any solution. We are using a tcp binary channel with typeFilterLevel=Full. The interface for the complex object AND the complex object itself are defined in a separate assembly (ApplicationServer) then the API (ApplicationSeverAPI). Thanks, Ron ...Show All
SQL Server How to determine output format during rendering?
Is there a "global" variable I could test for the output format I need to change styles/formats for a report based on whether its XML, Excel or CSV. There has to be a better way instead of developing reports for a specific format, in other words, I would like one report instead of multiple versions. Any suggestions would be helpful. Bob Hi, no so far there is no render-specific format. You will have to design the report for the appropiate format or produce a report to fit all rendering formats. HTH, Jens SUessmeyer. --- http://www.sqlserver2005.de --- ...Show All
Visual C++ Reinstalling VC++ 2005 - New machine
Hi, This week, I acquired a new computer. Before I erase former computer, I installed and configured my development environment. No problems except when I tried to install and configure Visual Studio 2005. Everything went OK except the fact that after successfully compiling a sample C++ application, I cannot run it... I even tried to run a few C++ applications (.exe) I made in the past (out of VC++ 2005 environment on former computer), directly from Windows explorer, and I cannot run them either... Seems something is missing... I compared programs installed between my former machine and my new machine and the only difference I could see ...Show All
SQL Server Execute SSIS package in a system without SQL server.
Hi all, Is it possible to execute a SSIS package in a system which doesn't have SQL server installed on it Note : The rights to use xmdshell is not given on the SQL server where the package resides. Any help would be appreciated. Thanks, DB Analyst To be correct the answer I think is yes. It is somewhat open to interpretation, but as I think of it, there are four main server components today - SQL Server Integration Services Reporting Services Analysis Services Whilst there is some dependency, notably RS requires a SQL DB somewhere, they can each be installed separately, and on separate machines. People often scale out in this way, with each server on a dedicated ma ...Show All
SQL Server Quest for advanced queries
I am pretty good at T-SQL as a .NET Application Developer, but now I need to take my skills of writing queries to the next level: the level required for Database Developers. I am sick and tired of writing simple inner join' s with a couple of where 's. I have a few books ("SQL Server 2000 Bible" and "The Guru's Guide to Transact-SQL"), and Books Online are always available, so I have no problems with finding the answers. The problem is not with looking for answers, but with finding questions... Could someone please recommend me some source of good SQL-related questions, which would require writing complex queries (not just a few inner joins) A book (perhaps, some university's textbook with lots of advanced exer ...Show All
Visual Studio Tools for Office Finding the current Table
Hi, I have a Smart document with XML tags inside of a Word.Table. The rows repeat these XML tags so I end up with Word.XMLNodes. This is not a problem, but I would like to have different information load into my action pane when different XMLNodes are entered meaning that I want the user to enter information into the action pane, then be able to come back to the same node and populate the action pane with the previously entered information. I would also like to have different information for each XML node created by the user(as rows are added to the table). How do I get the row index of the entered node Thank you in advance for your help and support. Thank you very much for your help. I just ca ...Show All
SQL Server query for recordset data into sql table
Hi, i have a recordset on an asp page and put into session now i want to move this recordset data from session to sql server table.how can i query this.Pls suggest me... any suggestion will be appriciable... Thanks Hi, depending on your version of ASP the work to be done can differ, but here is the ASP.NET 2.0 approach, if you have the data in the session: -Get the data from the session -cast it to a usable data object (like datatable) -Use a sqlcommand or datadapter to update the data on the database (depending on your implemented database interface, DML Command Access or SP access this can differ) HTH; Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All
SQL Server How to define a Left Outer Join in report using ReportModel as DataSource
Dear ppl, I got a Report Model Project, in which i have created a model of my Database and deployed it on the server... Then I have a Report Server project for my reports. The reports are using Report Model as the DataSource... Now in the Report Designer, inside a report, when I define query for Dataset using Report Model , I can't find a way to write a left Outer Join query... It always performs Inner Joins... was wondering ether Report model supports Outer Joins ... I might achive this using two different datasets but then i'll end up using two data regions e.g. 2 tables, but i don't want to do that... instead I want all of my data to appear in a single table which can reference to single dataset. Is there a way to define ...Show All
Visual C++ (MSVCRT) _iob disappeared?
What can I do to replace the functionality of _iob Seems to be missing in MSVCR7/8 (using VS2005). I've seen the __iob problem as well... I'm trying to make a mixed managed/native C++ wrapper for a static third party library. Upon linking, I get errors saying various symobls are already defined. E.g. libcmt.lib(mlock.obj) : error LNK2005: __unlock already defined in MSVCRTD.lib(MSVCR80D.dll) I get over 20 errors... so then I tried changing the linker settings to "Ignore Specific Library" for libcmt.lib. Then when I build I get rid of all the "already defined" errors and instead end up with just: error LNK2001: unresolved external symbol __iob from within the static third party library S ...Show All
SQL Server CPU Spike with SSAS and SQL Server Management Studio
I'm having a problem connecting to Analysis Services in SQL Server Management Studio. When I select Analysis Services as my Server type, and my workstation as my Server, SQL Server Management Studio spikes the CPU. Usually it will make the connection after several minutes but sometimes it never comes back and I have to kill the SQLWB.exe process in task manager in order to regain control of my machine. The first time I try to connect the CPU is usually spiked by a combination of Explorer.exe (30-50%), CSRSS.exe(30-50%), SQLWB.exe(0-20%), and MSMDSRV.exe (0-20%). If I disconnect and try to connect again, CPU it spike almost exclusively by SQLWB.exe but it takes less time to make the connection. I am running SSAS 2005 SP1 and Wind ...Show All
SQL Server JDBC Integrated Security problem
Hi, I am using the latest 6/26 JDBC driver to connect to sql server 2000 server. My url is jdbc:sqlserver://hostname:1433;integratedSecurity=true;. I was getting the following errors "Invalid integratedSecurity property value:true". Any suggestion to resolve this problem. Thanks. Hmm not really sure what the best way would be. I would create a windows dll and call from the Java app into my dll to use Windows impersonation APIs. This looks promising though: http://www.onjava.com/pub/a/onjava/2004/02/25/javavsdotnet.html page=4 ...Show All
Visual Studio Express Editions Assembly Resource File
I'm creating a new multilanguage application (french - english) and I'm following the step described in this MSDN Walkthrough. http://msdn.microsoft.com/library/default.asp url=/library/en-us/vbcon/html/vbwlkwalkthroughlocalizingwindowsforms.asp I set up the different string for the Form using the localizable and language property without a problem. It's working fine. However, I have to setup the string to put in my message box. To follow the walkthrough, I have to manually add resource file. Apparently the Assembly Resource File template is not part of the VB2005 Express Edition. Where can I find this template or is there an other way around it Thank you Did you ever find a resolution to this ...Show All
Visual Studio 2008 (Pre-release) lambda expression
Any plan to support lambda expression(or anonymous delegate) http://public.research.att.com/~bs/N1968-lambda-expressions.pdf cliext::for_each(v.begin(), v.end(), <> (String^ x)->void {Console::WriteLine(x);} ); Jonathan Caves - MSFT wrote: We will support anonymous delegates (which are not exactly the same as lambdas) in a future release of Visual C++. great! I do wanna use anonymous delegate to make simple/convenient adhoc functor (as C#). I hope it will be available soon. ...Show All
Visual Basic Fraction to decimal
Hi! I have a list with prices of US Treasury bonds. They are quoted in a particular way that I would like to convert to decimal form. They are quoted like this eg: 99-02. Now this means that the price is 99 and some decimal. The two first numbers are the number of 32:s. Thus in this case the price is 99 and 2/32. However if there are three decimals eg 99-021 the last digit refers to the number of 124:s. Thus the price is 99 and 2/32 and 1/256. Sometimes There are only two decimals followed by a plus or minus sign eg 99-30+ or 99-10-. The plus/minus indicates that you should add/subtract 1/64. Keep in mind that the non decimal numbers may be one, two or three digits. Thus, it could be eg. 6-02 87-22- or 105-21+. Is there any wa ...Show All
Visual Studio Express Editions resizing of vector drawings
I am starting out in drawing some vectors, by drawing a grid. My grid drawing method is triggered by the _Load event, and the same method resizes the grid, triggered by the _ResizeEnd event. I have looked around, made a few guesses, but I cannot find an event for when the window is maximised, or Restored down (based on the maximize button) , I would have hoped the _ResizeEnd event occured at the end of all resizing. Can anyone help, thanks. (I suspect its pretty obvious, just can't see it myself, at the moment.) Best wishes, Ray Hi Mike, I tried a few more examples - I wish I understood what they all meant -- I was getting the grid fine, if I dragged the window to a different size, or if I cl ...Show All