Denis Pitcher's Q&A profile

• SQL Server SQL Server 2005 Collation

  Can someone plz help me, how can i change the collation of an existing database Thank you in advnace Hi, Thank you for the response, I was also wondering about the following: Can SQL Server 2005 handle non-case sensitive sql statements. i.e. A table with the fields (fieldOne - fieldTwo) has some values: fieldOne fieldTwo i       insert L     lenght c     car I      inject C    construct l      loose So if one would to do a sql statement on that table i.e: A bit of ASP: var x = Request.QueryString("variable"); Lets say the value of x was: l "SELECT fieldTwo FROM table WHERE fieldOne = '"+x+"'" Th ...Show All

• SQL Server The AcquireConnection method call failed with error code 0xC0202009.

  I've seen the previous threads on this (although maybe not all of them). However, i don't think I'm getting the error for the same reason. The full error I'm getting is: - Pre-execute (Error) Messages Error 0xc0202009: {F1B3B35C-FAE3-48F6-A169-4E4D8D99F9B6}: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available.  Source: "Microsoft JET Database Engine"  Hresult: 0x80004005  Description: "Unspecified error".  (SQL Server Import and Export Wizard)   Error 0xc020801c: Data Flow Task: The AcquireConnection method call to the connection manager "DestinationConnectionExcel" failed with error code 0xC0202009.  (SQL Server Import and Export Wizard)   Error 0xc004701a: Data Flow Task: ...Show All

• Visual Studio 2008 (Pre-release) CAD with WPF: "Capture" External TabletDevice

  Hi everybody, a previous discussion in the thread http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=800439&SiteID=1 has lead me to a more general question/suggestion concering a hardware environment with an external Tablet device , like the Wacom Graphire4. The question: Will it be possible to temporarily "bind" a whole TabletDevice to a certain control, e.g. an InkCanvas I.e. the full size and resolution of the tablet device is mapped to the target control's client area (instead of to the whole screen.) This is useful for CAD UserControls or e.g. when a 1:1 relationship between physical drawing size on the tablet and the display size on the screen is desired. I know, that one can already setup a mapping to a sta ...Show All

• Windows Live Developer Forums VE and iframe

  Hi! I`m using VE from iframe, on IE it works fine, but on Firefox I get: this msg: bg.attachEvent is not a function veapi.ashx (line 1) J. ...Show All

• Visual Studio Express Editions People please help, can't use Visual Basic 2005 Express Edition!!!

  Hey people..Please help me i am going insane allready, I have installed and uninstalled Visual Basic 2005 Express Edition 3 or 4 times, and everytime i run it,and i click file->new project-> it has NO template files...so i cant have a new project, Here is the error massage the event viewer says that there are some errors but how can i fix them it should have fixed it self after 3 tries no this is what is says: The Visual Studio template information is out of date. Regenerate the templates by running 'vbexpress /installvstemplates' or reinstalling Visual Studio. Note: corrective action requires Administrator privileges. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. and there is ...Show All

• Visual Basic Referencing a form object in a Mainapp.exe from a form in component.dll

  Hi I have a form class in a .exe assembly (Main Menu Form A) and I have (Sub Main Menu Form B) in a class library assembly. Problem: I am having a hard time calling the Form A from Form B via the menu button, because I can not reference a .exe assembly from a .dll assembly without getting a circular reference error. What I tried: 1. From Form A: I tried to pass to Form B a variable(Me) to be set as the parent or owner of Form B. Then I tried to call instantiate a form A and show it, but that didn't work because of no reference to form A. 2. I tried to hide Form A and then from Form B try to just unhide form A, but that didn't work. Any assistance would be appreciated. I have spent several hours working on this, but it is ...Show All

• Visual Studio 2008 (Pre-release) WCF PeerChannel vs Vista's "People Near Me"

  So I'm sitting at home playing with Vista preRC1 (5536). I notice that "People Near Me" is still there, so I sign in and then go take a look at the API for it. Its completely unmanaged, low-level, Windows API type stuff, but the methods are pretty high level. You can sign in, you can enumerate who is logged into the network, and so on. Windows Meeting Space (Vista) runs on the "People Near Me" (Windows Collaboration API) functionality, and its pretty similar to something I want to accomplish. My question is this: Am I better off using default PNRP on Vista using WCF (what I'm familiar with) , or should I be using the "People Near Me" functionality If the People Near Me functionality is using PNRP, then should ...Show All

• SQL Server Reporting Services - How to create additional details section

  Hi All, I'm using VS 2005 to build a SQL Server reporting Services report. The wizard works great and prompts me to build my results query and then select fields to group the report by. I'm using the 3 groups as follows: Page: Product / Model name Group: Serial No Details: Orders Here's the problem. I also want to show my order lines as there is another linked table connected to my order table which holds all order line items. Classic order - line example. How can I modify the details section to show my line items, as well as not show empty rows when no line items exist Thanks! Hi. I myself have only just started using Reporting Services, but from what I have read, I believe that if you switch to Rep ...Show All

• Software Development for Windows Vista Comments, Suggestions, Features and WHAT THE HECK WAS THAT!?

  Hopefully, that got your attention. We're starting to sketch out designs for the next version of CardSpace. I'm starting this thread and makin' it sticky so we can continue a dialog around new features. Now, I realize that CardSpace ain't even out the door yet, but the planning is beginning. I can't promise anything, but I can tell you that I'll listen, and I'll bring everything to the team. So, What do you want to see in the Next Version of CardSpace g Garrett Serack | Program Manager |Federated Identity Team | Microsoft Corporation blog: http://blogs.msdn.com/garretts At the moment managed card can only be imported from filesystem. It would be great to be able to receive cards from a ...Show All

• Visual Studio Rendering Server Report To Printer

  Having just tested my applications print function with an actual printer and not the Document Imager, I have discovered that using the reportviewer.printdialog provides printouts once in a while when it feels like it, having just posted asking how to suppress the dialog box it seems somewhat ironic that the only way I can actually get the report to the printer is to display it twice per report :) I can render an image to the printer directly and it comes out every time however I am unable to print any pages after the first page. I started by taking the following article and attempting to send a server report. This seems OK however the code sample creates a stream per page, when I render I create 1 stream. Is there an easier way to do ...Show All

• Visual Studio few dll files in bin directory automatically gets checked out while compiling the project

  Hi, whenever i compile my web site from VS team, few of the dlls placed in bin directory gets checked out automatically. And when other users try to compile the web site on their system, it gives popup warning kind of thing saying that particular dll has been checked out by someone else. How can I disable this Ashu You may be hitting the bug described in this thread http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=106422&SiteID=1 See the thread for workarounds/patch/new functionality that will make this go away. Alin ...Show All

• .NET Development Problem with custom encoding

  Hi I'm writing my own Encoder which I will use on the SerialPort class. The small tests I've made work just fine, but when assigning the encoder to the SerialPort.Encoder, I get the exception System.NotSupportedException : No data is available for encoding 0 at System.Text.Encoding.GetDataItem() at System.Text.Encoding.get_WebName() at System.IO.Ports.SerialPort.set_Encoding(Encoding value) Does anyone know why this might be Have I failed to implement some overload, or incorrect overload I'm sorry I can't provide with any more information than this. Hopefully someone have had this problem before, and figured out what it was. Best regards Bjornar Sundsbo Using Reflector you can see that y ...Show All

• Visual C# How to replace a line on a text file without creating a new file.

  I am new to c#, I am using streamreader and streamwriter. However, I do I open a text file, replace the 5 line with a new string without creating a new file Thanks in advance. Hi, You can first create another file (diff file name from original one) which replace the 5 lines with new string, then delete the original one and try to rename the file (use File.Move() method) with the same name as the original one. Thanks. ...Show All

• .NET Development We've totally stuck, please help!!

  Hi everyone, Primary platform is full 64-bit both OS and RBDMS along with .Net Framework 2.0 We've totally stuck with this. We've got a .Net service running on Windows 2003 64 bit which has been compiled as x64 in project options. Everything is fine, service is installed, logged and finally started but the issue comes when you're going to Task Manager, and jesus christ, appears as "namexe.exe" instead of "nameexe.exe" *32 Is it running as 64 or 32 I understand when you set AnyCPU if destination CPU run as 64-bit mode it'll be a 64-bit executable and when you set x86 as 32-bit. Why Could you please so kind to provide me any clari ...Show All

• Visual Studio 2008 (Pre-release) Making a custom menu like Vista's Photo Gallery

  I like the way that Photo Gallery, Media Player and Movie Maker have a black bar at the top with drop down buttons, and I have managed to emulate the bar itself, but not the buttons... I am hoping someone here can tell me how this is meant to be done Do I just create a rectangle and make it act like a button - OR - is there a preset way to do this http://msdn2.microsoft.com/en-us/library/ms753328.aspx Here goes a sample which modifies the button template.You could modify that template to look like MediaPlayer buttons. I don't know whether the exact MediaPlayer button template is available or not. ...Show All