Jeffrey Schlimmer's Q&A profile

• Visual Studio Express Editions CDate function returns 'IndexOutOfRange' error - also in VB.Net 2005 Beta2

  Hi folks, I have already reported this error in the VS 2005 Beta2 forum, but was told that it was not reproducible (VbCity and VBug, and your UK Launch team were also unable to reproduce the problem). I think I now have a lead on the issue! It also looks similar to a problem reported yesterday on the VB Express forum - 'I keep getting the out of range exception'. I have condensed the problem to two lines of code:       Dim myDate as DateTime       myDate = CDate("01/01/2005") The above error is reported on execution of the second line. This has now occurred on 6 different ...Show All

• Visual Studio Team System please help with web recorder

  Hi! I'm trying to record webtest. 1. Create new web test 2. Window of recorder (IE) does not appears 3. Script is not recorded What solution can you suggest to resolve this problem Thanks for your reply! I'm wondering if the recorder has started but is hiding behind another window. Does a web test open in the IDE with a status bar across the top that says "Recording..." If so, does a link appear on the web test status bar that says "Show recorder" If so, click this link and see if the recorder appears. Thanks, Rick ...Show All

• SQL Server SSMSE license (can it be bundled along with SQL Express)

  We are planning to ship SQL Express, can the SSMSE be bundled as well and installed on the customer site What licensing does it follow Right now SSMSEE is prerelease software and therefore is not licensed to be used against live operating environments unless Microsoft permits you to do so under another agreement. When the final version is released our expectation is you will be able to bundle it and install it with SQL Express. ...Show All

• Visual Basic Saving Data to a Database (VB2005, SQL Server2005)

  Hi, When using the code Try     Me .Validate()     Me .CustomersBindingSource.EndEdit()     Me .CustomersTableAdapter.Update( Me .NorthwindDataSet.Customers)     MsgBox("Update successful") Catch ex As Exception     MsgBox("Update failed") End Try   in the walkthrough given in http://msdn2.microsoft.com/en-us/library/0f92s97z.aspx , changes were not saved to the  NORTHWND.MDF file in the project folder or bin folder  (not updated) . Does any one know why Thanks.    I cannot get  ...Show All

• SQL Server Invalid Data Type error with Subreports

  I have a report with two subreports.  The parameter connecting the report with the subreports is based on a field with a datatype of UniqueIdentifier. If I run each of the subreports by themselves, entering in value for the parameter, they run fine. When I try to run the master report, it runs, but the subreport sections contain the following text instead of the correct output: "Error: Subreport could not be shown."  The Output window shows 2 warning, one for each subreport: The  expression use in subreport 'subreport1' returned a data type that is not valid. I don't know for a fact that it is the parameter causing the probl ...Show All

• SQL Server Deliver to SharePoint

  Quite a while ago Brian Welker talked about Reporting Services WebParts (which are available now...) and a delivery extension for SharePoint. Is anybody aware of it I googled around and didn't find anything about that (besides Brian's statement)... Is there any other option to deliver reports to SharePoint (beside the "delivery to file system" and import/link it to SharePoint) Thanks, Currently Microsoft does not offer a way to deliver to SharePoint.  There are plans to include this in a future release however.   -Daniel ...Show All

• Visual Studio Team System TFS on WS2003 complete configuration tutorial

  Hi I am a VS programmer that was interested in testing TFS. My problem is that I don't know how to configure windows server 2003 (i don't know how to CORRECTLY configure things like AD, DNS etc). I have virtual pc 2004 in my computer, so I created the WS2003 installation in a virtual pc but I really don't know how to proceed from then. Is there a tutorial or a guide to do all these things (configure AD, install SQL Server 2005, TFS, etc) Thanks a lot Thanks for all your help guys that really helped me to get TFS working. And also thanks for the great news that TFS will support workgroups (someone heard my prayer ) ...Show All

• SQL Server Using VB2005 Express to access a SS2005 Express Edition DB: O/S Error 32

  Looking for help in diagnosing this error: Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\cartracker.mdf". Operating system error 32: "32(error not found)". An attempt to attach an auto-named database for file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\cartracker.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. I am using Visual Basic 2005 Express Edition along with SQL Server 2005 Express Edition. Now here's what I did: Rather than use the Database Explorer within VB2005 EE to create my database, I th ...Show All

• Visual Basic help with listview

  i'm currently building an app with vb.net and i'm having some problems with a listview and item activation, i don't understand the mechanics of it what i want is to double click on an listview item and show a form i've been searching in msdn but i don't seem to understand how it works any help would be appreciated To double click and show a form, you need to have a look at ListView Mouse Event, eg: MouseDown. In listview, Me.Listview1.selectedIndices(0) only return an Integer that if you set multi-select = False. Or else, you might have to use looping to get the Indices that were selected. P ...Show All

• Visual C++ C++/CLI confusion about % vs. ^

  Just a little confusion I am hoping someone can help clear up... I have a method passing in a handle to a Point structure to which I make changes to X and Y values. On return to the caller I find that the Point values are no different. The declareation is Point ^pPt Now if I instead use Point% pPt for passing a reference then any change to pPt.X or pPt.Y works. I thought I could treat Point ^pPt similar to a pointer where changes to pPt->X, pPt->Y would be seen by the calling code Thanx You should be able to use '^' similar to a '*' in C++. One question: is your Point class a value-type If it is then t ...Show All

• Microsoft ISV Community Center Forums Problems when accessing a text file using ADO

  Hello, I am having trouble with some code and I was hoping someone could help me out. I am writing an excel macro that uses ADO to connect to a comma delimited text file and retrive data. The following are the problems I am having: 1. I have no headers in my text file, but it is being treated as if it had a header row when I fill my record set ( it automatically starts on row 2) how do I get it to look at row1 first 2. I am using "MoveNext" to move through the recordset one record at a time. when I create a small test textfile this code works fine, but an interesting problem is occurring on a larger text file i am testing: M ...Show All

• Visual Studio How to support template export in VS 2005?

  Hi,    There is not the topic of the template export implementation In VSIP document .     Could anyone do me a favor   Thanks! You cannot disable the command. One note: we have tried export template with other languages, and it will work, but there are very stringent requirements. For example, you must implement VSLangProj on your project, including all the properties that VB, C#, and J# do. But this is unsupported, so there may be some bugs when working with other language types. Craig ...Show All

• Visual Studio Express Editions Why sometimes CreateObject("Scripting.FileSystemObject") doesn't work?

  On some machines with Windows Xp or 2000, with VB 6.0 or VB 6.3 CreateObject("Scripting.FileSystemObject") returns no object. How can i fix if Scrrun.dll is present. on some machines it could be a third party application that is keeping the scripting object from being created...There are virus scanners and such that have an option to block the creation of scripting objects especially the Scripting.FSO...If you have the option try using System.IO namespace for working with the filesystem versus using the scripting object! ...Show All

• Visual Studio File Deleted

  hi! i have some problem regarding one file in VSS. The file is shown in the VSS interface but when i took some action on this file, error message displays, which says that e.g aaaaa.b file not found. i want to recover this file how can i do. thanx Do you see a file with the same name but a ".a" extension You may be able to recover at least a version of it by renaming that ".a" into a ".b" Regards, ...Show All

• SQL Server help on approach

  I have to read in an excel file of employees, read DB table to see if employee exists, if yes update a column, if no, write to a different excel file w/ the contents of the input record.  I'm trying to understand (new to SSIS) if there is a 'right' way to do this.  I'm thinking I could do all the work in the Control Flow or use a mix of Control and Data flows - any suggestions thanks You can build a relatively simple data flow to achieve this. It will have Excel Source to read rows from the source Excel file, Lookup to look for employees in the reference database. If an employee exists (regular; green output) use OLE ...Show All