nbrege's Q&A profile

• SQL Server How to query an remote excel file using OPENROWSET

  Hi, can anyone help me out this problem. i want to query an excel file which at remote location through openrowset. Select * from openrowset(.... thanks thanks a lot i need more clarification for the same. if the excel file is kept in a remote mechine then i need to access the same ( \\ipaddress\foldername\xlsfilename.xls ). the same query will work if i give like this ...Show All

• Windows Live Developer Forums Problem with PageDriving

  Hi, i have tested the page driving(to launch an url in the same window as the conversation window, e.g. encarta bot) and it works, but i dont know why, sometimes i call the function to launch an url, it says on the msn messenger: MSN Messenger is currently unable to start this program. Please try again later. and this happens a lot of times, other times i can launch it with no problems, what can be the problem it can be because is the demo bot, and when i pay for hosting and for msn this problem should persist thks erick You are using the Colloquis Buddyscript SDK and the sample that Francois provided right   Where do you live   Messenger displays that error when it cannot find the page that was requested. I h ...Show All

• Visual C++ LNK1104: cannot open file 'gdi32lib'

  Using "Build" menu on Visual c++ Express Edition of my first sample source I encountered the following error: LINK : fatal error LNK1104: cannot open file 'gd132.lib' How do I fix it Thanks, Ed. Have you set up your build environment paths in the Tools/Options/Projects and Solutions/VC++ Directories Mark ...Show All

• SQL Server Image .BMP only shows on first page, place holder on the rest

  I am printing a batch of Explanation of Benefits and the image only shows on the first page for each person. If they have additional pages all I get is the little red X. Thanks, Phil I wasn't clear on that from the initial post. It really depends on the report layout. From what you say I'm assuming that you have a list control that's grouped by person with page break option checked. In addition to that some users data spans multiple pages. What's confusing is that you mention that you get a red X (image place holder) but no image. Where is the image placed In the header, the body, a list control To my knowledge there are 2 things you can have repeated when paging: The overall report header The ...Show All

• Visual C# MeasureString with HTML

  I have a string of HTML that I would like to put in a tool tip, so I need to know what size I should make the tool tip (width and height). I use the following code, and sometimes it will measure the HTML string correctly, and at other times, it is way off. I think it might be becasuse of HTML tags like "<br />" which is only 6 characters, but when rendered it turns out to be one line. StringFormat sFormat = new StringFormat ( StringFormat .GenericTypographic); System.Drawing. SizeF sDraw = webMain.CreateGraphics().MeasureString(myText, m_Font, this .Width, sFormat); Any Ideas Thanks, - Jon Do you want to show the full Html code or only the 'rendered' output (the t ...Show All

• SQL Server Query RowVersion in SQL Server 2005

  Hello all, I am new at SQL Server 2005 and have been reading everything I canfind about the new optimistic concurrency control mechanisms. As far as I can tell, the Snapshot Isolation Level is based avoids the use of shared locks using rowversioning instead. To control rowversions in SQL Server 2000 I was using an extra column in each table containing a rowversion datatype. What i do with this is find out if a row was modified. Is it possible in SQL Server 2005 to avoid the use of this extra column, using the new versioning features What I mean is, if the Snapshot Isolation already manages rowversions in TempDB, is it possible for me to query those versions using some stored procedures or functions given by SQL Server 2005 system What fu ...Show All

• SQL Server Need help to build the MDX query please?

  I need help on how to do this in MDX query. I have an OLAP cube with the following structure as an example Measures: M Dimension A: Attritute 1, Attritute 2, Attritute 3 Dimension B: Attritute 4, Attritute 5 (date/time) Dimension C: Attritute 6, Attritute 7 I need the dataset with all the attritutes and measures of this cube for the Reporting Services. First of all Attritute 1 and Attritute 5 are the parameters (cascade prompt) for the report. Based on this parameters it will filter out the Attritute 6 to a smaller subset of the original data. Then I need to apply the Attritute 1 (again) and the "filtered" Attritute 6 to filter out the cube data with the condition that Attritute 5 is less than or equal to the Attritute 5 selected ...Show All

• SQL Server "No data exists for the row/column" (InvalidOperationException) after a number of reads...

  I've been looking around for some kind of known issue or something, but can't find anything. Here's what I'm experiencing: I have a table with about 50,000 rows. I open several connections and use a command to ExecuteResultSet against each command, with CommandType.TableDirect, CommandText set to the name of the table, and IndexName set to various indexes. In the end, I have several SqlCeResultSet instances which are then maintained for the life of the AppDomain. In a loop, I call SqlCeResultSet.Read() on one of the instances, and if it returns false, I call SqlCeResultSet.ReadFirst() - essentially creating a circular pass through the result set. In a Visual Studio debug session, this approach goes swimmingly for a short time, and ...Show All

• Visual Studio Tools for Office Building Office integrated applications

  We have some applications that uses Office Interop's. We have downloaded the PIA's from Microsoft and references the Interop dll's that are included there. The problem occurrs when moving to a build server: In order to install the PIA on the build server, we must first install (at least one) Microsoft Office Application. While we can do that, this seems somewhat incorrect to install client applications on a build server in order to just make it compile. What is the recommended approach here In other projects we have created Interop-files manually be using the TlbImp tool. But with MS Office, we don't have a type library file. Regards /Jakob Hi Marcel, thanks for the response. Yes, we do ...Show All

• Visual Studio 2008 (Pre-release) Bitmaps on a toolbar

  I admit to being very frustrated right now. Will Expression ever be a useful WYSIWYG tool, or even a text editor as useful as notepad I am editing XAML in VS2005 right now, and using Expression merely as a preview. I have three panes in my app, and I can only edit one in Expression. Anyhow, that's my rant. Right now, I cannot work out how to put a bitmap into my app as a resource so I can add it to a toolbar Thank you, this is good feedback for the Sparkle and Cider teams. To be fair, the tools teams are working hard to expose the proverbial 80% scenarios and are still in CTP mode; it is likely something like this was not delivered in a particular CTP or is not on their plans. Now that the platform has stabilized and is feature-c ...Show All

• SQL Server Translation to XML (DAO/ADO)

  Hi friends, i want to know is there a possibility of translation to XML in DAO or ADO , I'm working with MS Access. Waseem Bahser , Thank you ))) Is there a possibility  in ADO or DAO  of conversating of whole database to XML I'm programming on VC++ (WinApi) and my database is MS Access, I was told that the best solution for the MS Access is DAO , but if there is no such possibility... Can I work with Access , using ADO or I will a have lot of problems with it ...Show All

• Visual Studio Express Editions Database connectivity using VBE

  Hello everyone; Hopefully you can help me with this little problem. I am working on a form that access a 2003 Access Database, and I am trying to get used to the new coding within VBE. However, my problem is this: I think I have the data connection set up, and I realize that there is a new way to include SQL into the code, just not sure how to get it to go to the database. I read that you need to use a "Rows" feature, but not understanding how to accomplish this. here's the code that I have so far, but I am at a loss as to where to go next Any thoughts I'm trying to have 5 fields saved to a database as listed below: Private Sub cmdSubmit_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ...Show All

• Visual C# Multi Interface inheritance

  Lets say you have two interfaces: interface IA: IComparable { int A {get; set;} } interface IB: IComparable { int B {get; set;} } and a class which implements both IA and IB class C: IA, IB { } class C now has to implement CompareTo, but the problem is that CompareTo should do different things if being used to compare this object to another IA, IB or classC. How do you implement the CompareTo function For instance lets say there is code like this: C c1 = new C(); C c2 = new C(); IA ia = c2; int comp1 = c1.CompareTo(ia); int comp2 = c1.CompareTo(c1); In this case, comp1 should equal 0 if c1.A == c2.A, and comp2 should equal 0 if both c1.A and c1.B are equal to c2.A and c2.B. Since you can only have one CompareTo method on class C how do ...Show All

• SharePoint Products and Technologies Site and Sub Site List Aggregation

  Is there a way to get all items for any given list (ie Contacts) for all sites and subsite using a single web service call Right now I am getting a list of all sites using "GetAllSubWebCollection" web service method, then for each site get the items for a given list. This is taking a very long time, can I execute a query from the root site and get this same list Thanks no, its not. Basically, the search engine isnt the way to go at all, but instead you will have to use custom code (build your own web service for example) that will run a recursion on the sites. A CAML query on each list will return the items you want and you will be able to aggregate. but instead of doing that, I would ...Show All

• Internet Explorer Development IE7 on Windows Vista Business Edition

  Hi all, I have bin experiencing some problems with IE7 on Win Vista Business Edition. I seems like web pages that contain flash animations are not displayed properly. Here are the images of the MS Home page: http://unclezen.com/Documents/ie_maximized_window.gif http://unclezen.com/Documents/ie_maximized_window_w.gif Interestingly enough this is how the same page looks when the same window is restored: http://unclezen.com/Documents/ie_restored_window.gif http://unclezen.com/Documents/ie_restored_window_w.gif Two more examples: http://unclezen.com/Documents/ie_maximized_dell_home_page.gif http://unclezen.com/Documents/ie_restored_dell_home_page.gif As well, any other action like moving the mouse over an link will c ...Show All