SevSamp's Q&A profile

• 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

• SQL Server Can't pass parameter - rsAccessDenied

  I am having a problem passing a parameter. When it gets to the last line of code where I set the parameters, I get this error. Can anyone help The permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are insufficient for performing this operation. (rsAccessDenied) Here is my code: ReportParameters(0) = New ReportParameter("ProjectKey", 262) rv.ShowParameterPrompts = False rv.ServerReport.ReportServerUrl = u.ConvertFromString(" http://localhost/ReportServer/ ") rv.ServerReport.ReportPath = "/Test/Duplicate_MIU_Report" rv.ServerReport.SetParameters(ReportParameters) I have the same pr ...Show All

• Visual Studio Team System SQL Server Name of Team Foundation Server??

  If you know the Team Foundation Server name, is it possible to get the SQL Server name that uses for its databases like VSTEAMTeamBuild I need to get the information from its TestResult table. Or, is there any other way to get Test Result information from TFS The DB information is stored in integration services registration.  That is what the application tier calls to get it's DB locations. If this is Beta3, go to iis manager on AT in the Services vdir, under v1.0 there is a registration.asmx browse to it in IE on the AT and invoke GetRegistrationEntries with no params to see all. You can also programma ...Show All

• Visual Studio Tools for Office vba excel compiling / creating library

  Hi, I created a lot of tools in Microsoft excel and microsoft access using VBA. Is it possible that i can convert it to executable files or creating (.dll) library for security of my macro Can I do it in Visual basic or Visual C++ and How to do it Hi, If you are worried about security, are you aware that Vba has a protection option to prevent your macros from being viewed   In the macros IDE, you can select Tools.Vba Project Properties and then click on the Protection tab.  From there you can choose Lock Project For Viewing and provide a password.  This will prevent your macros from being viewed and m ...Show All

• Windows Forms Guru ? on Error msgs

  One on my main problems is identifing the Object that failed. The lovely Object Instance failure :) I am wondering is there a way in code to identify the failed objects name  Thanks Deasun Hi Deasun,  Usually by examining your stack trace (the error message generated) you can see where your code failed. You might also consider placing breakpoints o ...Show All

• SQL Server asp.net confgiguration tool. tool keeps timing out

  is it possible to change the settings on this tool. i want to have it so that it does not time out at all or is that possible I suggest you ask this on the ASP.Net forums http://forums.asp.net/ ...Show All

• Visual Basic invalid parameter

  Can anyone tell me why this throws a system.argumentexception:Invalid parameter Imports System.Drawing Public Class form1   Inherits System.Windows.Forms.Form # Region " Windows Form Designer generated code " Public Sub New () MyBase .New() 'This call is required by the Windows Form Designer. InitializeComponent() 'Add any initialization after the InitializeComponent() call End Sub 'Form overrides dispose to clean up the component list. Protected Overloads Overrides Sub Dispose( ByVal disposing As Boolean ) If disposing Then If Not (components Is Nothing ) Then components ...Show All

• SQL Server Linked Server from SQL Server 2005 (x64) to Sybase

  Hi, We have been accessing databases on ASE 12.5 (on HPUX) from MS SQL Server 2000 (x32) successfully for years. We do this via linked servers we create on MS SQL Server. When creating the linked server, we would specify the Microsoft OLE Provider for ODBC as the provider, and the data source is the name of a DSN created with the Sybase ASE ODBC driver (4.20.00.67) that points the the HPUX box on which are the Sybase databases. We have also gotten this to work just fine on MS SQL Server 2005 (x32) Standard Edition SP1. However, we cannot seem to get this to work on MS SQL Server 2005 (x64) Enterprise Edition SP1. The Microsoft OLE D ...Show All

• .NET Development FK violation on TableAdapter.Update

  I have 2 tables, namely Parent(ParentID, ParentName) and Child(ChildID, ChildName, ParentID). I created a form by dragging the datasources based on the dataset produced by this tables. The Parent table is represented by details while the Child is with DataGridView. The Child table bindingsource is bound to the relationship between the two tables so I expected that Child.ParentID would change accordingly after updating the parent table to the database. To my surprise, it didnt and throws an exception about FK violation! Here's the code for the BindingNavigator savebutton click event generated by the IDE. private void parentBindingNavigatorS ...Show All

• Visual Studio vs2k5: Symbol not found error with web service

  Attempting to step into a web method, receive: "Unable to automatically step into the server. Unable to determine a stopping location. Verify symbols are loaded. Symbol not found: Service.HelloWorld()." I notice though there are .PDB files in the virtual directory for 2 DLLs that the web service is dependent on, there is no .PDB file for the service's own App_Code.dll file. Since the PDB file contains 'symbolic debugging info' I wonder if that's the cause of the error. Do web services emit PDB files, or do they work entirely differently I do not see anything in the property pages of the web service project addressing debug build configuratio ...Show All

• Visual Studio Team System WorkItem Created through code is not seen in query result only through go to workItems

  Hi there,      In VSTS Beta3 refresh  bug server I'm trying to add workItem through code. The workItems are actually getting created with new Id but when I run query like All Work Items , I don't see them , when i try to look at the bug thruogh Go to WorkItem given ID , I am able to see the workItem. Could someone please tell me what is going wrong here How can I fix it Thanks, Anu Cool, we've definitely got some bugs around deleting projects and we are working on fixing them. Brian ...Show All

• Smart Device Development Embedded C++ and the Samsung i600 Smartphone

  I been trying for several weeks to get my phone to comunicate with the Embedded C++ 4.0 tools.  I am getting the following error in the Platform Manager test view: Unable to load device side components. Please check server configurations. I have sent my smartphone to Verizon to be unlocked, which they say they have done and I still get the message.  I am using Activesync 3.8. Any help on this would greatly appreciated. Thanks. Rob. Thanks. The last link did it.  I was unaware of the need to run the SPDPS program. All is working now. Rob. ...Show All

• Visual Studio Express Editions Server Error in '/' Application Failed to map the path

  Need some help on this error. Everything was working fine for me. I had one site up and running with the Visual Web Developer 2005 Beta 2 and Microsoft Framework 2.0. I created a second website and put it in its own directory, configured IIS to use Ms Framework 2.0. Everything should work being the same just different directories. Unfortunately, now both websites are down. I have posted the error below. I have attempted creating the folder that it is yelling about even though I do not use it. I even tried creating a basic hello world website. It also receives the error. I have uninstalled and reinstalled to no avail. Any help would be apprec ...Show All

• SQL Server Images aren't being displayed in deployed Reports

  Hi everybody, When I develop and run (preview) a report in my machine (Vs.net 2003), the report is displayed correctly, including images. But, when I deploy the report to the server (Win2k Server), the report runs OK, but the images are not displayed! I've already tried everything I found in the internet about this problem .... changed the way of put the image in the report (Embedded, External), tried an image with only RGB colors, changed the account for unattended execution (rsconfig) .... but nothing worked!!! Does anybody have any idea about what might be happening Thanks a lot!! Hi Rodrigo, I am also facing the problem similar ...Show All

• Visual Studio Team System Getting info about local variables.

  How would you get information about variables local to a method I thought looping over a method's instructions would get me there but it appears there is no opcode generated for local variable declaration. Instead there is a .locals init ( ) line. Is there a way to access that information So far Method.Body.HasLocals is the only thing I've found to be of any use and I thought the Block class would lead me to my goal but so far it hasn't. Any advice Warning: this rules development API is likely to change in a future version of FxCop . Currently, the locals of a method are stored in a pseudo-instruction in t ...Show All