AlanKohl's Q&A profile

• SQL Server Back & Restore of Multiple Databases

  Hey all, I was wondering if I could get some help on something thats got me really stuck! At the moment we have in our product some SQL scripts that will backup & restore a database whenever required. We've now added another database (an audit database) so we need to change those scripts to include this database. The backup script seems fairly easy to change as ive added another 'BACKUP DATABASE' line that points to the same file. The problem I am having is that when it comes to restore the 2 databases I get a whole load of errors, most of them complaining that the '.mdf' & 'log' files can't be overritten because they are already in use by the previous database (since I restore the 'data' database first and then the ...Show All

• Visual Studio Express Editions Saving a record in a database in VB Express

  Hello All. I have the same problem as Engr.Faisal. The save button doesn't save modified records or new records in the database I've created using the tutorial. I've also downloaded the video and followed the instructions step by step, with no success. Can anybody help us please. I'm trying to re-design a program I designed using VB6, which requires the user to enter some personal details when running the program for the first time. The details also need to be modified from time to time, and the only way I could make sure the details were stored was to use a single record in a data base. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. D3DERR_NOTAVAILABLE while build of first example in help how to do

  I used to code in pascal, cobol, assembly, basic, etc, but not C. From: Your First Game: Microsoft XNA Game Studio Express in 2D following along and doing the first build, I get the error above. I did not think I was calling the 3d engine only the 2d. I cannot find any help on the error, where to look, etc, except what is in the error window when you cursor over it. I cannot figure out how to copy the error in that popup window to look at it further. I know some dislike nubies, but please help if you know the answer. Its disheartening to type in only 6 lines of code and not be able to debug it! To say the least. Thanks OH OH OH, I figured out how to copy the error: Error 1 Building content threw InvalidOperationExcept ...Show All

• .NET Development What is the Best Way to Architect an intensive online Data Access Application ??

  Hi I want to ask some general but I think which are important questions * - While developing an application which uses an online database heavily 1-How ADO.NET Can help achieving the best performance to make the application more responsive 2- How the efficient separation between Data layer and Application (GUI) Layer can be designed and implemented thanks for any reply Mohamed ...Show All

• SQL Server precision in MSAS 2000

  MSAS 2000 seems to lose precision of decimal numbers after 15 digits. According to MS documentation with MSAS 2005 there is a setting DeepCompressValue which allows turning off precision by turning off compression. Is there any way to do the same thing with MSAS 2000 Thanks for your help. ...Show All

• Smart Device Development WM 5 & Vista & Emulator Sync-over-DMA

  Hey gang. I am using VS 2005, Windows Mobile 5 SDK and I've tried the VS 2005 Device Emulator and the Device Emulator 2 BETA CTP that is available. I can't seem to get anything to "Cradle" with Windows Mobile Device Center. Can the current software Cradle properly on Vista If so what do I require I have also tried the following. I downloaded the VPC Network driver, and it doesn't work either. When I launch the emulator I receive the following error: "Failed to open VPC Network Driver". I'm really having a difficult time to debug internet enabled applications at this point in time because of this issue. Barry Bond said to ask for an ETA for DeviceEmulator V2's ship date He mentions the V2 that ships wi ...Show All

• SQL Server DtsPipelineComponent attribute issue

  namespace Dest { DtsPipelineComponent ( DisplayName = <<To read from Resource >> Description = "Loads data into database.", UITypeName = "Destination, PublicKeyToken=f14f4088843f32dd", ComponentType = ComponentType.DestinationAdapter, CurrentVersion = 1, IconResource = "destination.ico", LocalizationType = typeof(DestinationDisplayNameResources) ) public class Destination : PipelineComponent, { ... } } I have this code for a custom destination Component. I have issue in setting the DtsPipelineComponent attribute's DisplayName property to show me the name of component according to the local culture. Other than constant string I am not able to set the DisplayName. How wo ...Show All

• Software Development for Windows Vista .NET COM+ - "Error when enlisting in a distributed transaction"

  Hi, I developed a .NET serviced component with Framework .NET 1.1, instaled it in a win2k SP4 server (COM+ 1.0) and marked that component with Transactions=Required. This application server communicates with a SQL Server 2000 SP3 database server inside the same subnet/domain. When a simple select query is run under the .NET Serviced component, i got the message: "Error when enlisting in a distributed transaction" The COM+ package that hosts this component has an ActivationOption=Library and has the options "Enforce Access Checks for this Application" and "Enable Authentication" marked as false. The component is created from a ASP.NET webform using ASPNET user credentials ... this user is a member o ...Show All

• Visual Studio 2008 (Pre-release) Changing ComboBoxItem Properties from a DataTemplate Hosted in the ComboBoxItem Container

  I'm trying to change the ComboBoxItem's IsEnabled property from a DataTemplate and I can't figure out how to do it. How can I change the property of a ComboBoxItem container from the DataTemplate that's hosted in the ComboBoxItem container Is it even possible Kevin ignore the previous post, you dont need to change the template add this style and it should work < Style TargetType = " ComboBoxItem " > < Style.Triggers > < DataTrigger Binding = " {Binding IsActive} " Value = " False " > < Setter Property = " IsEnabled " Value = " False " ></ Setter > </ DataTrigger > </ Style.Triggers ...Show All

• Visual Basic "ENTER" key pressed in textbox?

  I am just learning Visual Basic 2005 and in the process of making my first super simple game but I am stuck with this problem, I have one textbox and one label. When the user hits the "ENTER" key I want it to check if the text in textbox matches the text in the label. As of now I have a button that does it but I want to get rid of it. Thanks for help with this simple issue:) Thanks for quick response and simple solution but I get an error with that code. 'KeyCode' is not a member of 'System.EventArgs' Thanks Again ...Show All

• SQL Server SqlTransactions in a Multi-Threaded Environment

  I am currently working on a project in which I am using SqlTransaction objects with their IsolationLevel set to Serializable. I am wondering what would be the effect if multiple threads were to call this code at the same time Would the second transaction (created by the second thread on the same connection), for example, be queued until the first one (created by the first thread on the same connection) finishes Or would an exception be thrown for the second transaction In case an exception is thrown, would using the synchronization (locks) around critical sections solve the issue I guess it is easier to understand the scope of transactions in terms of multiple users, but it is confusing (for me) when I start thinking in terms of multip ...Show All

• Windows Forms IExtenderProvider doesn't work for ToolStripMenuItem

  Hello All! I want to add some properties for ToolStripMenuItem (VS2005 - WinForms): [ProvideProperty ("TestID",typeof(Control)),ToolboxItemFilter("System.Windows.Forms")] [ProvideProperty("TestDesc", typeof(Control))] public class Test : System.ComponentModel.Component, IExtenderProvider { ...... public virtual bool CanExtend(object target) { return (target is Control); } ..... } it works almost for all controls but not for ToolStripMenuItem. I cannot make it work, although CanExted return true for it.I have tried to use Component, Control and ToolStripMenuItem in property "ProvideProperty" attribute and in CanExtend, but without the result. Can someone help me I cannot find solution ...Show All

• SQL Server Filtering by date on a chart

  Hi all, I have a datasource with three columns. NAME / DATE / COST The dates run from January 2005 to March 2007. They appear in the following format in the query window: 03/01/2005 00:00:00 All I want to do is put the dataset in to a graph and filter the date so it only shows any cost from January 2006 onwards. What ever date I type in the filter I get the following error "Cannot compare date of types System.Datetime and System.String" Anyone know what I am doing wrong or how to solve the problem Cheers, Rob. It's complaining that you're comparing a date to a string, so conver the string to date. For your expression, try =CDate("1/1/2006"). ...Show All

• Visual C++ Pointer dereferencing causes crash, only in Release mode, x86 Assembly related

  Hi. My application reads a file and suddenly it crashes when executing an x86 assembly command. The assembly command dereferenced a word pointer and suddenly crashed. The error message from Windows is : The instruction at "0x00421121" referenced memory at "0x041db000". The memory could not be "read". The instruction is a simple one : movd mm3, [esi] where mm3 is used to hold temporary values and esi is the offset of a DWORD within the file. If the application is build using Debug profile, it does not crash. Only when built with Release profile with optimizations does it crash. My guess is that the value of [esi] is 0xFF and when in Debug mode, this value is automatically replaced with 0x00 while in Release mo ...Show All

• Smart Device Development Programming for motorola Q phone

  Hi All. I cannot find a template in VS.net 2005 for mobile 5 smartphones. Can someone point me in the right direction for developing for a motorola Q phone thnaks You'd need to install Windows Mobile 5.0 For SmartPhone SDK. Download it from Microsoft’s web site. ...Show All