MShanahan's Q&A profile

• SQL Server Error on Export to Excel with Bookmarks and Navigation Jumps

  Hello All, We're running RS 2005. I have a problem in a report using two main sections. There's a top level report, made up from 4 tables within a rectangle. The second section of the report contains the detail of the calculations making the top level figures. The second section of the report contains bookmarks and jump links to drill to different levels of the reporting structure. This works fine. The top level of the report also has jump to bookmark links to drop into the relevant section of section two, and display the detail. The problem I'm having is that although the jump links work fine within report manager, the report will not export to excel from report manager. It errors with the error at the bottom o ...Show All

• SQL Server ERROR 5120

  I tried attach/detach approach to migrate sql server 2000 databases to sql 2005. I installed a fresh copy of sql server 2005 on windows 2003 server. I could move most of my databases except one. While attaching the database to the sql 2005 I got the following error: Unable to oen "c:\program files\microsoftSQL server \MSSQL.1\MSSQL\DATA\mydb_log.ldf". operating system error 32:" 32(the process cannot access the file because it is being used by another process)". microsoft SQL server, error:5120) I have a similar problem with the same error: 1) Detached MyDb.mdf (and .ldf) (Auto close = True) 2) copied MyDb.mdf and MyDb.ldf to a different folder 3) Re-attached My ...Show All

• .NET Development Application Design Question

  I have an database application that runs in a computer which has no static IP. I am going to build a web service that will retrieve information from that database and display it on a web site as users request it. something like a tracking system. My problem is, i can't send every record from my existing database to the web service (which will log it to a second database) because only 1 out of 100 records will be queried. it would be a waste of bandwidth and space. I need to implement the web service so that when a customers requests information it retrieves the data from the existing database (computer with no static IP). Any ideas would be greatly appreciated. Let's see if i can get this thread started. O ...Show All

• SQL Server Trying to get daily totals from cumulative totals in a pivot

  I have been providing sales data for a few months now from a table that is set up like this: Date WorkDay GasSales EquipmentSales 9/1/2006 1 100.00 200.00 9/4/2006 2 50.00 45.00 etc. As can be seen, the data is daily, i.e., on the first workday of September we sold one hundred dollars in gas and two hundred dollars in equipment. On the second workday of September we sold fifty dollars in gas and forty-five dollars in equipment. Now, however, the data I have to pull from is cumulative. So, using the last table as an example it would look like this: Date_WorkDay_GasSales_EquipmentSales 9/1/2006 1 100.00 200.00 9/4/2006 2 150.00 245.00 etc. To make things more complicated, the powers that be wanted this data p ...Show All

• Visual Studio Express Editions 16 bit programs

  I won't waist much time, I just got a laptop I can take apart/ use but it only runs 16 bit programs, can I use visual studio to output to 16 bit in some way. Is there any development tools still kicking around, I dont care about complexity or language, anything. its a windows 95 thanks, average joe Quoting this web page: http://www.axtools.com/products/csg2/htm/IntroSystemRequirements.htm Some of these requirements are based on the Visual Studio minimal system recommendations . Windows 95, Windows 98, Windows 98 Second Edition, and Windows ME are not supported . ...Show All

• Architecture Data Exchange

  We need to exchange our customer data with an external partner on a daily basis. This data is highly confidential. This size of the data will be around 1GB. The data format is unicode. What will be the best way to exchange the information Vikas, We don't have any connectivity between two networks as of now. The cusotmer data is stored in SQL Server (some applications in 2000 and some applications in 2005). The partner uses SAP(SQL server as its database) ...Show All

• SQL Server replication hangs on one table

  publisher - sql2000 sp4 distributor - sql 2005 sp1 subscribers - mix of sql2005 sp1 and sql 2000 sp4 we have a database with around 300 tables and replicate it to around 10 different subscribers. some in the same datacenter and others in different offices. We have around 50-60 different publications for this. Some have 20 or so tables others have only one table if they are large tables. Tables range in size from a few hundred rows to over 20 million. Some tables replicate a few commands, others 100000 or more commands on a daily basis. Around 6 weeks ago we started having problems with one table. It's 1.4 million rows and replicates around a few thousand commands on a daily basis. We saw a backlog of around 150000 to 400000 commands. We ha ...Show All

• Visual Basic vb6 upgrade wizard error - OLE_E_CANT_BINDTOSOURCE

  When I run the VB6 upgrade wizard in Visual Studio 2005 I get an error. It is not related to the application I am upgrading, because I even get the error if I run it on a "blank" vb6 app. I've re-installed, and still no luck. The entire error reads: Unexpected exception occurred during upgrade engine operation: Not able to bind to the source (Exception from HRESULT: 0x8004000A (OLE_E_CANT_BINDTOSOURCE)) Thank you Removing the Wow6432Node keys works with me too. ...Show All

• SQL Server Integrating SSRS with SAP

  Hi , I can see that there is an adapter description for SAP is available [although commented] in rsreportserver.config. Can anybody suggest what i need to followup to call the SAP interfaces[i alreday have RFC and SAP.NET connector avialable with me] and i am calling the SAP interface thru custom assembly. If the adapter is available can anybody suggest some how can i activate the adapter to call the SAP interfaces directly from SSRS and how the credentila flows from SSRS to SAP. Teo, Thansk for the reply.BOL was pointing to the netweaverBI sys but for our case the netweaver frx was not inplace...however i found the link http://msdn2.microsoft.com/en-us/library/ms141761.aspx and it was mentined that it came as a s ...Show All

• Visual Studio Team System Script Import: does not want to parse correctly?

  I'm using CTP6 and trying to import/parse as .SQL script. When I put eacht object type seperately (having multiple .sql files) parsing goes OK. When I try to import a complete script, it does not recognize the CREATE VIEW statement. The .SQL is just a small extension top NorthWind. .SQL file content: CREATE TABLE [dbo].[Auctions] ( [AuctionID] [int] IDENTITY(1,1) NOT NULL, [AuctionTitle] [nvarchar](50) NOT NULL, [AuctionDescription][nvarchar](2000) NOT NULL, [AuctionStartDate][datetime] NOT NULL, [AuctionLength][int] NOT NULL, [ProductID][int] NOT NULL, [ItemQuantity][int] NOT NULL, [EmployeeID][int] NOT NULL, [MinimumBidAmount][money] NULL ) ; ALTER TABLE [dbo].[Auctions] ADD CONSTRAINT [PK_Auctions] PRIMARY K ...Show All

• Visual Studio 2008 (Pre-release) Why marshalling instance is not working? [Code provided!]

  Hello, I want to marshall an an object to the client from the server, and then use this object. But it is not working giving error: "The socket connection was aborted. This could be caused by an error processing your message or a receive timeout being exceeded by the remote host, or an underlying network resource issue. Local socket timeout was '00:00:59.9530000'.". Stack Trace: "\r\nServer stack trace: \r\n at System.ServiceModel.Channels.StreamConnection.Read(Byte[] buffer, Int32 offset, Int32 size, TimeSpan timeout)\r\n at System.ServiceModel.Channels.SessionConnectionReader.Receive(TimeSpan timeout)\r\n at System.ServiceModel.Channels.SynchronizedMessageSource.Receive(TimeSpan timeout)\r\n at System.Serv ...Show All

• Visual C# A design pattern for retrying operations

  Is there a well-known design pattern for retrying methods that are likely to fail I am thinking of a delegate-based implementation where the delegate wraps the method to be invoked. The delegate would then be fed to a RetryMethod method that implements the actual logic behind retrying an operation. And what if each method that supports 'retrying' takes different parameters Would 'anonymous delegates' apply in this case Thanks, Yazan D Hi, IMHO, Observer design pattern can be used in this case though its not exactly for what you have asked for, using subscriber/notifier mechanism using delegates is the same what Observer pattern says. On failture, the notifier will notify to subsriber and it will call retry method (y ...Show All

• SQL Server raiseerror does not raise exception

  Hi friends i've a stored proc (sql 2005) that'll raiseerror statement when something violated. but my C# application that calls this stored proc does not any throw exception when this happens !! i remember visual basic used to through an exception for this type of things. is it different in C# and how do we handle this scenario Thanks for ur ideas. am doing something like below BEGIN TRY BEGIN TRAN /* one of below statements may result in error*/ insert into mytable1 values (...blah..) insert into mytable1 values (...blah..) COMMIT END TRY BEGIN CATCH DECLARE @ErrorMessage VARCHAR(4000) SELECT @ErrorMessage = 'Message: '+ ERROR_MESSAGE(); raiserror (@ErrorMessage) END CATCH ...Show All

• Visual C# Problem starting applications based on Skype Starter Kit for C#

  Hi All, I downloaded the Skype Starter Kit, I added the reference to the SharpLogic.Skype library and when the application starts I got this exception: "Could not load file or assembly 'SharpLogic.Skype, Version=1.0.2299.29912, Culture=neutral, PublicKeyToken=null' or one of its dependencies. This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem. (Exception from HRESULT: 0x800736B1)" I'm using VS2005 and Skype 2.0 Can anyone help me please Regards Paolo Are you sure you have Skype 1.3.0.54 or later installed Please provide us the full-stacktrace because i think SharpLogic.Skype.dll is not the problem but a Dll t ...Show All

• Visual Studio 2008 (Pre-release) netTcpBinding and Java Web Services

  I understand that netTcpBinding uses a proprietary protocol to communciate between WCF client and WCF server or vice versa. (If this is not true, please let me know.) Are there any plans to publish this protocol so that third parties can write a plug in for WCF client that communicates with java web services or that lets a WCF service to communicate with a java web service client using TCP transport channel If there are already libraries available, please let me know. The sole reason for my question is to boost the performance between WCF Client to Java Web Service or vice versa. Please do not comment on the virtues of using http only as it is not related to my use case. Thanks. Hi, Jus caught this post... Does this m ...Show All