die fledermaus's Q&A profile

• SQL Server Timeout error while executing procedure

  Hi, I have written a stored procedure that i then execute in a loop within a wrapper procedure: WHILE somecondition BEGIN EXEC dbo.PROC1 END If i run the procedure manually i can run it time after time with no error. However if i execute the procedure above i get a timeout error after about 2 or 3 loops. How can i avoid this I have been reading everywhere and i dont seem to be able to find a solution... It is not clear where you are seeing the timeout error. If the procedure indeed takes long then you will have to increase the timeout value on the client side or optimize the SP. The command timeout is typically 30 seconds on the client side for most data access API. Alternat ...Show All

• SQL Server Noobest question

  Hi everyone i know sql well yet i'm the noobest u can find in terms like DataWarehouse... I just installed sql server 2005 got a database with 1 big table in it. i was asked to "Build a data warehouse table based on existing table(s)..." this setence has a sense to it what the hell is a data warehouse table ... i checked lots of sites and docs about data warehouse and feel kinda lost of all the info regarding stuff like "analysis service" "integration tools" "bi studio.." "reporting service" .... where should i start in order to create this "data warehouse table" (no redundancy) i was asked to Your help(+patience...) would be most appreciated - :-) th ...Show All

• Visual Studio Team System saving username?

  I'm trying to use team explorer to connect to CodePlex and I have to re-type my username/password every time I open VS or every time I run tf.exe because my domain account isn't the same as my codeplex account. Any way to get it to at least remember my username This becomes seriously painful when running from the command prompt because every single action requires me to retype both username and password. Any way to 'login' to tf.exe so i can run more than one command without re-authenticating Thanks, Brandon Yeah, CodePlex complicates things. You could create a dummy user on your machine/domain with the same credentials, I suppose. You might also check if the CodePlex folks have any suggestions or s ...Show All

• Software Development for Windows Vista Visual Studio .NET 2003 Professional still can't be installed on Windows Vista

  Since Vista B2, I faced the same problem to install Visual Studio .NET 2003 Professional:   The prerequisites CD fail to install .NET framework 1.1 and J# .Net framework 1.1, so I can’t continue the installation process since prerequisites aren’t guarantees.   I can figure how I can’t install .NET framework 1.1 since Vista come with its own 3.0 .NET framework. But why .NET 2003 install process still want to install an older .Net framework   Moreover, this issue could be bypassed by installing Visual Studio .NET 2003 Professional on XP SP2, then by upgrading XP to Vista. Not so convenient…and it is no long working with Vista RC2 upgrade.   Is their any plan to correct this issue ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Should I Actually USE GameComponent?

  GameComponents look interesting, but why would I bother to use them in my game when I can just write my own cascading Update methods Same thing for DrawableGameComponent, IDrawable, and all that. Is there some future engine functionality I can leverage using these classes / interfaces Because I don't see any actual use for them right now. Thanks! I can see how it could be useful for beginners. Sometimes normal flexibility is too much. I have seen some reaaaaally poorly structured beginner indie program code out there, and this framework could go a long way towards helping beginners get started on the right foot instead of tripping on their way out of the gate. But for professionals who are experienced enough to safely play outs ...Show All

• .NET Development Debugging Problem after install Framework 2.0 From 1.1 with VS2003.

  Hello Friends. I Have One Question Related to Framework 2.0 I work on Visual Studio 2003 and 1.1 Framework. then I install Framework Version 2.0 ( Complete not Beta) I compile my Old Project created on Framework base 1.1 On new Framework new 2.0. Complie Succesfully done. but run time it give Error that " Microsoft Development Enviroment " "Error while trying to run Project " If You have some idea then post. Thanks. Did you install the .NET Framework 2.0 Runtime and SDK http://msdn2.microsoft.com/en-us/netframework/aa731542.aspx Alternatively, Visual Studio 2005 fully integrates .NET Framework 2.0. ...Show All

• Visual Studio 2008 (Pre-release) Proxy generation problems (methods with same name)

  When I create two services which happen to have methods with the same name (not same signature) svcutil incorrectly generates the proxy types. For example if I have two services TestService1.Get(Guid id) returns Thing1 TestService2.Get(Guid id) returns Thing2 The proxy for both TestService1 and TestService2 will contain a get method with the return type of Thing1. What do I need to do so the proxy generation correctly identifies the types to return -k Svcutil command: svcutil.exe /noLogo /l:csharp /config:"TestProxy.config" /d:"C:\Temp" /out:"TestServiceProxy.cs" "http://localhost/ClaimServices/TestService1.svc" "http:// ...Show All

• SQL Server question on tasks

  hi, if a package fails on error, would i be able to know code wise which particular task failed also, if the task is using a connection manager, how will i be able to access that particular connection object Ranier wrote: if a task fails, i want to be able to do this PROGRAMMATICALLY on error event: 1. know which task failed and get the connection object used by the task, if any. 2. so that i will try to establish connection to the connection object and 3. reexecute the task if #2 is successful. please let me know how to do this. thanks. do you really want to do this why don't you just execute the package within a transaction and then re-execute it if the package fails ...Show All

• Visual Studio Express Editions problem making a file builtin in a program

  I'm trying to make a file builtin in my application so i can write it to file when required but i'm encountering some problems. i've made an header file containing a char array containing the file this is a snippet of the code: static unsigned int size_prx = 99118; static unsigned char prx[] = { 0x7f, 0x45, 0x4c, 0x46, 0x01, 0x01, 0x01, 0x00, 0x00, 0x00, 0x00, 0x00, 0x00, 0x00, 0x00, 0x00, [...] 0x00, 0x2e, 0x73, 0x68, 0x73, 0x74, 0x72, 0x74, 0x61, 0x62, 0x00, 0x00, 0x00, 0x00, }; this header file has a size of more than 500KB and i've included it in the main form header file. But when i start the build process i get some warning (not correlated) and then nothing it stays compiling for hours and it ...Show All

• Windows Forms drop down combobox via code

  hi i need to open a combobox via code. how do i/ Private Sub myDGV_KeyDown( ByVal sender As Object , ByVal e As System.Windows.Forms.KeyEventArgs) Handles myDGV.KeyDown If e.KeyCode = Keys.Enter Then If ( Me .myDGV.CurrentCell.OwningColumn.CellType.ToString = "System.Windows.Forms.DataGridViewComboBoxCell" ) Then 'ctype(me.myDGV.CurrentCell,DataGridViewComboBoxCell) 'code to open the combobox and display the values End If End If End Sub Private Sub myDGV_KeyDown( ByVal sender As Object , ByVal e As System.Windows.Forms.KeyEventArgs) Handles myDGV.KeyDown If e.KeyCode = Keys.Enter Then If ( Me .myDGV.CurrentCell.OwningColumn.CellType.ToStrin ...Show All

• SQL Server INSERT INTO Another table containing an automatically generate primary key won't work

  I am trying to insert record from one table to the other. The target table is empty. I want the primary key value to be generated automatically when the records are inserted. The primary key is a bigint = 0 increment by 1 Here is the transact code: BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON ; DECLARE @CodeOrganismeMEQ nvarchar ( 10 ); SET @CodeOrganismeMEQ = NULL; --DECLARE @Key bigint; INSERT INTO GVG_V1_Central . dbo . InstitutionScolaire ( InstitutionScolaire_UID , InstitutionScolaire_ID , Nom , Sigle , CodeInstitution , CodeSuccursale , CodeOrganismeMEQ ) SELECT NEWID (), WHAT DO I PUT H ...Show All

• Visual Studio Express Editions something wrong with my complier

  When I compile my modified program, I am getting the earlier program without the modifications I added. Why is this firstly, try deleting the contents of the bin output folder in your project folder and see what happens. usually the location is: my documents\Visual Studio 2005\Projects\your project\debug ...Show All

• Visual Studio Express Editions Display URL in Textbox

  I have a tabbed browser. That when I open a new tab it opens a new browser. key to that is: Dim tx as new webbrowser How would I display the URL of this new webbrowser in a URL, for viewing purposes I dont want to be able to input a url just display the current URL. I found my own answer to this, so I'm posting that others can see. I know I'd learned about StringBuilder before, but had no need to use it. Private Sub Browser1_DocumentCompleted( ByVal sender As Object , ByVal e As System.Windows.Forms.WebBrowserDocumentCompletedEventArgs) Handles Browser1.DocumentCompleted Dim URL_String As New System.Text.StringBuilder() URL_String.Append(e.Url) Label1.Text = URL_ ...Show All

• Windows Forms problem with checkedlistbox

  I was trying to capture the 'checked' items on the checkedlistbox with the following code: private void SelectQuestion_Click( object sender, EventArgs e) { for ( int i = 0; i <= (clb.Items.Count - 1); i++) { if (clb.GetItemCheckState(i) == CheckState .Checked) { label23.Text = clb.SelectedItem.ToString(); } } } All I got is this message on label23 - System.Data.DataRowView Please give me some help. Thanks. Hi, can you please post some more code on how you're adding your items It appears you're adding DataRowViews from some DataView... I'm also wondering what text is displayed in this CheckedListBox. Andrej ...Show All

• Windows Live Developer Forums Map Control: What is legal?

  We are having a bit of trouble understanding the legal stuff for Virtual Earth. What we want is a very small internal system that simply displays a map with pushpins/custom icons. The system has a very small number of transactions daily. By internal system, we mean used by 3 people internally in a company. The site must not be accessible to the public. Can we do this free, or will we have to purchase a license   TroelsL wrote: We are having a bit of trouble understanding the legal stuff for Virtual Earth. What we want is a very small internal system that simply displays a map with pushpins/custom icons. The system has a very small number of transactions daily. By internal system, we mean used by ...Show All