Becker2's Q&A profile

• SQL Server Log Shipping between SQL 2005 and SQL 2000

  We have an environment where 3 SQL 2000 servers exist; one production servers and two standby servers that receive logs via log shipping. Everything works fine and it is stable. My client wants to get a new 64 bit server and run SQL 2005 64 bit version for the production box. Can we still do log shipping with the two remaining SQL 2000 boxes or do they all have to be on the same version and bit version Thanks Bill Hey Paul, When applying a transaction log built from a SQL2000 (version 80) instance to SQL 2005 instance but the database is in a (version 80) configuration I still get the following error: This backup cannot be restored using WITH STANDBY because a database upgrade is needed. ...Show All

• Visual Studio Tools for Office How to get the images from a word document

  Hi all I am using VS2005 and Microsoft.Interop.word assembly of word2003.How to read the word document which contains paragraphs and images.Can any one provide a sample code to accomplish my requirement. regards keshav The InlineShapes collection exists as part of the Range object, so you can implement the following method to get the shapes (images/pictures) contained within a specified paragraph: internal void GetShapesInParagraph(int paragraphIndex) { // get the paragraph we want to check Word.Paragraph para = this.Paragraphs[paragraphIndex]; // validate the object if (para != null) { // the InlineShapes collection exists in the Range of that paragraph foreach (Word ...Show All

• Smart Device Development Using DirectDraw in Windows CE 4.2

  My work is Nevigation system developing. This system's OS is Windows CE 4.2 and CPU is armv4i. Tool is Embedded Visual C++ 4.0(sp4) at my desktop. And important thing is I must use Directdraw. First, I used 'ddraw.h','ddraw.lib' in DirectX SDK. But in Embedded Visual C++, that didn't compile. So I searched all my hard disk, and found out those files in 'Windows CE Tools\wce500'. Second, I used those files, complie and build are success. But when I moved execute file to Nevigation system, that didn't work. Message was '.... can't find some linked files....' (this message is not accurately, because that was written by Korean) I think that is 'dll' problem. Third, I searched 'ddraw.dll' in my hard disk, and fo ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Adjusting amount of available attack/release time in XACT

  First off, I'd like to commend the developers of XACT for making such a user friendly program for those of us not super technologically savvy. Great program. My question is this. I've created an RPC for the attack/release time in background music we're using for a game. However, I've noticed that the upward limit on both attack and release is 15 seconds and I haven't been able to find a way to adjust this. Ideally, I'd like to have a 30 second fade both ways for the background music. Is there something I'm missing Aloha, Brian Thanks for the comment! No, you're not missing anyting. Currently, the max time for attack/release is 15 seconds. We are upping this in a future version, though. -Brian ...Show All

• SQL Server RunningValue ?

  I am having problems with the following - this represents the dataset Date Customer Voucher Number Document Amount Check Amount 7/15/2006 Company G 101 15.00 45.00 7/15/2006 Compnay G 101 25.00 45.00 7/15/2006 Compnay G 101 5.00 45.00 7/18/2006 Company A 102 35.00 35.00 7/25/2006 Company M 103 45.00 50.00 7/25/2006 Company M 103 15.00 50.00 This represents the final report this is what I am getting Date Customer Voucher Number Document Amount Check Amount Check A ...Show All

• Visual Basic DataGridView Navigation

  Hi, im sick of this error: Operation is not valid because it results in a reentrant call to the SetCurrentCellAddressCore function It happens, when i use (1 case) : MyGrid.currentcell = Mygrid.CurrentRow.Cells(0) it also happens when i try to remove a row, but not in all cases, how can i avoid this fu#~@n error . . . thanks in advance if u r doing in c# then u should set datagridview1.currentcell = datagridview1[datagridview1.currentcelladdress.x,datagridview.currentcelladdress.y]; u can set the col or row by assigning an integer ...Show All

• Windows Live Developer Forums VE development with BEA Portal

  Does anyone have experience integrating VE and/or MapPoint web services into a portal application We are looking into the feasibility of using VE or MP for locator services in a web site built with BEA Portal using Java as the underlying language base. Yes my current project integrates VE into a DotNetNuke (ASP.NET2) portal. I highly recommend an approach of writing webservices for all your server side functionlaity and then wrapper pages that are call using ajax, they call the web service and produce the javascrip to be executed. This architecture allows you to move to a point where the pages are calling the web services directly. I really like the idea of letting the client do as much of the presenatio ...Show All

• Visual Basic retrieving a selected value from DataGridViewComboBoxColumn

  How do you retrieve a selected value from a DataGridViewComboBoxColumn Thank you, I managed this with MsgBox( "The content of the Combo box is " & Me .DataGridViewTextBoxColumn5.DataGridView.CurrentRow.Cells(0).Value, MsgBoxStyle.OkOnly) seems rather a long winded way to get a control value, but I did get there. ...Show All

• SQL Server Partition Slice Property

  I'm having trouble processing a partition that has a slice property selected. My data is partitioned on a montly basis, hence the slice is along the lines of [Date].[Date Hierarchy].[Month].&[200607]. When I do process index or process full, it fails. Iget the following error: Error: The script threw an exception: Errors in the OLAP storage engine: The slice specified for the Half Year attribute is incorrect. Errors in the OLAP storage engine: An error occurred while processing the indexes for the Viewers 200607 partition of the Viewers measure group of the Viewing cube from the BDW database. I didn't type the mdx myself, just click and drag from metadata pane. Anyone know why this might be happening Thank. Rahil ...Show All

• SQL Server Import Data to SQL server from Excel spreadsheet

  Hi all, Firstly, i'm new to integration services and have only done a little with DTS jobs. I'm trying to create an integration services project which will import data from an two worksheets in an Excel spreadsheet to two different tables in a database. I'm looking at only one table at present to make things a little more understandable. One stipulation i have is that i need to be able to specify a variable value and insert that as an additional column in the database. I have and Excel source and a SQL destination both of which have been set up with there specific connection managers. I also have a variable which i add in using the derived column task. When i try to debug this i am getting a few problems. I think these may be to do with th ...Show All

• SQL Server Report Designer

  How do i split a dimension such that the dimension has its range ie. < 10 ,= 10 and > 10. in report designer instead of just drilling through all the values for display. Thanks. Regards Alu ...Show All

• SQL Server SQLSERVERAGENT

  Dear all, I can't start the SQLSERVERAGENT for my sql 2k under win 2003 sp1. SQLServerAgent could not be started (reason: SQLServerAgent cannot start because the instance of the server (MSSQLSERV) is not the expected instance (MSSQLSERVER)). I can't find any useful information regarding this error. Any one can help Thanks, bchu Seems that the registry then was corrupted somehow, THe entry can be found in the services section of WIndows. The sqlagent will start as a service taking the -i switch to k now which instance will be monitored. So search in the registry for -i MSSQLSERV and replace it with MSSSQLSERVER. Restart the service, then it should work like a charm. AGain, this does not happen ...Show All

• Visual C++ stdio.h errors in Visual Studio 2005

  I just finished installing VS 2005 (is it that hard for microsoft to just let people download like, a zip file of it, rather than an img file, which i had no idea what to do with at first ) and tried the following code: #include <stdio.h>    // include the standard input/output header file void main(void)    // our program starts here {     printf("Hello World!");    // print "Hello World!" into the console     return;    // return void to windows } It was part of an origionally blank win32 console app called test.  When i tried building the solution or compiling the file separately, I got all those errors: ------ Build started: Project: Test, Configuration: De ...Show All

• .NET Development MSXML2 vs .NET

  I've been having a little bit of succes employing my past knowledge of MSXML2 to create and send requests to an Axis based webservices. But clearly there must be a .NET way to achieve the same result. Currently I read request from a file sub the proper fields and parse the result with MSXML2.DOMDocument. This seems like a pain considering that in some point in time I need to select nodes and find values in these responses. What I have in MSXML2 (and works) is found below. How do I get this done in the .NET FW static public string sendRequest( string message ) { output.WriteLine( string.Format( @"{0:yyyy\/MM\/dd HH\:mm\:ss.ff (zz)} > {1}", DateTime.Now, message ) ); // // create request // MSXML2.XMLHTTPClass http; ...Show All

• Windows Live Developer Forums Friends List Query

  Can you access Freinds Lists of Freinds etc (to the point of viewing thousands, if not millions of Freinds of Freinds of Freinds etc) . Have you got a limit on how many friend lists down you can go from one Freinds List. Surely if someone was to write a program that did this automatically they could log quite a few thousand Live IDs for purposes such as spamming and hacking individual accounts Is this possible Nice feature but i dont think it'll work to well if someone was to do this. Short answer: No. In order to access a user's contacts list or friends list, you (the developer) need the permission of the user to access their data. With the user's ok, your app has access to their immediate contacts. That's all, nothing else. ...Show All