Yeti32's Q&A profile

• SQL Server WITH NAMESPACES in SQL function is causing error

  Hi All, I'm getting the following compliation error when i try to execute the following function. I need your expert opinion on how i can solve this. ALTER FUNCTION [dbo] . [GetOrgChildHierarchyXML] ( @HierID int , @fiscalyear int ) RETURNS XML WITH RETURNS NULL ON NULL INPUT BEGIN RETURN ( WITH XMLNAMESPACES ( 'uri' as i ) SELECT OrganizationHierarchyId as "ID" , OrganizationHiera ...Show All

• Visual Studio Express Editions error installing Visual C# express

  help me solve this please it happens when its loading installation components.  will deeply appreciate all your efforts. Try to upgrade windows installer http://www.microsoft.com/downloads/details.aspx FamilyID=889482fc-5f56-4a38-b838-de776fd4138c&DisplayLang=en It might help to preinstall .NET framework http://www.microsoft.com/downloads/details.aspx FamilyID=0856eacb-4362-4b0d-8edd-aab15c5e ...Show All

• Visual C++ Help on very basic OpenMP program

  Hello, I have a hello world program that uses OpenMP, and I am unable to understand it's behavior. The code is: #include <iostream> #include <omp.h> using namespace std; int main () {      cout << "Max openMP threads = " << omp_get_max_threads () << endl;     #pragma omp parallel     {         int num = omp_get_thread_num ...Show All

• Smart Device Development Deploying a .net2/sqlce app

  Hi! note: new in mobile development but experienced .net developer Can you give me a guidance on what do I need to install in a wm2003 device to deplory a .net 2.0 app which also uses sqlce 2005 Are some specific dll's enough I would like to create a complete CAB with all the necessary files so that end-user can easilly install/uninstall the application. Unfortunately, you can not do that. License does not allow you to break NETCF/SQL Mob ...Show All

• Visual C++ Finding file handle count

  Hi all, I m working on a file security project in which I have to track the handle count for any secured file at any time. There will obviously be a way to find the handle count for any opened file but I dont know how to find it. Plz let me know how to find the handle count. Thanx in advance Regards, Thanx for replying Perhaps I was not clear or use wrong word. It is handle referenec count-number of processes that ar ...Show All

• SQL Server Output format

  I'd like to take the results of my report and save them as tab delimited text files.  This is not one of the options available when I click the save button.   The only options I have are XML, CSV, TIFF, PDF, Web Archive and Excel. I'm new to this software.   Any help would be appreciated. TIA, Paul Hammond Richmond, VA Thanks, All this sounds like a lot more work and research, which is not why I started using this p ...Show All

• .NET Development How to use SocketType.Seqpacket?

  Hi, I was wondering how you would use SocketType.Seqpacket in a server (asynchronous non-threaded). Currently, I've got the following code: listeningSock = new Socket ( AddressFamily .InterNetwork, SocketType .Seqpacket, ProtocolType .Unspecified); // Bind to the local IP Address listeningSock.Bind(ipLocal); // Start listening // WARNING - ONLY 10 listeningSock.Listen(10); // Now begin receiving connections listeningSo ...Show All

• Visual Basic Calling SQL Server Stored Procedures in VB 2005

  I am new to Visual Basic and am having some difficulty calling a stored procedure in a SQL Server database. I have set up a Stored Procedure in SQL server, uspGetCompanyDetails, which has a parameter of @CompanyID . When calling the stored procedure in Visual Basic, I have used the following line of code; Dim objDataAdapter As New SqlDataAdapter( "uspGetCompanyDetails 6" , objConnection) This code fires on a button c ...Show All

• SQL Server Rendering RS Reports on PDA's

  I have a partner using SQL RS for building Web-based reports, they want to access and render the reports on Pocket PCs and PDAs; any special things to consider for that Certain transformations to apply, etc On the same note, what are the formats supported by RS for rendering on Pocket PCs/PDAs ...Show All

• Visual Studio Tools for Office Add/Remove Worksheet in VSTO Workbook

  I created various worksheet inside a VSTO workbook, but now, I can't remove my testing worksheet and add blank new worksheet. 1. I can't select Delete in solution explorer when right-clicking on the worksheet item. 2. Even I remove worksheet in Designer pane (right click the tab at the bottom of Excel workbook and selete Delete), rebuild the VSTO project and then the deleted worksheets are all still here. I then Refresh the workbook object in S ...Show All

• SQL Server Temporary tables

  Hello! I'm creating a temporary table in a procedure to help me with some calculations. I would like the name of the temporary table to be 'dynamic', I mean, to have the hour it was created, something like this: create table #myTempTable15May11:10:00, so if someone access the procedure while it's running, he won't have problems in creating his 'own' temporary table (create table #myTempTable15May11:10:02). Is there anyway I can do this ...Show All

• Visual Studio MSBuild: A Quick Question!

  Hi Everyone, I have seen the examples on Scott's blog. I have built an example with WebProject and a Class Library. I built a Web_Deploy project and the dependency from the Class Library was in the bin folder. But my question is in a situation where my solution consists of one or more Web Service Projects, a Web Project, and one or more class libraries. I have looked for an example to use MSBuild in such a scenario but have failed to fi ...Show All

• Windows Forms Loading report failed

  Hi, I try 2 run a report  with the crystelreport viewer nothing fancy just 1 label. After hitting F5 i keep getting the error Load report failed.  Beschrijving: Er is een onverwerkte uitzondering opgetreden tijdens het uitvoeren van de huidige webaanvraag. Raadple ...Show All

• Visual Studio 2008 (Pre-release) Lose XAML in Feb CTP?

  If I create a file like HelloWPF.XAML and place valid XAML in that file should it be displayed when I double click on it What happens on my machine is that a browser window opens and nothing displays. If I use the context menu on the file the "open with" option is Windows Presentation Foundation Host. But, when selected I get the browser window again. Interesting. Can you try deleting the ClickOnce application store and see if t ...Show All

• Visual Basic VB 2005 Compiler Optimization Discussion

    There's been something percolating in the back of my mind. I come from a computing environment that preceeded windows and the Intel Architecture and instruction set. n comparison to the instruction set that i'm used to, the Intell instruction set looks like a house wreck which may or may not be important to the discussion at hand. Everyone knows that moderators agree on everything and that in moderator space we just stand in love ...Show All