Nectuss's Q&A profile

• SQL Server SQL 2000 Trial Edition Upgrade Path

  Hi, Our CRM application (Sage/Accpac CRM MME) only supports SQL Server 2000. I installed a trial version of SQL Server 2000 and the trial has now expired.  We have since purchased SQL Server 2005 Standard Licences. The 2005 edition lists the upgrade path as: 2000 trial -> 2005 trial -> 2005 Standard Is there an upgrade path from 2000 Trial to 2000 Standard and what process do I use to achieve it Thanks in advance for any help or information. John Thanks Jens. I searched for hours for that confirmation. You've saved me a lot of time and money! Thanks again. ...Show All

• SQL Server Can you setup backup/restore functionality in SQL Express 2005 from a C# app?

  Hi, I'm currently working on a project which uses a SQL Express 2005 database. I want to be able to setup SQL Express from my C# program so that it can perform backups to a specified path location at the requested interval itself. This would free up my program from having to manage the backups. Just wanted to know if this is possible Also, when the current database becomes corrupt will SQL Express perform the restore for the user automatically, instead of them having to manually request a restore I realize that it might not be able to handle the restores in the same way as backups, but I figured I'd at least ask. Thanks, ...Show All

• SQL Server Failure to create first Replicated Database (SQL Mobile/SQL Server 2005) / Err 28627

  Hi, I'm trying to get my first replication going, and I have set up a database successfully, along with merge replication, however when I attempt to create the first subscriber, I get a permissions issue, regardless of what I do. In the SQLCESA30.LOG file, I get the following entries: 2006/01/07 16:59:36 Hr=00000000 SQLCESA30.DLL loaded 0 2006/01/07 16:59:58 Hr=80004005 ERR:OpenDB failed getting pub version 28627 I posted the initial thread under the "Replication" forum, but am including this 'pointer' post here due to a lack of replies there, and the relevance of this thread to this forum. Please see http://forums.microsoft.com/MSD ...Show All

• SQL Server SQLInfoMessageEventHandler and PRINT statement in SQL Express

  I have a stored procedure contains a few PRINT statement that return the status to the client.  On the client side, I am using vb.net to add handler for it, as follow: '-------------------------------------------------------------------------------- con = New SqlConnection("Data Source=.\SQLEXPRESS;Initial Catalog=IntranetMaster;Integrated Security=True;Persist Security Info=False;Connect Timeout=0") AddHandler con.InfoMessage, New SqlInfoMessageEventHandler(AddressOf ShowSQLMessage) Sub ShowSQLMessage(ByVal o As Object, ByVal e As SqlInfoMessageEventArgs)   Dim err As SqlError   For Each err In e.Errors &n ...Show All

• SQL Server Stupid Replication Q

  Hi, Here's the brief. I have DB_A on Server A, which I'm replicating to Server B. I then want to replicate tables from DB_A on Server B, out to DB_X on Server_B, but when I try and create the publication, the row is locked from selection, as it's obviously locked for replication from Server_A to Server_B. Does anyone know if there is anyway round this I ideally want Transactional Replication as our need is to have an identical copy for other calculations to be done and reporting purposes. (Server_A is on it's last legs, so we have Server_B to do all the calculations and host MSRS) Would we just be better off getting a bigger, more powe ...Show All

• Visual Basic Updating a dataset help...

  Allright, well it seems simple enough, but I'm kind of stuck. First of all, I'm using VS 2005. I've run into trouble while trying to use the save on the navigator tool bar that automaticaly appears when you drop a table onto a form. After I delete a row from my table, I want to save the data; thus, I click the save button on the navigator toolbar. Here is the code that is automatically generated when the toolbar is created to handle the save button click event: Private Sub TblTeamInfoBindingNavigatorSaveItem_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TblTeamInfoBindingNavigatorSaveItem.Click ...Show All

• Smart Device Development CameraCaptureDialog Issues

  I've been having some issues using the CameraCaptureDialog class on an HTC Apache device (rebranded as the UTstarcom 6700): 1. After exiting my application, the device's camera capture screen comes into focus. This happens whether I dispose of the class instance or not, and the Close() method is protected, so I can't call that. Any ideas on getting rid of this lingering capture screen 2. On a seemingly random, intermittent basis, an InvalidOperationException will be thrown from within the ShowDialog() method. Sometimes this will happen after taking 4 or 5 photos, but other times it will work fine for 40 or 50 photos before I give up trying ...Show All

• Smart Device Development Web Services - C++ - VS 2005

  When I add a Web Service in C# - no problem. When I use C++ in VS 2005 I get: _CE_ACTIVEX was not defined because this Windows CE SDK does not have DCOM. _CE_ACTIVEX could be caused to be defined by defining _CE_ALLOW_SINGLE_THREADED_OBJECTS_IN_MTA, but it is recommended that this be done only for single-threaded apps. _ATL_NO_HOSTING was defined because _CE_ACTIVEX was not defined. So I define _CE_ALLOW_SINGLE_THREADED_OBJECTS_IN_MTA My question is - what is different about C# that I don't get the error. If I create and call the Web Service from a thread I create would this be good thing Try this. ::CoInitialize(NULL); ...Show All

• Visual C++ Avoiding compiler complains about redefine variables???

  Hi all: When I am writing C++ program, I need some global variables and structs to be visible from many files. But the compiler always complains that variable is already defined somewhere else. The problem seems to be caused by not #include file properly, but is there a good solution to avoid this irritating problem happen please Here is an example error message: Topology error LNK2005: "int COLUMN" ( COLUMN@@3HA ) already defined in ParticleSystem.obj Topology error LNK2005: "float UNIT" ( UNIT@@3MA ) already defined in ParticleSystem.obj Topology fatal error LNK1169: one or more multiply defined symbols ...Show All

• Visual Studio Team System Windows SharePoint Services Service Pack 2?

  Is it ok to use the just released service pack 2 for SharePoint with TFS beta 3 -dave Hi, Just an update. I have installed TFS Beta 3 on Windows Server 2003 R2 running Windows Sharepoint Services v2 SP2. Everything is working fine. Regards, Vikram ...Show All

• .NET Development Migration from 1.1 to 2.0b2 - Could not load type 'SingleTagSectionHandler' from assembly 'System.Configuration'

  Hi All, I'm migrating a perfectly working app from .Net 1.1 to .Net 2.0 b2 and I'm having very hard time to understand why I'm getting the following exception: "An error occurred creating the configuration section handler for ColumnMappings: Could not load type 'SingleTagSectionHandler' from assembly 'System.Configuration, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'. (C:\Documents and Settings\...\MyApp.EXE.config line 5)" line of code where the exception occurs: IDictionary mappingTable = ( IDictionary ) System.Configuration. ConfigurationManager .GetSection( "ColumnMappings" ); section of the .config file: &l ...Show All

• Visual FoxPro Needed help regarding VFP 9 Installation....

  Hi, I've installed the VFP 9.0 in a Win XP(SP 2) environment. Though I've installed I'm still unable to use any of the wizards or the sample files provided. Even i'm unable to invoke the help. When I press F1 the message " out of memory.... swtich to...." appears. When I invoke the wizards, "File corrupted...." sort of message appears. Can anyone help me out. Thanks in advance... Markish >. When I press F1 the message " out of memory.... swtich to...." appears Sounds like a bad installation. Try un-installing and starting over ...Show All

• Windows Forms Dbl click btw rows in grid?

  Hi, Some time double click between rows on data grid cause UnHandeled exceptions. Any body experianced this  How could avoid/ignore that Can you catch Application.ThreadException or AppDomain.UnhandledException  ...Show All

• Visual Studio Specifying a generated CS file as to be not-source-controlled

  I'm using integrated source control in a C# project.  I recall a Source-Control related feature in the VS.NET 2003 (or 2002 ) IDE that let you identify a particular file as to be not-source-controlled'.  I used this feature in the past to indicate that a generated CS file was to not be checked in with the project. I had thought a menu option on File->Source Control let you do this, but I cannot find any such menu option. Is it possible in VS.NET 2005 to specify that a particular file is to be not source controlled I'm using a Perforce SCC provider, in case this is a source-code-provider specific feature. Thanks in advance, Ho ...Show All

• Visual Studio How To Establish Environment Variables For Debugging

  Can the visual studio debug environment be configured using command scripts in [cmd] or [bat] files I need to debug projects that require specific environment variables to be established at runtime. These environment variables are not needed during project development. How can specific sets of environment variables be configured for use by the Visual Studio Debugger When working outside of the Visual Studio .NET environment, the appropriate variables are often established using [cmd] or [bat] script files or a console program equivalent before the program executable is launched. Working with $(MACROS) and Environment Vari ...Show All