Gregor Suttie's Q&A profile

• .NET Development Microsoft Office 12.0 Access Database Engine OLE DB Provider

  I am accessing Data from Excel 2007 that needs the above mentioned provider. My question is that What minimum Office 2007 components will suffice to install the Microsoft Office 12.0 Access Database Engine OLE DB Provider on system, or did microsoft release any MDAC like compnents to install this. Thanks in advance... Atul I'm not certain that this is the right forum for your question.  This forum is for .NET Framework setup issues.  Can you describe in greater detail what you're trying to do   It seems like you're trying to pull data from Access into Excel.  Is that right Have you tried contacting the Excel, Access, or Office technical support forums ...Show All

• Silverlight (formerly WPF/E) Clipping an animation

  I have a rectangle that I'd like to move from an off-canvas location to a location on-canvas. No problem... Except I'd like it to appear to 'open' out of a space on the canvas. Hard to explain without showing, but I'll try. Let's say the final location of the rectangle is (0,0) to (100,100). The rectangle starts out off-canvas to the right. I want to slide the rectangle to the left on command (not a problem), but I only want to see the rectangle once it gets inside the rectangle it will rest at. It will appear to open up in that rectangle from the right-hand side. My thought was to add clipping to the Canvas, but it didn't work (or I did it wrong). This is a little weird since the canvas itself has a Canvas.Left ...Show All

• SQL Server Extremely Poor Performance - Identical DB's but very different performance

  Hello Everyone, I have a very complex performance issue with our production database. Here's the scenario. We have a production webserver server and a development web server. Both are running SQL Server 2000. I encounted various performance issues with the production server with a particular query. It would take approximately 22 seconds to return 100 rows, thats about 0.22 seconds per row. Note: I ran the query in single user mode. So I tested the query on the Development server by taking a backup (.dmp) of the database and moving it onto the dev server. I ran the same query and found that it ran in less than a second. I took a look at the query execution plan and I found that they we're the exact same in both cases. Then I too ...Show All

• Windows Forms How to use key Enter instead of Tab in DatagridView

  By default, datagridview in Winform use Enter to move focus to next row(move to cell below the current cell) and Tab to move focus to next cell in the same row(but cannot move to row). How can I make all operations use the Enter key and the current cell will move in path like shape "Z" I have tried events of datagridview like KeyDown, CellValidating, CellValidated ..etc, but fail. Anyone can help Thanks. Alternatively you can also do this: creating custom grid with enter key : Public Class DGV Inherits DataGridView Private Const WM_KEYDOWN As Integer = &H100 Private Const WM_KEYUP As Integer = &H101 Private Const WM_CHAR As Integer = &H102 Public Ove ...Show All

• Internet Explorer Development Customizing Toolbar in IE7

  I am having a small problem. I have TWO search boxes on my browser.. One for Google toolbar, and the one that was originally there on IE7... I set my default to google. I cannot find how to get rid of the original search bar (to the right of the address bar) and just keep the google toolbar search box.. There is no option that I can find to just have the top row be an address bar..Any suggestions.. I cant even tell google toolbar to take away its search box, it is automatic.. It is ridiculous to have TWO search boxes on the toolbar.. Anyone know a way I've tried everything I know.. Thx JP Yes there is. It is a simple registry change: http://www.intelliadmin.com/blog/2006/12/remove-search-bar-from-ie ...Show All

• Internet Explorer Development IE 7 back button option

  I'm opening the crystal report in IE 7. When I right click in the browser and click back on the meno opened it does not take me to the previos page. Rather it redirect me to the same page. But if I click the down arrow beside the back and forward button and click the approriate option it takes me to the previous page. How can I make it possible with clicking the back on the menu opened with right click and it takes me the previous page. Even I am facing the same problem with IE7. Added to that I noticed, a ' ' sign gets added with all the URLs I type. Say, if I type http://www.google.com , I get http://www.google.com/ Is it a Virus Please Help.. ...Show All

• Visual C# Allocating memory throws exception when trieng to use native code dll

  Hi, I need to use a native code dll in my application. I am working on .NET2 env, written in c#. When I try to use the Init method in the native dll, it throws the following exception: "Attempted to read or write protected memory. This is often an indication that other memory is corrupt." I know this method supposed to open a com port and allocate a block of memory. I wrote a .NET wrapper for this dll. The h. file of this native dll includes 2 structures: 1. typedef struct ALARMREC { int Flag; int AlarmType; int AlarmUnitNum; int AlarmUnitWing; int AlarmLocation; int AlarmDelayFlag; char AlarmTime[20]; }alarmRec; 2. ...Show All

• SQL Server RS 2005 Prompting for Credentials

  For the life of me, I can not get integrated windows authentication to work with an installation of Reporting Services 2005. I get prompted when connecting to the /Reports IIS virtual directory when not on the IIS machine. If I'm logged onto the machine I don't get prompted. Or if i use the IIS servers IP address in the URL I don't get prompted. The only way I can avoid windows prompting (when not logged onto the IIS machine) is to set the /Reports virtual directroy to "Enable Anonymous Access" I know Windows Integrated authentication works because we have other web applications where Anonymous access is turned off, and everything works as expected. Meaning going to another server for database access thos ...Show All

• Windows Forms How to tell (event) the user changed a bounded value

  I hoped to use CurrencyManager on a bounded table to tell when a user changes a value. (IsDirty state) Instead of having an event for each control bounded for the same table. Any one knows what the trick is Sorry I should have said ItemChanged Event. Public Class Form1 Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim dt As New DataTable dt.Columns.Add("Name") dt.Columns.Add("State") dt.LoadDataRow(New Object() {"Ken", "Florida"}, True) dt.LoadDataRow(New Object() {"Cor", "Holland"}, True) DataGridView1.DataSource = dt Label1.DataBindings.Add("Text", dt, &qu ...Show All

• Visual Studio Express Editions code not associated with a button

  I need to have code that collectes UDP frames from another computer (port 1234). I found some examples but the code is not part of a button. I have yet to find anything telling me how to add code that is not associated with a button. The code example is here: http://www.codeproject.com/vb/net/Silence_Socket.asp But it does not tell me where in the project/solution to put it. What window do I open and how do I open it How or what starts running the code Thanks for your time Hello ahmedilyas, I suspect you are overestimating my knowledge. You say where I put the code is up to me. But if I paste it in below some code that was automatically written for a button, I get errors. And if I did not get the errors, what wo ...Show All

• .NET Development Regex / string processing

  I'm working on an app which interfaces to the ebay system, i'm getting the following format of string returned for time left P4DT19H23M36S This above example means 4 days, 19 hours, 23 minutes, 36 seconds left What I need to do is extract the four numeric values from the string, whats the easiest way, I thought regex but never used one! Or could I get an array of the numeric values something similar to string.split Or is there a better way Any help appreciated. (Moderator: Thread moved to the Regular Expression Forum) MondeoST24 wrote: Save regex for another day! Here is that day...and a regex to get you started. What the regex does is look for a pattern. Since the ebay tag has anchors ...Show All

• Visual Basic Setup Produced By "Build, Publish" Gives Error After I Uninstalled VB With CD And 'Removed' All Installation CD Programs

  Hello, I created a setup file from my application. I did this because I want to put my application on other PCs without installing Visual Basic. I basically want to just run the applicatoin on other PCs. What I did to create the setup file was within VB I clicked "Build" then "Publish." I then wanted to test the setup file on my PC, so I removed everything given to me by the VB installation CD! So, I uninstalled VB using the installation CD. But, I also had to go to the control panel to remove some of the programs that the installation CD gave me. I did this because the uninstall via the CD left things on my system that the installation CD gave me. When I was done, the control panel, remove programs listing ...Show All

• Visual Studio Tools for Office Outlook Automation and Outlook Addin

  We're writing a robust Outlook Addin to act as an agent for a business app. The addin will detect when an event occurs on items with specific custom properties, and will synchronize the changed data to the other application through (local) remoting. We have a need for the application to create a new appointment through automation, set some custom properties, and then open the item in an inspector. The add in will detect when the item is saved, and communicate the appointment details back to the application. Some of the addin's startup routines work with properties that would not be accessible through automation -- contact stuff, email addresses, etc. What I'm seeing is that if I start Outlook through automation some of my startup rou ...Show All

• SQL Server How to use CLR security ..Impersonation to access external resources?

  I want to Access External resources inside the CLR Code... But I am getting Security Exception I have marked Assembly with External Access... here is the way I am doing.. I read articles and MSDN .. everywhere is written to use impersonation like using ( WindowsIdentity id = SqlContext .WindowsIdentity) { WindowsImpersonationContext c = id.Impersonate(); //perform operations with external resources and then undo c.Undo(); } In above case .. I tried both Windows Authentications and SQL Authentications ... In case of Windows.. I am have a domain login to logon to my pc, while sql server is at another machine and Active directory is at different machine .. when connect to Database .. it says cannot fin ...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