Rick Shaw's Q&A profile

• SQL Server Drop Stored Procedure causing Dropped Tables

  Hey guys, has anyone ever seen this happen: Try to move stored proc from one DB to another using DTS, errors on create proc. Create proc manually. Three tables referenced by that stored proc have been dropped and re-created with the same table structure. I'm not 100% certain that it happened at exactly the same time, but it seems to be around the same time. Any ideas Anyone seen this happen before You will have to check the options you picked for the Transfer task in your DTS package. Did you ask it to move dependent objects also For more help on the DTS package/tasks, please post in the SQL Server Integration Services forum. ...Show All

• Visual C++ find the datatype

  Hi, Is there a function available in VC++ to check if the datatype of an object is string or not. Thanks in anticipation. Warm regards, Hi, U can use typeid operator. This operator returns const type_info& structure. U can use name() method of type_info structure for getting the name of type at run-time. For Example; int a; printf("%s",typeid(a).name()); //This will print int at run-time. In case of run-time polymorphism, We are using base class pointer to instantiate derived class methods. For Example; Base* a = new Derived(); printf("%s", typeid(a)); //this will print Baspr); //this will print Base* printf("%s", typeid(*a)); //this will print Baspr); // ...Show All

• .NET Development DCOM got error "RPC server unavailable"

  Hi, I got the above error on the client when I tried to invoke a COM+ enterprise service on the server. I checked the RPC service is started. I could ping the server with out issues. Any idea hi, this is the code i am using to create the remote object. public static object CreateRemoteObject( string progID, string server) { Type remoteObjectType = Type .GetTypeFromProgID(progID, server); return Activator .CreateInstance(remoteObjectType); } ...Show All

• SQL Server How to get an absolute sum for all values in a certain level in a hierarchy

  I am looking at a cube using excel. I have added two dimensions to row fields and one to the columns (date). Is there any calculation that will return the sum of a specific measure for one of the dimensions regardless of what is selected for the second dimension The dimension in question is a hierarchy and I want to get a sum for a certain level in the hierarchy. I have tried SUM with ANCESTORS but it still only returns the sum as constrained by values selected for the second dimension. Here is what I was trying: CREATE MEMBER CURRENTCUBE.[MEASURES].[Portfolio MV] AS Case When IsEmpty([Measures].[Market Value]) Then 0 When [Portfolio].[Portfolio Name].CurrentMember.Level Is [Portfolio].[Portfolio Nam ...Show All

• Visual Studio Tools for Office Analysis ToolPak Functions Become Disabled

  After installing a custom Add-in built using VSTO2005 (C#), the Analysis ToolPak seems to become disabled. Checking the "Disabled" status of addins under help and in the registry shows that it is actually enabled. However, all of the EONAME functions have now become "Unavailble". Has anyone seen this behavior Scott Hi Scott There's no good reason for this to happen, so I suspect some corruption in your installation of the Analysis TookPak. Are the files physically present They should be in a subfolder of your Office install folder, eg: C:\Program Files\Microsoft Office\OFFICE11\Library\Analysis You should see these 4 files: ANALYS32.XLL FUNCRES.XLA ATPVBAEN.XLA ...Show All

• SQL Server Can't find PInvoke sqlceme30.dll

  I am using an O2 XDA II mini running Windows Mobile 2003 SE. Tried creating a Windows Mobile 5.0 Pocket PC project but during deployment, I get this error. Can't find PInvoke sqlceme30.dll I have searched thru the forums and found something similar. I tried all their recommendations but no luck. Is there anything I am doing wrong I copied the DLL files in the device's \Windows directory (sqlceme30.dll, sql*.dll...around 5 DLLs) I would appreciate any assistance Please install SQL Mobile CAB, do not copy these DLLs to the device manually. Also it's not clear to me why exactly you would use Windows Mobile 5.0 project for Windows Mobile 2003 device instead of using Windows Mobile 2003 project This error is a runtime e ...Show All

• Visual Studio Express Editions Hello, I need some information on how to clear IE explorer history for versions 6 and 7 and Temporary Internet Files

  I am writing a troubleshooting application and I need some information or code snippets on how to delete the urls out of the history folder and temporary internet file folder using Visual Basic version 6 and express edition version. We are currently using Version 6 to write our application. .Net: Dim FilesToDelete () As String = IO . Directory . GetFiles ( Environment . SpecialFolder . History ) For Each s As String In FilesToDelete IO . File . Delete ( s ) Next For VB6 questions please see the following for more help: Useful Links Visual Basic 6.0 on MSDN Library Visual Basic 6.0 Help and Support Visual Basic 6 Support on Windows Vista VB 6 Service Pack 6 Micros ...Show All

• Visual C++ vector memory deallocate

  Hi all, I have a C++ declaration like this typedef struct { int x; vector<int> y; }mytype; vector<mytype> myvar; If I have to free the memory, is it enought to free myvar like myvar.clear() or should I first clear child vector in each vector element, then clear the parent vector Thanks, gojon Thanks for the reply einaros I tried using vector destructor ~vector(). It seems it does the job. What do you think gojon ...Show All

• .NET Development Raiserror and select statement combination having problem with sqlexception

  I have a stored procedure having following code in it create proc tmpproc as begin Select 'test' raiserror('not cought',16,1) end when i call this proc using sqlCommand the exception doesn't get cought in the catch block. I am catching SQLException. If I remove the select statement from the code it works fine. Now i need some work around as i 100s of SPs that have this kind of code and want call these procs using ADO.net If any body can i help me it would be really great for me Regards, Vikas Bindra set nocount on is also not working, the exception is still not caught. Follwoing is the updated script: select @localvariable 'Localvar' raiserror('not caught',16,1). Is there any other ...Show All

• Visual Basic Save data from a listbox to a .CSV file.

  Hi, I am pretty new to Visual Studio, but know enough about SQL. I am working on creating some applications with VB to access my SQL database. I created a listbox that is extracting some data from a table. I am trying to Save that data to a .CSV file, but I am having major issues. I would really appretiate it if someone could help me and explain why my code is not working. I used examples to get to this code, but lack of experience is helping me to get stuck at this point. Thanks!!! Code: Try With sdlgTextFile .AddExtension = True .CheckPathExists = True .CreatePrompt = False .OverwritePrompt = True .ValidateNames = True .ShowHelp = True .DefaultExt = "txt" .FileName = filename .Filter = _ "CSV Fil ...Show All

• Windows Forms Multi threading

  Hi All. I have a question that im hoping to get a little help/advice with. Im writing a forms application (just local - not web or anything) that calls out to a com dll for data processing. The processing may take anywhere from 1 minute to a couple of hours. So of course I would like to be able to display a progress bar - to the user. I tried muti-threading (background worker) the call to the dll - but that doesnt seem to work - either to any dll or at least a com one. So im wondering if anyone can give me some ideas on how to handle this. Can i use multi threading thats a little more sophisticated than the background worker, or can I make the dll - multi threaded (unsure how or even if this is possible). BTW - I am the ...Show All

• Visual Basic Activate new form on button click

  Can anyone pls tell me. how to activate form2 on click of a button of form1 in vb.net 2.0.. Thank you. What seems to be the problem - if you have a form reference simply call the activate method on the reference to activate. Public Class Form1     Private form2ref As Form2 '//Hold the reference to the form     Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click         '//Create New Instance and set reference variable         Dim x As New Form2         form2ref = x         x.Show()    ...Show All

• Connected Services Framework Installation Issue CSF 3.0

  When I install CSF 3.0 I'm always having this error : Product: Microsoft Connected Services Framework 3.0 Developer Edition -- Error 25532.Failed to find node: /configuration/microsoft.connectedServices/componentConfigFiles/add[@key='IdentityManager']/@value in XML file: C:\Program Files\Microsoft CSF\V3.0\Connectors\Identity Manager\Web.config, system error: -2147020584 When I'm looking at the sample web.config and the installed web.cofig, it seems that I'm missing some configuration values. It's strange that the installer missed some configuration. Anyone have an idea Steve Charland Hello Steve, Can you please clean up all the installation and try installing the CSF 3.0 by follow ...Show All

• Visual Basic VB2005 Upgrade, or not?

  Hello, I am not sure if this is the right place to ask this question, but I couldn't find anything more fitting. I am considering getting the Visual Studio 2005 IDE, but I have a reservation. I currently have VS2003, and have heard that the .NET 1.1 framework is falling by the wayside, so to speak. I have used the trial version of VS2005, and like it very much. However, I have heard that VS 9.0 will come out soon, and I don't want to have to upgrade again in a year or two. So, I guess my question is, is VS2005 going to be viable long enough to make it worth the purchase Is Microsoft making the higher level languages like Visual Basic "disposable", in other words, changing every few years Please, don't take me as being an ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. MS - CreateBuffer - Init Limitations

  It seems that D3D10 unnecessarily limits your options for initializing buffers. You can't partially init a buffer, as there is no size for the init data. It must assume that you're filling the entire buffer. Also, placing multiple resources into one buffer is hindered by the fact that there is only a single data source. For example, if I load 5 meshes, odds are I have 5 pointers to data. If I want this in an immutable buffer I either have to make 5 seperate buffers, or string together the buffers first, then pass that off to CreateBuffer. It's trivial to append the data myself before CreateBuffer, but it just seems unnecessarily wasteful to do an alloc and set of copies, just for D3D to copy it yet again. How are other people appr ...Show All