Mory0Tiki's Q&A profile

• SQL Server Two instances accessing the same data file.

  Is this possible: Can a single database be shared between two servers. We would like one database to be accessed from two instances. Our need is to give a copy of a DW for users who will do adhoc queries and potentially cause performance issues on the server. We want to give them their own server, but not have to duplicate a TB of data. Hence, can instance01 and instance02 both access the same .mdf containing the data. Second being read only. I think clustering will not easly allow us to direct user A to one cluster etc. TIA Glenn Hi Glenn, No, this is not possible. There is no way to meet your requirements without duplicating the data volume so to speak (log shipping, mirroring, replication etc) Cheers, ...Show All

• .NET Development "Not enough storage to complete operation" Exception

  Hi, I am using the Excel object from Microsoft Excel 11.0 Object Library version 1.5 to export data to Excel. I received the error "Not enough storage to complete operation". Below is my source code. The error is thrown by the line "excel.Cells[rowIndex + 1, ColumnIndex] = row[col.ColumnName].ToString();" Does anyone know the potential causes and possible fixes Thanks Excel.ApplicationClass excel = new Excel.ApplicationClass(); excel.Application.Workbooks.Add(true); Excel.Worksheet ws = (Excel.Worksheet)excel.ActiveSheet; ws.Activate(); int ColumnIndex = 0; foreach (DataColumn col in data.Columns) { ColumnIndex++; excel.Cells[1, ColumnIndex] = col.ColumnName; } int rowIndex = 0; foreach (DataRow row in data.Rows) { row ...Show All

• SQL Server Parameter default not updating on deploy

  I've got an issue with a report of mine where the default parameter isn't being cleared. Let me explain... I created a report with a parameter on it. While I'm working on the cosmetics of the report, I didn't want to have to keep typing in a value just to see it run, so I set the default value on the parameter. I finish the report and deploy it and everything is ok. Then when I go to the page to view it, I notice that the default is still there, so I go back and edit my report to take out the default and just use NULL. In the preview tab, it looks ok, so I deploy the report again. Now when I go to the report, it still has the default value in the parameter box. Does anyone have any idea as to why this is happening The only way I cou ...Show All

• .NET Development 'upgrading' from 1.1 to 2.0. by the way im a newbie

  Hi all, I want to deploy .net 2.0 on my webserver (server 2003). The server already has .net framework 1.1 on it, and I've downloaded and installed the 2.0 framework. Only thing is, I don't quite understand what's changed as nothing appears to have. I still only have 1.1 framework configuration manager and 1.1 framework wizards on my admin tools, and nothing at all relating to 2.0. Is this normal I have 2.0 in my add/remove programs list but not 1.1. Is this normal too I wanted to install SQL server 2005 express and saw that 2.0 framework was a pre-requisite. I havn't tried to install it yet. Many thanks in advance... by the way im more of a developer than a server admin and im not a network manager either.. Thanks Dave ...Show All

• Smart Device Development Hiding the save as dialog/button...

  Hi, Is there anyway I can hide the save as button while downloading a content in Pocket PC 2005 using Internet Explorer or the Web Browser control. I want to do this because I wan't the user to save all the downloaded files in one location only. Thanks for any reply. Dipesh The save as dialog that you see when downloading content is a native control and you will not be able to hide the save as button from managed code. If you want to have exclusive control over where content gets downloaded to then maybe you should not use the Web Browser control but use the HttpWebRequest class. ...Show All

• Visual Studio Team System TFS Error 29106

  Hi, I am trying to install TFS application tier in a dual server installation and I get the following error Microsoft Visual Studio 2005 Team Foundation Server (services) - ENU -- Error 29106.Team Foundation Report Server Configuration: Access to the Report Server databases could not be granted. Verify that the Team Foundation data-tier server has the recommended enough free disk space Any ideas what might be causing this I have moved your forum post to the Team Foundation Server - Setup forum, where people might better assist you. I also noticed that there are some other postings in this forum on that error that you might check out. ...Show All

• Windows Forms Accessing selected text in other application

  I'm running a Tray Application which gets on focus when a hotKey is pressed. In a few words, the user will select a piece of text in any application (IE, word, acrobat, or any custom application), press the hotkey registered by my application, and the application should be able to read and display the selected text. Could anybody guide me to accomplish this Is it possible Thanks, Seb. But the SendKey sends keystrokes to the active application. When the hot key is pressed, my application becomes the active application. ...Show All

• SQL Server FIX TO: The attempt to connect to the report server failed. Check your connection information...

  If you get the error message: The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. If you then scan the recent logfiles in C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\LogFiles and find the following exception: Microsoft.SqlServer.ReportingServices2005.RSConnection+MissingEndpointException: The attempt to connect to the report server failed.  Check your connection information and that the report server is a compatible version. ---> System.Net.WebException: The request failed with HTTP status 404: . it means that you have configured the /reportserver/ app to not be reachable via http://localhost/ ... - there are two options ...Show All

• Windows Forms How to bind the textbox in windows forms with the column in dataset?

  Hi I have manualy created a dataset and datatable and created 2 colums. My question is How do I bind a control (textbox or control) in the windows form with colum in the datatable(manualy created) Advance thanks Vaish, MyCompanyTextBox.DataBindings.Add("Text", MyDataSet.Tables["MyTable"], "CompanyName"); MyAddressTextBox.DataBindings.Add("Text", MyDataSet.Tables["MyTable"], "CompanyAddress"); ~~Bonnie ...Show All

• SQL Server start from expression

  Hi, Maybe somebody experienced the same thing: It happens more and more that I have to split up my packages into two flows and then execute one flow dependent on a variable's value. Like for example if a boolean variable is true -> do one side of the package otherwise follow the other flow Untill now I started from an empty script task and then achieved my goal via constraints but as I want to cut out all the quick and dirty parts of my packages... So, should I create a custom component greets, Tom Thanks, clever idea I'll give it a try allthough this is not really the way I like it, in my opinion there should be a "switch component" or a "case component" greets -Tom ...Show All

• Visual Basic database report

  hello, i'm using ADODB on my vb8-access. before on vb6 i use data report designer to prepare a print, but here on vb8, how can i do that, without using crystal reports i would like to design my report just like report designer, is it possible or are there any turn around for this thanks Hi, have you considered using ReportViewer control (more info here and here ) There's also a bunch of similar 3rd party solutions available... Andrej ...Show All

• Visual Studio Express Editions Help making Express work with MS DDK

  Hello, I'm just starting to learn C/C++ programming and used Brian Johnson's article,  Using Visual C++ 2005 Express with MS Platform SDK , to add windows application capabilities to Express. I would like to do something similar to Express so that I can write drivers as well on my Win2k system. I've installed the MS DDK but need the additional steps to get my C code to see things like ntddk.h. I thought of doing something similar to what Johnson wrote up on SDK but the DDK stuff has ntddk.h in three paths and the path needed depends on whether your in Win2K, Win2003 or WinXP. Now I can add the required additional path to Express but where does it get placed in Express In executable files, in include files, in libra ...Show All

• SQL Server Can not Subscribe a Report

  Hi, I just create a report using Whidbey and deploy it to the Project reportserver. And I can access that report correctly, but I can not subscribe that report, what's going on Additional, I create that report using Shared Data Source (connected to Analysis Service of my TFS DT) which I created in Whidbey. The exception info is below: The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. (rsInvalidDataSourceCredentialSetting) Thanks. The report is set up for Integrated Security. This doesn't work with subscriptions as you are not around to authenticate to the Analysis Server. You would need to ...Show All

• SQL Server How do I find the server name?

  I need to deploy a multi-user application to several different customers. My app was built on VB.net and uses SQL Server Express. For remote client to connect to the server I understand that I need to use a connection string something like this: “Server=ServerName;Database=myDB;Trusted_Connection=True;” My question is, how will I know what the server name is Can that be different for different customers When I test this on my PC, I use (Server=.\SQLEXPRESS;), but what do I use for deployment Thanks. Thank you for your reply. I have written below what I am thinking as to how I may go about it. Please review and let me know if you have suggestions or comments. On the install CD, there will be ...Show All

• Visual Studio A Java programmer needs help with right tools for Mobile development

  I am new to .Net as I have been programming in Java for a long time now. However, there is a need to develop a Windows Mobile app for the Windows Mobile 5.0 platform and I need help in determining what I need. Background on project: - Java based server accessible via SOAP Web Services - Supporting Windows Mobile 5.0 - Need a DB on device to store data - DB doesn't need to be synced with server db (aka no Active Sync needed) - I am planning on using NHibernate as I have experience with Hibernate - I am planning on using the Java to C# converted provided by MS to convert all necessary files to get a head start Specifically: - Which Visual Studio version do I need: standard or professional - Besides .Net Compact ...Show All