zybernau's Q&A profile

• SQL Server BLOBs

  How does SQL Server 2005 handle BLOB's of large magnitude, could a group of a few BLOB's of a large file, say a 1Gb document be handled effectively within SQL Server If not, what is best practice, are there any articles about the pro's/con's of using BLOB's versus doing the process another way ...Show All

• Visual Studio Tools for Office add-in doesn't load when launching using new excel.application

  When launching excel via interop, I've noted that the addins don't appear to load. Dim xlsApp As Microsoft.Office.Interop.Excel.Application xlsApp = New Microsoft.Office.Interop.Excel.Application xlsApp.Visible = True Does anyone have any idea why and how to solve it Otherwise, I need to figure out how to load excel via System.Diagnositics.Process.Start() where I can pass it the location of the excel exec, which I am uncertain how to determine Hi Denis, As Dennis pointed out, this behavior is by design in Excel. It is not an interop or VSTO issue. Whenever you create an instance of Excel as an automation object, add-ins will not load unless you explicitly load them. One of the reasons behind this design ...Show All

• Microsoft ISV Community Center Forums ADO Recordset CursorType Property

  I want to create an updateable recordset, whereby the values in a particular field in the recordset once opened are changed to something else if certain conditions are met. However, I do not want these updates to change the underlying datasource, otherwise I would be in trouble! I would therefore need to set the recordset's cursor type property prior to opening the recordset, of which there are 4 constant values: adOpenForwardOnly, adOpenKeyset, adOpenDynamic and adOpenStatic. I'm guessing the last one of these is the one I need, but can anyone confirm this is the case before I start Are there any other recordset properties I need to consider as well Cheers! Keith I've ressurected this thread ...Show All

• .NET Development SAPI - missing?

  First off, sorry if this is somewhere else in the forum but I canot find it and at my wits end. First off, I have been beta testing Vista since Beta1, now have RC1 and have the Voice Recogition working. I am now trying to get my new Mac Pro with XP sp2 so that the Voice Recognition is working and having issues. I have a vs2005 project that has VR and TTS and works in Vista RC1, yet I have installed the .net 3.0 framework and all 4 items. So the issue is that my Vista project when copied to XP SP2 cannot find the file Interop.Speechlib.dll AND I think that I do not have SAPI installed but I have read that SAPI is part of the Windows SDK Does anyone have this issue How can I get the VR Control panel as in Vista Thanks ahead of time Brad ...Show All

• Visual C# Performance Optimization of C# Application

  hi Is there any guide or documentation available that help me understand various factors that can optimize my application with respect to performance . What steps should i take or what factors should i consider in order to cater the performance issue while coding .How attribute and code analysis feature can really help Any idea , guideline will be highly appreciated .... Thanks Tabish. Hi Salvador, I was searching through the forum for threads on .net performance and I came across your post. I would appreciate if you could help to answer some of my doubts. 1. Since you've designed and implemented a real time auction engine, do you think .net is also suitable for signal processing that requires performance in term of a f ...Show All

• Visual Studio Sandcastle Help file - First page is blank except for a warning icon.

  Hi Foks, First let me say, GREAT product. I can't wait to see it develop further. Second, I'm having a problem. Every help file I create with Sandcastle results in a CHM file that has a blank opening page. The Namespaces node is selected, but the Namespaces help page isn't displayed unless the user clicks on the root node again. Any ideas Thanks! George George, You can get Sandcastle to include information on the opening page by providing a "project" description. The easiest way to accomplish this that I've found is to create a project summary XML file that has the following format: < xml version="1.0" > <doc> <members> <!-- Descripti ...Show All

• Windows Forms wsus update failed

  hi i installed WSUS2.0 SP1 to update my 100 Client. while update i get this error : >>> WebException: The underlying connection was closed: Could not establish trust relationship with remote server. at System.Net.HttpWebRequest.CheckFinalStatus() at System.Net.HttpWebRequest.EndGetRequestStream(IAsyncResult asyncResult) at System.Net.HttpWebRequest.GetRequestStream() at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Microsoft.UpdateServices.ServerSyncWebServices.ServerSync.ServerSyncProxy.GetAuthConfig() at Microsoft.UpdateServices.ServerSync.ServerSyncLib.InternetGetServerAuthConfig(ServerSyncProxy proxy, WebServiceCommunicationHelper webServiceHelper) at Microsoft. ...Show All

• Windows Forms Visual Basic - printing to a listbox

  How do I make Visual Basic enter values in a listbox while the program is running, instead of waiting until the end and then displaying all values Thanks for the link. Wow, Euler is my favorite mathematician. Because he was practical AND a genius. Fourier needs to kiss his mantle, and then nobody for a while until Leibnitz and Newton. Way too tuff for me... ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. UV Coordinates of a mouse click

  Is there any way to find out the UV coordinates of a ray's intersection with a model (i.e., to read the position of a mouse click on the "screen" of a model of a TV in a scene ) Yes, although you have to do the work yourself. Once you have the intersection coordinate between the mouse ray and a given model triangle, you can decompose that position to the barycentric coordinates between the vertices, and interpolate the vertex U/V values using that. So: 1) Implement mouseclick to ray. 2) Implement ray against mesh testing (which is a sequence of ray-against-triangle tests in the simple case) 3) Implement barycentric interpolation There's google pages on all of those steps. ...Show All

• Visual Studio Team System CTP6: Menu item View->Lotus/Domino Explorer???

  Hi there, I cannot find any documentation about this menu-item. When I click on it I only get the annoying error message, that the appropriate module does not exist. Any info on this I am curious about this, because I am a Notes user... THX Fridtjof This is not something we put in. Are you having Lotus Domino installed on your machine or ever had it installed It could be a stray VS Package that registers this, but you would have to dump the Registry to find that out. If you want you can run the following diagnostics script and send it to me. http://SQLDev.Net/VSDBProDiag.zip contains a CMD file that will dump all your settings, so we can look at these. -GertD "DataDude" Development Manager ...Show All

• Visual Studio Express Editions using VBE across a LAN

  Hello! What I have done so far I have just taught myself some VBA where I produced a module inside Excell on my own P.c that displays some statistics from an SQL database held separately on on a server on the LAN (Using a connection string to the SQL Database ) T he Excell file is in use also by other people in my company who have it locally and produce the statistics and reports thanks to the connection string that I refer to above to the remote SQL database. (It works quite well but managing data and displaying the results in a worksheet are quite like knitting jelly) What I want to do next I want to move on and learn VBE and I am wondering about something which is ; I know that I can probably u ...Show All

• SQL Server Reporting Services Currency (￡)

  I am trying to produce a report showing Currency in ￡ using Visual Studio 2005 reporting services. On trying to format the textbox the only option that it seems to give you is for it to be displayed in $. Does anyone know how i can display a number in ￡ instead of $ Another way to do this is to set the language property of the report to 'English (United Kingdom)', then set your fields to display with the format code of 'C' (currency). It will automatically set the default currency symbol for that language on any fields set for currency. Jarret ...Show All

• SQL Server Need Help on this SQL Statement

  Hi All, sqlLstProds="Select * From PRODUCT_DEF "&_ "WHERE productID IN(Select productID From PRODUCT_DEF WHERE (IDProductCriteria = 5) AND ([Value] = '"&getSession("ModelID")&"')) "&_ " Order By IDProduct, IDProductCriteria" I have the above SQL Code in an ASP page. This queries the Product_Def table, however there is also a table called Product_sType, the primary key in that table is productID which corresponds to productID ub the Product_Def table. I need to add to the query a where clause, where active = 1 active 0 is obviously discontinued products, how would I do this So basically, it's somewhat of a join of some sort, like select * from Produc ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How to monitor microphone input level?

  I'm using VB.net with Framework 2.0. How to monitor the mic level of the default soundcard I would like to be able to set a threshold value (0-100%) and when the mic level is greater than that a message box would appear. It would be important that the detection would be fast (with as short delay as possible) and consume CPU resources as little as possible. Is this possible without DirectX SDK I found some code in VB6 and C but could not translate them in VB.net. Thank you! If this is possible to with Win32 APIs, I would prefer that way. I have googled and googled but found nothing but C code or VB6.0 code. I'm a beginner and would need very basic step-by-step instructions how to solve this problem... I wo ...Show All

• Software Development for Windows Vista Workflow monitor from July SDK isn't showing the workflow

  No errors just doesn't show the actual workflow in the right pane. Workflows show up fine in the left pane. ...Show All