ornorn2's Q&A profile
SQL Server Get list of all Databases in an SQL server
Hey all, I have a pretty simple question, how do i get a list of all databases on a given SQL server I just want a list of them, how is this done I know that you can use SMO, but I am acutally trying to do this without using SMO. Can it be done Thanks to anyone who helps Hi, there are many options, some of them are listed below: --SQL2k5 Select name from sys.sysdatabases --Pre SQL2k5 Select name from dbo . sysdatabases --System procedure sp_helpdb HTH, jens Suessmeyer. ...Show All
SQL Server How connect SQL server 2000 with c#.net .....?
Hello masters, help me yaar i am using dotnet 2003 and SqL SERVER 2000. BUT UNABLE TO CONNECT DATABASE using dataAdaptor(design time ) or sqlconnection any can help me gs whats the error lets see the connection string. make an empty text file called "c:\test.udl" - double click it and try to build a SQL Ole Db Provider datalink. . . can you get that to work Are the TCP protocols enabled in your machines client network settings and in the servers network settings ...Show All
.NET Development Inheriting Forms
Hi, im using VB.NET2003, I want to add muliple forms to my project, (that I can do), I can add the forms, display the forms, and everything. But I don't want to use the new keyword, like : Dim frmtest as new form2 this way of displaying a form can cause trouble, I want to call the form only once, but when I want to hide, or close the current form and frmtest.show the new form, I don't want the Dim frmtest as new form2, to create a new instance of that form each time I want to access the test form. Can someone please help me. In VB6 it was like you can open, and close a form as many times as you like, without creating mult ...Show All
Visual Basic How to Pass "Pointer Function" as parameter in VB.net
i am developing the video confencing in VB>net but i face some problem where How to pass pointer Function in VB.net ,there is one function " capSetCallbackOnVideoStream" it need "Pointer to the video-stream callback function" as parameter ( from vfw.h) . But i do not know how to send this parameter, do you have idea or you have other solution Besides using the vfw.h component to create video conference, it is there have other way to do in VB.net You need to use a delegate http://msdn.microsoft.com/library/default.asp url=/library/en-us/vbcon/html/vbup1048.asp ...Show All
Visual Studio web service build question: friendly name and debugging
With VS2005/msbuild, i have converted my 2003 web services over to 2005 (and dropped the IIS vdir for it, opting instead for a "deploy" strategy. (1) How can i get a friendly name shown in VS2005 Solution Explorer right now, it shows as "D:\..\WebService\". I tried renaming this part in the sln file, but VS2005 keeps changing it back to the ugly version. Project("{E24C65DC-7377-472B-9ABA-BC803B73C61A}") = "D:\...\WebService\", "Vault\WebService", "{08885456-EC15-49D0-8CDB-021B3C5EED8D}" (2) With this strategy, i'm disconnecting the web service from the web site it's deployed to (this works well for me becaus ...Show All
Visual Studio 2008 (Pre-release) The system.messageBus namespace has been removed from WCF?
I see some aricles about system.MessageBus, but can't find it now. Hello, The principle Windows Communication Foundation infrastructure resides in the System.ServiceModel namespace. This is where you should be looking if you wish to prototype with WCF ("Indigo"). Thanks, - Craig McLuckie ...Show All
Windows Forms Dynamic Property
Hi! Please help me! I plan to write my onwe button control, which have "Style" and "Grand" property. I want "Grand" property is hidden from Property Grid Window ("of IDE") when "Style" property is set to "IDE" and it is shown when "Style" Property is set to "Office2003". Where: - IDE and Office2003 is value of Style enum type as bellow: public enum Style{ IDE, Office2003 } - Slyte property is property of my button, which is declared as public Style Style{ get; ...Show All
Visual Basic Refactor and Module?
Started today my first experiences with VS2005 Beta2. I also installed the Refactor! AddIn and tried with the most simple project: A console application! Extracting a method was not possible. I think the reason behind it is that the wizard creates a Module, not a class. (With a Windows application all went ok. Great product by the way!) Strange, it now works. The only difference I see is the fact that the first, non-working, console application was created directly after installing a complete fresh VS2005 and Refactor!. I was so eager to see this product, that it was the first thing I have done with the Beta ...Show All
Visual Studio Tools for Office Attaching solution to Document on the fly
Hi, I have a smartdocument solution that I am wanting to move from using VSTO 2003 to VSTO 2005. Under VSTO2003 it was possible, using VBA, to connect a document to a solution by simple using the object model and document properties. In VSTO 2005 it seems this has gone! I can add a solution using the ServerDocument.AddCustomization method, but this apparently only works from 'outside' the document, ie. I need to have a document (closed) and run an external program to link the solution in. Obviously I can write an app to do this, close the document and then call it from VBA and re-open the document, but that seems a lot of trouble to go to! I ...Show All
System Center Feedback
Been playing with the SCCP today and just a couple of things I noted: - Will there be an option to select additional service (like OMA, OWA, etc) - Clustering mailbox servers - When SAN selected no Quorum disk in configuration Andy Lambert wrote: Been playing with the SCCP today and just a couple of things I noted: - Will there be an option to select additional service (like OMA, OWA, etc) - Clustering mailbox servers - When SAN selected no Quorum disk in configuration OWA's there right now (as front end/IIS servers), but OMA and clustered mailbox servers d ...Show All
Windows Forms Wiew(get) result in text.Box from DataGridWiew
How wiew result from dataGrid( sum of one collumn and get it in one textBox) -example: sum of xlx Column and i will this sum show in a textBOX PJ. van de Sande wrote: Thanks for the reply POSKOK! I'm glad everything is working now! thanks YOU PJ vdS :) again ...Show All
SQL Server Accessing SQL Mobile Databases in VB2005 - Pocket PCApp
I am using VS 2005 to develop a Pocket PC 2003 application and for some reason I dont have the ability to assign my datasource to a SQL Mobile Database When opening Server Explorer, right clicking Data Connection, Add New Data Source, Change Data Source, the only options I get are Microsoft Access Database File Microsoft ODBC Data Source Microsoft SQL Server Microsoft SQL Server Database File Oracle Database <other> I was trying to follow the tutorial Step by Step: Developing a SQL Mobile Application with Visual Studio 2005 and SQL Server 2005 (http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnppcgen/html/med ...Show All
SQL Server SSIS Auto Documentation
Is there a tool that documents the contents of any given SSIS package Thanks, Loonysan There isn't yet but there was always plan to be: http://blogs.conchango.com/jamiethomson/archive/2005/09/14/2150.aspx Don't know what has happened to this. -Jamie ...Show All
Visual Studio 2008 (Pre-release) unknwn.idl Win SDK Beta 2 issues
Hi all, I'm running into a huge problem and am desperate in trying to find a solution. Upgraded to the Beta 2 SDK (Uninstalled all the Beta 1 stuff first) and am trying to recompile my code. I get the following error: 1>C:\Program Files\Microsoft SDKs\Windows\v1.0\Include\unknwn.idl(108) : error MIDL2025 : syntax error : expecting ] or , near "annotation" 1>C:\Program Files\Microsoft SDKs\Windows\v1.0\Include\unknwn.idl(108) : error MIDL2026 : cannot recover from earlier syntax errors; aborting compilation I followed the directions in the SDK readme to setup the include and library paths and have them moved up to the top ...Show All
Visual C++ Saying Goodbye to an Old Friend
I recently read this article regarding security changes to the C/C++ ANSI standard in order to improve overall behaviour and programming issues when dealing with memory overruns and potential malicious use of the Runtime library functions. [EDIT] http://msdn.microsoft.com/library/default.asp url=/library/en-us/dncode/html/secure03102004.asp Anyway, it was only until after starting to use the Microsoft C++ 2005 Express Beta 2 system that these changes had already been implemented in the runtime library. This of course supprised me, as I had to make changes to my existing code in order to get the source to compile. I rea ...Show All
