B_Walton's Q&A profile

• Visual C# using vb6 component ?

  Hi, Is there a way to use vb6 components in C#, just like in old asp (Server.CreateObject)... I tried with Activator.CreateInstance but didn't worked...is continue to as kfor the reference... Fom dll, in vb6 yes, from the C# directly yes...... But from the DLL in vb6 through C# I can't....and for security reasons in the client side I can't connect directly to the database...Damm it...=) ...Show All

• SQL Server Better was to handle fixed width flat files?

  Is there a better way to handle fixed width flat files than the built-in SSIS capability I have a fixed width file with over 400 columns and it looks like I need to manually click lines where each column starts/ends (quite tedious and prone to error). I have an excel version of the spec with start position, length, and data type for each column. So far it looks like the only way to automate this task is to somehow automatically generate the package XML from the spec and paste it into the dtsx file. Anyone know of a better way Yes, an adjunct tool(s) would be very useful. In general, I'm very impressed with SSIS (vs DTS). It really puts Microsoft on the map as an ETL provider. Where SSIS falls short thoug ...Show All

• Windows Forms Methods in windows service

  Hi all, Just i've created windows service called "MYserv1" and controlled(like start and stop) it via VB.NET client apps. Now i want to write my own function calls in the windows service. i need to pass the parameters as well as need to get a return value from the function from/to normal windows client application. How to do it Most importantly,how can call those methods from client programs. Kindly advice me in this aspect. Thank U! In the example on codeguru.com (which you have refered), you write some info to C:\Log file. Instead is it possible to store the Qunitity in Service object and refered from a ServiceController Class So effectively an external program gets the value ...Show All

• SQL Server Copying a project. How?

  We recently migrated to SQL2005 and have moved all OLAP databases to the new server. I need to create new OLAP databases. In SQL2000, just a copy would do it, but I am having problem in 2005. I tried to script the database as 'create' or even created an empty one and try to change it by 'alter' from a valid DB, but no luck (XMLA file was modified to have the new names). Any pointers, suggestion would be appreciated. I know how to change the DataSource and DataView later, just need to know how to copy one!!!! Also please let me know what tool is used (Management Studio, Visual Studio, etc...) Thanks in advance! One more follow-up since the other stuff had errors and there was an easier way: I used BIDS, ma ...Show All

• .NET Development Web Service has no dll generated

  I've create a web service in VS 2005 and I already installed the service pack 1.0. When I build my application it does not generate any dll or the assembly. I presume that it should generate the dll unlike in VS 2003 which is the 1.1 version it generate an assembly. I need your help... Thanks in advance. Try installing Visual Studio 2005 Web Application Projects and create a new ASP.NET Web Service Application project. (File -> New -> Project... -> ASP.NET Web Service Application vs File -> New -> Web Site... -> ASP.NET Web Service) Phil Bolduc ...Show All

• SQL Server Building KPI in SSAS

    Hi, I am trying to build a Kpi, based on a table like this: Mounth  | Budget August    | 1234€ October  | 123€ Having Budget as a Measure and Mounth as Dimension. i would like to create a Kpi using Analysis Services where, on Value Expression, i would like to point  the measure  for value of budget in October, and not for the value corresponding to the sum of all budget values. How should i have the expression Thanks. Hello Maia, You can define the value expression for the KPI like this: ([Measures].[Budget - YourFactTable],[Mounth].[Mounth].&[10]) assuming that &[10] is the key of October in your Mounth dimension table. ...Show All

• SQL Server ex.Message in debug mode is much shorter

  Exception ex.Message I am getting in debug mode calling AcquireConnection is much shorter than the logged message in run time because all the errors come to output window in debug. Is there any way to get all these errors description from exception object in debug time to be able to parse it Thanks. Ok, now I see. This is not a SSIS issue, rather a .Net programming issue, in so much as it is actually bad practice to just catch the general Exception type. It is also very common, we all do it! Really you should catch targeted exceptions as they are richer classes that have more information relevant to the exception thrown. If you catch the SqlException type you can get access to the Errors collection, that is a property on the ...Show All

• Software Development for Windows Vista Media Player Audio DSP Plugin error

  I have created the example Audio DSP Plug-in using the Wizard in Visual Studio 2005. The plugin loads correctly and runs on my PC in WMP 9, Windows XP SP2. When I try to install the plugin on other PCs, however, I get the (somewhat obtuse) error: "The plug-in could not be added." Both of the other PCs I have tried it on are running WMP 10, but otherwise same OS version. Is this a WMP version problem If so, could someone point me to some instructions on how to make a WMP 10 compatible audio DSP plugin Is there a doc that explains the difference between v9 and v10 plugins Or is the difference in WMP versions a red herring and really there is a different error Is there a way to figure out the cause of this er ...Show All

• Visual Studio 2008 (Pre-release) MenuItem DataTrigger error trying to change Header

  Hello, I am trying to toggle the header text of a menu item based on bound data, but the following code will not compile due to the error below. Why is it treating MenuItem as a gerneralized ContentPresenter and how can I implement the intended behavior if this is not correct < MenuItem Header = " Signed In " > < MenuItem.Triggers > < DataTrigger Binding = " {Binding XPath=Presence} " Value = " SignedIn " > < Setter Property = " Header " Value = " Sign Out " /> </ DataTrigger > </ MenuItem.Triggers > </ MenuItem > error MC3011: Cannot find the static member 'HeaderProperty' on the type 'ContentPre ...Show All

• .NET Development ProtectionLevel of SSIS

  My SSIS works fine on my machine but other members of my team are not able to execute my packages. Is this because of the ProtectionLevel property Should I change it from the default value i.e. EncryptSensitiveWithUserKeys toEncryptSensitiveWithPassword ad provide a password for my package   The solution to this problem is While importing the package in SQL Server 2005(Integration Services) from File System Set the Protection Level: Encrypt sensitive data with password Give a password to your package and it works fine all other team members. Thanks, Paarul ...Show All

• Visual Basic How transfer the vbscript code to vb.net?

  I found the following Visual Basic Script example about BCD Class using in Vista, but do not know how to transfer to vb.net(2005), can anyone help me //////////////////////////////////////////////////////////// set Locator = CreateObject("WbemScripting.SWbemLocator") set Services = Locator.ConnectServer(".", "root\wmi") Services.Security_.ImpersonationLevel = 3 DefaultOsIdentifier = WScript.Arguments(0) 'These hardcoded values will be replaced with official constants ' whenavailable. const BootMgrId = "{9dea862c-5cdd-4e70-acc1-f32b344d4795}" const DefaultType = &h23000003 ' 'Open up a connection to WMI BcdStore class, allowing for 'impersonation. We need to request that Backup and Restore 'privi ...Show All

• Visual Studio Visual Studio freezes

  I have Visual Studio.NET 2003 Professional. It was working just fine a couple of days back and all of a sudden the IDE has become so slow to start up. The logo comes and freezes for a about 6-7 minutes before it allows me to chose the project to open. After that everything else works just fine. I did a repair and a reinstall but the problem still exists. Please help. Thanks. A third thing is to download VSTweak: http://visualstudiohacks.com/vstweak Then go to the MRU List manager and try to clear it and then retry opening Visual Studio to see if that solved it. ...Show All

• SQL Server Top 10 orders by production

  Hi All, Got a question. In table Production.Product of AdventureWorks database, is there a way I can get a list of top 10 orders dates by product. It is not the lastest 10 orders of all product. I want to get the lastest 10 orders' date by every product. Let's say in that table, we have 5 different product. Then I want to get 50 records back. Is this posible without looping Thanks, George Although I used for my testing the pubs database, you can replace with yours: -- Get the titles from the sales, including an Identity to limite the number of rows that you need -- The fields title_id and stor_id can be replaced with a unique key if exists, otherwise create yours -- The order by is following how you want it ...Show All

• Commerce Server Retrieve ALL products best practices?

  I'm looking for the best way to retrieve all the products in a catalog. Currently, i'm running a CatalogSearch to retrieve all the product Ids and then calling GetProduct for each product Id to get the Product objects. Is there a better way to do this Michael. In that case you should be able to do something like ProductCatalog productCatalog; CategoryConfiguration cc = new CategoryConfiguration (); cc.ChildProducts.SearchOptions = new CatalogSearchOptions (); Category rootCategory = productCatalog.GetRootCategory(cc); ProductCatalogCollection products = rootCategory.ChildProducts; This will return you a ProductCollection ...Show All

• Visual FoxPro Using a dial-up modem to communicate

  Hi All, We are developing a systems functions test program which is periodically checking our file servers, ftp servers, databases, etc. and sending e-mails / messages to our Systems Administrator's cell phone if any of them fails. We see that if our e-mail server is down we can't send out warning e-mails. That's why we have a PC with an internal modem which will operate parallel with our test program and communicate with our Administrator if our email server is also down. 1. I appreciate, if I can get any information, sample code or a link to download an API. 2. Is it possible to play a recorded message after the connection is established, If so how We are using VFP 8.0 on W2K Client/Server. Hopefully everything is clear enough. Thank yo ...Show All