learningdba's Q&A profile

• Game Technologies: DirectX, XNA, XACT, etc. Displaying textured 3D objects

  Hi there, I've been working my way through the tutorials at http://xna101.spaces.live.com/ , and I am stuck on lesson 16, the first 3D tutorial. The download of die.x didn't work, so I whipped up my own little 3D cube in Blender and applied a simple 64x64 pixel texture to it and saved it in DirectX format as cube.x. I was able to add it to my Project fine, but when I try to compile the program, it has all sorts of trouble understanding any texture I put on the thing. It will say the texture file is not found in the debug/bin directory; or it will give me other error messages about the structure of the texture file. I tried saving the cube as cube.3ds and cube.x3d and whatnot, and none of that worked. (Indeed, the Project didn't even rec ...Show All

• Visual Studio 2008 (Pre-release) Binding to DateTime.Now

  Hi everybody, I want to show a digital clock at statusbar, so i put a TextBlock on StatusBar and bind it Text property to DateTime.Now. I got no error but nothing happened. Here is my code: <!-- this block is inside status bar --> <TextBlock Name="blockClock" Text="{Binding Path=Now,Source={x:Type sys:DateTime},Mode=OneWay}" Grid.Column="2" Grid.Row="0" Margin="10,0,10,0" Foreground="Blue" VerticalAlignment="Center"/> with "sys" is xmlns:sys="clr-namespace:System;assembly=mscorlib.dll" Am i doing something wrong Thanks, Dat It's actually easier than that: <TextBlock ...Show All

• SQL Server Could not obtain information about Windows NT group/user .......error code 0x534...

  == I asked this question directly to Remus and wanted to share the response to all of those people using this forum == We recently moved our database server from SQL Server 2000 to SQL Server 2005. All applications on our intranet development server stay the same [VS.NET 2003], but recently resources in our Dev DB server ran out of space. While doing a thorough investigation, I noticed ERRORLOG file was occupying about 35 Gig of HDD space. I immediately checked SQL Server error log and noticed an entry which says – =========================================================================================== Date 7/7/2006 4:45:37 PM Log SQL Server (Current - 7/7/2006 4:45:00 PM) Source ...Show All

• SQL Server Are these queries possible without cursors or a while loop?

  I appreciate any help or advise! Thanks assuming the contents of the table are: 1 52 PUERTO RICO 2 52 PUERTO RICO 3 10 MA 4 52 PUERTO RICO 5 5 NY 6 10 MA 7 5 NY 8 52 PUERTO RICO 9 10 MA 10 11 RI 11 12 PA 12 13 CT 13 14 GA (1) detect if there are duplicates and select those records create table twoCol ( id int identity(1,1), colOne int, colTwo varchar(30), modified_last datetime ) I would like to detect all duplicate rows based on colOne and Col2 e.g(all three of these rows have same colOne and Col2) 3 10 MA 6 10 MA 9 10 MA e.g(all four of these rows have same colOne and Col2) 1 52 PUERTO RICO 2 52 PU ...Show All

• Visual C# C# Visual Studio User Control Designer Bug

  Does anyone else have this problem I am using Visual Studio 2005 Professional, Service Pack 1 is installed just for information. This happens in all my controls, but only for labels. I have my labels in the designer partial class as internal, so I can refer to them in code from my client controller (parent object that does the displaying). Also my labels are in a seperate region called Controls in the designer. Just to give all the information. If I build and keep the designer closed, I can modify the code and everything works. If I open up the control in the Visual Studio Designer (The graphical editor) and so much as change a property or add a label, or anything, Visual Studio removes all my labels from the controls re ...Show All

• SQL Server Differences between 2000 and 2005

  Just installed 2005 Enterprise Edition on an XP Media computer... I am blown away because nothing looks familiar to me. Anyone else feel lost Where is the best site for specific changes from 1 version to another... it appears that Enterprise Manager is gone, Query Analyzer is gone, my brain is gone thx Kat I spoke with Microsoft and they said I couldn't install 2005 on a XP media machine. I'm not sure now about the other versions. All versions of 2005 require 2000, xp, etc. Nothing is listed as working with the Media version operating system. I was told I had to upgrade to the full version of XP professional. Nice huh Or I could get rid of all of the programs installed and bring it to another operating system. Oh well, on ...Show All

• Windows Forms How to load XML objects into custom .Net classes?

  Hi all, Hoping someone can point me in the right direction here. I'm writing a VB.Net 2.0 WinForms admin app to allow users to do maintenance on an Oracle database behind another very large app. To keep the size of the admin app down and to avoid a maintenance nightmare when the tables (about 70 of them) change I am trying to write it so it's totally automated. I already have code to read the schema of each table to get the columns and then I have a form that adds an appropriate custom control for each table column. This works very well but I need it to be advanced enough to hide some columns, make sure others are entered, validate some others, etc, etc. So my idea is to have an XML file (see XML below) containing the tables and colum ...Show All

• SQL Server selecting from a SP

  Hello How can I select from an output of SP . I have created to SPs, say myProc and myproc2 to test this: CREATE PROCEDURE dbo.myProc AS begin select * from STOCKS end GO CREATE PROCEDURE dbo.myproc2 as begin select sto_id from myProc end GO When I run myproc2, I get an error: "Invalid object name 'myProc'." If myProc produces a table, so why can't I select from it insert the result of stored procedure into table or temporary table of the same structure declare @temp table (sto_id int , name varchar (20 ) ) insert @temp exec myProc select sto_id from @temp ...Show All

• SQL Server Giving a user permissions on objects in a schema

  Hi, SQL Server Security is not my strong point so forgive me for asking stupid questions.   I have a bunch of tables and sprocs within a schema 'MySchema'. I have a user 'MyUser' defined in the database. I would like to give MyUser permission to SELECT from tables and EXECUTE all sprocs in MySchema. What is the simplest way of doing that Will the following: GRANT EXECUTE ON SCHEMA :: [MySchema] TO [MyUser] WITH GRANT OPTION AS [db_owner] GRANT SELECT ON SCHEMA :: [MySchema] TO [MyUser] WITH GRANT OPTION accomplish that (I can't test it out at the moment because our DBA isn't around and I don't have permission)   With best practices in mind - is what I am doing here considere ...Show All

• SQL Server Reporting Services Instance could not be found

  Hi I am receiving an error message when I connect to Reporting Services in SQL Server 2005, the error is: Cannot connect to <SERVER> Reporting Services Instance could not be found (Microsoft.Sqlserver.Management.UI.RSClient) Can anyone help with this please Thanks Hi David, thanks for the solution. In this case I have found a solution by my self. The Problem is, I used a developer version of the SQL server installation. There are no information about a incompatibility with development SQL installations. So I tried to install a standard SQL server edition and now it works. ...Show All

• .NET Development xmlreader

  < xml version = " 1.0 " encoding = " iso-8859-9 " > < annPanel > < ann > < annID > </ annID > < annTitle > </ annTitle > < annBody > </ annBody > < annPubDate > < annDate ></ annDate > < annTime ></ annTime > </ annPubDate > < annPriority ></ annPriority > < annSender ></ annSender > </ ann > </ annPanel > how can i find last ann node if xml have too much announcement(ann node) with xml reader; and how can i get AnnID value with type integer; 1. You can read the file and each time you meet 'ann' element you remember all f ...Show All

• .NET Development How to list or get all the entrypoints in a dll?

  Hi, Some time back there used to be an application called QuickView using which I could get entrypoints of a dll. I am not able to find that anywhere. Any Idea how to get them now Or where can I get a free tool to get it Thanks. For native dlls you have a tool called depends.exe that comes with Visual Studio (C:\Program Files\Microsoft Visual Studio 8\Common7\Tools\bin) and Windows Support Tools (you can find it on the Windows CD or download it from here http://www.microsoft.com/downloads/details.aspx FamilyID=49ae8576-9bb9-4126-9761-ba8011fabf38&DisplayLang=en ). For .NET dlls you can use Reflector for example ( http://www.aisto.com/roeder/DotNet/ ). ...Show All

• SQL Server SQL 2005 Stored Procedures return no rows

  I am trying to execute a simple SELECT statement in a stored procedure from within Visual Studio 2005. The procedure executes but returns no rows. (There are rows in the table and a VIEW using the same SELECT statement does return the rows.) I added a PRINT statement to the stored procedure to see if it executed and it did print my text in the output window as expected. The SQL server is running on Windows Server 2003 with latest service packs and patches. I had detached the database while doing maintenance on our system and re-attached it later. I can not find any reason why it refuses to return rows. Larry run the sql profiler and examine the trace whether vs is connecting to the appropriate database.. plea ...Show All

• SQL Server Both SQL 2000 and SQL 2005 on same production server

  Hello, We have a vendor supplied application that only supports SQL 2000 (for at least another 6 months.) Our team also wants to use SQL 2005 for some of the native XML benefits with custom code. Several of our team wants to install both versions of SQL (2k, 2005) on the same server even in our production environment. I am wary of supporting this for a high availability application, and am concerned that the next service pack or hotfix could cause problems. 1) Though I have read it is supported, are any Fortune 100 type companies using this configuration for high availability applications 2) Does SQL's fundamental capability to support multiple instances make this more trivial than I am thinking 3) Would anyone have points t ...Show All

• Community Chat zune not recognized by PC

  My PC will not recognize my zune, any other device i hook up usb i getthe old DOng ding sound and it shows up. When I hook up the zune, I get nothing. This is the second zune and third cable, it will not even charge on my PC and yes i have 2.0 usb. Any help would be great. Thanks Chad K DTOLLE wrote: Hi, I am new here, looking for help with the zune I got my son for Christmas. We seem to be having the same trouble you are. The device is not recognized on the software or the device manager. I have updated everything I can think of and spent several hours on the phone with zune help. I exchanged one at the store already but we are out of the store's 15 day limit on exchang ...Show All