Summoner's Q&A profile

• SQL Server Importing Database from Analysis Services 2005 to SQL Server 2005 database

  Hi all, How can I Import a database from Analysis Services database to SQL SERVER using SQL SERVER 2005. forexample the Adventure Works DW database from Analysis Services to SQL SERVER database. Any ideas will be higly appreciated. Thanx Ronaldlee Ejalu wrote: That Link does not help. Once again I need to migrate a database from Analysis Services 2005 to SQL SERVER database.2005. if i'm not mistaken, the as 2005 cube should've been created from a sql server 2005 db. does the original sql server 2005 db no longer exist ...Show All

• Visual Studio warnings when I try to create guidance package

  I get errors and warnings of this kind when I tried to create a Guidance package using the GAT SDK. Message 17 Could not find schema information for the attribute 'ReferenceType'. C:\Documents and Settings\sanjukta_dan\My Documents\Visual Studio 2005\Projects\MyGuidancePackage\MyGuidancePackage\MyGuidancePackage.xml 27 7 MyGuidancePackage Warning 5 The element 'Recipe' in namespace 'http://schemas.microsoft.com/pag/gax-core' has invalid child element 'include' in namespace 'http://www.w3.org/2001/XInclude'. List of possible elements expected: 'DocumentationLinks, Types, Caption' in namespace 'http://schemas.microsoft.com/pag/gax-core'. C:\Documents and Settings\sanjukta_dan\My Documents\Visual Studio 2005\Projects\MyGuidancePackage\M ...Show All

• .NET Development Prevent instantiation of COM-visible interface

  Hi, A COM component can expose an interface to consumers, but at the same time prevent consumers from creating an instance of the interface by not defining a coclass. Is there a way for a .NET component that is COM-visible to expose an interface to a COM component without the interface being creatable by the COM component Thanks, Roy OK, I took your suggestion, and I have a working example (see the C# class and classic ASP script below). COM clients cannot create an instance of CMyList, but they can get an IMyList interface from CMyListMgr. I think I have a handle on why it works. Please let me know if my thinking is correct. The visibility of the interface and class can be different. CMyList implements ...Show All

• SQL Server Using Merge Replication, Parameterized Filters

  Dear ppl, I am using Merge Replication between SQL Server 2005 (Publisher) and Pocket PC (SQL Mobile 2005-Subscriber). I have a Windows Mobile appliction on the Pocket PC that replicates data from the server. I am using SqlCeReplication class on the Pocket PC application to synchronise the data. By default, when i call the Syncrhonise() method, it pulls all the data from the server. What I want is to pass a parameter from the Pocket PC and filter the data based on that paramter. E.g. from the Employee table, I want only those Employee that belongs to a CompanyID that I pass as a parameter. Is there a way to do this, so that i can pass parameters from my PDA application (Windows Mobile), and make the Filters specified in the Pu ...Show All

• Visual Basic Optional Object parameter passing in a function

  Hi, I have this code. I want to use the same procedure with the controls on a form instead of just controls on a groupbox. The catch is i do not want to repeat the procedure. I tried to declare grpbox as optional but it will ask for the default value and I don't know what i can give as default. Any other recommendations to make this function precise would also be welcomed. Thanks Public Sub checkCriteria( ByVal GrpBox As GroupBox) Dim grp As GroupBox = CType (GrpBox, GroupBox) Dim ctrl As Control Dim flag As Boolean flag = False For Each ctrl In grp.Controls If TypeOf ctrl Is TextBox Then Dim sctrl As TextBox = CType (ctrl, TextBox) Try If sctrl.Text <= txtasUMin Or sctrl ...Show All

• Visual Studio Team System Notification Service : Any Success stories

  Hi All, if anybody successfully subscribed for the TFS events like BranchMovedEvent NodeCreatedEvent NodePropertiesChangedEvent NodeRenamedEvent NodesDeletedEvent ProjectCreatedEvent ProjectDeletedEvent the events which i mentioned above won't have the schemas right now..and the same i have created using XSD tool and using TFSReg command i have registered and subscribed the command using Bissubscribe but i am not getting email... please ref my post: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1084653&SiteID=1 if any one have the perfect subscription, please share me the COMPLETE PROCEDURE TO DO THE SAME (from top to bottom) Thanks, Kathir Hi, Thanks Naren. I have created ne ...Show All

• Visual Studio Team System How do I get the state (edit - xavito) of an item programatically?

  Hi, I need to find the state of a specific item programatically. For example I need to know that file 312.cs is checked out by Xavito. Any ideas on how to do it Hello, I don't have access to Visual Studio right now, so it's kind of pseudo code, but should be helpful: First you need to get collection of PendingSets for given item: PendingSet[] VersionControlServer.GetPendingSets(String[] items, RecursionType recursion) PendingSet has properties: OwnerName (what you want) PendingChanges - collection of PendingChange - here you can chceck what changes user pended Hope this helps ...Show All

• .NET Development Returning a VARIANT to C++ web service client?

  I have a .NET web service that returns an object defined as: public class NameValue { public string Name; public object Value; } When a .NET app consumes this service (via Add Web Reference), the client always receives the correct type information for Value. That is, if the web service sends an int, the Value on the client side is typeof(int). If the web service sends a string, then the client object is typeof(string). Exactly what I want. However, when I Add Web Reference in a C++ app, the code that is generated forces Value to a BSTR. So if I pass an integer, it receives "42" instead of 42. It appears that the C++ code is ignoring the xsi:type= info passed along at runtime for the Value from the web servic ...Show All

• Windows Live Developer Forums VE API 4.0

  Since the release of the VE API 4.0 is only a week away. Is there anyway we can get a preview of what new features will be included Thanks in advance, Brandon "Could we not simply have a public collection on local.live.com " Well, yeah...but where's the fun in that (not to mention the fact that only 1 person can create/edit/add t0 the collection.) It would be cool to have a site for people to add their own custom pushpin. I think for privacy reasons we can't get to the location info in the forums... ...Show All

• Visual Studio Express Editions Copy files from FTP to Harddrive

  Hi. I have code which downloads a file from my FTP space onto my hardrive. Can somebody help me to incorporate a loop so it downloads every file in the FTP dir, and puts them in the HD. So it downloads every file in ftp://ftp..../pub/myprogram and puts them in C:/myprogram. This is the code i have for 1 file: Imports System.Collections.Generic Imports Utilities.FTP Public Class Form1 Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'Values to use Const localFile As String = "C:\myprogram/blah.exe" Const remoteFile As String = "/pub/myprogram/blah.exe" Const host As String = "ftp://ftp.invision.ecwhost.com" Const username As String = & ...Show All

• SQL Server SQL2005 SP1 Upgrade Failed : The specified driver is invalid

  We are getting a failure when upgrading to SP1 for SQL2005.  We're running Windows 2003 Enterprise Edition SP1.  We're running 4 SQL 2005 instances and 6 SQL 2000 instances on this machine.  One of the four 2005 instances did upgrade successfully - don't know how or why. Looking at other postings, it seems that the 10 lines or so preceding "value 3" in the upgrade log file (under C:\WINDOWS\Hotfix\SQL9\Logs) are helpful in diagnosing the problem. Here are the lines preceding the value 3: <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='0'> Doing Action: Do_sqlPerfmon2 PerfTime Start: Do_sqlPerfmon2 : Mon Jan 08 13:38:23 2007 <Func Name='Do_sqlPerfmon2'> <E ...Show All

• Visual Studio 2008 (Pre-release) General queries about DLinq

  Hi, I have read a bit of documentation about DLinq. I find it a very interesting prospect. However, I have a few doubts regarding DLinq. Here is the first set of doubts (They are not categorized. They are just random). We wish to use DLinq in our project. What are the major risks you forsee with respect to the early adoption of DLinq What are the major steps we should take to minimise the risk because of early adoption Why isnt there a feature to map a property with a different name than the column it is being mapped to Are composite keys supported I have a requirement where two columns should not be direct properties of my business entity and instead should be part of another component which is a propert ...Show All

• Windows Search Technologies Remember Password option

  When logging on to a server from client machine of LAN I used to give login name and password after enabling remember password option I am not prompted of the log name and password. The moment the system is started it is automatically loged on to server. the problem is If I wish to logon with different user name how can I do we are having windows server 2003 on server. any help Hi Shobha, To logon to other user area use log off option. and search for caching option to cach only user name not password.(In user settings, you can do only if you are admin) Hope this helps. Regards ...Show All

• SQL Server Dynamic columns for Flat File destination?

  I have a database app, and we're implementing various data export features using SSIS. Basically, it's a couple of straight extracts of various recordsets/views, etc. to CSV (flat files) from our SQL Server 2005 database, so I'm creating an SSIS package for each of these datasets. So far, so good, but my problem comes here: My requirements call for users to select from a list of available columns the fields that they want to include in their exported file. Then, the package should run, but only output the columns specified by the user. Does anyone have any idea as to the best way to accomplish this To recap, at design time, I know which columns the users will have to choose from, but at run time, they will specify the columns t ...Show All

• .NET Development I need help for xml database

  sir, i am implementing Asp.Net in my project and new to xml database i have web form which contains firstname and lastname and address and etc,... whenever i am submit this page it will store on sql database and also xml database i done sql database storage but i dont know how to add data to xml file. Please help me With Thanks S.Senthil Nathan Hi, Unfortunately, you cannot just open a file and append to it, you have to load the file (You can use XmlDocument.Load(filename), add the row and save it. Or open 2 streams (XmlTextReader and XmlTextWriter) add the record at write stream, and copy the rest from read stream. You may choose to create the xml file on fly from the database whenever it's neede ...Show All