Andrew174's Q&A profile

• SQL Server Creating a row guid in SQL Express

  I am an asp developer who is finally serious about learning .net. I have downloaded SQL Express and am working through the ADO Step by Step book. I can easily create a table and set all the columns. What I cannot do is create a row guid. The option for this is grayed out in the column properties window and when I try to set a field in the "Row Guid Column" in the right side properties window I get an error mesage stating the field must ...Show All

• Smart Device Development Native Exception Error - 0xc0000005

  I am running the following code - which takes the data from an XML file and updates a SQL Mobile table - it seems to consistenly throw a native exception error (ExceptionCode: 0xc0000005) Here is the code: #region DataRefreshFromXML public void RefreshDataFromXML() { if ( File .Exists(appPath + @"\data\HandheldInventory.xml" )) try { DataSet ds = new DataSet (); ds.ReadXml(appPath + @" ...Show All

• .NET Development Multithreading on database server side

  Hi, should I take a care of threading synchronization when accessing the database I mean, what happens if one thread executes SELECT and the other one DROP at the same time What about transactions If I have transaction, some DROP and DELETEs within it, isn't it possible that both fails if executed parallely Thanks. The database is designed to handle all this for you. Think about it. There is no difference in h ...Show All

• Visual Studio Team System Cannot access Documents in Team Explorer when not logged on as TFSSETUP

  I have the Beta 3 Refresh of TFS installed. I logged in as TFSSETUP and created a new Team Project (AdventureWorks). In addition, I added my personal id to the admin groups in the Team Foundation Server Security Group and Windows SharePoint Services Role. In the server/reports server, I added BUILTIN\Users to the Properties\Security (this was not enabled by default and thus everyone other than server administrators received security errors for t ...Show All

• SQL Server How to unsecure my database!

  This is the opposite of the question most asked on this forum, but it is the one I"m trying to solve. I have a simple home network with a desktop and laptop connected via a router on a Microsoft network. I use one application that requires SQL Server Express. I have installed SQLE and the application on both machines and every thing is fine, almost. The problem is that I want to be able to include the MDF and LDF files from my application dat ...Show All

• Software Development for Windows Vista how does the instanceId get set on SqlWorkflowPersistenceService

  Hi, I'm trying to set up multiple servers each hosting workflow runtimes of their own. These servers persist their instances to the same SQL server. I can't get the locking mechanism to throw an ownership exception when a second runtime tries to load an instance from the persistance store. Looking at this, the Persistance service provides an @ownerId parameter to the stored procedures, I assume that this identifies which runtime locked the ...Show All

• Visual Basic thread problem - please help

  I have this winform that calls a messaging window, i managed to make it work invoking the messag window as a background thread, but somrthing weird is happening If I invoke like this, it works fine: Dim aFrmAlertPopUp As New AlertWindow("oi", "test", "123", "A", "dude", "joe", "joe", "A", ListView1, "", "123", "123") aFrm ...Show All

• Software Development for Windows Vista XOML Version (beta 1)

  How do we get XOML content of a Workflow file say "Workflow1" Scenario: i opened a new project (Sequential Console application). then "Workflow1" will automatically added to our project. take a host Application and display the xoml content of that "Workflow1" file. To show the XOML xml use the following steps: Start with a workflow project Right click ...Show All

• Visual Studio Express Editions Creating a Database in Visual C++

  In the SQL browser on Visual C++ the menu is greyed out to create a new database. I cannot seem to find out how to create a data base. As someone else said, the Express Editions are very limited in this way. I have the VSTS edition, but I'd still create databases by writing SQL in Query Analyser, because then I end up with a script I can use to install the DB on the client machine. ...Show All

• Visual Basic Reload my form

  I made project using VB.Net 2005 with multi languages, the first form is MDIParent form with MainMenu and toolbars also there is some changes in properties as righttoleft and text of forms. In my Mainmenu (Menustrip) there is opetion to change the UI Culture and I have already done but I need to change all texts in the form as mainmenu items anf form properties. My quetion is: how can I reload my form again to read the ...Show All

• SQL Server GPL RegEx Source Component

  While working on a recent project, I needed to import a number of old mainframe generated text reports. Since they didn't work on the one-record/one-row construct, the Flat File Source won't work. So, I created a custom component that allows you to specify a Regular Expression pattern, and it will parse a text file and return columns. Each capture in the RegEx pattern is returned as a column, and you can also specify column names in the regex ...Show All

• .NET Development Connection pool size issue

  Hi, I have a question about ADO.Net's way of handling connections. My server app uses ADO.Net to connect to SQL Server to server clients' calls. Some times I get error message that says that I may run out of connections in the pool and I should consider exband the size of the connection pool (not the exact words). I am a little confused by this error because, to my knowlege, the connection pooling is by defualt set to a certain size. If all t ...Show All

• Windows Forms How to deploy and update ClickOnce applications using MSI?

  I am creating a product that will be installed using MSI on the customer's server and want to use ClickOnce so that they can easily deploy the Thin Clients of the system.  I have yet to find a tutorial or writeup on how to deploy and update ClickOnce applications using MSI.  Does anyone know of a good one Thanks, Adam. Hi, David your post did help us through the server install issues. I posted a ...Show All

• Visual Studio VS 2005 Final - Installation problems - LoadSetupObjectGuid() : vs_setup.dll

  Hi, Can't install VS2005, released version on my WinXP Prof (Swedish), laptop. Started with a clean ghosted mashine yesterday with no beta or any other old stuff. Installad XP_SP2, WindowsInstaller 3.1. Run the installation (VS/setup.exe), 65 files are copied to the temp folder, the installation wizard starts and "Setup is loading installation components" and the progress bar stops after approx 40% I check the temp folder and in the dd_vserror80 ...Show All

• Visual Studio Express Editions Please Help!! Can't download due to BITS error!!

  I have read the faq on my error message: "Background Intelligent Transfer Service (BITS) Disabled" and I have set the BITS service to Manual - (it already was) and the only dependency it has is RPC and that is set to 'automatic' (it is disabled so I can't change it to 'Manual').   I tried to "start" BITS and I ran the BITS admin repair tool but still get the same error when I begin to download. Please help friends - I can't ev ...Show All