SSRS Jon's Q&A profile

• Microsoft ISV Community Center Forums MS Office document and image writer print driver

  Besides removing this feature from Office during setup, is there a process to remove this virtual printer from 300 users with roaming profiles on an active directory network We are having an issue with this printer assuming the "default printer" selection for our users. As a work around we have changed their default printer, but after they reboot or log off / on it has defaulted back to the MS Ofc doc and image writer printer. OK, this installed the Office document image writer but users are reporting that when they send files to it, they don't know where to find them. Please advise. Thanks. ...Show All

• Visual Studio Express Editions Physical memory convert

  How can I convert My .Computer.Info.AvailablePhysicalMemory from bytes to megabytes Depends on your defintion of a megabyte...but I think most people accept the following: 1Kb = 1024 bytes 1Mb = 1024 Kb = 1,048,576 bytes ...Show All

• Visual Studio Express Editions Components Disappeared From Designer

  Hi, I don't know what happened but this afternoon all my menu items, toolbar buttons and statusstrip controls disappeared from the designer. They're in the Designer.cs file but do not show in the designer at all. If I build the app they don't appear in the running app either. I can't give much more info because I've only been using Visual C# for a couple of weeks and have no idea what happened or where to start looking for further information. Is there any way I can get the Designer.cs file and the designer back in sync I hope someone can help or can point me in the right direction. Edit: I should mention that I can't see anything obviously wrong in the Designer.cs file and I haven't edited it myself. Only the Designer has touc ...Show All

• .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

• Windows Forms interacting text boxes & events question

  hello: I have a user form in vb.net 2.0. When a user enters a price in one of 10 price fields, their corresponding percent fields and dollar fields(which are read only fields) are computed based upon the change in price. These computations involve a cost and a quantity field also on the form. In addition when either the cost or quantity fields are changed, all read only fields of the 10 price fields must change since these computed fields involve cost and quantity. So I have an event each time a price is changed to compute that price's read only fields, and I have an event to change the read only fields of ALL the prices if the cost or quantity fields are changed. I was thinking of putting these in the validating event routines ...Show All

• SharePoint Products and Technologies Displaying Workbook using external data with periodic refresh in EWA

  Hello. I have a very simple workbook containing a Pivot Table that is populated by an external data source (SQL Server 2005 database). The connection properties of the external data source are configured to Enable background refresh, Refresh every 1 minute, and Refresh data when opening the file. The connection is configured to use Windows Authentication. The workbook resides in a Trusted File location. When I open the workbook in Excel 2007, the refresh works fine. No problems. When the workbook is opened in EWA, it appears to load a cached (old) version of the workbook, then the first time a refresh occurs, the Data Refresh Failed message is displayed. I have closely followed the "instructions" provided at http://technet2 ...Show All

• Visual Studio How to filter ItemTemplates in "Add New Item" dialog?

  Hi there, I implemented my own Project SubType and some Project and ProjectItemTemplates. When adding a new item, I'd like to filter the shown list of ItemTemplates. Is that somehow possible Regards, Jens Thanks for the hint, but i think you meant GetGuidProperty instead of GetProperty ;) ...Show All

• Visual Studio Team System 411 Length Required

  Hey Everyone, I am a complete newbie to VSTS and have been playing with the webtest functionality to simulate a user going through a purchase on our system. I recorded the web test using the web recorder fine and then had to modify the coded version but get: HTTP/1.1 411 Length Required error when posting back my last page. Any ideas Here is my code for the specific request, can I specify the length somewhere in code Much appreciated, D. request9.ThinkTime = 2; request9.Method = "POST" ; request9.Headers.Add( new WebTestRequestHeader ( "Content-Length" , "3495" )); FormPostHttpBody request9Body = new FormPostHttpBody (); string [] rav = this .Context[ "$HIDDE ...Show All

• Community Chat Buying questions about Zune

  Hello! I am considering getting a Zune (I have no music player at the moment, and am willing to give Microsoft's music player a shot), but I am very concerned about it being a "1.0" product; how much upgrading can Microsoft perform on the Zune through firmware/software upgrades before Zune 2.0 is released (I guess I'm concerned about plunking down $300 for a music player this year, only to see a new, improved version of Zune come out next year...) Specifically, I am wondering if the list of supported video and audio formats will ever be expanded through firmware and/or software upgrades, or if those will require a new Zune product... I am primarily interested in listening to my CD collection (the subscription service doesn't interest ...Show All

• .NET Development Is it possible to serialize data in XML from a class containing a generic collection?

  Hello, I am trying to produce a serialized output of a class that contains some generic dictionary collections and I'm coming up against an exception. Is it possible to do this The exception is " There was an error reflecting type 'ConsoleApplication2.Container'. " I have created a small console application that gives the same error below. If anybody could help me that would be great. using System; using System.Collections.Generic; using System.Text; using System.Xml.Serialization; using System.IO; namespace ConsoleApplication2 { public class Container { public Dictionary<int, InputInfo> Data = new Dictionary<int, InputInfo>(); } public class InputInfo { public string Info = &qu ...Show All

• SQL Server Import from Data from Microsoft Access

  In SQL Server 2005, Im trying to append data to tables which already exist. Im importing the data through the import wizard. The source from is Microsoft Access with no username and password. The source to is SQL Server 2005 using OLE DB Provider SQL Server with the login information of the schema I wish to use. I click through and the tables appear in the source. When I select all, they appear in the destination but they appear with the dbo. prefix which would regard them as new tables since the tables dont exist under that schema. I can click on the first destination table drop down text box and see all the tables under the schema there suppose to be under but its not the default. There are a lot of tables and I don't feel lik ...Show All

• SQL Server Death of ODBC

  ODBC is not supported as a data source in SQL Analysis Services 2005. ODBC is not supported as a data source in SQL Reporting Services 2005 Model Designer. Any thoughts Joe With regard to Model builder - in SQL Server 2005 Reporting Services supports building models on top of Analysis Services and SQL Server 2005 and SQL Server 2000 data source.  This is not to be read as a 'death of ODBC', rather it reflects the significant effort required to support a particular data source for semantic modeling purposes.  Essentially what Reporting Services does under the covers is: 1) Evaluates the schema and content of the data source to determine what entities, attributes, and roles (r ...Show All

• SQL Server Bootstrapping SQL Server Express

  Can someone tell me if there is a definitive description somewhwere re how to get SQL Server 2005 to install from the same CD as a VB application. Despite the help pages that I found not mentioning anything about copying the files into the Bootstrapper\Packages folder, I found this in the forums. However, whilst Windows Installer and .net framework install ok, it still bombs out with SQL. I discovered that the old machine I was using to test on was a P2 and it needs P3 to work. A friend has now tried it on a modern PC and it wouldn't install for him either. Don't have the error codes yet. Is there anywhere that lists exactly which files need to be where and any other little hidden secrets Regards, Rich ...Show All

• SQL Server update flat file before import SSIS?

  Hi, We have a csv file which contains a date field. The data in the field contains "0" as well as "dd/mm/yyyy". Is it possible to update all "0" to "01/01/1900" on import using SSIS. Basically when we import the flat file now it falls over due to the destination table data type being datetime. If this is not clear please let me know and i'll try and explain more Thanks for any help. Slash. Thanks Phil, That seems to have done the trick, i've just done the destination to a flat file for a test and its correctly changed all dates matching "0" to to a date. Just one problem its turned all dates into "yyyy-mm-dd" and really ...Show All

• .NET Development How to pass the command to the other executable file?

  Hi, I'd like to make a gnuplot to load a file and do some commands in the file. I would like to use C#. I found that I could use in C#: Process.Start("wgnuplot.exe"); to call and run gnuplot, but I don't know how to pass the command for the gnuplot. The command I'd like to pass to gnuplot is: load 'command.gp' where command.gp contains some commands for the gnuplot. There are qestions: Is it possible to pass the command to the other executable file If it is possible, how to do it Thank you very much, Komomomo Actually, "wgnuplot" is a "gnuplot" but for windows, I believe. Your question is: Is there accessible source code of wgnuplot If this is correct, I think ...Show All