RookieDBA's Q&A profile

• .NET Development Website

  Can Any body help me how can i create a web site that ather than localhost,i want it to have an address like juandelacross.com in my own computer my os is server2003 standard,please i'm an amature. they are all correct but,there is also other thing to do you have to configure your dns or if u dont know how you have to register ur domain,if u want to learn about configuring your dns to host your own internet domain or windows domain just text me so i can responce you any time i dont have internet connection at this time so you have to text me (0920-272884) ...Show All

• Community Chat What version of vista are YOU getting?

  So, out of all of the editions, Home Basic, Home Premium, Business, Enterprise, Starter and Ultimate , which are you getting I am going to get Home Premium because it seems like it has mostly everything I would need. Comes with mostly everything except backing up software which you can just download. So, what are you getting I'm going for the Ultimate. I'm going to needed it, for everything I need to do. Now here's to hoping I'll find an OEM that will include it on a system of theirs... (why do I doubt this) ...Show All

• .NET Development Help with sync between DataSet and datasource (Fill problem)

  Hi there, I'm having a weird problem with the fill method. Basically the structure of my program is: Fill > Make changes in data source directly through sql statements > Fill again For some reason the second fill retrieves the same data as the first, as if the changes in the data source have not yet been commited. I'm not using transactions, locks etc etc, everything is very basic. Each time I fill this is the code: DataSet.Clear(); DataAdapter.Fill(DataSet, "TableName"); If I put a MessageBox between Clear() and Fill(), forcing a pause, the second fill suddenly "sees" the new records (in the case of an insert, for example). What could be the cause of this It's causing great headaches! :) This is OLEDB, with an ac ...Show All

• .NET Development manual IL code fails verification with "unable to resolve token"

  Hi, I'm trying to write a (naive concept test) script that adds a prologue & epilogue to methods. It modifies the output of ildasm on an assembly to create a new IL file which I in turn compile with ilasm. It works by adding the following lines to the begining of every method: call class [Reflex]Reflex.ReflexWriter [Reflex]Reflex.ReflexWriter::get_Instance() callvirt instance void [Reflex]Reflex.ReflexWriter::Enter() It works on very simple assemblies I compiled with C#. To challenge my naive idea, I tried running it on the fxcop executable. The executable compiled but peverify fails with many similar errors, I copied the first one here: [IL]: Error: [D:\Program Files\Microsoft FxCop 1.35\FxCopy_trac ...Show All

• .NET Development How to Prefix an XML document?

  How to add prefix to all of the nodes in an XML document Following is my xml. < xml version="1.0" encoding="utf-16" > - < XYZ123 :NameRequester xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" d1p1:SID="20" d1p1:HID="21" d1p1:RID="22" xmlns:d1p1="http://tempuri.net/" xmlns="http://tempuri.net" xmlns:XYZ123="http://tempuri.net"> - <d1p1:NameBlock> - <d1p1:Test1> <d1p1:Name>Bob</d1p1:Name> <d1p1:HisName>Tom</d1p1:HisName> <d1p1:HerName>Marie</d1p1:HerName> </d1p1:Test1> <d1p1:OtherName>Sally</d1p1:OtherName> ...Show All

• Visual C# DataListView and Generic BindingList

  For my project i'm using business objects instead of datasets Now to each class i added a property RowState to see when a record is added, modified or deleted. When deleting a item i just change the rowstate so that all records changes are aplied to the database when the user clicks the save button. Only problem i have now, when i change a rowstate to deleted its still visible in the datagridview :( I allready tried changing the name of the RowState property to State like its on a DataRow class but it aint working. How can i hide records from the datagrid when the rowstate is set to deleted ...Show All

• Visual Studio Express Editions How to get Free VBE E-Book

  I obtained VBE 2005 in a looong download. I registered it using my real name. I accessed the VBE forum using a fictitious name. I want to obtain the free VBE book "Writing my first program" but when I try to obtain it I get a page stating I have no permission to get it and it gives me a long coded value that looks suspiciously like something in the Windows registry. It offers me a change to contact someone and use the entered code as a reference. How do I complete the process to obtain my free copy of the e-book, preferably downloaded Please respond to old7t1@msn.com Thank you. Did you register the product Have you applied for registration benefits Once you register the product, you c ...Show All

• .NET Development how can i detect internet explorers event

  i want a code in C# , show a url in a textbox when anyone clicks on download a page or file in an internet explorer. Please send me code to show url in a textbox. in C#.NET I believe File.Open(URL) will launch the default browser and go to the URL. For your case you could hook up to the click event handler to handle the click. Another option would be just use the Link Windows Forms control. ...Show All

• SQL Server Using Parameters with the Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider

  Hi, For using Measures in rows and not in columns, I have to use the Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider. When I try to use named parameters within my reporting query I get an error, that this provider can't handle named parameters (the "@" parameters in the example). I can only use the " " replacement for parameters, but how do I join the " " to the right parameter under reporting parameters menu And how do I use the " " placeholder in the right way in my subcube query part For exampleI will do a query like this: SELECT { [Date].[Periode - Year].[Month].ALLMEMBERS } on columns, { [Measures].[Sales Volume KG], [Measures].[Sales Volume M2], [Measures].[Average W ...Show All

• SQL Server fyi - broken link (Project REAL: Enterprise Class Hardware Tuning for Microsoft Analysis Services)

  On http://www.microsoft.com/sql/solutions/bi/projectreal.mspx is a link to a useful article: Project REAL: Enterprise Class Hardware Tuning for Microsoft Analysis Services http://download.microsoft.com/download/4/1/F/41F09116-19B3-40FE-9D54-D1E9B7AF9E82/REAL_Ent_HW_Tuning.doc The link is broken, in case anyone on the MSDN side might be able to fix it. A google cache is available here: http://66.102.9.104/search q=cache:KnpD0fuGHyIJ:download.microsoft.com/download/4/1/F/41F09116-19B3-40FE-9D54-D1E9B7AF9E82/REAL_Ent_HW_Tuning.doc+REAL:+Enterprise+Class+Hardware+Tuning+for+Microsoft+Analysis+Services&hl=en&gl=uk&ct=clnk&cd=2&client=firefox-a ...Show All

• Visual C++ Problems with VS2005

  Following a mini-rant regarding the quality of VS2005 on the DirectX Dev list, it was suggested that discussion was continued on these forums, so I'll try and quantify my earlier rants/complaints with real problems I've encountered over the last six months. It should be noted that all these problems I've encountered are with the Professional version of Visual Studio 2005, building native C++ projects targeting x86, x64 and Xbox 360. My PC is a dual core 2Ghz AMD with 2GB of RAM and an X800 ATI video card. IDE Aside from the performance issues, which I'll get to in a minute, these are the main problems I have with the IDE in VS2005: Configuration Manager is broken. Really broken. Changing platform or solution configuration l ...Show All

• Visual C# How can I retrieve advanced file information?

  ...Like the Title of a song, the Bitrate, Album, etc. Thanks, absolutely - I did it in VB.NET since the post was in the VB forums But anyway: FileStream theFileStream = New FileStream (PathToFile , FileMode.Open); Byte[] theByteBuff = new Byte[128]; theFileStream.Seek(-128, SeekOrigin. End ); theFileStream.Read(theByteBuff, 0, 128); theFileStream.Close(); System.Text.ASCIIEncoding theEncoding = New System.Text.ASCIIEncoding(); string theTagInfo = theEncoding.GetString(theByteBuff); If (theTagInfo.Contains( "TAG" )) { string theTitle = theTagInfo.Substring(3, 30).Trim() ; string theArtist = theTagInfo.Substring(33, 30).Trim(); string theAlbum = theTagInfo.Substring ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Picker Problems - SOLVED

  Good Evening- I made a picker function so I could click on the screen and have the function tell me what mesh I clicked on. It worked great with only one mesh. However after adding a second mesh to the scene I now have a problem: when I click on the first mesh it says I clicked on both meshes, and when I click on the second mesh it says I clicked on none. Here is the function: void Pick(object sender, MouseEventArgs e) // Broken for some reason. { double x, y; x = e.X; y = e.Y; Vector3 near = new Vector3((float)x, (float)y, 0.0f); Vector3 far = new Vector3((float)x, (float)y, 1.0f); near.Unproject(manager.device.Viewport, manager.device.Transform.Projection, manager.device.Transform.View, manag ...Show All

• Visual Studio Team System Why is "from" type not allowed as value for the SERVERDEFAULT field default ?

  Is there any reason why the from-type is not allowed for the SERVERDEFAULT field default This would allow you to set fields to specific value without the user being able to edit it. Are there any plans to allow this in futere versions Could you provide details as to why you would like this feature What business/process problems are you trying to solve with it This will help us understand where you are coming from. ...Show All

• SQL Server Problems working with Many-to-Many relationship

  I'm trying to report on Doctor transactions and Doctor Credentials. A Doctor (dim) has many transactions (fact) and a Doctor has many Credential (dim) records. I have tried setting up the Credential/Fact relationship as snowflake through Doctor, referenced, fact and Many-to-Many. Everytime, instead of getting the specific credential records associated with the doctor, I get all possible credential types (cartesion product). Thanks for the help, Dave The Doctor table has a DoctorKey (PK) and the Credential table has a DoctorKey (FK). I have tried setting up the Credential table as a Measure Group and Fact dim, but the result is the same. On an example Doctor that should only have one Credenti ...Show All