Marc Lacoursiere's Q&A profile

• SharePoint Products and Technologies Multivalued bdc column - a dream?

  I think (based on experiment and crawling through the internet) that this is impossible, but I will ask again - does anyone know of a way to make a BDC column multivalued I have a web service that allows people to seach for values from an external system, but they need to select more than one value. Please let me know if you know the solution. Thanks, Ishai Sagi Thanks, Ishai. I'll have to take a look at this. I still think a multi-value BDC lookup is very useful and I'm sure most people will start to ask for it as it is used more. Ultimately, I'd prefer not to have to sync lists with external datasources. Have you found a viable solution via API and custom controls yet ...Show All

• Visual Basic Opening File in textbox

  How would I open a file selected in an openfile dialog in a richtext box Thank You! I got that way to work, but i mustve have changed something because it won't give me any errors, it just won't load the file anymore and I can't fiqure out why. I've tried creating a new text box and a new OpenFile dialog to no avail. Any suggestions ...Show All

• SQL Server Sql 2005, x64 box, bad performance on data import

  We are importing 5 millon records from a legacy ssytem into sql 2005, x64 eiditon (box has 8GB of RAM, dual cpu, triple-bonded NICs). We are getting terrible perofmance (say 150 records/sec imported). We have not been able to determine the "bottleneck" I have set the database we are importing into to use "Bulk Logged" mode. We will see if this has any impact. Do you have any other general suggestions for the sql side for how to improve import performance TIA, barkingdog 5 mil records is not a big deal. DTS is definetely slow. Even slower with SQL 2005. I have had to move about 5-600 mil rows across tables. The quickest way would be to BCP OUT the data into multiple ...Show All

• SQL Server Local cubes connection

  Hello, I have created 3 local cubes which resided in the same .cub file. The cubes created from AS 2005 cubes. How can I make ADOMD connection to all 3 cubes at the same time in my client application (C#) The problem is that Initial Catalog (database name) in connection string in case of local cubes is the same as the cube name. Thanks, GB Still have the problem. My local .cub file created by XMLA script contains 3 databases with 7 cubes each. When I open this .cub file in MDX Sample application I can make a connection and MDX query to any of 3 databases and accordingly their cubes. But in my C# application when I try open connection to all local databases in a loop from the same .cub file I got the error just after ...Show All

• SQL Server Get The Last Record by Grouping

  I have a view listing tickets and reports for those tickets. I want to query LAST REPORT's OPERATOR SELECT OPERATOR AS EXPR2, NUMBERPRGN, IS_BITIS AS EXPR1 FROM SCADMIN.V_ESKALASYON_2 WHERE (NUMBERPRGN = 'IM1289657') ORDER BY NUMBERPRGN, IS_BITIS DESC That query brings the resultset IM1289657 OGUZY 04.12.2006 14:01:09 IM1289657 MUJDEO 01.12.2006 10:42:30 IM1289657 MUJDEO 28.11.2006 10:58:22 IM1289657 ILKERD 20.11.2006 14:36:12 IM1289657 ILKERD 13.11.2006 16:02:27 IM1289657 ILKERD 07.11.2006 14:02:21 IM1289657 ILKERD 31.10.2006 15:47:56 IM1289657 SINANK 19.10.2006 13:00:00 IM1289657 OGUZY 18.10.2006 1 ...Show All

• Smart Device Development Class Library for Compact and Desktop

  I want to create a business class library that will be used by both WM5 applications and desktop applications. The class library contains finance functions and the code will be completely independent of the device the application calling it is running on. The applications themselves will be different (at least on WM5 application and one desktop application). What is the best practice to create and manage the development of the class library. Should I just create a compact framework class library project and us it in both applications. Or should I create a compact framework class library project and a normal class library project and in each project include the same source code files -Darrell Either ...Show All

• Visual Studio Team System Send notifications to other roles

  Hi I'm Business Analyst creating the scenarios, one of the sub-Activities of Prioritize Scenario List says: "Send a notification to the project manager and developers requesting general estimates for the top scenarios." Is there any automatic way to send the notifcations to the other roles How is it solved Thanks in advance Javier There is nothing automatic or out of the box, but you can do it based on event subscriptions of Team Foundation to send emails or any other kind of advise, based on the creation of specific work item, for example. ...Show All

• Microsoft ISV Community Center Forums SeriesCollection(i).Delete

  Hi, I added some series to a chart and .seriescollection.count results = 6. That's OK. Now, series(6) references to empty cells. I want to delete the series but that's not possible. Err. 1004. Series with data can be deleted without problems. How can I access the series 6. Chris Hi, Empty cells certainly cause problems when dealing with charts via the object model. A way around the problem is to change the chart type. Column charts are quite happy of empty data series to be deleted. With ActiveSheet.ChartObjects(1).Chart With .SeriesCollection(6) .ChartType = xlColumnClustered .Delete End With End With ...Show All

• SQL Server Installation of Multiple named instances in Cluster environment

  Hi All.. We are planning to build a cluster environment on MS SQL 2005. We want to install multiple named instances in a single database server and use cluster for that database server. Is this option possible Any relevant documentation would be helpful Thanks in advance Regards Madhav here is some supplemental information to Books Online that was recently published: SQL Server Failover Clustering White Paper http://www.microsoft.com/downloads/details.aspx FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en ...Show All

• SQL Server Reporting Services in SQL 2000

  I would like to learn/more, practice creating and using reports but I don't know if I can do that on my home laptop with version 2000. I know, I know... upgrade to 2005. Can't do that due to technical difficulties on my other pc. Can I do this with my current setup thx Kat Hi, I should get my xp professional laptop back this next week and I will have the Developer edition of SQL Server 2000 soon to be upgraded to 2005. You say I need IIS installed which I understand, but is VS.Net 2003 a free product or does this have to be paid for thx, Kathleen ...Show All

• Smart Device Development WebService calling from Pocket PC

  Hi all, I have created a hello world web service. I can access using web browser like - http://localhost/TestWebService2/TestWebService2.asmx That is good. I created an Windows application to call that web service. It worked fine. I copied that windows application to other computer in the same network. That windows application worked fine in that computer. It could call that web service from that computer. I created a Pocket PC application to call that web service. I run that PPC application from my Pocket PC which is in the same network as my desktop computer in which Web service is running. I got an error. System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection ...Show All

• Visual Studio Express Editions How can i send multikeys to program?

  Hi ; i have a shutdowning program i did by myself. i want to do that: when clikc Close me button. setting the timer. it's ok. but i want to lock the windows like when we press WinKey Right + L i write like this. but nothing happenes... Could you say my error SendKeys.Send("{WINR}{+}{L}"); thank you so much. Hi, SendKeys is to send keystrokes and keystroke combinations to the active application . For example: SendKeys.Send("%{F4}"); mean to shut down the application. Here is the reference about the method: http://msdn2.microsoft.com/en-us/library/system.windows.forms.sendkeys.aspx To register system-wide keys, pls check the RegisterHotKey in win32 api. Thanks ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Video/Animation Playback

  Hi, I'm currently writing a library (for XNA/DirectX) for animation/soundless video playback, and I have a few design questions for the pros out there if you don't mind answering them : I'm having my animation class inherit from game component, and update the frame depending on game time in the overriden Update method, and render it in the overidden Draw method, but even when I preload my textures to render, playback is choppy. Not sure exactly why, but I notice this only when I have significant number of frames (I noticed it with 100 frames, but *not* with 10/15). This problem may be linked and solved by the 2nd point, so please read on. When I preload all the textures for the frames in the animation (and the no. of frames ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Problem with the default Windows Game in XNA

  When I go in debug mode, what happens is that it fails, and the problem is caused by this: this.GameComponents.Add(this.graphics); If I remove, however, the program does not work as it should, as all it does is display a grey screen that doesn't refresh itself. What's wrong with it For hardware info, I'm using an Inspiron 1000 laptop, with a SiS M650 graphics card. I know it's not because I'm missing a file, because I have downloaded Visual C# and the XNA Game Studio Express. From here , the chipset only supports DX8. Time to upgrade. ...Show All

• Visual J# draw a graph with J#

  Hello I want to draw a temperature graph on aWindow form with J# but I don`t know how can I draw something with J# on a Window Form. So could you help me please. Thanks Mayer Thomas Hi Thanks for your help but now I have an other problem. I want to draw the graph on a new Window Form. The new Form should be open when I click on a button of my first Form. But when I click on the button I got an Exception: InvalidOperationException The code: private void temp_vor_Click(Object sender, System.EventArgs e) { Application.Run(new Thermo_V1._0.Form2()); } Could anybody help me ____________________ Thanks Mayer Thomas ...Show All