JoachimLaursen's Q&A profile

• Visual Studio Team System Response time Vs Connections

  Hi, I am doing load testing on web application. I have executed the test with 100 users with Connection pool size was 50. Average response time was 27 seconds and I got the errors for average connection time out counter. I have increased the connection pool size from 50 to 100. When I have executed the load test second time I did not get errors for average connection time out counter. But response time was 60 seconds which is almost double than first time (27 seconds) Why response time varies when connection pool size increases. Is it right that increasing connection pool size when we get the errors for average connection time out counter In forum I have seen some messages connection per user is better ...Show All

• SQL Server get first row first column value into a variable

  It is my second time on this forum Nice people managed to help me on my first thread. I am encouraged to proceed with you ! Well   I  have an Excel source that returns One row , two columns: what I want is get the value returned in  the first row - first colum into a variable so I can then execute sql tasks based on this filter parameter ! Can you guide me   Regards Jacques   Hi Again Jacques, Here is an entry of a previous post I did (you can read the whole thread at http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=736614&SiteID=1 ) ---------------------------------- You may have more than one option here; I would try with a script ta ...Show All

• SQL Server Error in OLE DB Command task

  Hi all, After applying the SP2 for Korean - we are getting the following error in the above task. Transfer Fact Data From StagingDB to Presentation DB: Insert Update MetricFact [1021]: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 Description: "'OPTIMIZE' .". Not sure what the problem is. The same task was running properly before applying the SP2. For other language SP2 (on other languages) the same task runs correctly and without any error. I m getting the error at design time also when the Package is opened in BI studio when i tried using Pro ...Show All

• .NET Development Dataset.datarow parameters

  Hello there, I have a simple question, any answer will be appretiated. I have recorded a set of values in a datatable, i want to read a coloumn value in each row of that datatable and perform a loop operation to run some more queries and get more data from the database. the problem is that i am not able write a loop to implement this code. so need help...if possible a sample code will be useful thank you Saad We need more information. Looping though a datarow is easy enough.. For Each dr As DataRow in Datatable.Rows PerformQuery(dr.Item("ColumnName")) Next but are you trying to put more data in to the same table Maybe you can write the query so that you don't need to loop through the ...Show All

• Visual Studio Team System tfpt & server option

  For some commands like 'query" it seems possible to use the /server or -S option from tf.exe to specify the server. For other commands like 'uu' this does not work. I could not find any documentation on this in the Powertoys manual. E.g.: - tfpt query "Test\Public\MyDefects" results in " Unable to determine the source control server " when ran from a NON-workspace folder - tfpt query "Test\Public\MyDefects" /server :TFServer works just fine from NON-workspace folders - tfpt uu /server:TFserver however results in " Unrecognized command option 'server' ". Can anyone explain what the correct behavior should be for all tfpt commands Thanks. Here is the comp ...Show All

• Gadgets Link opening weirdness in x64

  Hello, In x86 Vista, this will open IE7 in a gadget: var ie = new ActiveXObject('InternetExplorer.Application'); ie.navigate2(URL); In x64, nothing... Any ideas I need to open IE and not the default browser. Thanks, Ty An iframe I don't understand. I want to open a new browser window not something in the gadget. What is the preferred way to do this Ty ...Show All

• .NET Development XmlSchemaException Changes from Visual Studio 2003 to 2005

  I am working on a project that was developed using Visual C# 2003 and I recently built several modules using Visual C# 2005. I found that the 2003 binaries handled XML Validation exceptions differently that the 2005 binaries. The code in question uses the XmlValidatingReader class ( which I realize is no longer used ). The code also depends on the XmlSchemaException message string format not changing and the content of the string being basically the same. I realize that this is potentially bad code ( I did not write it). My question is were do I find information about what was changed Is there a way to make 2005 create the same binaries as 2003 Harry Kuhar Strings you see in exceptions come from resource ...Show All

• SQL Server SQL Server 7.0 shows a suspect database after attaching it in SSME?

  Hello, I have a database that resides in SQL Server 7.0 that I can attach in Microsoft's SQL Server Management Studio Express and I can see all the tables from the database in that program. My problem is that when ever I re open SQL Server Enterprise manager, the database that I attached to SSME, shows up as Database(Suspect). Now I am unable to view my tables in that database. Can anyone tell me what causes this, and how I can resolve that issue I need to have my sql server database, and sql server express edition database present in SSME because I am doing an import of data from SQL Server 7.0 to SQL server express. Also, if there is another easier way to import data from SQL Server 7.0 to SQL Express edition, I would like to ...Show All

• Visual Studio Express Editions com interop.

  Hi, I'm trying to develope some "command" for ArcGis. The problem is that ArcGis need command.dll and command.tbl When I build my project in Express Edition I get: command.dll, command.dll.config, command.pdb and command.xml. How can I obtain .tbl ! ! Note that I already flagged the "Make Assembly Com-Visible" option... Tnx Do you mean .tlb (Type Library) You can use regasm.exe to create a type library from an assembly (VB Express does not have the ability to directly create it for you when compiling). ...Show All

• SQL Server connection management

  hi.. i have like 50 ssis packages,, most of all have the samne conexion to my target server.,, the user an pwd i'm using is the same for all of them... but the pwd has been changed because of security rules,., the result: these packages will no longer execute correctly .. is there anyway i can change this conexion for all the packages without doing it manually and if so.. how thanks!!!!! You should have used package configuration from the really beginning. If you didn't and you are planning to go over all the packages again; do that for adding the required package configurations to set the connection string of your connection manager at run time; that way next time a change of this nature happens you will have to update ...Show All

• Visual Studio Express Editions Running a exe application from a form but in minimize mode

  How can I call an exe appliation from a form but in minimized mode Take a look at the ProcessStartInfo class: http://msdn2.microsoft.com/en-us/library/system.diagnostics.processstartinfo.aspx once configured, simply set the WindowStyle to ProcessWindowStyle.Minimized. Example: Dim the PSI as new ProcessStartInfo("fileName.exe") thePSI.WindowStyle = ProcessWindowStyle.Minimized Process.Start(thePSI) is this what you are after ...Show All

• SQL Server Installing SQL Server 2005 Standard, Note: 1: 1708, Installation failed.

  Hi, I first attempted to install SQL Server 2005 with the management tools, SQL server services installed ok but the management tools did not install. I tried to re-install the management tools but the setup program thought that they were already installed. I then un-installed everything in Add/Remove programs, & rebooted. I then tried to install again but this time it thought that the SQL server services were already installed. I removed the services from the registry and rebooted again. Now when I try to install SQL Server 2005 it simply fails The last message in the log is "Note: 1: 1708 MSI (s) (A0:6C) [15:34:23:656]: Product: Microsoft SQL Server 2005 -- Installation failed" Any help would be appreciated MSI ...Show All

• Visual FoxPro send mail but don't want the outlook ask permission

  I would like to send the e-mail in the foxpro program using Msmapi32.ocx, I have used the following coding: this.mpssession.logonui = .f. this.mpssession.signOn this.mpmMessage.SessionID = this.mpsSession.SessionID * set for Direct Message Handle this.mpmMessage.MsgIndex = -1 this.mpmMessage.RecipDisplayName = "xxxxxName" this.mpmMessage.RecipAddress = "xxxx@bhss.edu.hk" * Resolve recipient name *this.mpmMessage.AddressResolveUI = .f. *this.mpmMessage.ResolveName *Create the message * mail subject heading this.mpmMessage.MsgSubject = "Status Report" * mail message this.mpmMessage.MsgNoteText = "Build successful!" *Add attachment *Add attachment 1 *this.mpmMessage.AttachmentIndex = 0 *this.mpmMessage ...Show All

• Visual Studio Any Idea On Crystal Report Connection???

  Hi All, I Changed My Server from SQL 2000 To SQL 2005 Server. I Also change my ServerName and Database name... When My applications Running From SQL 2000 Server i have not set ConnectionString on my Page. But when I migrate Server From 2000 to 2005 and also change servername and databasename It ask for ConnectionInfo...... You can find my code on http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=879486&SiteID=1 First I Try to setup following code for Connection Info rpt.DataSourceConnections[0].SetConnection( "Server1" , "MYDB1" , "sa" , "db" ); My Report Data will not refreshed.... Then I tried following code. rpt.SetDatabaseLogon( "sa" , "xys06" , "Server2" , "MyDB2" ); Then i will get Mis ...Show All

• .NET Development Display a pdf document in VB.Net app

  I want to include a pdf article in my VB.Net application...Adobe Acrobat should fire up, displaying the article when the menu-item is selected...how would one go about doing this... I am using Visual Studio 2005 (VB.Net). Hi, you could use Process.Start method to start the (default) Pdf application - (Adobe Acrobat Reader in most cases): Dim pathtoPdfFile As String = "C:\Pdf\MyDocument.Pdf" System.Diagnostics.Process.Start(pathToPdfFile) Note that Acrobat should already be installed on the system for this to work. Andrej ...Show All