Yaakov Ellis's Q&A profile

• SQL Server Another Major Flaw with Reporting Services!

  Where is the text (.txt) export functionality I don't see any ascii text export mechanism without the .csv extension. Where is actual .TXT file of the reports. How do I get a .txt conversion out of the reports without messing with the .csv files. I would've wanted direct .txt export from the generation mechanism. This seems extremely basic form of reporting generation. I can't believe you can't get txt report out of reporting services. Enkh. Ok that's great, but the bottom line is that there should be another feature in the export dropdown for text, and text generation with some decent layout except the coma delimited text export. I mean something close to the actual report. I think text gen ...Show All

• Windows Search Technologies How do you get the Desktop Search Bar to show?

  I am trying to figure out how to work this thing. I can not figure how to get the Desktop Search Bar to show on start bar. Can anyone give me some insight as to where I can get a Getting Started paper for this thing or tell me how this works Thanks Greg Forster I'm having exactly the same problem, doesn't seem to be any info anywhere. I've installed and reinstalled, tried to open WDS manually from C drive. Nothing. WDS does not show on the taskbar or anywhere on the computer, aside from an installed program. There's no indexing going on, nothing. It just doesn't work, and isn't there. ...Show All

• Visual Studio 2008 (Pre-release) Page Flip Effect?

  I have seen demos where content has changed through a page flip technique - where the user drags the corner of the page and flips over to the next page... Does anyone know how to do this its in the wpfe sdk http://msdn2.microsoft.com/en-us/asp.net/bb187358.aspx also you could take a look at http://11011.net/archives/000661.html ...Show All

• Visual Studio Tools for Office VSTO and Microsoft Office

  I am having trouble getting VSTO to work. When I go into Visual Studio to create the project I get a cryptic error telling me to check for disabled items in Excel (I have none) and then it instructs me to reinstall VSTO. A classmate suggested that it is because the University edition of Office (Microsoft Office Professional Enterprise Edition 2003) is crippled. Can anyone confirm if this is so Thanks, Michael I'm glad to hear that. I was trying to research an answer, but not coming up with other examples of this behavior. Just in case it helps, here's a theory from one of the main developers: "I think the cause might be that he has a managed COM Add-in registered for Word/Excel and thi ...Show All

• SQL Server ability to use variables in package configurations and set their values at runtime

  Hi, My scenario: I am using a FTP Connection Manager and the configuration setting for it is being set in the package configuration xml file. So the xml file contains the Ftpserver, FTp server username and password. The package is picking up the values from the xml file and is executing successfully. I have to do this because I was not able to provide an expression to the Connection Manager Server Password property. Now, I want to pick up the ftp details from a database table and set it in the xml file during runtime. Is this possible OR something like using the <Configuration ConfiguredType="Property" Path="\Package.Connections[FTP Connection Manager].Properties[ServerPassword]" ValueType=" Variable "><ConfiguredValue ...Show All

• SQL Server Lost SQL Logins, but still have DB logins - Script to recreate SQL logins?

  ok, first, I know... I forgot to run a backup of the master database, and I forgot to run a script to caputure logins. Not that that is out of the way... I need to recreate the logins under the Securities tab below the databases. All the company databases have the user names and passwords assigned to them, but they are not able to login, because they are not able to authenticate to the SQL server first. Is there a script that someone has that will copy the company database security info for the users and recreate them in the SQL security tab I know that I can rebuild them manually, but I need to delete them first in the application software, then delete them from the databases, and then recreate them in the application software... an ...Show All

• Visual Basic Problem with checking an object is nothing

  I'm currently building myself a new object class and am having a problem checking wether an object has been instanciated or not. I'll show the code then i'll explain whats ment to be happening Private objRiskInformation As RiskInformation Public ReadOnly Property RiskInformation() As RiskInformation Get If objRiskInformation Is Nothing Then objRiskInformation = New RiskInformation objRiskInformation.getAccountRiskInformation(intID, strDBConnectionString) End If RiskInformation = objRiskInformation End Get End Property This property is in my main class and is ment to allow access to the risk information ...Show All

• .NET Development XML File Storage

  I have designed a Windows Form database and I currently store my data in memory. Now I am looking to store data from a windows form database into an XML file instead of memory. I will need to read and write data to this file and possibly delete it. I have checked around but i am not finding many clear answers. Can someone please help as this is driving me crazy !! Thanks If you are looking for storing a dataset or datatable into an XML file and you are using ADO.Net 2.0. You can use the functions of the mentioned classes. DataSet.ReadXml(filePath); Dataset.WriteXml (filePath); You can also look at the Walkthrough: Reading XML Data into a Dataset . edit: If you are storing much data think ab ...Show All

• Windows Forms Question about HandleDestroyed event

  Hey guys. Under what circumstances is HandleDestroyed called Is it only called when a control is being Disposed I sometimes get the following exception in my app: UnhandledThreadException, Exception='System.NullReferenceException: Object reference not set to an instance of an object. at System.Windows.Forms.ListViewItemCollection.get_Item(Int32 displayIndex) at System.Windows.Forms.ListView.OnHandleDestroyed(EventArgs e) at System.Windows.Forms.Control.WmDestroy(Message& m) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ListView.WndProc(Message& m) at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m) at Sy ...Show All

• Visual Studio Team System Data Dude on Windows Vista Broken

  I'm trying out Visual Studio 2005 on Windows Vista. I've installed Visual Studio Team Suite including Team Explorer and Team Edition for Database Professionals. I then installed VS 2005 SP1 and the VS 2005 SP1 Update for Vista Beta. I then created a new SQL 2005 Database project and attempted to build it and Visual Studio just crashes. I've tried adding some schema objects, adding no schema objects and every time it builds it crashes. I followed the steps found in the short video describing how to setup the schema validation database (I'm running SQL Server 2005 Developer Edition with SP2 installed). Has anyone successfully run VSTEDP on Vista If so what configuration (what product versions and what order were they installed) did you use ...Show All

• SQL Server MDX to aggregate measure over specific dimensions

  Hi, I'm trying to write a calculated member in SSAS 2005 that will only aggregate across certain dimensions. For example, say I have five dimensions: D1 - 5. I only want the member to aggregate across three of these dimensions. So in the cube browser, when I drag these three dimensions in, I get the correct aggregated value. But when I then drag dimensions four and five in, I want this value to stay the same. (The measure is currently in a measure group that uses all five dimensions). I was thinking that the solution would be to have an MDX expression of the form ([Measures].[Measure], [D1].CurrentMember, [D2].CurrentMember, [D3].CurrentMember, [D4].[(All)], [D5].[(All)]) but I would prefer not to have to list all dimensions and their hie ...Show All

• Visual C++ Some DLLs load, others won't

  Hello. I've been trying to display dialog boxes from two different DLLs. AfxLoadLibrary() loads the first DLL fine; with the other DLL, I get an error that says the DLL cannot be found. The thing is that I know the paths to both DLLs are correct, because they're both in the same place. Also, a resource-hack program I have loads both DLLs fine. Any ideas Here's my code, sans all the error-checking: p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:'Times New Roman';} h1 {margin-top:12.0pt;margin-right:0in;margin-bottom:3.0pt;margin-left:0in;page-break-after:avoid;font-size:16.0pt;font-family:Arial;} p.ListingHead, li.ListingHead, div.ListingHead {margin:0in;margin-bo ...Show All

• SQL Server Exclude duplicate records

  Hello I'm developing my fist Integration Service and I have this operations: Reading from a XML Check for duplicate records and discard them Insert the result into the database The XML I don't control and could came with duplicate records that I have to discard. How can I find them I want to find the duplicates in the XML and not in database. tkx for the help Paulo Aboim Pinto Odivelas - Portugal Do you want to exclude all records that are duplicated, or just return one row where there are duplicates In other words, do you want to return 0 rows or 1 row -Jamie ...Show All

• Visual Basic How to insert data (probably simple question)

  I am quite newbie and I have one, probably simple question. I try to insert data into my database (SQL Server 2005) with this code (VS .NET 2003): Friend Sub Datainsert(ByVal Name As String, ByVal Surname As String, ByVal DateOfGame As Date) Dim ConnectMe As New Odbc.OdbcConnection ConnectMe.ConnectionString = "Driver={SQL Native Client};Server=localhost;Database=ProjektKoncowy;Trusted_Connection=yes;" Dim Writeit As New Odbc.OdbcCommand("INSERT INTO ProjektKoncowy.dbo.Wyniki (Name, Surname, Points, Status, DateOfGame, KindOfGame, Autor) VALUES (Name, Surname , ' 3 ', ' 1 ', DateOfGame ,' 4 ','John Smith')", ConnectMe) Writeit.Connection.Open() Writeit.ExecuteNonQuery() ConnectMe.Close() End Su ...Show All

• Commerce Server Question on pipelines

  Hey Guys, I just want to know the inherent benefits of implementing my custom payment method in a pipeline as opposed to the standard convention of calling classes and methods explicitly - using assemblies. I'm not too sure i get the whole picture of how pipelines are going to make life better. Kind Regards, John John, The pipelines are meant to execute a set of uniform business logic on all orders, such that every order placed on the system uses the exact same entry point to calculate taxes, check discounts, validate inventory, et al. To be fair, I don't know that there is any performance benefit from using pipelines instead of runtime methods/classes, but the product team should probably clarify ...Show All