mmonte's Q&A profile

• SQL Server Sql Server for Oracle developer and DBA - references

  Hi all, Would anyone know of any references (online or books) that make it easier for experienced Oracle people to Learn SQL Server. The type of things I'd like to know for example are The environment for SQL server on a PC (e.g. where the datafiles are, what's the replacement for tnslistener - general architecture info) Any significant differences that I'd need to know for creating tables and applications, like what do I use instead of varchar2 for example. that should get me started. tia, Dave Hi, Here are some SQL Server 2000 for the Oracle DBA by Christopher Kempster Copyright 2003 Publisher's Website SQL Server 2000 Fast Answers for DBAs and Developers by Joseph Sack Copyright 2003 C ...Show All

• Visual Studio Tools for Office Saving OLEObject content to a file

  Greetings, colleagues I have spent quite some time on trying to solve the following problem: I get the OLEObject from the Excel worksheet, e.g. Excel.OLEObject myOLEObject = (Excel.OLEObject) currentSheet.OLEObjects(1); I need to to save this myOLEObject object back to file on hard drive (in my Excel 2003 managed code extension). The only thing I know about the OLE object is that it was created in Excel 2003 through "Insert -> Object -> Create from file". So the exact data type of this OLE object is unknown. Casting it to Bitmap or Word document does not solve the problem. I.e. it may be a bitmap image, a word document, etc. including a generic binary file of unknown format. Manually an Excel 2003 user ...Show All

• Microsoft ISV Community Center Forums VBA Harddisk serial

  Hi, How can I take serial number of harddisk by using Access VBA. Hello Probably not the best way but I had to do this once and I did it like this Hope this is what you were looking for. If you find a neater way of doing this please let me know. Sub test() Dim DirEntry As String Dim thisPath As String Open "C:\DIRFILE.BAT" For Output As #1 Print #1, "DIR > Direct.TXT" Close #1 thisPath = Application.ThisWorkbook.Path x = Shell("C:\DIRFILE.BAT") Open thisPath & "\direct.txt" For Input As #1 Do While Not EOF(1) Line Input #1, DirEntry z = InStr(DirEntry, "Serial") If z > 0 Then MsgBox "Hard Disk : " & Trim(DirEntry) ...Show All

• Windows Live Developer Forums Where can i get the Windows Live ID SDK

  Hi, Do you know where can i get the Windows Live ID SDK Go to http://dev.live.com/liveid and download it there ...Show All

• Audio and Video Development please help. how can you clear files from windows media player 10

  hey I have Windows media player 10 and I need to know how to clear out the things I have played with WMP. When I click on file, about halfway down the menu are all the things I have played. I looked for a way to clear them but I couldnt find it. I need to know how to clear these. please help ...Show All

• Visual Studio 2008 (Pre-release) XAML Paging Control

  Could any one can explain how we can achieve the paging / Custom paging / Page break functionality in XAML. Is there any predefined control like DataGrid in .Net 2.0. Thanks and Regards Gobi N Hi Gobi The Grid in WPF does not have a standard paging mechanism.  However, bear in mind that a GridView object [which displays items for a ListView control ( http://msdn2.microsoft.com/en-us/library/system.windows.controls.gridview.aspx )] can be bound to a Grid. The reason I point this fact out is because Kevin Moore (a WPF progam manager) has posted his Bag-O-Tricks at the community site ( http://wpf.netfx3.com/files/folders/controls/entry7094.aspx ).  One of the controls th ...Show All

• Software Development for Windows Vista Certified for Vista - TEST CASE 15

  I have a question, regarding Certified for Vista, TEST CASE 15. Verify application installs to the correct folders by default (Req:2.3) and which one it says: 6. Default install directories are: a. Native x86 and x64 applications i. Program Files - %ProgramFiles% ii. User’s AppData - %APPDATA% iii. ProgramData – ALLUSERSPROFILE% Our application has 2 kind of shared user data: 1.) Sample data that is the same for all users, that is copied at the install time, at may be modified by users at application run-time 2.) License data (serial number) that is the same for all users, that is taken from user input at the install time, and also sholud be written at install time to a shared folder. In witch directory should I put this kind of ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How Do I Determine The Currently Visible Area?

    I'm building a 3D game and currently have everything working, but I'm in the process of optimizing my framerate.  The world in the game is many times larger than the screen/window.  How would I go about determining the world coordinates that are visible on the screen   Even though the objects outside of the viewport are clipped, the draw code still has to translate (and rotate) the meshes in the objects (many of which will be clipped).  It would be much more efficient if I could just not process meshes that will be outside of the screen.  Thanks!   If your looking for somewhere to upload your game, Derek who runs threesixbox , happily hosts publish ...Show All

• SQL Server What decides on the tables available for a partition?

  Hello, I am using the Partition Wizard. On the first screen (Specify Source Information) there are two tables listed. They are called: QMR_610_MembersOther_GrAmountAnalysis QMR_610_MembersOther_ReinsShareAnalysis Only one of those (the first one) is used as the fact table for the measure group that I am creating partitions for. So what I don't understand is why its making these 2 tables available for my partition. Can anyone explain how the Partition Wizard determines which tables are available for the partition Thanks Jamie Hi Jamie, I tried to use the profiler while BIDS was doing the selection via the partition wizard. And I think that the wizard is scanning the database connected in the datas ...Show All

• Visual Studio Team System Uninstall SP1 on data tier problem

  I'm having many of the same issues that several others are having when trying to replace SP1 Beta with SP1 RTM on TFS. However, this particular problem is on the data tier, which I have not yet seen documented. When I run the uninstall for "Microsoft Visual Studio 2005 Team Foundation Server (databases) - ENU Service Pack 1", it moves along nicely, and then fails. The log file for the uninstall contains the following lines: MSI (c) (E4:BC) [09:12:08:874]: Product: Microsoft Visual Studio 2005 Team Foundation Server (databases) - ENU - Update 'Microsoft Visual Studio 2005 Team Foundation Server (databases) - ENU Service Pack 1 (KB922996)' could not be removed. Error code 1603. Additional information is available in the lo ...Show All

• Visual Studio Express Editions e As System.EventArgs Help!!

  I have been messing around in Vb6 for a few years...and before i could call the _Click event from within another button. What i would like to do is have 2 buttons...and if one button is clicked, it would automatically click the second when i try to use this code..i get a blue line under cmdRemove_Click() and the tip: Arguement not specified for paremeter 'e' of 'Private Sub cmdRemove_Click(sender as Object,e As System.EventArgs) code is: Private Sub tbRemove_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles tbRemove.Click cmdRemove_Click() End Sub Can anyone give me some sample code..that would allow me to call a _click event from a command button ...Show All

• Visual C++ Showing one instance of the same control in multiple windows

  Is this possible Can I, for example, have a CTreeCtrl in my CDocument class, that gets shown in all dialogs that might need it and updates on all windows when a change is made through one of the windows Thanks in advance It is not possible. A window can have only one owner/parent. However See Windows SDK forum for Windows programming questions ; you might get better help in a Windows programming newsgroup or forum. For questions about the Windows MFC Document/View Architecture, there is a Microsoft newsgroup for those. I am not sure if those questions are supposed to be within the scope of this forum. I can say this much: whenever possible, it is best to use MFC in a manner consistent with it's d ...Show All

• Visual C# Sending HTML Mail Messages with Embedded Images

  Hello, I am facing one problem. We have created a small utility that can email HTML messages. The HTML is coming through fine, but we are not able to get around the problem for embedding images. I have some code from Python that is doing what I am looking for. Does any one have a C# equivalent to this code snippet msgAlternative = MIMEMultipart( 'alternative' ) msgRoot.attach(msgAlternative) msgText = MIMEText( 'This is the alternative plain text message.' ) msgAlternative.attach(msgText) # We reference the image in the IMG SRC attribute by the ID we give it below msgText = MIMEText( '<b>Some <i>HTML</i> text</b> and an image.<br><img src="cid:image1"><br>Nifty!' , 'html' ) msgA ...Show All

• SQL Server Report Builder Formatting Currency

  Hi all I need Report Builder to format Certain Numbers as Currency by default. According to the documentation I need to set the culture setting in the report's datasource. I'm using a SSAS2005 Cube The Report Manager then let's me create the Model wich is used by Report Builder. My Question is: Where do I set the culture setting I cannot find it in the Cube and viewing the model's xml hasn't helped. Any help will be dearly appreciated G GDavids - SAO wrote: No good, the report model does not contain a connection string. As this is what Report Builder uses: I'm assuming that this is the datasource that is being reffered to. report model have Datasources link in Properties Datasource have connectio ...Show All

• Software Development for Windows Vista "help and support" not working

  this is what I get when I open help: (on vista RC2) "Internet explorer cannot download /from help..." Internet working well and is enabled. How to fix it Perfect - thanks! It works fine now on OEM Vista HomePremium! I also have dreamweaver, and had the same problem - and have been franticly trying to find a solution, with most answers being to re-install, which i didnt really want to do! Thanks again KA-50Hokum! Pete ...Show All