Tom Moore's Q&A profile

• Windows Forms DataReader and ListBox!

  How bind the sqlDataReader with ListBox  (in code) Personally, I'd rather you'd at least give it a shot before asking how to do something with code.  It seems very lazy and almost demeaning for you to ask with such little information.  however, I am hoping there's articles that others may have come across that may help you.  I'd& ...Show All

• SQL Server Table created in SQL Query Analiser won't work

  Hi all, We're facing a rather strange problem here: Oe of my colleagues is trying to create a table using Sql Query Analiser. the "create table" command returns no errors. But when we try to access the table, it says it's an invalid object name. I've checked sysobjects, and the objetc is there. Can someone give me any clues Thanks Can you include the 'create table' command that was used Chances are that it was created in the user's default schema, or in a schema other than 'dbo' and your default schema's don't match...if you can get the schema that the table was created in, try ...Show All

• Visual FoxPro GRID REFRESH

  Im having problems refreshing a grid.i have placed a table in data enviroment.then i drag and dropped all of his items creating a grid.then in a button i have a select...where..into this table.this way i put new values in the table,basically i overwrite the entire table.at that time grid becomes white,no values i tried grid.refresh nothing i tried to grid.recordsource="" select where into... grin.recordsource=mytable  still nothing is there a way to make the grid to reload the table Hi before the update or  set the source to 0 ex:    thisform.grid1.RecordSourceType= 0 ... do anything wit ...Show All

• Visual Studio Display Multi selected listbox Items' text

  How can I show the Multi selected listbox Items' text in a message box Visual studio sounds not happy to this declarations:    Dim li As ListItem Thank in advance. Hi, fill the listbox with your own objects which override the ToString() Method and get those selected Items in the value changed event of the listbox. then put textbox.text = yourSelectedObject.ToString(). ...Show All

• Visual Studio Team System Windows SharePoint is not configured as recommended by TFS

  Hi, the headline says it all - it comes up, when I start the TSF-Services setup. But the installation doesn't say, what it likes to have exactly done in addition ! Can anybody help Thx, Klaus - Uninstall SharePoint. - Clear away any empty Application Pools that may have been left behind in IIS as a result of this (e.g. StsAdminAppPool). - Install SharePoint using the steps indicated in the Team Foundation Installation Guide. ...Show All

• Visual Studio 2005 client and V6 Server

  Does the new client work or is it supported with the new V6 server Are there any good reasons to run this way Or, what is gained by doing it The database format did not change between the previous release and 2005. This means that you can use the new tools with the older version of the product which should improve stability and reliability. VSS 2005 has a lot of stability and reliability improvements. -mark ...Show All

• SQL Server Update in Sybase 11 Linked Server problem

  When trying to update records in a Sybase 11 ODBC linked server got this error: Server: Msg 7330, Level 16, State 2, Line 1 Could not fetch a row from OLE DB provider 'MSDASQL'. OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset::GetNextRows returned 0x8001010e]. Thanks for your time. I found that I cannot update rows in Sybase but I can insert new rows. So I’m now inserting rows in a temporary table, this new temp table has a trigger that updates the original table with the inserted data. It is working fine by now. We are migrating the conflict database from Sybase to SQL Server, and in ...Show All

• Windows Search Technologies WDS 2.6.5

  Congrats on the release of WDS 2.6.5. I have some questions before I start digging into it. Background - I have a product due for release this summer that uses WDS. Currently it uses the MSN Toolbar 2.05 version (beta, I think, as in it was always beta). It works pretty well and I am happy with it. - Is the new 2.6.5 and the old WDS 2.05 compatible from an API stand-point, as in, do I need to reference a new WDSQuery.dll My current WDSQuery shows file version 2.5.0.0. - If I need a new WDSQuery.dll, where do I get it from - Is there a list of breaking changes (i.e. the use of the URL field in the return results). I realize tha ...Show All

• SQL Server General network error in VB Application

  Hello All, I need some help with tracing this problem. Only one system in our network gets this error. Runtime error '-2147467259(80004005') [DBNETLIB][ConnectionWrite (send()).]General network error. Check your network documentation. I am using SQL Server 2000 I have checked the access rights of the user they are perfect and also as i have mentioned earlier this error comes up with this login only. I have also tried replacing the system but it was not helpfull.     What can I do to trace this error. Thanks in advance. If this happens during the connection (login) time most likely the server closed ...Show All

• SQL Server Push and Pull subscription?

  As I understand replication in Sql2K the only difference in push or pull subscriptions is where the agent runs. If I wanted changes in the publisher to be sent to the subscribers immediately after the change then I thought push would be better. But, if I am equally interested in changes made at the subscriber then what should I use Or does the agent monitor both the publisher and subscriber at the same time Thanks for your help Graham Graham, assuming you're talking about merge replication, changes will be propagated up/down whenever the agent runs.  If you run the agent in continuous mode, then the ch ...Show All

• Windows Forms ErrorProvider problem

     I modified the layout of my desktop app, and now the function to capture the errors doesn't seem to be seeing them. It is returning a "True" when in fact there are errors as shown by the icons/messages that are there. control error code: Private Sub txtExPosTestB_Validating(ByVal sender As Object, ByVal e As System.ComponentModel.CancelEventArgs) Handles  ...Show All

• Visual C# Entity must be parameterless?

  I am new to write application that connect through internet via web services. I wrote several entities with parametered constructor. But I got the following error when I run through Internet(but not on LAN). Does it means .NET entities that pass by web services must be parameterless Thanks a lot. System.ApplicationException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> There was an error generating the XML document. ---> Entity.eWarehouse cannot be serialized because it does not have a parameterless constructor. at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapCl ...Show All

• SQL Server how to change the instance name back to default of SQL2k5

  hi, While installing SQL SERVER 2005, I had opted for providing custom name for the SQL Server and named it as for eg. as 'xyz' . Now I would prefer to change it back to default instance so that I can use server=localhost in my connection string of my ASP.NET page. With the custom instance name everytime I have to give server="Machinename\xyz" which is annoying as I will have to change the connection strings in so many places for my exisiting ASP.NET page. For e.g. strConnection="server="Machinename\xyz";database=test;Integrated Security=SSPI;"; I tried using server=(local). It did not wor ...Show All

• Visual Studio 2008 (Pre-release) Textbox Bug

  I don't know if the textbox was changed to work like this now, or if it is a bug. Up until the Feb CTP the .Drop / .PreviewDrop events of the textbox always fired, no matter what you dropped inside of it. (The data didn't show, but the event fired) Now, when dragging data, I have to use the .DragEnter event and set e.Data.SetData("") to something before the .Drop method will work. Is it suppose to work this way now Thank you Jaco The PreviewDrop event works for the MayCTP. It worked for a simple WPF project. ...Show All

• SQL Server Need more info on

  I am looking for more detail on these "integrated reporting controls" mentioned below (from http://www.microsoft.com/sql/2005/productinfo/top30features.asp#B ): "With SQL Server 2005, Reporting Services will provide report controls that will be shipped with Visual Studio 2005. Integrated reporting controls will provide improved reporting capabilities for enterprise applications". Specifically, I am looking for more detail on these new ASP.NET 2005 controls that make dynamic server side reports generation via the Reporting Services Web Service easier. Thanks. The Report Controls are described at http://w ...Show All