Frans Vander Meiren's Q&A profile
SQL Server Query Timeout in SSAS
I am using Sql 2005 SSAS. When building the Data Source Views using "Edit Named Query", the data source is pointed to a Sql 7.0 server. When I tried to execute the query, it terminates after 30 seconds with "Query Timeout Expired". Try editing the DataSource object for your SQL 7.0. You should be able to change query timeout. I beleive it is part of the connection string. Edward. -- This posting is provided "AS IS" with no warranties, and confers no rights. ...Show All
Visual Studio Get StrongDataSet reference
Hello... I'm writting an Unbound recipe that will open Custom Wizard pages. This recipe activates only when xsd files (Strong DataSets) in solution explorer are clicked with the IDE context menu. Thats all Ok... But I can't get this StrongDataset reference to get a DataSet reference in the WizardPage Code to cross it's tables. How to do that... Thanks CarlosMag If what you want is to have the schema loaded into a DataSet, you could use a DataSet instance, and call the ReadXmlSchema method providing to it the full path of the item (the .xsd file in the project). HTH, -Victor. ...Show All
Commerce Server CS 2007 Starter Site - stored procedure 'dbo.inv_CheckInventory' doesn't exist
Downloaded CS2007-StarterSite-En.exe and installed successfully. However, when I attempt to add a product to my cart, an unhandled exception occurs: Component Execution failed for component[0x2] hr: 0x80131509 ProgID: Commerce.CheckInventory The stored procedure 'dbo.inv_CheckInventory' doesn't exist. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.InvalidOperationException: Component Execution failed for component[0x2] hr: 0x80131509 ProgID: Commerce.CheckInventory The stored procedure 'dbo.inv_CheckInventory' doesn't exist. Source Error: Line 152: ...Show All
Windows Forms app.application Publish file
Hi, I know this has already been posted, but I need to get it clear in a simple way. The 'app'.application file is created when you publish an application to a web/ftp server, along with other files. The publish.htm page shows a button linking to the 'app'.application file and I can correctly install it, but a friend of mine (and maybe many more people too) get the 'app'.application file contents displayed in his browser. He has the .NET Framework 2.0 installed (installed automatically with VB 2005 Express), and I would like a simple solution to resolve this issue, without reinstalling .NET 2.0 (unless you are sure it resolves it). I also heard that it has to do with MIME types , but I'm not too familiar with this term to unders ...Show All
.NET Development ResolveEntity for File Entities
So the gist of what I want to do is copy an xml file like: < xml version="1.0" encoding="utf-8" > <!DOCTYPE chart[ <!ENTITY XAxis SYSTEM "XAxis.xml"> ]> <chart> <chart_data> <row> <null /> &XAxis; </row> </chart_data> </chart> The copyed file would contain: < xml version="1.0" encoding="utf-8" > <chart> <chart_data> <row> <null /> <number>1</number> </row> </chart_data> </chart> After looking around the web and experimenting this is what I have: XmlValidatingReader reader = new XmlValidatingReader(new XmlTextReader(@"")); XmlTextWrite ...Show All
Windows Search Technologies Uninstalling Windows Desktop Search
When I go to uninstall windows desktop search it pops up a message saying that it found these programs, then lists the programs, and at the bottom says "uninstalling windows desktop search might cause these program to not work properly". How can I uninstall WDS and have it not effect my other programs, and what did WDS do to these programs on my computer so that I have to have WDS installed before they will work properly Why is WDS tampering with my other installed programs This is very disturbing. WDS does not tamper other programs installed on the machine. The dialog box gives user an option to review the programs list which if dependent on WDS may not work. If you are sure that the program l ...Show All
Visual Studio Express Editions Problems with filling a combobox in combination with SQL
Hello everyone m very new with vb , so i hope you all understand me. I have a Datagrid, Tableadapter,Combobox. The connections with sql are all open Table is use with it : Drinks Now i have a combobox that i wanna fill with flavours like, strawberry,kiwi's etc. But when i want to insert data into the Flavour Column it saying it doesnt allows null values, cause i need to fill in the whole table Here s my table DrinkID Brand Flavour Price So i need to fill everything in like Brand and Price, but i only want a list from the Flavour Witch people can select with adding a new Drink. And when i try to create a collection list it doesnt transfer it into the database So i hope your guys understand my situation ...Show All
Software Development for Windows Vista ACT
Hi All, Can ACT 5.0 be installed on VISTA OS ...Need brief understanding on the same. Regards, Ajay kumar Hi Ajaykr, Yes ACT can be installed on Vista, it is recomended that you use version 5.0 which is currently in RC however I have not experienced any show stopping issues with it. You can find more information on and download ACT 5.0 from here: http://connect.microsoft.com/site/sitehome.aspx SiteID=81 , Detailed instructions can be found in the ACT 5.0 product guide which is located here: http://connect.microsoft.com/Downloads/DownloadDetails.aspx SiteID=81&DownloadID=1570 Thanks! Matthew Braun ...Show All
Visual Studio 2008 (Pre-release) There is no Keypress event In WPF textbox, what is the alternative event?
We would like to see an example of importing 3D models from 3rd party animation software's like softimage Maya or 3D max into Expression Interactive. We have seen on web that there are plug-ins have been introduced for Maya and 3dMax that generates XAML for 3d objects. ...Show All
SQL Server Need help to find a professional approach
Hi guys, I'm designing a sql server database for a recruitment site, I have a resumes table that stores pieces of information about every jobseeker, among this information is the employment history which includes(Job title, company name, from, to), of course one jobseeker can have multiple previous jobs. Now, I want to know how this structure would be applied this structure suggests a field within the resume table that is by itself is a table! So, any ideas how can I design this database traditionally and basic to database design is to first identify the entities. The entities becomes a database table. In your case you may identify several entities like the applicant which is the ...Show All
Visual C++ ActiveX in WIN32 and Console
Greetings all, I'm in at an impass and hope someone on the forum can help point me in the correct direction. I am working with a control system that is writen in C/C++ and built on an OSI/Posix core. The main program body is a Console/Server application that expects few or no user events or inputs. We build with VC8 using Gmake ( from the cygwin suite ) and everything works well, the main application runs from console under Server2003 with no problems. We run in to an issue here, we have vendor supplied ActiveX controls that we would like to access from the control system. I dont know how, and neither do any of my vendors or other devlopers. Being a unix devloper for most of my life I assumed that we could instancate the control ...Show All
SQL Server Displaying Data of a Cube over Web
When you use BI Dev Studio or SS Management Studio to process an Analysis Services database or object, there's a nice dialog box that shows very robust status and progress information. Is there any way to capture this information if you are processing something programmatically Specifically interested in both the ability to capture and display this information to a user when processing via a custom application. Also interested in whether or not there's a way to capture this information to a log (or table) for display and analysis after the fact (or if the custom application is running in a batch mode via a schedule). Thanks, Dave Fackler AMO doesn't provide the list of supported columns ...Show All
SQL Server conditional IF
Hello. I have a query whice look like this: select a,b,c,d from table1; Now - when pressing a cell in the first column we are jumping to another report with the value as parameter (called- p_param);. In the other report the query is: select * from table1 where a=::p_param. What I want to do is taht in the first report I'll will check if the second query return any result and if so to leave it as a link. If the second query does't return any result (zero rows) to remove the link so the user won't go to an empty report. So first i need to know how to check in the first report what will be the result of the second query. Can u help me Thanks in advance, Roy. YOu will have to join the cuont results to your or ...Show All
Visual C++ Matrix of managed garbage-collected objects
Hi everyone! How can I put in a double array some gc objects I mean, let's suppose we have some Foo objects (instances of the ref Foo class) and their pointers Foo^: if Foo were not a managed class, I would use the statements: Foo*** fooMatrix = new Foo**[elemNum1]; for(int index=0; i<elemNum1; i++) { fooMatrix[index] = new Foo*[elemNum2];} Instead, what have I to write if I use gc objects Something like Foo^^^ (but it doesn't seem to work) Thanks! What error exactly Beginning of this file is standard for Console application: #include "stdafx.h" using namespace System; ...Show All
Visual Studio Express Editions DataGridView Before Update Event ?
In a DataGridView, is there an event before update we can used to perform some tasks, like updating fields of the current DataGridView or updating other tables that are not link to the current view Tanks for your answer the datagridview only shows the data being bound from the datasource, or directly added to it. That's all. In terms of doing operations before the update event, wherever you are placing the code to update the database, only there would be the chance for you to do your editing on wherever it needs to be done as far as I can understand. Sorry if I misunderstood ...Show All
