Stamey's Q&A profile

• SQL Server New Subscriptions

  When I go to the "My Subscriptions" screem in the Report Manager, I don't get a " New Subscription" option. I am running SQL Server 2005 Developer's version, as a domain administrator with every role function enabled. How do I get access to this functionality ...Show All

• Windows Live Developer Forums cannot deliver messages to MSN bots

  i've been hosting 2 bots with the Incesoft bot provider for the last 2 months. after the Messenger service problems (on Wednesday ), i have not been able to reliably host the bots ( MobileRecordBot@hotmail.com and TextAdventureBot@hotmail.com ). the message i get when trying to communicate is : "The following message could not be delivered to all recipients" i've been trying the last 3 nights to get them working again, and have run out of ideas. the bot program seems to be connecting fine to Incesoft's servers, and using the Incesoft admin tools seems to log the bots in and out properly. also, a small # of sessions will work properly when i leave them running overnight. my own user experience is that i can start a session with ...Show All

• Visual Studio 2008 (Pre-release) N Extracting DataTable from query expression

  Hello, I would like to be able to "extract" the DataTable used in a query expression. Sepose I have the following code var query = from c in Customers select c; I would like to "walk" the query expression and to receive Customers as base table in that query. If I have the following query: var query = from c in Customers join o in Orders on c.ID equals o.CustID select new { c, o } I would like to receive Customers and Orders as base tables in that query. Is it possible Good catch. My example did not need to bring up IQueryable<T> there. I could have easily have been IEnumerable<T> ans still have been a query, not results ...Show All

• Smart Device Development C# + PPC

  Good day to the MSDN members, I've asked this question before, but didn't get much of a reply, and so I gave up thinking it would go away, but it seems it's quite important for a project that I'm working on. Situation: I'm in charge of creating a DLL file that will pull information from a PPC running Windows CE, and has Pocket Access installed on it. I know what needs to be pulled, but the question is...How would I code such a thing. I've been searching on the internet for many a moons now, but have come noticed everyones comments...Switch to SQLCE. I'd love to but can't, the client is set on using this software that uses MS Access as its backend as well as its frontend. The VBA programming when a PPC is cradled seems to be pullin ...Show All

• Visual Studio Team System Readonly flag for System.ChangedBy field not possible?

  i do want to display the changedby field in my form. but it should be readonly. i tried the following code but i always get an error message when trying to save the work-item. <FIELD name="Changed By" refname="System.ChangedBy" type="String"> <VALIDUSER/> <READONLY /> </FIELD> error message: Save failed. The value for field 'Changed by' must be the same as the original value. but i didn`t changed the value of this field. obviously because it is read only ;-) is it not possible to set a system field to readonly Very interesting. System.ChangedBy field is core field and this field gets the current user when a work item is changed (happens in the background). As you mentioned REA ...Show All

• Visual Studio Team System Team Foundation Server - Deleted project asks to unshelve...

  Hello! From VisualStudio .NET, I right-clicked on an open solution and added the solution to source control. Then I deleted the folder from the TFS server b/c it was added in the wrong place in the tree. Then I right-clicked on the solution again to add it back, but the TFS server, but the option "Add to source control" is not there. Now there's an option "Unshelve Pending Changes...", but when i go there, there are no shelvesets to unshelve. How can I fix this problem so the solution can be added to the TFS server Thank you in advance, Richard Any chance you still have the pending changes If so, try to undo the delete (or just undo all changes in the workspace). If ...Show All

• SQL Server 2005 breaks sp_rename for constraints?

  BooksOnline indicates that sp_rename can still be used to rename constraints such as primary keys, foreign keys, defaults, etc. in SQL Server 2005. However, when I try to do so I get this: "Either the parameter @objname is ambiguous or the claimed @objtype (object) is wrong." After looking at the code for sp_rename, it looks like this problem might be related to another bit of apparent misbehavior on 2005's part: when I execute "select object_name()" with the Id number of a constraint, it returns the name, but when I execute "select object_id()" with the name of that same constraint, it returns null. Why is that Thanks, Ron Did you specify the schema make sure that Object_id is only v ...Show All

• Visual Studio 2008 (Pre-release) How to use UIElement.AddToEventRoute Method ?

  I want to do same thing of ToolBar as behavior. I was not able to find the sample. Does not the change in the routing of the event use AddToEventRoute I wanted to customize the route of the event. At that time, I thought that it was able to achieve it if this method was used. The event is received with CommandManager.AddCanExecuteHandler and CommandManager.AddExecutedHandler now, and RaiseEvent is done routing ahead. Is there a better method ...Show All

• Visual Studio Print Layout mode showing incorrect # of pages at first

  Sometimes when switching to Print Layout mode, it will say page 1 of 1, switch back to Interactive Mode and back to Print Layout mode again, and then it will display the correct # of pages. Anyone have any idea how to correct this FYI: I am using the report viewer in local mode. Most reports work just fine. This is a known bug that has been fixed in Visual Studio 2005 SP1. See this thread for more information: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1032267&SiteID=1 ...Show All

• Gadgets Gadget Piracy

  Vista hasnt been out for long but we are already seeing a big issue relating to gadgets which is piracy. I have already seen probably 5 examples of people taking someone elses gadget, making a few changes and re-releasing it. I have been developing widgets/gadgets for Mac OS X and Yahoo Widget Engine for 2 years now and i dont think i can even think of 5 similar cases in that time. As far as im concerned unless a gadget specifically states that you may modify and re-release it then those people are breaking copyrights. Just because you can view the source of a gadget that does not mean it should be considered open source in a typical sense. I've released more then 25 widgets/gadgets over the past 2 years and ive never had a proble ...Show All

• SQL Server sqlcmd with trusted connection and IP address or fully qualified hostname

  The command sqlcmd seems to fail when using trusted connection and an IP address or a fully qualified hostname. For example: sqlcmd -E -S nnn.nnn.nnn.nnn where nnn.nnn.nnn.nnn is the real IP address of the machine, or sqlcmd -E -S hostname.domain.com where hostname.domain.com is the fully qualified hostname of the machine, gives the error: Msg 18452, Level 14, State 1, Server 380GX280B05, Line 1 Login failed for user ''. The user is not associated with a trusted SQL Server c onnection. On the other hand, sqlcmd -E -S 127.0.0.1 works, and so does sqlcmd -E -S hostname, or sqlcmd -E -S tcp:hostname,1433. This is on a clean machine, with SQL Server 2005 freshly installed as Administrator with mixed authentication, and t ...Show All

• Visual Basic Good Systems and Analysis Design

  Wher can I get some free help on Systems analysis and design for VB.net applications. I'd check out comtent on msdn, with components such as the enterprise library they build on established patterns and provide some clues as to an implementation. Microsoft certification also addresses the subject of architecting applications - look at the examination study materials for MCSD certification. These are based around either VB.Net or C# and have a design/architectural component. The web is full of information of design methodologies - AGILE, SCRUM, WATERFALL are certain design methodologies that come to mind that can be applied. Try you local .NET users group - there are often experienced developers/architects there that can also ...Show All

• SQL Server Not getting all the data from the stored procedure

  Hi, I am new to SQL reporting services and currently trying to create a report using an existing stored procedure. Using the wizard I created a dataset and associated the stored procedure with it. When I go to the Data Tab and execute the stored procedure I am not getting all the rows back. I am getting around 100 rows although I am expecting more than 250 rows. I ran the SQL profiler and the parameters that are getting passed to the database when the stored procedure is run from the Data Tab is right. If I use the entry of SQL Profiler in the SQL Server Management Studio (copy and paste), I am getting the right information back (i.e., around 250+ rows). Till now I haven't set any filter on the dataset. A quick analsiys of the result ...Show All

• SQL Server Problem with asp page and ODBC on Windows 2003 SR 64 Bits

  I have an Application developed on ASP, I got a few new servers 64bits, I installed microsoft WIN 2003 SR. When I get in into the web site I receive this errors: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified /ConnectToDatabase.asp , line 17 I made some obvios checks, I checked that the ODBC really exists and we move the IIS 6.0 to run in 32bits mode as I found in some page. Thanks you. Ahmed You are likely using an ODBC driver that is not available for 64bits. See http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=20574&SiteID=1 for the relevnat discusion. C ...Show All

• Software Development for Windows Vista Accessing Database from Property designers

  I am writing custom activities that have custom property designers. The property designers need access to the database in order to allow the users to configure the activity correctly. The long term goal is to rehost the Designer, but in the interum, we need to be able to do this in VS. Does anybody have on suggestions or recommendations for doing this Andrei, If you're looking to have the user select a value for a custom activity property from a list of values in the drop down list, you'll want a typeconverter. I just posted a sample a few mins ago in another thread. Take a look and tell me if this is what you were looking for. http://forums.microsoft.com/MSDN/ShowPost.aspx Pos ...Show All