Lisa Shipley's Q&A profile

• Visual Studio Team System Steps to install SP1

  I cannot find the answers on any of the SP1-sites/blogs. I have a number of PC's running VS2005 against TFS. When i update TFS to TFS SP1, must i also update all the client machines to VS2005 SP1 Or can i just update TFS and not (yet) update all the clients On the TFS-server, must i also install VS2005 SP1 I know that i must install the 'pre-SP1-patch' and the TFS-SP1, but since there is VS2005 installed on the server (not for C# or VB, etc, but Team Explorer) must i install the VS2005-SP1 for that part Thank you, Dennis Greg is correct. You do not need to have both client and server at SP1. The only requirement is if you are running a dual-server configuration you must update both the AT and ...Show All

• Visual Basic wrong Count of Records

  Hi, I am having troubles with the count of records in a Form. All my Tables used in my Access database are linked tables to an SqlServer. The Form I use is a wizzard created form and the recordsource is simple like "SELECT * FROM tab1 join tab2 ..". I want to display the number of records in the form, but it seems, that the recordset does not load all records at once. What i did is: Private Sub Form_Current() lblRecordCount.Caption = Recordset.RecordCount End Sub But when I open the form, it displays just "16", if i move to a record below, it changes to "28", when i scroll to the end it finally displays "100" - which is really the right count. I tried this also with a new database, where i created a table with 500 records ...Show All

• Visual Basic Getting 'Object reference not set to an instance of an object' error with User Control :(

  Hi, I have a simple form with a user control MyUserControl which has another user control inside it called StringUserControl which has a function in it called GetString() and returns a string variable within that user control class. When I try to access it from my main form via a simple.. MsgBox(MyUserControl.StringUserControl.getString() .... my program throws a run time exception System.NullReferenceException: Object reference not set to an instance of an object. Any ideas Thanks in advance. -heedree well I managed to fix it by setting MyTabPage3.show() in InitializeComponent section of the form. There's probably a better way but this will work for now. thanks anyway. -heedree ...Show All

• Visual Basic Compile

  Is there a way to compile my aplication so that it does not need the .net framework The correct version is installed on your development machine - its version 2.0 of the .net framework. Publish your application and set the .net 2.0 requirement which will install the framework if it isnt already installed when you install your application. ...Show All

• SQL Server Access DB2 on AS/400 using IBM OLE DB Provider

  Hi, I am using the IBM OLE DB Provider (IBMDASQL) provided with Client Access (IBM) to access a DB2 database on an AS/400 (iSeries). Using an OLE DB Source in the data flow and Access Mode set to "OpenRowset" this works fine (even though I think it is quite slow). However, when I change the Access Mode to "SQL Command" my data flow fails at the OLE DB Source component - not giving me any meaningful error description (only the mysterious "... the error is specific to the component..."). Using and SQL Command to access the data is important to me, since I need to put a WHERE-statement on the rows returned from the source. /Michael PS: I am not able to use the MS OLE DB Provider for DB2 (as far as I know it is only shipped with HIS ). ...Show All

• Visual C++ need a help regarding dwmapi.dll and DwmExtendFrameIntoClientArea function

  Dear All, My compiled code asking dwmapi.dll, which is nowhere to find on my windows XP box. using dependency walker, it reports that the "c:\windows\system32\urlmon.dll" is looking for this dll, and the function name is DwmExtendFrameIntoClientArea. I searched internet, and some people say that the IE7 is making this problem. and I am kind of agree, and I have it on my machine. So I need this dll badly, or somebody can give me a way to un-install IE7 quickly Thanks a lot. rcen Upon further research, scratch my previous message. The real culprit is IE7. It appears my install of IE7 includes a version of IEFRAME.DLL that has this missing dependency. This is throwing an exception in a 2002 dl ...Show All

• Visual C++ DataSet Creation Visual C++ 2005 Express Edition

  Hello All, I am trying to create my own dataset like this: using namespace System; using namespace System::Data; ..... .... int main( array <System::String ^> ^args) { DataSet TT = gcnew DataSet(); } When I am trying to build this it gives me the following error: ..\DbCheck.cpp(29) : error C2664: 'System::Data::DataSet::DataSet(System::String ^)' : cannot convert parameter 1 from 'System::Data::DataSet *' to 'System::String ^' I don't know why Can somebody help me out and explain to me why this doesn't work' Many Thanks !! Well, keep in mind what the gcnew operator is doing. Your original code won't compile for essentially the same reason the s ...Show All

• Visual FoxPro File is in use by another.

  When getting an error "File is in use by another" - Is there a way to trap what file is this I am using the sys(2018) but I don't get any info in there. Thx. Obviously when I try to use a file. But I am not sure what file is the one causing the problem cause Sys(2018) won't supply that in the error trapping routine. thx. ...Show All

• .NET Development New customer acquisition count

  Hi there I have a field, customer acquisition date which is part of the customer dimension table and is a date field. I want to have a count of customers who were acquired on a specific date and I want this date to be related to my other measures, so I can show number of customer acquired and Revenue for a particular date period. Do I need to remove from customer table and create a separate fact table with customer_id and date and a value (say 1) and then join this table to all other tables Or is there a way to join the field as it is to the date table Thanks in advance Derek Hi, In addition to that, you may also want to create a view so that you can JOIN it to other tables in your data ...Show All

• SQL Server export the query result to html

  I am using the query window n SQL server 2005 express to execute some sql statement but i want to export the resut to html.. is that possible within the sql statement Could you try to export your query result as XML and then create style sheet to transform it to browser Just a thought. I didn't try this, but you can try if you like. ...Show All

• .NET Development Using multiple SqlConnection objects, bad for performance?

  Hello, I am planning to use three databases on the local SQL Server. DB1 will be for App1, DB2 for App2, and DB3 will hold tables, that both, App1 and App2 need to access. With applications I mean ASP.NET applications. Obviously, I need in App1 and App2 at least two SqlConnection and SqlCommand objects, one that access their respective databases, and one that will access DB3. Will this result in a worse performance (The using of two SqlConnection objects in one aspx page as example, and switching them) Should I for better performance get rid of DB3 and add the tables there to DB1 and DB2 (Thus multiplying data, but, if the performance will be much better, it will be fine with me) I would be thankful for any advices. ...Show All

• Visual Studio Team System we are adding unit scrits into load test but it is giving erros like object varible or with block variable not set?

  we are adding unit scrits into load test but it is giving erros like object varible or with block variable not set what could be the problem and weather we need to add any load test plugings into unit test because i don't know what could be the problem .....................pls let me know........... because its very urgent................ A couple of things: 1) Your unit tests need to be thread safe. So if you are accessing any shared variables (e.g. statics, class variables, or singletons), you need to make them thread safe. 2) you should try running the load test under the debugger to try to debug the problem, and break when this exception is thrown. Ed. ...Show All

• Visual Basic CPU Temprature

  Is there any way to get PC/CPU temprature I just reviewed this myself. I believe the answer is no, not in the clr and not in API that I know of. Although WMI, I believe will tell you if there is a temperature sensor is there, it won't tell you the information you want. The information is in the bios, at addresses which are board dependent. Beyond that, some sensors are linear and some are not so some bios correct for the information and some do not. Usually a vendor accesses this with board accessories via a driver. There are various peces of freeware floating around such as Motherboardboard monitor which is excellent but support for it ceased a couple of years ago. So if you have a newer board, the degree that MBM will support i ...Show All

• Visual Studio 2008 (Pre-release) Looking for lab or sample on WCF security

  I am new to WCF and want to learn about setting up security between server and client. I have read Keith Brown's article in the August MSDN magazine, which explains things clearly but I need more sample code, showing particularly how to configure endpoints, bindings and behaviors to set up message-based and transport-based security via the app.config file. I have come across a couple of blog entries with sample code, but they are from earlier times and the APIs have changed sufficiently that they don't build any more.   I am now using RC1, the latest. (Trying to figure this out from just reading the docs is HARD!) Craig, I presume you mean to chack this setting on the server I looked all over th ...Show All

• .NET Development Remoting through SSL and Keep-Alives

  Hello, My remoted objects are hosted in IIS. I am using HTTP and binary serializer for single-call activation. Due to scalability considerations, I prefer to have the Keep-Alives option turned off. Now my task is to enable SSL on this channel. When Keep-Alives are turned off, a new connection is established between the client and the server for every remote call. Will this force the SSL handshake happen for every call as well In other words, must the Keep-Alives be enabled when SSL is in use Thanks, Val As part of design recommendations http keep-alives should always be turned off on service host as it may result in adhoc connection errors to remote objects. http://DotNetWithMe.blogspot.com ...Show All