JIM_LANGDON's Q&A profile

• .NET Development Retrieving data from Excell 2003 - Could not find installable ISAM.

  I am trying to access some data in a Excel 2003 file and import it to a dataset using a oledb provider.Here is the code : string cnxString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=C:\\TEST.xls;" + "Extended Properties=Excel 8.0;"; this.excelConnection.ConnectionString = cnxString; this.excelConnection.Open();I keep getting this error :A first chance exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dllSystem.Data.OleDb.OleDbException: Could not find installable ISAM.I have search everywhere there is a space between data and source. I have read the KB articles but nothing seems to be doing it. Any help would be greatly appreciated.Thanks. ...Show All

• Visual Studio Tools for Office ComponentID of VSTO 2005 SE --> vstor

  Can someone pls provide the GUID for the VSTOR runtime that is associated with VSTO 2005 SE or explain how to determine it once installed tx Hi Tadwick, yes it is is, but there is also a new registry key HKLM\Software\Microsoft\VSTO Runtime setup\v2.0.50727 Update=1 Thanks and regards, Darryn Lavery [MSFT] ...Show All

• SQL Server Linked Server issue

  I have a problem querying a linked server connected via the OleDB provider for ODBC. This is the DataDirect 32-BIT SequeLink 5.4 client driver connecting to a FileMaker Pro 8 database. I've tested this in VB.net 2005 by adding an ODBC connection in server explorer and a data grid to a form. I can run the tooty and the data loads in the grid with no errors what so ever. So using the above ODBC connection I added a linked server called 'DNA' and run the following query on the Stock_DNA table. SELECT * FROM OPENQUERY ( DNA , 'SELECT * FROM Stock_DNA' ) The result I get is this; OLE DB provider "MSDASQL" for linked server "DNA" returned message "Requested conversion is not supported.". Ms ...Show All

• Internet Explorer Development Strange behavior getting location string

  I 'm developing a site named 'goodcreations' and I want report a issue encountered testing locally in Apache (from a XAMPP distribution). My system is XP with service pack 2. 1) I addressed my browser with following: " http://localhost/goodcreations/index.html ". 2) Then I clicked one of various buttons whose 'href' was set to a html page between two hashes (i.e. #multimedia.html#). This turned string in the address bar to: " http://localhost/goodcreations/index.html#multimedia.html #". 3) Finally, when I refresh the page a javascript uses function substring to take the address ('multimedia.html') and pointing to 'multimedia.html'. 4) Multimedia.html is a simple page containing only javascript ...Show All

• Visual Studio can I disable the SourceControlProvider in VC 8.0?

  Hi, I transfered from VC 7.1 to 8.0 just now when I worked on VC7.1, I change the reg HKLM\SOFTWARE\SourceCodeControlProvider\ProviderRegKey to emtpy to avoid the the VC binding my local file to the version control software without changing any local project file to remove these information. but in VC8.0, I remove the key as before, also, I remove HKCU\Software\Microsoft\VisualStudio\8.0\CurrentSourceControlProvider but it seems VC80 can always find the version control software when i open the solution and open the version control software to ask me login and binding... I just really don't like VC do the checkout automaticly, and I wander is there a way to disable it easily. any suggestion will be apprieated and thank you very much in adv ...Show All

• .NET Development Difference between 'string' ans 'String'

  Hi all, I am new to this forum. I have a basic doubt regarding the System.String class. Can anyone tell me what is the difference between "String" and "string". Thanks in advance.......... Hello All. jkmurty: "string" is the C# keyword that you use to declare a variable to be of type string . "String" is the name of the .NET class that you would use to access static members of that class. For example: string varname = String.Empty; In this line, the variable varname is declared to be of type string , and the static member of the String class, String.Empty, is used to assign to that variable the value of that member, which is "", or an empty string. HTH. ...Show All

• .NET Development ampersands

  I've got some HTML data that I'm trying to read with an XMLTextReader (or a plain XMLReader). When ever it hits an anchor tag where the href contains an &, it crashes. I realize that & are supposed to prefix tokens like   < & etc..., but is there a way to have the &s inside tag arguments No. Technically, bare ampersands aren't valid in HTML either, but browsers don't compliain. (The W3C validator, of course, will :) -Ryan ...Show All

• .NET Development Closing Web Application like Window Based form

  Hi guys, How do i close the web application i run just like the window application. I mean in vb you use End to end the application right or just close the window and it will terminate the application. How do i do that in asp I am running a dll that will automatically update tables in a database. it runs perfectly in a window based app (vb.net) since it automatically end the app, but when i try to transfer the code in asp, though the return result was successfull it doesnt appear to my tables when i open it. It seems that the transactions were rolled back since the web app wasnt closed as like the window based form. can anyone help me on this Thanks in advance... ...Show All

• SQL Server Windows 2000 Report Server Connection Issue

  Every so often a client Windows 2000 pc that is trying to access the report server cannot connect to it (page cannot be displayed). If I go over to the server itself, the same report runs fine. After several minutes, it is possible to connect to the report from the Windows 2000 client machine. Report Server is running on a Windows XP Pro machine. My first thought is that the problem is your application pool is set to shutdown after a certain time limit. Go to IIS, under application pools, right click on the one being used by Reporting Services and go to properties. On the performance tab, uncheck "Shutdown worker processes after being idle for (time in minutes):" You might want to also uncheck the boxes for ...Show All

• SQL Server Getting Error when datasource view is refreshed

  Hi, In the cube project, When i right click on the datasource view pane and refresh, it throws an error as "Object reference not set to an instance of an object". How to fix this. what will be the problem. Please help to fix this. Thanks & regards, Vivek S Hard to say what is going on. The error message is very generic. Try narrowing down the problem: Create a copy of your DSV and start deleting tables from it. See if refresh still gives you the same behavior.. Edward Melomed. -- This posting is provided "AS IS" with no warranties, and confers no rights. ...Show All

• Visual Studio MS SQL 2005 RS

  What would I gain for the SQL Reporting Services if I purchased the Visual Studio 2005 Pro or higher Does it give me any extra tools or anything for the Reporting Services for SQL 2005 Visual Studio 2005, Standard or higher, includes ReportViewer controls. There is a Windows Forms version and an ASP.NET version of the control. The controls can be embedded in your application and they can either display reports that are hosted on a Report Server, or they can process and render reports locally, i.e., without needing a Report Server. In local mode you can supply data using ADO.NET DataTables, or a collection of business objects. ...Show All

• Visual C# Opening and Saving Text Files

  Hi, I'm making an application that has an RTF Box as part of its contents. It is a read-only RTF Box, so you can't edit it, but the file can be re-saved. My approach is thus: you open the file; you read it; you either: save it to a different location or you close the document. I have tried the following lines of code to open the file: richTextBox1.LoadFile(openFileDialog.FileName); and the error “File is not valid” occurred. I don’t know why, but it does occur, so I’m assuming that anything that wasn’t created by a C# application would behave the same way. You may remember me asking about a word processor earlier (which I discarded due to too many bugs), and I used the code above, to open files, and the following to save: Ric ...Show All

• Visual Studio Team System No Sound or Video

  I have sound and video cards installed, but they do not appear to work. I recently installed a new clean copy of windows xp, and it can not play any sound, and when I try to play the sims 2 the graphics are horrible. I got my own video card installed at a computer place, and it worked until i installed the new copy of windows xp. Please help, if you have any information that would help i would love to hear it. This forum is meant for answering questions on Visual Studio Team System. Your issue is related to the sound and video cards, which you might want to post to other forums or contact the hardware support folks. ...Show All

• Windows Forms Bound Text Box not Updateing Underlying Data Set

  In ASP.NET 2, C#, I am trying to determing whether a user has changed the data in a form's text box. The text box is bound to a DataSet as follows: this.txtCOPK.DataBindings.Clear(); this.txtCOPK.DataBindings.Add("Text", ds, "invcusth.copk"); The change is checked as follows: foreach (DataTable table in ds.Tables ) { foreach (DataRow row in table.Rows) { row.EndEdit(); } if (ds.HasChanges()) { MessageBox.Show("Changes"); boolChanged = true; } } Whn I type a new value into txtCOPK, the snippet above works correctly. If I put the change in programatically as below, the correct value shows up in the text box and the TextChanged event fires, but the DataTable ...Show All

• .NET Development How do i keep Instance of current dataset???

  I have a Datagrid.DataSource = mydataset.....when i add new rows to it and close out the form and then i try to open that form back up...the form is blank...why is that Ok Well i have an OrderEntryForm which is my parent form...I have a child form called Order Details that shows a grid with two columns Name and Cost...When i enter the Name and Cost in that grid say I add three row of data...I Close that form and my txtTotal reflects the cost by using this method... this .txtTotal.Text = Tracking.UI.Dialogs. OrderTotal .DisplayOrderCostTable( this ._Order, this ).ToString( "$#,##0.00" ); Here is that method signiture public static decimal DisplayOrderCostTable(Tracking.BusinessObjects. Order _order, Syste ...Show All