wDiechmann's Q&A profile

• SQL Server Export to XML file from SQL Server 2005

  I have a stored procedure which returns XML using SELECT with the FOR XML PATH, TYPE commands. How do I pipe the results to a file I had assumed that Integration Services would do this, but I see nothing about XML as a destination, only as a source. Hello, Well, I already try this, runing a query in Data flow source (OLE BD Source) and send the result to a flat file destination. The problem now is matching types. OLE DB Source generate DT_IMAGE and until now I couldn't put directily into a xmlt/html file... ...Show All

• Visual Studio Express Editions Multiply Users Accessing SQL2005 Express Database

  Hi All, Not sure if I'm posting this in the correct location. I've created a SQL 2005 Express Database from with VB2005 Express. I want users to login with a username and password and have diffrent rights, etc.... What's the best way of going about this Thanks in advance Wayne user tables Well they do that for their own authentication method, for example if it were a login system, they would then have all the user details stored in the user table. The security/logins in SQL Server is a different type of authentication - that is for connecting to and using the database itself. to create some authentication database system (user tables) you need to create a users table and store ...Show All

• Smart Device Development 802.11 connection not recognised on PocketPC 2005 (WM5)

  Hello, We have an application that we developed initially for Pocket PC 2002 (Win Mobile 4.2). This application establishes an 802.11 association when the device is in range of "special" access points. "Special" basically means an AP is in a database of known APs that provide the services the consumer is authorized to use. This is for a VoIP application. This application works well on PPC 2002 and has for over 2 years over multiple devices in multiple countries. After upgrading the app to support some new features in Win Mobile 5 (Pocket PC 2005), the application is still able to establish a perfectly valid 802.11 association (valid IP address included) but when the VoIP part of the application goes to make a connec ...Show All

• Visual C++ Does Edit and Continue work in VS2005?

  Hi All, After importing a VC6 project into VS2005, I cannot get Edit and Continue to work. What am I missing Here are my project settings. Compiler: /Od /D "_DEBUG" /D "_WIN32_WINNT=0x0500" /D "WINVER=0x0500" /D "WIN32" /D "_WINDOWS" /D "_VC80_UPGRADE=0x0600" /D "_AFXDLL" /D "_MBCS" /Gm /EHsc /RTC1 /MDd /Gy /Yu"stdafx.h" /Fp".\MyProj.pch" /Fo /Fd /FR /W3 /nologo /c /ZI /TP /errorReport:prompt Linker: / OUT:".\MyProj.exe" /NOLOGO /MANIFEST:NO /DEBUG /PDB:".\MyProj.pdb" /SUBSYSTEM:WINDOWS /OPT:NOREF /OPT:NOICF /MACHINE:X86 /ERRORREPORT:PROMPT and Tools->Options->Debugging: Edit and Continue enable ...Show All

• .NET Development problem when reading keys from app.Config

  Hi, I'm experiencing problems when trying to retrieve keys from the app.config-file using C# VS2005. This is the contents of app.config < xml version="1.0" encoding="utf-8" > <configuration> <configSections> <sectionGroup name="userSettings" type="System.Configuration.UserSettingsGroup, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" > <section name="ConfigManagerTest.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" allowExeDefinition="MachineToLocalUser" requirePermission ="false" /> & ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Subscription availability??

  Hi, This may be a silly question; but will the subscription service be available outside the USA I'm in Australia and everything seems to take a very, very long time to be supported here... Thanks, T From the FAQ: Q:Is the XNA Game Studio Express subscription available for programmers worldwide Are you planning on localizing the software A: XNA Game Studio Express development tools and environment for Windows will be available for download worldwide from http://msdn.com/xna. The XNA Game Studio Express subscription for Xbox 360 is available in nearly all countries currently shipping Xbox 360 retail consoles and with Xbox Live connectivity. The current version of the tool is available in English only ...Show All

• Visual Studio 2008 (Pre-release) Pages to Scrollbar in FlowDocumentReader

  I have a FlowDocumentReader that I'm using in Page mode. It is working perfectly for the most part. But when I shrink the window down where some of the text is cutoff, it is giving me the paginator stuff (ie. < Page2 >). What I want it to do is to give me a vertical scrollbar instead. Any ideas Thanks Lee ...Show All

• SQL Server Install programming is terrible

  I use SQL server 2005 for a year now at work and home. The intsall process and logic is TERRIBLE compared to previuos versions. The most common problem I get on developers machines is when they are using EXpress and then upgrade to the Developer or Enterprise edition. Sql Server 2005 Express database instances get left in the registry or somewhere, and the next install sees it and refuses to install its instance. The ARPWrapper.exe. tool in the boot strap can be run and you can see the instance there, but they is NO POSSIBLE WAY to remove it.. I have been woring on this for 2 days and really hoping someone has a fix for this. I have tried the variosu registry HACS out there on the net, but no luck still. I noticed that a huge proportion o ...Show All

• Visual C++ Reading delimited data files using ifstream and getline? (sample erroneous code included)

  Hey guys! I have a question about reading delimited text files. I have a file in the following format delimited by space: JAMES SMITH 0 6 7 14 0 9 4 18 BARBARA WILSON 7 6 12 2 1 16 18 15 JENNIFER THOMAS 11 4 7 19 15 14 MARY JOHNSON 1 0 JOHN WILLIAMS 2 5 4 5 5 1 7 The problem is that my code doesn't read all lines. For instance, the file that i'm reading contains 450 entries, while the code will only process half of that. The others are just skipped. The Code i'm using is provided bellow: enum stdColumn { stdFirstName = 0, stdLastName = 1, stdStudentID = 2, stdNumOfCourses = 3, stdCourse1 = 4, stdCourse2 = 5, stdCourse3 = 6, stdCourse4 = 7, stdCourse5 = 8, stdCourse6 = 9 }; int stdLoadData( ...Show All

• SQL Server SQL Trace Analyzer Tool

  Hi guys, I just want to announce the launch of SQL Trace Analyzer - A SQL server reporting and performance tuning tool from Lakeside Technologies. Lakeside SQL Trace Analyzer is a SQL server performance tuning and reporting tool that analyzes data collected by Microsoft SQL Profiler to pinpoint SQL server database performance problems. Trace Analyzer generates statistics and identifies problem areas in easy to read reports, enabling you to see a clear picture of exactly how your SQL server database and application are performing – from CPU health to procedural statistics to errors. Lakeside SQL Trace Analyzer can help you make sense of the overwhelming information that you can derive about your SQL database server, using the Microsoft SQL ...Show All

• SQL Server Linked servers and Windows Authentication

  I have seen similar questions, but none of the answers have solved my problem. I have several SQL2000 servers running under Win2003. In the past, we have been using SQL logins, but I have been trying to transition to using Windows Authentication. It has been working great except that sometimes queries using linked servers fail. The linked servers are set up for the connection to use the login's current security context. For testing this problem, I have limited myself to two servers to do this between. My Windows account is defined with sa rights on both servers. I have tried explicitly to impersonate my account, I have told it to explicitly use the same account and password on the other server. I have tried not listing my account ...Show All

• Visual Studio 2008 (Pre-release) Namespace 'var' could not be found...

  Am evaluating LinQ. I created a LinQ Windows Application using the LinQ Preview template without any problems. Would very much like to use it. I then tried to use LinQ in one of my existing projects. However I get the following error when using "var" when trying to compile var x = "string" ; The type or namespace name 'var' could not be found. (are you missing a using directive or an assembly reference) I think I have added all the LinQ using directives and references. Not that familiar with C#. Would appreciate any help. How can I get the project to compile Compare the csproj files, assuming your old project is under VS2k5.  Toward the bottom ...Show All

• Visual Studio Tools for Office VSTO2005SE document level customization

  i've installed VSTO2005SE on my VS2005 Professional Edition and it work fine on adding my custom ribbon and custom task pane with our own custom control on it but how do i access the element or table cells in the document itself. Let say i would like to highlight a table and read the value and sum them up in microsoft world how do i do that i cant seems to find a way to get the data in the documet it self does it has to do with this statement is VSTO2005SE download page in microsoft * Note that if you install on top of Visual Studio 2005 Professional, no document-level customizations or other functionality that is part of the full version of Visual Studio 2005 Tools for Office (VSTO 2005) is installed. VSTO 2005 SE adds only the app ...Show All

• Visual Studio Tools for Office Microsoft.VisualStudio.Tools.Applications.Runtime error '8004040a'

  i have a web site that enables users to upload excel workbooks and on the server i am adding a new sheet of mine(custom) and attacing a manged code behind to the work book this managed code is some kind of tool that opens in the action pane. 1) it works on my development pc - of course after configuring each end user pc 2) deploying it on another server, well that is impossible. my application is devided to two: the call is from an asp page in vbscript the vbscript creates a com visible object and calls its init this is how init looks like ExcelPricingHelper pricingHelper = new ExcelPricingHelper (workBookPath, demoExcelPath, serverPath ); System.Globalization. CultureInfo oldCulture = System.Threading. Thread .Cu ...Show All

• SQL Server SQL 2000 Licensing with CALs

  Hi, I didn't find any other forum to ask this and I didn't find any matching post for my question, so I post it here: We have an application that is running on 2 web servers connected to a sql2000 server with a 2-processor license ... so I think there we have no problem no matter how many users are using our web application. But the web application is producing a huge amount of logs that we want to analyze on a distinct multi-proc sql2000 server with a huge amount of harddisk space that's running with CAL licensing (not really sure how many we have for that server). In a perfect solution we will provide access to the logs via our 2 web servers using the same application, but only for a given number of users (the number of users ...Show All