MickT
Last Activity: Jun 17 '24, 03:35 PM
Joined: Feb 21 '07
Location:
-
I hope that's all right now. -
Starting SQL Server 2012 services in Visual Basic 2013
I am using SQL Server 2012 Developer edition and Visual Studio 2013
...Code:Imports System.ServiceProcess (also included in project.references) Dim service As New ServiceController("MSSQLSERVER") ' For checking status of SQL Server & starting if necessary If service.Status = ServiceControllerStatus.Stopped Or service.Status = ServiceControllerStatus.Paused Then Try service.Start()Last edited by Rabbit; Feb 8 '16, 05:41 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data. -
Hello,
I am attaching the screen print of the error message. It seems to the same as described by zmbd.
SQL Server Agent was closed, along with all the other services, so that only MSSQLSERVER was running.
I've looked at the 2 links, and tried the 2 suggested -m switches. The sqlcmd was accepted but I still couldn't log in. The longer one came up as an invalid command.
I guess I'll have...Leave a comment:
-
Thank you for you interest and for trying to help.Leave a comment:
-
I can't even login to run a query.
I stopped all the other SQL services.
I'm the only one using the SQL Server.Leave a comment:
-
SQL Server 2012 - Single Mode User to Restore Master Db
I've closed all SQL Server service except the MSSQLSERVER, and have set that service to startup in single user mode by using the -m switch in the Configuration Window.
However, when I tried to login using the "sa" account" a dialog box popped up telling me that the service was in single user mode and only one Administrator could login.
I am the only Administrator as the server (Developer edition)is on... -
Setting form backcolor in code leaves part of tabcontrol at default colour
In vs2012 I have a form with a tabControl on it.
If I set the form backcolor to some colour in the form designer the tabcontrol area to the right of the tabs takes for the form's backcolor, as expected.
However, If I set the form's backcolor to a colour in code (e.g. in the Load Event) that area of the tabcontrol remains at the default colour, and looks a bit silly as a greyish bar. As the tabcontrol doesn't have a... -
Conversion of a system path in a string to the real path
In VB.NET
I am trying to read in application paths from a text file and then execute the application with the Process control, to avoid editing and re-compilation for different machines.
The path reads like "%windir%","\sy stem32\calc.exe " OR "My.Computer.Fi leSystem.Specia lDirectories.Pr ogramFiles, "\Calc98\CALC.E XE"
I am splitting the string into an array, using the comma as... -
VB.NET - Detecting control key in form.resize event
I am trying to detect whether or not the control key is pressed whilsr resizing a form by dragging the right side or bottom of the form with the mouse.
The purpose is to exit the resize event if the CTRL key is pressed so that code in the event is not executed.
I have tried form.keydown to set a boolean if the CTRL key is pressed but that doesn't work.
I can't find a mouse event that detects a "qualifier"... -
I have a similar problem
I am trapping most keys in the form_Keydown event, but the ENTER (numpad) and RETURN keys seem to be the only ones that aren't trapped in that event.
Any idea why?Leave a comment:
-
Compare VB.NET and C# for Windows Applications
Can anyone point me where I can find an unbiased comparison between VB.NET and C# for writing Windows Applications, please? -
Many thanks for your help.
I get my test machine going and try it.
MichaelLeave a comment:
-
DLLs needed for a VB.NET Windows Application Setup
I have developed a couple of windows applications in Visual Vasic Express 2008. To my horror, I have just discoved that the Setup Project is not available in the express edition.
I have been searching to discover which DLLs I will need to include when using my 3rd party Deployment Application.
I know which ones I need for my 3rd Party Controls, but am stuck on which Microsoft DLLs will be needed the Microsoft Controls... -
Many thanks for your help.Leave a comment:
-
Microsoft Office Automation - Deployment
I have created a VB.NET application. A number of reports may generated from a form, and 2 of them use office automation to create reports in WORD templates.
The reports work well, but I have 2 querie about deployment on target machines.
1. I can't find a way for the application to check for the installation of WORD on the target machine, so that the report can exit cleanly if it is not installed.
2. Do... -
Many thanks for your help.
The ctype() solution in the Ken Puls Blog worked.Leave a comment:
-
Automating WORD in VB.NET
Hello,
I am coding in VB.NET with Option Strict ON in Visual Basic 2008 Express
My code is to automate WORD from a VB.NET windows application, as I used to in VB6.
Part of my code is
Dim oWord As Word.Applicatio n
oWord = CreateObject("W ord.Application ")
and on the 2nd line I am receiving the error message that Option Strict ON disallows the implicit... -
I have dowloadeded VS2008 Express Edition as you suggested, and have found the Settings that you indicated.
I have created 3 settings: -
TBoxBackColour as type color
cboBackColour as type color
CDialogCustomCo lours as System.Collecti ons.Specialised .StringCollecti on (only array type I could find)
When I set the first two manually, the following two lines of code retrieved the settings.
...Leave a comment:
-
Many thanks for your response, but you seem to be using a later version of Visual Studio.
I am using VS 2003, and can't find a screen showing user setting as shown in your screenshot.Leave a comment:
-
You'll need to add AxMAPISession and AxMAPIMessages to your form.
The emails are sent via Outlook.
If you don't want to use that, I'm sure that parts of the code will provide your loop.
Private Sub MySyb()
' Email reports to specified recipients
strSubject = "My Subject"
strBody = "My Body"
' Collect the email addresses...Leave a comment:
No activity results to display
Leave a comment: