nardev's Q&A profile

• Visual Studio Team System History details on initial changeset is slow cause changeset is huge

  I added a whole project to TFS (2078 dirs, 34116 files and about 967 MBytes in size).  The changeset details info is huge for that initial changeset.  I am working on this from home via VPN over a ~3.5 MBs broadband connection.  If I double-click on that initial changeset in the history window for any particular file, the resulting details window takes a minute or two to appear.  Initially (first 15 seconds or so) there isn't even an hour glass.  Even with the hour glass there is no indication of progress and no ability to cancel the operation.  Both of these would be nice to have if you can ...Show All

• SQL Server ODBC connection problems in SSIS

  I'm trying to connect to a Postgres database via ODBC from SSIS. The odbc connection is defined on my PC and works perfectly with other applications, including Access. However, when I set up the connection in SSIS, everything appears to connect fine (test connection works, etc.) but when I look at the data connection in Server Explorer, there are no tables, no views, and no procedures. Also, the name of the data connection is ODBC.csidb. csidb is the name of the server where the postgres database resides, but the database name itself isn't showing up. Can someone please let me know what I'm doing wrong Thanks! Laurie ...Show All

• SQL Server Help Please...request to send data to the computer running IIS has failed

  Hello,    I am trying to complete the BOL sample " Creating a Mobile Application with SQL Server Mobile". Using SQL 2k5 and VS Team Suite. I have the emulator about to get on to the internet and can even get to the http:// sqlce.domain.com/sqlmobile/sqlcesa30.dll url but when runing the vb.net code I get the error 28037 "A request to send data to the computer running IIS has failed. For more information, see HRESULT.". Any help would be greatly appreciated. No software firewalls are running. I have a dns entry that points to my laptop for testing. The sync function code is below. Sub sync() Dim repl As New SqlCeRep ...Show All

• Visual Basic How do I solve TargetInvocationException problem with WebClient in Visual Basic 2005?

  Hello, I've created a small programme which downloads file over web using the WebClient interface. I've added 2 handlers to the to the webclient, one for the download progress and the other for the download completed. Sample code: Private Sub DownloadAsync( ByVal URL As String ) Dim wc As New WebClient() Dim dpc As DownloadProgressChangedEventHandler AddHandler wc.DownloadProgressChanged, dpc Dim ac As AsyncCompletedEventHandler AddHandler wc.DownloadFileCompleted, ac Dim Address As New Uri(URL) If (URL.Contains( " " ) = True ) Then URL.Remove(URL.LastIndexOf( &q ...Show All

• SQL Server Reporting services access problem !!!!!!!

  Hi .. I am facing a peculiar problem ... We have Sql Server 2005 reporting services installed on our server ...unfortunately our sysadmin by mistake has reinstalled the IIS on the server due to which the report server is not accessible .. The sql server is working fine no problem .. normally we used to give .. http://domainname/reports and all the reports will be shown. Now how do i reinstate the settings of the IIS ... for the Reporting services. Could anybody suggest some ideas ... Rgds Chandru In your Configuration settings stop the report server. Then restart IIS, then restart the report server. This may ...Show All

• Smart Device Development Program Size / Memory Issues

  In trying to convert our software from eVC4 to VS2005, I have noticed that the size of the compiled code is larger for VS2005 compiled for WM5.0 Our software was close to not having enough application memory on a 2003 device and now I'm wondering if converting it to 2005 has pushed it over. Here are the current program sizes: Release version for 2003 : 4015 KB Dubug version for 2003 : 7886 KB Release version for 2005 : 5267 KB Debug version for 2005 : 11903 KB !!! Additionally, on a 2003 device the program loads 20 to 30 dlls. I cannot get either release or debug 2005 versions to run on a 2005 device, both ...Show All

• Windows Forms ComboBox in DataGrid using Mark's class

  Hello, I'm using <a href="http://windowsforms.net/TrackViews.aspx ID=131&Type=Samples&Redir=%2fSamples%2fdownload.aspx%3fPageId%3d1%26ItemId%3d131%26tabindex%3d4">Mark Boulter's custom class</a> to use a comboBox in a datagrid field. I've been able to implement it once already in one part of my project, but I'm having problems with in another part.  It seems to only have a problem when there's&nb ...Show All

• SQL Server Stored Procedure typed xml parameter DDL

  The following will create a stored procedure that has @testXml as an xml datatype. As my tables in the database store "testXml" in a typed xml field, can I "type" the @testXml parameter coming into my stored procedure using an item from the database's "Xml Schema Collections" What would be the DDL syntax THANKS! ALTER PROCEDURE [dbo] . [PearUpsertShapeImage] @id [bigint] , @testXml [xml] AS GO I believe I found the answer at: http://msdn2.microsoft.com/en-us/library/ms184277.aspx CREATE PROCEDURE SampleProc @ProdDescription xml (Production.Pr ...Show All

• Visual C# Using Timers in a console application

  Okay, so... I've only worked with Java so far, and never even understood multithreading in that, but anyway, now I'm REALLY lost. Yes, I looked all over for tutorials, but they were all talking about applications in windows forms which have their own threading thing going on apparently, and mine is a console application. So here's my question. I have this (using Syste.Threading.Timer): t = new Timer(callback, null, Timeout.Infinite, Timeout.Infinite); t.Change(0, Settings.FRAMERATE); //Start the timer Now what do I do If I just say while(true) { } nothing happens. If I say Thread.Sleep(500); this thread sleeps for a bit, then executes again ...Show All

• Visual J# OLEDB 64, 32 (SQL 2005/64 / Jet)

  Hello. I want to read access db from within SQL Server 64-bit. On 32-bit, I can do: SELECT f1, f2 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'd:\db.mdb';'admin';'',SomeTableOrQuery) This fails on 64-bit because there are no jet oledb for 64-bit. I need to do this, and I suspect I am not the only one. !! Please compile a 64-bit Jet oledb provider !! For now, I will try to query through a 32-bit SQL Server (express) on the same machine, it might work, but is a card-house of a solution. How about a generic OLEDB32 provider I could write my query like SELECT f1, f2 FROM OPENROWSET(   'Microsoft.Generic32.1.0',   ' ...Show All

• .NET Development Converting streams

  I have a Stream which is Stream stream = httpWebResponse.GetResponseStream(); I need to convert this System.IO.Stream into System.IO.MemoryStream. How can I do that with C# 2003 The data that a server returns is an image. I would do byte [] data = webClient.DownloadData(uri); but for certain reasons I have to use HttpWebRequest/Response. Thank you. You can't convert it from one to the other .. you would read data from that stream into a memory stream. Although I am curious why you need to read it into a memory stream as opposed to using the response stream directly I can write code such as .. public void DoSomething(Stream s) ...Show All

• Visual C++ Convert CString to *

  Hi, How can i convert CString to int or CTime...,etc Thanks anndy wrote: Hi, How can i convert CString to int or CTime...,etc Thanks Use _ttoi to convert a CString containing a numeric string to an int. You cannot directly convert a CString to a CTime object. If you have a formatted time string in a CString, you'd have to extract out the numbers (minutes, seconds etc) and manually create the CTime object. ...Show All

• Windows Forms listbox

  I am populating a windows ListBox with the persons names. At the same time I am loading the personId into an array so that later it can be retrieved for the selected person. Please note that in the ListBox I only would like to show the name and not the personId Dim clst As New ArrayList() foreach person in the table clst.Add(row.PersonId.ToString())    personsListBox.Items.Add(row.DisplayName) I am not sure if this is a good way or not, BUT my main issue at the moment is that I don't know how to get the personId for the selected person in the listBox. I tried clst.Item..... but Item is not in the drop down Thanks ...Show All

• Visual Studio SourceSafe plug-in in Beta2?

  Any of my projects that previously were connected to SourceSafe now generate an exception that the plug-in is unavailable. Sure enough, there are no source control plug-ins installed. Is this something that must be independently installed to access Source Safe Strange that this all worked just fine in Beta1. I have successfully installed Visual Studio Team Suite Beta 2. I still get that error. I am not using Team Project yet so I don't really care about that. Let me know, please! thanks, Darcy ...Show All

• SQL Server SSIS Requests...

  May be it's too late, but I think this requests could be scheduled at least for a SP1 if it's not possible for the RTM. 1) Execute Task without debugger: it would be very nice to be able to execute a single task without going in debugging mode. Just as you would ask "Start Without Debugging CTRL+F5" but for a single task 2) Customize default properties for task and component: when you drag a task on the package you get a default value for the properties that you could want to change; often I need to change the same property in the same way each time (for example I'd like to set the Batch Size for a OLE DB destination to 1000 instead than 0 ...Show All