JHB's Q&A profile

• SQL Server Import Data

  how I make to import some tables of a data base in Access to SQL server 2005 express edition You can use the Export functionality in Access to send data to a number of places, including SQL Server. You should be able to find information on this in the Access help file, but here is the general process: Open your database in Access and choose the Export option. Choose ODBC Database from the Files of Type list. Follow the wizard to create a DSN to your SQL Express instance. Pick the tables and click OK. You will need to enable TCP connections to SQL in order for Access to be able to connect a ...Show All

• Visual Studio applying smart indentation rules

  Hi,  I have been facing a problem regarding the implementation of smart indentation rules in my custom language service. i am not able to find out which interface should i implement and where should i write my rules.   Please help me with the process.    Thanks in advance..   Hi, i have given indentation to my editor at the time of parsing by capturing the charcters in OnCommand method and then applying edits on textspan and it is doing perfectly fine. But the problem i am facing now is that when i opens more than one file of my editor in one project in expiremental hive i am not able to get in ...Show All

• Visual Studio Team System TF26027 error after work item import

  I created a custom work item type and uploaded it to 4 Team Projects. On 3 of these Team Projects all seems to be working fine.  On the 4th Team Project, when I click 'My Work Items' query I get an error showing "TF26027: A field definition somefield in the work item type definition file does not exist.  Add a definition for this field, or remove the reference and try again." Please note this was the exact same work item uploaded to all projects, but only one complains. I ran witfields, and verified that the field it complains about does not exist.  I also verified that there are NO references to this field in the work i ...Show All

• .NET Development Help needed with cookies and WebRequest

  Hi all, I have to do some web scraping from a client's web site as they can't give me a direct feed of data (for various reasons too long and boring to explain here!) so I thought I'd use the WebRequest class which I've used before with success. However, the data I'm scraping is on pages linked 1 or 2 levels down and they require cookies which WebRequest doesn't seem to handle natively. I added a CookieCollection object to my code but when I call my FetchHTML method (below) for a lower level page (ie: linked from the top page) I just get back HTML containing a message saying that cookies have to be turned on. I think I basically just don't r ...Show All

• Visual Studio Help with Help .. its driving me crazy!!

  Installed the new Visual Studio 2005 (*not beta) from an .iso image file (CD) Installed MSDN Library October 2005 edition from CD's. NOTE: I chose the option to install the library from the Visual Studio 2005 setup. Launching VS 2005, the dexplore help is showing help on help only, not any documentation from MSDN Library 10/2005 version. So, I Launched the help seperately, still not seeing anything related to MSDN. But I did see options to install additional help libraries from third-party component makers (Infragistics to be exact). I dont understand why there are all these variations in the way HELP is installed between versions of devel ...Show All

• Windows Forms WebBrowser: setting manually Document.Body.InnerHtml

  Hello, I'm trying to implement a help in my test application. The home page of the help is defined in the configuration settings. When no setting has been found, I would like to display "No help available". My problem is that WebBrowser.Document is readonly and by default Body is Nothing... How can I do that Thank's a lot Serge Perhaps the browser control doesn't have its Document property set, in which case it will throw a NullReferenceException.  You can use the DocumentText property to build the HTML manually. This is easier than working the DOM object model. StringBuilder builder = new ...Show All

• Software Development for Windows Vista loading workflow from xoml file

  i save workflow in xoml file now when i load it back its loads fine but i had to cast it into prope type can any body give me better way of doing it ..... XmlReader xmlReader = XmlReader .Create( "seq.xoml" ); WorkflowMarkupSerializer serializer = new WorkflowMarkupSerializer (); seq. Workflow1 wf1 = (seq. Workflow1 )serializer.Deserialize(xmlReader); WorkflowInstance wfInstance = wfRuntime.CreateWorkflow(xmlReader); wfInstance.Start(); I mean simply using Activity type for wf1 not works .... If you are trying to deserialize a workflow from a XOML file you do the following: XmlReader xml ...Show All

• Windows Forms Programmatically selecting a TreeNode in tree view fails???

  Hello, I am writting an app with a TreeView and attempting to programatically select a TreeNode. This is the call I make: p_node->TreeView->SelectedNode = p_node; But this call fails. The SelectedNode property of the TreeView stays <undefined> after the call. I can't figure out what I am doing wrong. Any ideas Thanks ...Show All

• .NET Development If I want to work with an xml file as a dataset

  I have an XML file and I want to know the easiest way to work with it in general. What is the easiest way to get access to all the data and then have the power to manipulate and modify the data before then saving back to file. If I have xml file like this: <people> <person> <name>Bob</name> <age>20</age> <gender>M</gender> </person> ... </people> and I want to read all about all the people from within VS 2005 in VB.NET 2005, whats the best method I would like to be able to sort of "transform" it into a class like object and then be able to deal with it like ...Show All

• SQL Server RDA and sql server mobile database

  hi all in the wireless application, if i use RDA to pull data from SQL server 2005 database. do i need to code a exernal class for the PDA to connect to the sql server. RDA pull data trough what medium, wireless or active sync, if i wanna pull data through wireless what should i do. By the way, how to i create a database in PDA by using sql server mobile Hi Kang,     Please visit SQL Server Mobile Books Online for initial understanding and how to program against SQL Mobile @ http://msdn2.microsoft.com/en-us/library/ms173053(en-US,SQL.90).aspx Thanks, LaxmI NRO, MSFT, ...Show All

• SQL Server Communication link failure; 08S01; TCP Provider: An existing connection was forcibly closed by the remote host.

  Hi, I'm having a problem processing my cube. I keep getting the error stated below everytime I process the cube. I'm a newbiew and can't quite understand the error fully. I'm processing the cube from the server itself so I cant understand why there will be a communication link error.Why do I keep getting this error OLE DB error: OLE DB or ODBC error: Protocol error in TDS stream; HY000; Protocol error in TDS stream; HY000; Protocol error in TDS stream; HY000; Communication link failure; 08S01; TCP Provider: An existing connection was forcibly closed by the remote host. ; 08S01. Errors in the OLAP storage engine: An error occurred while the ...Show All

• SQL Server Stored procedures

  Hope someone can help me with this question. I am wondering if it's possible to create a stored procedure in a database that retrieves data from a table in another database. database1 has dbo.table1 database2 has stored procedure db1_getTable1data -- Insert statements for procedure here SELECT * FROM [database1][dbo] . table1 WHERE PC_ID = @PC_ID any help would be greatly appreciated. Thanks Rod Hi, you are close: SELECT * FROM [database1].[dbo] . table1 WHERE PC_ID = @PC_ID So you can use the three part name: Database.Owner.Objectname (whereas owner has t ...Show All

• Software Development for Windows Vista Workflow Activities

  Can some illustrate how to use the If..Else Activity.....I am really looking for how an activity can use data from a previous avtivity in a sequential workflow. Let's say there is a web service avtivity which flows to an if..else activity. I would like the if..else activity to use the output of the web service that was called in the webservice activity. Of course I could put all of this in a composite activity but lets just assume there are reasons these are seperate activities in the workflow. For information on the IfElse activit specifically, please see the following thread:     http://foru ...Show All

• Visual Studio Team System Team build - building native C++

  I have a team project with an associated native C++ solution.  I created a team build for this project, but when I tried to build it, it failed because the PSDK files are not present on the build machine (only TFS, Team Client and Team Build are installed). That's no problem - I can install the PSDK.  What else is missing   (e.g. is MFC there   ATL   STL   CRT )  Do I need to install VC++ on the build machine or should team build be sufficient (other than PSDK) Hi Carl! Here is a detailed table of what we intend to support under each installation type post beta for C++ apps. However, for beta bui ...Show All

• SQL Server MS Reporting Servicew

  I installed the evaluation version, but there are no Reporting Rervices, although it asks me to configure a report server. How do I get this to work properly! john welte ...Show All