Kevin Rodgers's Q&A profile

• Game Technologies: DirectX, XNA, XACT, etc. By the numbers - why so big?

  My content, using JPG's, is roughly 14.4 MB. However, the XNB version is roughly 515 MB. About 38 times bigger than the original. Is this normal What steps do I need to take to reduce the size of this I'm just begining with my development but if I can't augment this behavior of the Framework I'll have to serverly strip down my game. Maybe, I'll have to replace Content<T> altogether ( ) You're pretty much correct. JPG compression is good at saving DISK space. When we're talking about hardware accelerated graphics, all graphic formats must uncompress so that the GPU can have direct access to the bits. My guess is that a .XNB file is an uncompressed format so that the XNA framework doesn't have to do uncompressio ...Show All

• SQL Server Importing XML File using SSIS (DTS)

  I can use MS Access to import an XML file and it builds the columns and loads the data. I am trying to use SQL Server 2005 to do the same thing and there doesn't seen to be a way to easily accomplish the same task that works so well in Access. Has anyone tried this If so and you were successful, what were the steps to set up the package Thanks. Mark, Thanks It worked. So the impression that i get is that all XML's should be waped in a root node. Is it True ...Show All

• Visual C# Converting System.Type to OleDbType

  I can`t find class and methods that convert System.Type to any of dbtypes(OleDbType or SQLType). I know for the mapping tables, but I need conversion methods for all data providers(OleDb, SqlClient, ODBC) . It is not difficult to write that by your own, but I can`t belive that it is not alredy written by Microsoft. Why do you need this OleDbDataReader.Item and SqlDataReader.Item return an Object, just cast it to the native type: int count = (int)(dataReader["count"]); ...Show All

• Microsoft ISV Community Center Forums Assign an array to .values and .Xvalues in an excel chart

  Hi, I'm having trouble with assigning arrays to a chart. Below is how I done. Anyone nowing how to make this work     Set MyDispl = Application.InputBox(Prompt:="Select displ.", Type:=8)     Set MyForce = Application.InputBox(Prompt:="Select force.", Type:=8)     Do '''Collects Displ data             plot_disp(i) = MyDispl.Offset(i, 0)             i = i + 1     Loop Until IsEmpty(plot_disp(i))           Do '''Collects force data                ...Show All

• SQL Server There's just no escaping it... data containing quotes ruining CSV files

  Much to my surprise and dismay, after burning hours and hours developing various SSIS packages to extract data from my SQL 2005 DB to CSV flat files, I found out the hard way that SSIS doesn't properly escape quotes (") in the data (my output file is required to have quotes as text qualifiers). It seems like I'm pretty much forced to create derived columns to test for the existence of quotes in my data, then either escape them or replace them with another character. This is really NOT COOL. Not only will this significantly hinder performance, it makes my packages a heck of a lot more complicated (especially when I'm exporting lots of text columns). Am I doing something wrong, or does SSIS really not escape the text qualifier ...Show All

• SQL Server INSERTING Data From Server to Server

  hi there! Well i have two Servers on this two Servers i have the Database with the same Tables. But the Database in the Server_2 consists no data, I want to fill the Tables in Server_2 from the Data in Server_1. What i want to do is to is liked this. -- I performing this on the second Server. SET IDENTITY_INSERT [Server_2].[Database].[user].[Table] ON INSERT INTO [Database].[user].[Table]({COLUMN_NAMES}) SELECT * FROM [Server_1].[Database].[user].[Table] WHERE id=25 SET IDENTITY_INSERT [Server_2].[Database].[user].[Table] OFF This did not work and i have the following Error Message its in German but the ERRORCODE is 7391. I already check out the help section in MSDN but it doesnt really helps... Any Ideas Thanks Die Oper ...Show All

• SQL Server Stuck between "Failed to generate user instance" and "An attempt to attach...failed"

  I wrote an application using Visual Studio 2005 beta 2 which uses a SQL Express .mdf file, included in the project, for the database.  After installing Visual Studio 2005 RC and the SQL Express that comes with it (I followed all of the uninstall instructions first) I can no longer add a SQL Express database to any of my projects, nor can I open the SQL Express database in my original project.  When I try either of these tasks, I get the "Failed to generate user instance of SQL Server due to a failure in starting the process for the user instance.  The connection will be closed."  I read the thread which dealt with this error, and changed the connection string for the database file that had worked before to User Instance ...Show All

• Internet Explorer Development Alternatives to IELaunchURL: use CoCreateInstance to create a WebBrowser object running in Protected Mode?

  Originally posted in this thread , but got no response after 5 days. Sorry for the long-windedness, but I'm getting desperate for some answers. I'm revising an existing application for Vista-compatibility. This application makes extensive use of the IWebBrowser2 interface and IE to display web pages, primarily from the company's own site (like an about page), but it could potentially navigate anywhere. The app is written in C++ and runs at medium integrity level (medium IL is required for most of what this app does). The problem occurs when the app navigates to a URL in a zone that requires IE Protected Mode. Because my app runs at medium IL, the WebBrowser object I obtain via CoCreateInstance is in an instance of IExplore.exe runnin ...Show All

• Windows Forms Question about docking a control in a panel

  I created a search form in a panel, to be placed in forms: A textbox and a button on top, and a datagridview docked to bottom. I add this panel to my form, and set dock to fill. Then the problem occurs: If the form i add this panel to is higher than the panel, the datagridview will just remain the same size, and stay at the bottom, while the textbox and the button is at top, making a big empty space in the middle. Like this: [TEXTBOX] [BUTTON] ----------------------------- | Dataridview area | ----------------------------- How can i make the datagrid automaticly adjust it's own size, to fill the empty space What i basicly want is to spike the top of the datagrid to right underneith the textbox and button, and whenever ...Show All

• SQL Server PERSISTED Column In View

  I have a view that calls a User Defined Function. I want to index this calculated column if possible, but trying to do so gives me an error saying that I have to mark the column PERSISTED. I see how it's possible to do this when creating tables with calculated columns, but is it possible to do this from within the view itself Does the UDF use GETDATE(), or some other nondetermininstic function, internally   Can you share more information about what you're trying to do   -- Adam Machanic Pro SQL Server 2005, available now http://www..apress.com/book/bookDisplay.html bID=457 --     < boulderbum@discussions.microsoft.com > wrote i ...Show All

• Smart Device Development Pocket PC access Web Service

  Hi. I have a pocketpc application to retrieve data from WebService and works fine only when I used url with IP...if I used server name I get an WebException... Code: ws = New WebService.Service1 ws.Timeout = timeoutWebService ws.Url = WebServicePath What I'm doing wrong Thanks in advance. I would guess your network has no address resolution service (which translates names into IP, such as DNS) at all or it’s not properly configured. ...Show All

• Visual C++ Error result 31

  Hi I have a VC++ project(VS 2005 beta 2) that gives the error:- Error result 31 returned from 'C:\Program Files\Microsoft Visual Studio 8\VC\bin\mt.exe'. Project Could anyone tell me the cause of this It doesnt seem like a program specific error. blitZ Hi I have also faced this problem in VS 2008. On my machine, two source code were open and both were referring to the same dll. When I closed both and then started, then I didn't face this problem. But, the problem is that since many days, I am doing the same thing but never faced this problem. Vinod Sah ...Show All

• Visual Basic cursor

  How do i set the position of the bllinking cursor in a text box Mitch Public Class Form1 Private Sub Button1_Click( ByVal sender As System.Object, _ ByVal e As System.EventArgs) Handles Button1.Click ' Select caret position 6 ' If it exists TextBox1.SelectionStart = 6 TextBox1.Select() End Sub End Class ...Show All

• Visual C# Can't debug threads! Please, help!

  OK, I found a thread that confirms this problem and offers some solution http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=147707&SiteID=1 ____________________________________________ I run in very strange problem. For some reason, Debugger hangs for a few seconds after hitting a BP. After that, any complex object isn't visible in debugger (displayes something like that: "function evaluation disabled because previouse function evaluation timeouted") and if  I try Step Over/Into the app just runs and never get back to the debugger. This happens only if I try to debug thread other then main, in exaple below i can debug button1_Click and can't debug backgroundWorker1_DoWork. This happaning to any new pro ...Show All

• SQL Server acces multiple servers

  Hi, I need to access a table from another server in my procedure...I am now connected to say SERVERA...I need to access another table SERVERB.TABLE2 in the same procedure... Is there a way to do that... I need to connect to two servers from the same procedure to get data.. Please get back Thanks, Hi Swapna, Yes, there are a few methods, however the most straightforward would be to create a linked server. Have a look at BOL or http://www.databasejournal.com/features/mssql/article.php/3085211 for more info. Cheers, Rob ...Show All