jvallier's Q&A profile

• SQL Server SQL Reporting Services Web Service SLoooowwwwww

  Okay here is my delema, i got this great query nice and tune that brings back 2280 records in 3 second... im like great so when i try to run the report the blasted thing times out... my query is super optimized and i got my indexes lined up... so the only thing else i can think of is the web service call... and i am running a reporting web farm... i got 4 web servers infront of this 1/2 TB datawarehouse... and i only do 3 joins in my query.... any ideas or thoughts please let me know... thanks You probably already thought of this, but in the Report Manager, Execution Properties (under Report Properties), what is your Report Execution Ti ...Show All

• Windows Forms designer view causes vc# to crash - please help

  Hello everyone! Im a newcomer to .NET and C# and recently (about a month back) I had started using visual C# express edition 2005 beta . It worked just fine uptil about a couple of days ago. Two days ago, I started vc# express and chose 'New Windows Application' under File->New->Project. (1)Now, earlier this would have meant that the design view would have showed up. However,now vc# just opens a new project,displays the property window for the new project's form and does NOT display the form at all . If I choose form1->designer view , then vc# crashes with the following message- "An error report is being collected.This could take s ...Show All

• Visual C# Incorrect File Tab Insertion

  I am using Visual C# 2005 Express Edition and when in the text editor when I open a new file it puts the tab in the tab group on the left-hand side. How can I change this so it puts the tab on the right-hand side, just like it does in 2003 or even like the task bar, which when you run a new program it adds it on the right-hand side Thanks James, that has clarified it for me. Even though I understand the reasoning behind the change I still think that its a big oversight not to be able to have it work as it used to, especially as the text editor is the area that you spend most of your time in. The c ...Show All

• SQL Server I have an error while connecting to sql server 2005

  When I try to connect to server in SQL Server Management Studio TITLE: Connect to Server ------------------------------ Cannot connect to OMER. ------------------------------ ADDITIONAL INFORMATION: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2) Can you help me Hi, i think thats a configuration issue: http://www.da ...Show All

• Visual Basic VB vs C#. How capable is VB compared to C#?

  I need some clarification please. I am learning VB.NET right now and have a co-worker who has a very strong technical background and feels very strongly that learning VB is a "waste of time in all respects" compared to C#. I don't understand this point of view. Since VB is a .NET language does it not posses the same capabilities as C# Am I on the wrong track I really enjoy the VB.NET syntax and am picking it up quickly. Here's my background ( being totally honest ). I am self taught, I learned C++ back in the late 90's. From there, I moved to C# because ASP.NET is the best platform availabl ...Show All

• SQL Server Simple Question: Testing an Update Script

  When writing simple update SQL statement, what is the proper way to test the script before committing the changes Is there an easier way than wrapping the script in a TRANSACTION and rolling-back the transaction, like so : BEGIN TRANSACTION -- Do the update UPDATE sometable SET somefield="something" FROM sometable -- Show the changes SELECT somefield FROM sometable ROLLBACK TRANSACTION If you -don’t have a sample database and -you don’t want to create another table with the same data -and you don’t mind that all records are locked during your update (cause you are doing an update on the complete table) and -yo ...Show All

• Visual C++ LNK problems continued

  Hard life in C++ lane, I'll tell you. Trying to compile code with unmanaged CAsyncSocket class I got LNK errors: Build Log     Build started: Project: SocketCplus4, Configuration: Release|Win32 Command Lines      Creating temporary file "c:\Documents and Settings\....\My Documents\Visual Studio 2005\Projects\SocketCplus4\SocketCplus4\Release\RSP00000E1064772.rsp" with contents [/OUT:"Release\SocketCplus4.exe" /INCREMENTAL:NO /MANIFEST MANIFESTFILE:"Release\SocketCplus4.exe.intermediate.manifest" /DELAYLOAD:"OleAcc.dll" /DEBUG /PDB:"c:\Documents and Settings\....\My Documents\Visual Studio 2005\P ...Show All

• Windows Forms Keys Property

  Hi, I am working on a tetris control which is almost finished. At this point I am adding property grid with options at run-time. I have properties with Keys values to let the user choose Keys to move figures left, right and down. But in the property grid not all the Keys values are displayed - only the F-keys and modifiers are displayed. Any ...Show All

• Visual Studio Tools for Office VSTO - Outlook - Unload addin

  I have written an addin for Outlook 2003 using VS.net 2005, VSTO, and C#. In " ThisApplication_Startup" I perform several tests to see if the addin should load for the current user. If the addin should not load, how do I unload the addin without shutting down outlook I keep seeing things that say you can shut down the addin's app domain, but I have not seen code that says how to get the addin's app domain. If this is how you are supposed to do it could someone give me a code snippet to accomplish this If there is a better way could someone please let me know what it is Thank you very much Kelly Johnson ...Show All

• Visual Studio 2008 (Pre-release) Nullable columns in database table

  How they are handled in entity class property Thanks I've just see all the options for Column Attributes. I'll add to this post if I have any luck. ...Show All

• .NET Development FileInfo?

  Thanks to Aidy, I got what I needed to work for the most part. My program can now get the subdirectories and stuff. So I started implementing the next part, which is to get the Files in each directory. I got that working. But I can't find anything to get the filesize. I'll still be looking but suggestions are welcome. Hi, try this code:     FileInfo f = new FileInfo ( "yourfile" );    MessageBox .Show (f.Length.ToString());   ...Show All

• Smart Device Development Passport authentication in Windows Form SmartPhone application

  I wish to add .NET Passport authentication when the user logs in through a Windows form in SmartPhone device. Please advise me on the steps to be followed. Is it possible to consume a Passport Authentication provider from my SmartPhone application .NET Compact Framework does not provide a way to do this out of the box. There may be third-party libraries that enable this scenario. You might also find more information in one of the Windows Mobile newsgroups: Windows Mobile API : microsoft.public.pocketpc.developer microsoft.public.smartphone.developer Windows CE API : m ...Show All

• Visual Studio Could not load file or assembly Microsoft.ReportViewer.ProcessingObjectModel.dll

  My VB .Net Windows application using SQL Reporting runs fine on my development machine.  But when I deploy it to a user's machine and try to run a report, I get the message: Could not load file or assembly Microsoft.ReportViewer.ProcessingObjectModel.dll This file is in the GAC on my machine, but not on the deployment machine.  I tried installing SQL Reporting Services on the deployment machine, but that didn't resolve the problem.  Can someone explain how to get a DLL out of the GAC on one machine so it could be copied over to another one   Thanks. ******* Resposta em Portugues ******** ...Show All

• Visual Studio Tools for Office Access 2003 Developer Extensions with VSTO

  Hi: I just got Visual Studio 2005 Tools for MS Office System, but couldn't find Access 2003 Developer Extensions on the CD. I am not sure if I am missing some components or making some mistake in installation. I would greatly appreciate any help in this regard. Thanks reez Hey Reez, VSTO 2005 does not have support for programming against Access. Please let me know if I misunderstand your questions. Thanks, Mei Liang ----------------------------------------------------------------------------------------------------- This posting is provided "AS IS" with no warranties, and confers ...Show All

• Microsoft ISV Community Center Forums Does KeyPress event trap "Backspace" key?

  according to VBA-Help KeyPress event can occur when BACKSPACE key is pressed. but it doesn't occur in my code. why can it happen Code is following: Private Sub TextBox1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)   Select Case KeyAscii       Case 8         MsgBox KeyAscii       Case 27         MsgBox KeyAscii       Case Asc("1") To Asc("9")         MsgBox KeyAscii       Case Else    ...Show All