Ryan McCauley's Q&A profile

• SQL Server Looking for the definitive answer: Microsoft SQL Server 2005 Express Edition x86 install failed

  I installed, uninstalled, deleted, editted my registry etc and I finally goto to this error while trying to install VS2005 (released) on a Windows 2000 PC (that had Beta2 and RC1 installed & uninstalled): [11/17/05,16:46:51] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value. [11/17/05,16:46:51] Microsoft SQL Server 2005 Express Edition x86: [2] Return from ...Show All

• Visual Basic Getting the connection string for a project

  I'd like to set a string variable to the connection string for a project. I've seen the build connection string module/function and tried to use it but it's hopelessly complex for what I want. I just want the string. Is there an easier way Hello. I'm not sure whether you're trying to figure out how to build the connection string or to query an existing one. For information on building a connection ...Show All

• .NET Development Problem with XsltCompiledTransform for large data

  Hello! I was wondering if anybody could help me to solve my problem: I call a stored proc in SQL server with ExecuteXmlReader, then load my xslt stylesheet into XsltCompiledTransform, create a output file stream.  and call Transform method. The problem is that it works fine for small resultsets. Fot large resultsets ( ~1Mil Rows ) the process in Task Manager increases memory allocation and slows down extremely. I hoped that as I used xmlrea ...Show All

• Microsoft ISV Community Center Forums how do i print selected informations from the database wherein the input of user are textboxes ( ie; beginning date and ending d

  how do i print selected informations from the database wherein the input of user are textboxes ( ie; beginning date and ending date ) how do i print selected informations from the database wherein the input of user are textboxes ( ie; beginning date and ending date ) Started by mhiga at 05-05-2005 9:02 PM. Topic has 0 replies. ...Show All

• Windows Forms quick way of detecting if any changes have been made to form

  I am looking to see if there is a quick way of finding out if any changes have been made to a form. Thanks. If you are using Databinding, you can raise events to handle modifications. This article explains it: http://msdn.microsoft.com/libra ...Show All

• SQL Server Implicit conversions using UDTs

  I've written a CLR UDT that basically wraps a COM FILETIME.  While using and testing this UDT, I've come across some unusual behavior that I can't seem to track down.  My question is this: When I make the T-SQL statements DECLARE @ft dbo.MyFileTime SET @ft = 0x0123456789ABCDEF What's happening within the SET statement   My first surprise was that it succeeded.  Then I thought, "The hex value, I understand, is implicitly a BI ...Show All

• SQL Server unabe to create new table using sql server management studio express

  hi all, i just installed sql server 2005 express and sql server management studio express on a windows xp sp2 box. i can create a new database through the sql server management studio express GUI, but if i try to create a table (right-click on database icon and choose option for new->table), the application immediately hangs and i have to shut down the computer ("end task" fails to close it). i can, however, create a new table throu ...Show All

• .NET Development how can we put a resultset of a sqldatareader into a datatable object

  how can we put a resultset of a sqldatareader into a datatable object Thanks. The DataTable.Load method is new to .Net 2.0. It takes an IDataReader object and populates the DataTable object with it. This could not be done with any built in methods of the DataTable class in .Net 1.1. You can use the code provided to accomplish the same thing. smc750 ...Show All

• Windows Forms File System Protection

  Dear All, I am trying to create a setup for my C#application The application makes use of a reference to System32.dll While I try to build the setup, in the task list it says: 'System32.dll' should be excluded because its source file 'C:\WINDOWS\System32\System32.dll' is under Windows System File Protection. It will only work if I exclude it from the setup project. What implication will it have on my installer setup What will ha ...Show All

• Visual FoxPro My form runs great inside of VFP, but has errors running from the exe...

  I have a form that uses a combo box for the user to select from. Their selection then is used as a basis for searching a table via a SELECT statement. The results of the SELECT statement are then written to a different table, where they are available for export as an xls file. It is searching an automotive customer info list by car make... This works flawlessly within VFP, but from the compiled exe I get complaints that Object 'wholesale_form ...Show All

• Visual Studio 2008 (Pre-release) How to determine which part of a FlowDocument is visible in a FlowDocumentReader?

  I can't find any way to determine which part of a FlowDocument is currently visible in a FlowDocumentReader. Any ideas I knew you were going to say that I shouldn't depend on the implementation details of the Visual tree . In the mean time, I have changed my code to use GetPagePosition and a FlowDocumentPageViewer and that works. I have some observations on the FlowDocument viewer behaviour on though: 1) GetPagePosition only gives y ...Show All

• SQL Server Reporting on Exchange Emails

  Is it possible tpo query exchange directly from reporting services or ... how do i extract data out of exchange  into a sql database so i can report on it with RS. Any ideas anyone.. Cheers There is an OLE DB provider for Exchange that is built into Exchnage and one for HTTP DAV somewhere (I think it is called 'OLE DB for Internet Publishing') but I can't remember where to find it right now. There are also ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Resource management

  I was wondering how much difference improving my resource management would make to my applications performance. I use a lot of Sprite animations in my game, that use D3DXSprite. With the animations I know that once I have displayed a frame that image won't be needed again for a while and also know which texture I will want for the next frame. So I wondered how much difference it would make to performance if I wrote a system that would Lower the ...Show All

• Visual Studio 2008 (Pre-release) Cannot play video after installing WinFX

  It seems strange, but since I installed WinFX (runtime components, sdk and extensions) Feb CTP I cannot play video in IE, neither do I get any flash conent in IE. To make sure that it was due to WinFX, I built a WinXP VPC and got the same outcome. Is there anyone who has faced this issue Does anyone from MS know about this Regards, Deepak Do you have Windows Media Player installed If so, what version Also does this machine have a ...Show All

• SQL Server Send Mail task errors

  My SSIS package processes a flat file in several ways, capturing information about numbers of records read, number inserted / updated / ignored / etc. and writing informative error messages regarding each data row to a database. It then generates a flat file (I wanted to use an Excel file, but can't seem to get it to work. Then again, I'm still on an older CTP.) of all the error messages. Finally, it sends email with all the run s ...Show All