AcidRainLiTE's Q&A profile

• SQL Server timeout errors, and General Network Error messages

  Hi We have a VB6 app, with SQL2005 database, SQLOLEDB driver We have it installed at many clients and normally works fine. We've migrated one client from SQL2000 to SQL2005 and had to move the database to a new machine. It's now running SQLExpress sp1, on a Win XP sp2 machine The clients now frequently get either a) SQL timeouts or b) Runtime Error’2147467259 (80004005) [DBNETLIB][Connection Read(recv()).]General network error. Check your network document Errors I suspect it is something to do with connections not be released (even though we explicitely free them in the app). Where do I look Thanks Bruce Which version of Windows are you using Keep in mind that WIndows XP P ...Show All

• SQL Server Totally Lost in 2005 vs 2000 Enterprise

  I relied so heavily in the DTS package Design windows that used to make it so easy to import, copy a table from one db to another, and so on. All I had to do if I wanted to copy a table from one DB to another was drag 2 db icons over (in a new package window), assign each to the correct DB, drag that little connector thingy over, double click on the line and then use the "Design Query" thing to automatically have SQL build the code necessary to make it work. OMG I AM LOST now., Does SQL 2005 have anything like this or is it all hand coding stuff Where is my cool tools Another thing I have noticed and still cant find the answer for is adding a user to a DB. In 2000 I was able to create a user and assign them to a db and twea ...Show All

• SQL Server Microsoft report builder is a very BAD product

  This product can't make a report selectin measures from more then on cube at the same time crossed by to shared dimensions, it's a shame. Please don't say you have a web base ad-hoc query if you can’t even do same basic stuff like this. So may be you would use a view with UNION strategy or a (select subquery) as Column strategy instead I am sure you can do it. No matter what. I did lot of these apparently impossible to merge things, there is always a way around, it just take more from the developer. Philippe ...Show All

• Visual C# How can i convert a 4 bytes hex to decimal?

  I have a hex number, for example "C2D3". How can i convert the 4 bytes hex to decimal I try to use byte.parse(), but the compiler show "C2D3" is too big. I also want to try BitConverter.ToInt16(), but i feel it's not convinent. Do you guys have any good function on converting the "C2D3" to decimal Thanks! qiyushen wrote: If i have a sign indicator at the 1st bit in the Hex number, what can i do For example, "8001" -> -1, "0001"->1 Thanks! Btw. FFFF == -1 not 8001. But yeah use the Int16 parse with base 16. ...Show All

• Visual C++ c++ pointers & opengl

  Hi there, this is really strange for me, i'm making a snake game using c & openGl, i use function called LengthenSnake to increase it's length, it uses pointers (linked list) when i call this function in the main before glut taking control of the program for (int i=0;i=any number;i++) lengthensnake(); it works and now problem and i can see the snake is longer, but after the glut starts, and i call this function through MyDisplay, the programm hanging, i know working with pointers is not fun, but what's wrong here, it works somewhere, and somewhere not Can any one help Thanks in advance Can any one help With the description you provided so far, definitelly not. It's like saying "I have a car. ...Show All

• Visual Studio 2008 (Pre-release) How to position tooltip?

  I have tow controls(buttons), I want to show both button A and button B's tooltip on Button B's center and right side. I set button A's PlacementTarget as button B, and use custom placement callback to set the position, but no change was got. How can I achieve that Unfortunately Bindings to ElementName sources from inside Tooltips and ContextMenus don't work. The resolution of the name occurs in the Logical tree and these controls do not live in the main logical tree. What you can do is set the ToolTipService.PlacementTarget attached property on ButtonA because the binding is evaluated in the correct logical tree: <Button Margin="44,59,135,0" x:Name="ButtonA" VerticalAli ...Show All

• SQL Server Error Handling in SQL Server 2000 - Need Help

  Hi Everyone: I have a stored procedure with the following structure and I would like to find out how to catch my error from each block, and raise them if transaction is rolled back in the end. As you can see, I am on SQL Server 2000, so no TRY CATCH functionality is supported, please let me know, specificaly I am looking for the code that would catch the raiserror msgs from each block, and return in the block all the way in the end, where it says if @@error condition. Thanks and here is the code: CREATE PROCEDURE [dbo].[uspSaveLoanApplicationMain] @Bor_BorrowerGuid uniqueidentifier , @Bor_FirstName varchar (15), @Bor_LastName varchar (35), --and so forth AS SET NOCOUNT OFF BEGIN BEGIN TRANSAC ...Show All

• SQL Server Import and Export Data Wizard missing in SQL Server 2005 Express Edition

  After some weeks evaluating tools and platforms for developing an application, I decided to move to SQL Server 2005 Express Edition. Everything was fine till last night, when after creating my tables, I needed to populate them. I tried to find the Import and Export Data Wizard that SQL Server 7.0 and 2000 used to have, but great was my surprise when I found -  in this forum - a post that said that it's not available in the Express Edition. I'll have to move back in time (what I hate) to remember the way BCP worked. Can somebody post some examples to not start from zero   Does anybody know a third party visual tool that can import/export data from text files to a SQL Server DB via ODBC What's the reason it wa ...Show All

• Smart Device Development UPnP Programming

  Thanks Alex !!! I don't think it's a UPnP_E_INVALID_ACTION because I've included a switch in the code and the error message caught correspond to a non specified error (OTHER PROBLEM). switch (hr){ case UPNP_E_ACTION_REQUEST_FAILED : MessageBox(NULL, "UPNP_E_ACTION_REQUEST_FAILED", "M E S S A G E", MB_OK); break ; case UPNP_E_DEVICE_ERROR : MessageBox(NULL, "UPNP_E_DEVICE_ERROR", "M E S S A G E", MB_OK); break ; case UPNP_E_DEVICE_TIMEOUT : MessageBox(NULL, "UPNP_E_DEVICE_TIMEOUT", "M E S S A G E", MB_OK); break ; case UPNP_E_ERROR_PROCESSING_RESPONSE : MessageBox(NULL, "UPNP_E_ERROR_PROCESSING_RESPONSE", "M E S S A G E", MB_OK); br ...Show All

• Audio and Video Development Preventing a focus sound from playing on start

  Any ideas on a slick way to prevent the focus sound from playing on start when you have a button that starts with the focus I'm managing focus sound like so: <g id="ButtonFocus"> <set style:backgroundFrame="1" /> <event name="PlayFocusSound" /> </g> function playFocusSound() { Player.audio.effect.play('file:///dvddisc/ADV_OBJ/main.aca/focus.wav', 1, function focusSoundCallback(status){}); } Several ways... Make your event handler ignore the first event after every markup page load Put the cue that calls ButtonFocus inside a parent container that has a begin of (eg) 1s so that it won't fire immediately Create an alternate ButtonFocusNoSound animation, and use a ...Show All

• Visual Studio Team System How to copy changed files only

  I work on a very large public website. Before Team Foundation server, we had a build process in place that would run a build and then copy changed files, remove deleted files, etc out to the QA server. I dont see anyway to do this with Team Build. Whenever Team Build gets the source for a build from Team Source Control, the file Date/Time is the date that the file was retrieved from source control. So If I deploy(copy) the site to QA, every file is replaced on the QA server. This is bad but not as bad as the problem I run into when I have to replace files on Production. We are talking about a huge public site here. I cant just replace every single file. I only need to move files over that have been modified. Is there anyway to have team ...Show All

• Visual Studio Tools for Office VSTO Outlook Add-In not loading outside of VS2005

  I created a Add-In project using the Add-In for Outlook 2003 project template. I started with some simple code to test functionality and then continued to create the add-in I wanted. During development I always tested using the debug in VS2005. I never had a problem with it appearing this way. However, now that I am trying to deploy the Add-In, I am unable to get the Setup project to work. Even on my own machine, once the setup project is installed, the add-in does not load. I created a simple MessageBox.Show("hello") add-in to see if I had introduced the issue. However, this add-in behaved the same. I could always run it in VS2005; however, when installed from the setup project, the add-in would never load. Another str ...Show All

• Visual C# string.Contains values from a Hashtable?

  Morning all, I have the following code: ========== Hashtable strAllowedExtensions = new Hashtable(); // more code here private bool SetExtensions() //*** SetExtensions //* Add extensions to the array collection //*** { strAllowedExtensions.Add("DOC", "Microsoft Word"); strAllowedExtensions.Add("PDF", "Adobe PDF"); return true; } // more code here if             (objFileUpload.FileBytes.GetLength(0) > intMaxUploadSize)             {                 objFileUpload = null;              ...Show All

• SQL Server SQL Server 2000 - Issue with having a drop down parameter list

  Hi, I have a drop down parameter. The drop down elements is coming from the database. The Drop down is not a mandatory field. I.e. I may choose to select an item or ignore it. Still I should be able to view the report. I have checked both the ‘Allow null value’ and ‘Allow Blank value’ options. But if I don’t select an item from the drop down I click on the view report button, nothing is happening. After selecting an item, I am able to view the report. Is it not possible to have a drop down list as non mandatory parameter thanks, Vijay Vijay, You need a dynamic query to get what you need. It has been neatly explained in report tutorials walkthroughs.. ...Show All

• SQL Server Installing SQL server 2005 evaluation

  After unzipping the download I have run the splash.hta file. I then chose run the sql native client installation wizard. I then receive the installation package is not supported by this processor type. Contact your product vendor. I am installing this for a class I am taking on a test station. It is a PIII 863 with 512 MB or Ram, running windows 2003 enterprise server SP1. I have looked at the hardware guidelines and it seems this is enough to run it. Any ideas I was able to find a link to the SQL Server 2000 evaluation edition, and may opt to install that if I cannot corrent the other issue. Does anyone have any other ideas ...Show All