MidNightQc's Q&A profile

• Visual Studio Allowing user to subscribe to a report

  Hi, I'm integrating a reportserver 2005 report into a VB application. It all works just fine, but I'd also like to give the user the same ability to subscribe to the report that he would get if he went to the report server website to view the report. I'm sure I must be missing something obvious, as all the articles I've found so far seem to imply it should just work, but I'm not seeing any UI elements to support it on the report viewer, or anything in the report viewer object model to handle it myself in code. Any clues Kevin The ReportViewer control is only a viewer. It does not support management operations. But subscribing to a report can be done through the Report Server public SOAP API. You ...Show All

• SQL Server SQL Execution Error: "clr Enabled"

  I've Created a DLL Library and added it as an assembly in a database when I make a select statement from SQLCmd using my functions it runs fine but when I try to Create View from the VB 2005 Express Development Environment it Gives me the Error SQL Execution Error Error Message: Execution of user code in the .net Framework is disabled. Enable "clr Enabled" configurartion option note that CLR Integration Option of the SQL server is ON and I've Tried sp_configure 'show advanced options', 1; GO RECONFIGURE; GO sp_configure 'clr enabled', 1; GO RECONFIGURE form SQLCMD in vain when I execute the select statement from the SQLcmd it runs fine but when I try to make a View from the Developmet Environment i gives me that ...Show All

• Visual Studio Express Editions the transaction manager has disabled its support for remotenetwork transactions.

    Hi pal's...  I had developed application in C#.Net1.1 Version1.1.4322 in windows2000. The application is executing fine when i installed and runned in same OS. But i am facing mentioned problem when running in WindowsXP-version2002-Service Pack2. the transaction manager has disabled its support for remote/network transactions. Our archetecture as follows: -MS-SQLserver2000Database running in different system of Windows2000. We are connecting to the system through LAN. -Our .Net application is also running on Windows2000 with com+ service -SetUp package is built on Windows2000. ===========following exeception Occred====== See the end of this message for details on invoking just-in-time (JIT) debugging ...Show All

• Visual Basic Advanced data bindings and DBNull

  My project reads dates back from SQL Server and displayes then using a Details view. In some instances, two of the dates displayed are meaningless data, they only apply if another value is set. Under DataBindings - Advanced, I notice you can set a NullValue to display in the event of a DBNull being returned. Well, the fields are Null (at least according to the Show Data function in Database Explorer) but regardless of what I put in the box, today's date is always displayed when I run the application. Rich Didn't make myself too clear there, it is both a "calculated value" and also one which can be reset by the user. Anyway, I made the date/time picker invisible and dropped a form ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Creating depth textures and getting back buffer in beta 2?

  Alright, so the API for this is totally different for beta 2. That's fine. But I can't see how you create depth textures now. I'm using them to render shadows. Also, how do you get and restore the back buffer now Do you do something like: RenderTarget2D backBuffer = (RenderTarget2D)device.GetRenderTarget(0); ... device.SetRenderTarget(0, backBuffer); I've managed to successfully convert my shadowing code to work with beta 2. To achieve colored/alpha blended shadows I use two render targets. One render target receives the shadow depth "color", which is just a single floating point value. The other render target receives the shadow color and alpha. In my main pixel shader I fetch the depth and color/alpha values and do a blend between ...Show All

• Windows Forms IIS FrontPage extensions required for deployment?

  1. Are the FrontPage extensions required on the IIS server in order to publish a click once app 2. If FP ext required, can I do this some other way (copy to web site dir ) 3. Where can I get/load the IIS FrontPage extensions On Win2K3 CD or available for download via my MSDN thanks, Rob. I figured this out, add the FrontPage Server extensions via Add/Remove Programs. Then from IIS select my web site and "configure frontpage server extensions". Is this secure, no idea -- see lots of warnings about security issues with FrontPage extensions, don't know if that applies to 2002 extensions. Rob. ...Show All

• Visual Studio 2008 (Pre-release) How to assign database/source of ListView programmatically in WPF?

  I tried some sample coding from the net. It uses the XMLDataProvider <XmlDataProvider x:Key="MyData" XPath="/Info"> <x:XData> <Info xmlns=""> <Song Name="Love at first sight" Time="4:04" Artist="kylie" Level="3" Disk="Disk-1" /> <Song Name="At Night" Time="4:31" Artist="Shake Down" Level="4" Disk="Disk-1" /> <Song Name="Believe" Time="3:54" Artist="Cher" Level="5" Disk="Disk-2" /> <Song Name="Don't cal ...Show All

• Visual Studio Team System Source Control Explorer Display Options

  I have removed a couple projects from TFS using TFSDeleteProject. Unfortunately, the two projects continue to be displayed in Source Control Explorer. They are shown as deleted and I can view the history of changes. I'm assuming there is an option to hide these items, but I am unable to find it. Any help would be appreciated. Thanks. ...Show All

• Visual Studio Layout design help

  Dear All Below is how I want my out to be in my form. I only want type A to be with multiple column and the rest to be arrange sequential row by row. Any help I will appreaciate. I have done grouping base on type and name and also format to multiple column. Type Name A ProA 11234 11235 11236 11237 11238 11239 11244 11245 11246 11257 11258 11259 B ProB 67565 67888 C ProB 45366 77777 ...Show All

• SQL Server Why do SQL Queries take long to execute ?

  Hi, We have built a Windows VB.NET application using SQLServer 2000. Sometimes when we run a specific query via ExecuteNonQuery, they take very long to execute, for example a simple query like: "UPDATE tbEmail SET EmailIcon = 'HospitalCaptured' WHERE EID = 19053" EID is the primary key. This table has about 40 000 records. This query timedout in .NET - we pasted it in Query Analyser and it then took 11,5 minutes to execute. Once completed, all similar queries (with different primary key values) that are run after that, are executed immediately. Does anybody know why this happens and what the solution is so that our .NET application does not timeout. Thank you, Lesego an update on table should not take such ...Show All

• SQL Server Recommendations please

  Hi all, I'm fairly new to Analysis Services. I've been working through Brian Larson's "Developing Business Intelligence with SQL Server 2005" which has been a great starting point. I wonder if anyone can recommend a more advanced book which covers Analysis Services in more depth and/or acts as a reference manual. I'd also be interested to hear which front-end tools people have found most endearing. Thanks Hello Sean, I'd recommend the following two books to take you to the next level: (1) Professional SQL Server Analysis Services 2005 with MDX (Programmer to Programmer) by Sivakumar Harinath and Stephen R. Quinn (Paperback - May 30, 2006) Amazon link: < http://www.amazon.com/Professional-Server-Analys ...Show All

• SQL Server Unable to use SQL Express wizards to export, import

  I am using SQL Server v8.0 Enterprise Manager and I have been trying to export a database and a table. But no matter how many times I try I keep getting error messages. It just wont let me make a backup of anything. Ideally I would like to make a backup of a table from within a database. Then restore it but use a different file name so I can have a sandbox with which to test something out. When using the Export wizard the destination server is local using Windows authentication. Here is the error I typically see: Error Source: Microsoft OLE DB Provider for SQL Server Error Description: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Context: Error during initialization of the provider. I only have one bo ...Show All

• Visual Studio Team System What does Build and Deploy Mean?

  Can anyone tell me what it means to 1) Build a project Building say a C# app means to rebuild all the source files to create an executable. It's not clear to me what it means to rebuild my database project. 2) Deploy a project I suspect this means more than just synchronizing my database project to some target database. Thanks - Amos. Howard, I would say that if your process works for you - then you are using the product correctly. I've been using DBPro as long as anyone and I'm a firm believer that having a proper process in place is integral to the proper use of DBPro. Its up to you what that process is. -Jamie ...Show All

• Visual C# Completely dynamic method invocation

  In java, I believe you can attempt to call a method even though the compiler can't find the method in the object's known class. Basically, you could do something like this - Object o; o.SomeMethod(); The java compiler doesn't look to see if SomeMethod exists in o. It simply compiles the code and tries to find the method on the object at run-time. If it's not found, something like a MethodNotFoundException is thrown, and can be handled gracefully. I want to do precisely the same thing in C# without using reflection. I think this type of behavior can be acheived in a roundabout way using the item of a foreach loop, but I want to be able to do it anywhere. Essentially, I want to be able to get this piece of code to compile - tr ...Show All

• Visual Studio WinForms: Find() generates "Object Reference" error

  Hello. We're using the WinForms report viewer in a vertical market accounting product we distribute. Working well for the most part. One problem: The Find button generates an object reference error when clicked. We have the same problem when calling Find(string,int) programatically. When the button is clicked, the "object reference" error appears in the ReportViewer window. When we call Find(string,int), we get an "object reference" exception thrown with the following stack trace: Microsoft.Reporting.WinForms.RenderingItemContainer.MarkupSearchResults(CompositionBase composition) Microsoft.Reporting.WinForms.RenderingItemContainer.MarkupSearchResults(CompositionBase composition) Microsoft.Reporting.WinForms.RenderingIte ...Show All