MagedSalah's Q&A profile

• SQL Server SQL 7.0 Compatibility &/or Linked Server Parameters

  Hi, don't know if anyone can help me but I desperately need to roll a report out which relies on an SQL 7.0 datasource. Current situation - Reporting Services 2000 up and running on an SQL 2000 box - no problems getting reports to run from the native machine but I cannot get the thing to make a hop to our SQL 7.0 box. I've created three data sources - OLEDB, Native and ODBC. For the OLEDB and Native I am getting a DATABASEPROPERTYEX error - I assume here that reporting services is polling the SQL 7.0 box with an unsupported method. For ODBC I CANNOT get the parameters to work - I've read all sorts of stuff about using unnamed parameters, so I've put a in the query and I'm getting Invalid parameter number and invalid parameter numb ...Show All

• SQL Server SQL Agent Job to refresh Analysis Services Cubes

  This was a very easy task in SQL 2000, but I can't figure out how to create a job that will process AS cubes in 2005. Does anyone have a reference for how to set this sort of thing up in SQL 2005 Edward, You are awesome!! That worked perfectly!! Thank you very much for your help! Alan ...Show All

• Visual Studio Team System TF30177: Team Project Creation Failed - Unnable to connect to Sharepoint

  I have been getting this error over and over, regardless of what I try: Error Unable to connect to the Windows SharePoint Services at 10.61.70.50 Explanation The Project Creation Wizard was not able to connect to the Windows SharePoint Services at 10.61.70.50. The reason for the failed connection cannot be determined at this time. Because the connection failed, the wizard was not able to complete creating the Windows SharePoint Services site. User Action Contact the administrator for the Windows SharePoint Services at 10.61.70.50 to confirm that the server is available on the network. Also, you might find additional helpful information in the project creation log. The log shows each action taken by the ...Show All

• .NET Development XmlSerialization with Interfaces

  I'm trying to serialize a class that exposes a property as an interface. When I try to serialize the instance of the class the XmlSerializer throws an InvalidOperationException with the following message: {"Cannot serialize member SerializationTest.ParkingLot.MyCar of type SerializationTest.ICar because it is an interface."} This may seem like a silly question but is this true I've never ran into this before and I use interfaces pretty extensively in my designs. Can the .NET XmlSerializer not handle interfaces Thanks! Jeremy You can not serialize an interface. The problem is that an interface is an opaque type. There is no way for the serializer to know what to write out and more importantly what to create when ...Show All

• Visual Studio 2008 (Pre-release) ADO.NET vNext Entity Designer Problem

  This is quite possibly a stupid question, but because I'm not used to creating an EDM in this manner... I created a new EDM called MyModel, generated it from the database, everything compiles... Here's what I can't figure out - I don't actually have a generated class called MyModel in my app, so does anyone have a quick syntax snippet of how to run a LINQ to Entities query off the designer-modelled EDM called MyModel Thanks! Hi! Kevin, Section 2.3.5 in the overview document has a description of how to add an Association relationship between two entity types in the designer. Please can you take a look and let us know if it satisfies your scenario To summarize, you can click on the Association tool in the VS toolbox and "dr ...Show All

• Visual Studio Tools for Office Remove delegate from Item.Read and Item.Open

  the following code, adds the delegate to the Read of the Item, but doesn't remove it, why MailItem Item = new MailItem(); ItemEvents_10_ReadEventHandler handler = new ItemEvents_10_ReadEventHandler(Connect_Read); Item.Read += handler; Item.Read -= handler; Hi, I have re-posted your question to an Exchange newsgroup http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.exchange2000.development&lang=en&cr=US Regards, Darryn Lavery [MSFT] ...Show All

• .NET Development SQL statement problem in vb.net 2003 & sql server 2000

  This normally would work fine in vb6. but now after switching to vs.net, i am getting problem with my sql statement. Private Sub ComboBox1_SelectedIndexChanged( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged Dim csql As String csql = "SELECT UnitPrice FROM(dbo.items) WHERE item LIKE '" & Me .ComboBox1.SelectedValue() & " ' " lblUnitPrice1.Text = csql End Sub Uf, I've missed that completely. Well, you can't display sql statement, ok, you can, but then you see sql statement on the screen. You need to execute SqlCommand.ExecuteScalar (passing csql) to get the value fetched from sql server. And before that you need t ...Show All

• .NET Development Excel and ODBC

  So I'm using ODBC to connect to an Excel spreadsheet. I use an Adapter with the simple SELECT * FROM [Sheetname$] to fill a DataTable. The problem is the DataTable doesn't fill correctly. I went ahead and just attached the DataTable to a DataGridView and noticed there were missing values. Specifically where values above them were different. Ex. Value in [4][4] = "1/1/2002". Therefore it expects every value in [x][4] to be a date. Entire columns of data are missing I'm guessing because they didn't match the first data type encountered in that column. Is there a work around for this No, I don't want to use COM. They do not want to have Microsoft Office installed simply to use this application. This is why I'm using OD ...Show All

• Software Development for Windows Vista Seeking doesn't update

  I'm using C# and directShowLib. The software implements a simple seek bar as outlined in the MS documentation. The app. pauses the VMR9 filter in windowless mode and uses the IMediaSeek interface to let the user scrub through the video. It works great on my laptop, but not on my desktop. On the desktop, the play and pause work, and you can move the slider to a location and resume play from that location, but scrubbing doesn't work. It seems that on the desktop, the IVMRWindowlesControl9.RepaintVideo(..) doesn't not update the display while the graph is paused. Any suggestions how I can get scrubbing to work on the desktop VisualStudio 2005, C#, DirectShowLib4.1, XP SP2 on both machines. Greg ...Show All

• Visual C# How do I use a subset of columns from a DataSet to fill a DataGridView?

  Hi there, I have a DataGridView with 5 columns on a Windows Form, that I have filled from a matching DataSet, and that's working fine. If I want to expand my DataSet for other purposes, how do I go about binding my DataGridView to only the 5 columns that I require on this particular form TIA, JackStri. Thanks Mark, Yes, that's an option as well. What I have done in the meantime is created a second DataSet that contains a subset of the first one, and then used that for the binding. It seemed the shorter option rather than approx 40 hide statements! Thanks again, JackStri. ...Show All

• .NET Development VS 2005 Pro - App. won't run on network drive (W:) - System.TypeInitializationException was unhandled

  The compiled application (*.exe) works fine on the local drive C:, but doesn't work on the network drive W: (no forms and no diagnostic messages appear). Visual Studio 2005 Pro compiles (without any warnings) and runs that project just fine on the local drive C:. But when I copy the whole project to the network drive W: and run (F5), an error message appears: System.TypeInitializationException was unhandled Message: The type initializer for 'yf_test.yf_main' threw an exception. Any thoughts on that Thanks! This sounds like a security permissions problem, follow the steps on the following post to see if this fixes or identifies this as the problem: http://forums.microsoft.com/MSDN/ShowPo ...Show All

• Windows Forms [EDIT] PtrToStructure bug in xp x64

  I have an old control I wrote, that worked in 1.1 but doesnt anymore (actually it does, but marshals some interop stuff wrong). its the SysIpAddress wrapped into .net, and one of the events isnt comming out right. in my WndProc: protected override void WndProc(ref Message m) {     if(m.Msg == (WM_REFLECT + WM_NOTIFY)) {         NmIPAddress ipInfo = (NmIPAddress)Marshal.PtrToStructure(m.LParam, typeof(NmIPAddress));         if(ipInfo.Hdr.Code == -860) {              if(values[ipInfo.Field] != ipInfo.Value) {                 values[ipInfo.Field] = ipI ...Show All

• Smart Device Development Transparent images inC#.NET Compact Framework

  hi, I'm want do put some images with transparencys in a Pocket PC 2003. I had tried everthing, png, green background, gif, etc... And I steel cann't make the images appear propely... Can anyone help me ! Sorry, my bad. This is actually more of UPNP sample. It does not do much wrt transparent drawing. Transparency is actually discussed in my blog: http://blog.opennetcf.org/afeinman/default,date,2006-02-03.aspx ...Show All

• Visual C# c# InvalidProgramException

  Hi, I am auto-generating large (but simple) blocks of C# code, compiling to a dll then loading the dll via reflection. This seems to work fine for smallish test cases, but when generating larger programs otherwise similar code decides to throw the InvalidProgramException. The c# compiler version is 8.00.50727.42 from the .net framework sdk v2.0.50727. Is there an updated compiler I can try If not is there an appropriate place to report the bug with an example Cheers. Andy. I know this is an old thread but this issue just hit me with a code generator I'm working on this is the first thread I've found on the subject. I'm pretty sure I've hit some soft limit on how many instructions a function can have; the ...Show All

• Audio and Video Development How can I hide picture in DIV?

  I have following problem: I write DIV tag in XMU file: <div id='animation' style:position="absolute" style:x="0%" style:y="0%" style:width="20%" style:height="20%" style:backgroundColor="rgba(255, 0, 0, 220)" style:opacity="0.86" style:backgroundImage="url('Pages/pic.jpg')" style:contentWidth="scale-to-fit" style:contentHeight="scale-to-fit" >.... </div> By default "style:backgroundFrame" attribute equal "0" and I see "Pic.jpg" picture. I tried to set style:backgroundFrame at "-1" and "1000" but I anyway see picture. How can I hide picture in DIV without remove (or change ...Show All