DavidLant's Q&A profile

• .NET Development Connection Pooling not working

  I have a form that has a number of database calls. It does these sequentially. In some cases it's not possible (due to archetecture more than anything) to make these calls all on the same connection. However it does open then close the connection. (all connections created are in using statements) What I'm seeing is that we're getting a timeout when the 100 connection limit is hit. Looking at Activity Monitor I can see these connections growing and growing over time in the activity monitor the more windows you open and close even though these connections are closed. (and they all use exactly the same connection string) data source=(Local);initial catalog=Evolution;password=dyknalna;user id=EvolutionUser;Connection Timeout=20; I read ...Show All

• SQL Server A question about sqlxml

  Who use sqlxml .net How can I write code like this: select count(1) as count from Orders for xml auto That's error.   And what is the correct sqlxml code   Tks. Hi, the code works fine with SQL2005 but fails on SQL2K Eralper http://www.kodyaz.com ...Show All

• SQL Server Restoring master Db to Secondary server- Service unable to Restart

  Hi, I'm having trouble with restoring the master db on w2k3 sql2000 sp3a to a Secondary Standby server. Firstly, I place the server in Single user mode and then restore the master db. The sql server then tries to restart sql services but immediately stops as soon as it starts up. Can anyone help Please ! Thx, Steve First, is the secondary server running the same version of SQL It needs to be. Secondly, look in the SQL errorlog and in the system event log. It should tell you why it can't start up. ...Show All

• Visual Basic simple question textbox to textbox

  i am working with one form, i want the text inputed by a user from one textbox to be displayed in another read-only textbox thanks for your time Yes there almost definetly is a value. The value is WindowsApplication1.Form1.Webbrowser1.URL.ToString() (btw is the to string necessary ...i get an error without it...) In debugging, it correctly displays the webbrowser's URL... But when you publish the application (make an external build) it does not function as successfully as it did in debugging. ...Show All

• Windows Search Technologies WDS 3.0 RTW Enterprise Search and Admin Guide

  It appears that more than a few things have changed since WDS 2.65 which is the last version with an admin guide that I can find. I'm trying to enable a Intranet search button where I now see "Search Desktop" and "Search Web" buttons, and the instructions for 2.65 in this regard don't seem to work (using Policies) - I'm wondering if the registry keys / values edited by the policies have changed If anyone has any guidance or comments on either issue - finding the Admin Guide for WDS 3.0 or on enabling Intranet Searches in WDS 3.0, I'd welcome the input. Thanks in advance! Yes indeed - I'm looking for the same information. Guys on the team - any chance you could post links to that ...Show All

• Visual Basic Programmatically retrieved event log EventID does not correspond to Windows EventID

  Hi, I am developing an application that reads the event log in windows. I have managed to retrieve everything correctly except the Event ID. Most EventIS's are similar but for e.g. " Broadcom NetXtreme 57xx Gigabit Controller" Windows Event-ID is 15 and when I retrieve it programatically it is 327695. Another Event ID also for this controller is 6 and 327686. The difference between both are 9. Can anyone explain this Can it be fixed Best /M Yes, no problem I log events to an xml file for further use. Each event of interest is logged to an XML file using this function. The code is as follows (simplified): Public Function LogSingleEvent( ByVal oEventLogEntry As Even ...Show All

• .NET Development How to send FREE SMS from my application?

  Dear all, How can i send sms(Free) from my application I tried to send using a webservice which i got information from this link.But its not working even if there is no error! http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=236013&SiteID=1 Is there any other way to achieve this Please guide me... Waiting for your valuable inputs.. Thanks in advance, Sunath Typically you need to go through an SMS gateway. As you stated there are some free webservices out there that claim to do it, but I have not had much luck with those when I tested them out. For reliable messages I think you will need to get an account setup with a carrier. ...Show All

• Visual Studio Tools for Office Error in AddIn After installing using .msi

  I published the project, signed, checked prerequisites and i got a .msi and setup.exe now when i install the addin using this .msi i am not getting my addin loaded in outlook. this was was error shown when i selected that after clicking the COM Add Ins button in outlook. Not loaded.A runtime error occured during the loading of the COM Add-In. But the same application works if i run it directly from Visual Studio Please help. how can i make msi properly Hi, did you follow all the guides for the security http://msdn2.microsoft.com/en-us/library/aa537173(office.11).aspx http://msdn2.microsoft.com/en-us/library/aa537179(office.11).aspx You might wanna try to surround the ThisApplication code with an ...Show All

• Windows Forms datagridview vertical scroll bar

  Is there a way to make the vertical scroll bar always show in a datagridview I know it's possible with datagrids through datagridtablestyles, but havn't been able to find anything comperable with datagridview. Thanks in advance. since i couldn't find a way to do it, i made the columns fill the window and they just decrease if there's a vertical scroll bar, this at the least prevents a horizontal scroll bar. ...Show All

• Windows Forms window form not responding vb.net 2003

  have created window form class name Cinterface when i instantiate this Cinterface form from with in click event of another form it is working perfecty ok like private sub Button_click(byval sender as object,byval e as Even...... dim nf as new Cinterface nf.show() end sub but when i use same code to instantiate Cinterface form from with in some other user defined event handler form popup but stops responding like dim ob as new some_class AddHandler ob.user_defined_eventname ( AddressOf processdata ) ' this user_defined_event will be raised from some_class and handled by processdata() of this class private sub processdata() { dim nf as new Cinterface nf.show() ' This code is poping up the Cinterf ...Show All

• Visual Studio Express Editions error C4430: missing type specifier - int assumed.

  Hello, I am migrating a working program from mangled C++ .NET 2003 to Vistual C++ Express 2005 with SP1, and I am getting very weird compilation errors. One of them is C4430. In order to make the post clear, I reproduced the error in this simple code. --------------------------------- header file "Blocke.h" -------------------------------------- #pragma once class Blocke { public : Blocke( void ) {} Blocke( const &Blocke dummy ) {} Blocke& operator =( const &Blocke dummy ) {} ~Blocke( void ) {} }; ---------------------------- implemetation file "Blocke.cpp" ------------------------------------- #include "Blocke.h" ---------------------------- Results --- ...Show All

• SQL Server Rights for clickonce Report Builder access?

  I'm attempting to grant rights to Report Builder as deployed as part of my TFS install. My problem is that I have to add my users to the builtin\admin group in order for them to see the report builder button on the SQL Server Reporting homepage & then have rights to launch the ReportBuilder click once app. I obviously do not want make users admins on the box, but I've tried adding them to all of the other groups having to do with SQLServer to no avail. How can I grant users access to launch the Report Builder app Users need to have the Report Server system permission "Execute Report Definitions" in order to see the Report Builder icon in Report Manager. 1. access Report Manager Site Setti ...Show All

• Visual Basic Error Creating Interop Form Wrapper Classes for Project ...

  Hi, I successfully used the interop forms toolkit V1.0 (by the way didnt you promise V2.0 ), but after adding another interop form I receive the message: "Error Creating Interop Form Wrapper Classes for Project ..." when I start >Tools>Generate InteropForm Wrapper Classes. On the machine I have installed only with .net I receive this message 2 times, on the machine with the vb6 IDE I receive the message once. Can you help I have no idea where to search... Thanks Alex Hi Jonathan I m also getting same error as alex. I hv my two modules generated in visual studio 2003. and my company's main product in vb. so i have converted my this two modules in visual studio 2005 to util ...Show All

• .NET Development Convert packed date to DateTime

  I am working on porting an unmanaged C++ application to C#. The C++ code uses a packed date: typedef double DATE; I could use the VarUdateFromDate() API function (and associated structures), but I would like to eliminate COM Interop. Is there a way to do the conversion from a date packed into a double to a DateTime without involving COM Interop TIA David Yes, this looks like it does help - exactly what I was looking for. I skipped over these methods because I did not understand what they were. I should have been more thorough. I shall give it a go. Thanks! David ...Show All

• Windows Live Developer Forums Did something bad happen to the v3 api/endpoint? My maps are now all failing

  Did something bad occur to the v3 version as a result of this new release My maps are all failing. Is this still the js reference - http://dev.virtualearth.net/mapcontrol/v3/mapcontrol.js Thanks,. Jeff Hi all, We became aware of this issue a couple of hours ago, as soon as we flipped the switch on the new v4 map control. The folks here got to work right away on it, and it looks like we have it fixed now (as of about 10 seconds ago :). We are very sorry for the inconvenience. If there are any more problems, please let us know. Thanks, Andy ...Show All