Doug DeBug's Q&A profile

• SQL Server Yet another xp_cmdshell problem SQL Server 2005

  Hi, I have to named instances on one server. I'd like to use xp_cmdshell for some interfaces. I've "activated" the xp_cmdshell feature. I set a proxy account und and gave the sql user the right to exec xp_cmdshell. Unfortunately the command EXEC sp_xp_cmdshell_proxy_account 'DOMAIN\proxyaccount','APassword' throws following error: Msg 15121, Level 16, State 200, Procedure xp_cmdshell, Line 1 An error occurred during the execution of xp_cmdshell. A call to 'LogonUserW' failed with error code: '1326'. ... and yes, the username and password should be valid ;-) When I exec (makes no sense, I now...) EXEC xp_cmdshell 'echo 123' The following error occurs: Msg 15121, Level 16, State 200, Procedure ...Show All

• Visual Basic classfactory cannot supply requested class

  Operating System Version: Windows XP Home Problem Application Name & Version: Visual Basic .Net 2003 Error Messages: "ClassFactory cannot supply requested class" i have installed everything with no error and when i went to start a new project, i get the above error...i uninstalled and reinstalled multiple times and even used different setup discs and still get the same error...please help! I received the same error message when I tried to uninstall my old printer drivers "ClassFactory cannot supply requested class". I downloaded and installed the latest Windows Script for XP but the error message persists, It makes no difference if I use the printer's uninstall drivers program or try remo ...Show All

• Visual Studio Express Editions [VB Express] program freeze

  hi my program adds COM ports to a ComboBox and there i choose the Right COM ( where i have connected a device) to send commands to that device. the problem is, that when i chose the wrong COMport the program freezes and i have to shut it down. how can i solve this problem i want my program to still run, when i choose a wrong port...so i can choose another one! code sample: With mySerialPort .PortName = ComboBox1.SelectedItem .Open() ''here i open a port If mySerialPort.IsOpen Then .Write("AT" & vbCr) ''sending commands via RS232 to a .Write("AT+CPIN " & vbCr) GSMmodem Else Label1.Text = ("Port still closed" ...Show All

• Visual Studio Express Editions This is my connection routine for an SQL Express database I'm using with ASP.NET and C#..

  connectionString = "server=.\\SQLExpress;uid=sa;pwd=;database=cartridge;" + "Integrated Security=True;"; connection = new SqlConnection(connectionString); connection.Open(); When I run the database in "debug" mode through the VWD IDE the connection is made and I get query data etc, but when I try to access the database from IIS I get a login failed message, I assume this means I must create another SQL user I can't find any option to do this in the GUI. Please advise on this issue, it will be much apprecaited. Hi, By using Integrated Security=True the uid and pwd fields are being ignored and the applications is trying to logon with the ASP.NET account. Try to set it to false ...Show All

• Windows Forms Datagrid Cell Keypress

  VS 2005 windows unbound datagridview I want to ensure that only numeric values are entered into a datagridview cell. Is there anywhere to put a keypress event in a cell The Regex is a way, maybe not good enough here. hehe The link does provide some information. There are lots of events out when you move from cell to cell: cell leave(old cell) cell validating/ed (old cell) cell endedit (old cell) cell enter(new cell) cell beginedit(new cell) So it's a great ease for users to validate their input data. ...Show All

• Visual Basic Starting/Stopping Processes

  Hello: My scenario follows- I have a solution that contains 2 projects. Project 1 has Form A Form A has a button that starts a process, namely Project 2 Form B. Form B has a 'close' button that I want to terminate the process that was started when I clicked the 'start process' button on Form A. I hope that made sense. Basically, I want Form B to be able to close itself (using a button that I added to its form), even though it was launched (started as a process) from a button click from Form A. Thanks in advance for any help. Can accept the code in VB or C#. the best sample is in the MSDN in VS2003 Look for Threads and Threading.... try exploring the System.Threading.Thread Object Quick Sample (VB Coding): ...Show All

• Visual C++ C++ Windows Forms Project Header Files

  Hi, Somewhat of a very basic question here. I am using C++/CLI. Why with a windows form project is all the code in the .h file Thanks Jeff Hi, thanks for the response. I have never really seen any explanation on MSDN or documentation that I have so I was not sure. Seems a bit strange though. Usually you just see class interfaces in the .h file and implementation in the .cpp file. Thanks Jeff ...Show All

• Visual Studio Team System Old Database Project vs New Database Project

  Hi, A customer has a solution with a “old” database project type that opens fine with VS 2005 Pro. After they installed the CTP 7 Bits of DB Pro and now get an error when opening that same solution. Can they use the Old Project Type along side(In the same solution) with the new DB Pro Database Project type Does that make sense Thank you. Randy The project files created in the DB Professional Edition (SQL Server 2005 DB Project for example) are not compatible with any other edition of Team Systems; so adding them to your solution essentially breaks the solution when loaded by a different role. This seems counterintuitive as even though the Tester Edition and Architect edition can create ite ...Show All

• Visual FoxPro config.fpw

  how i can find my config.fpw how i can call my program that use only my codepage=950 for hongkong characters i wan create my own config.fpw and at my main.prg call this config.fpw... how i can do that thanks in advance. To add to Cetin's, you can find the location of your config file with SYS(2019) http://msdn.microsoft.com/library/default.asp url=/library/en-us/dv_foxhelp9/html/60c1a9a7-3f99-486a-a131-590baf487aa2.asp frame=true ...Show All

• Visual Studio 2008 (Pre-release) Textbox Baseline

  I have a TextBox on a canvas panel. The FontSize property of the TextBox is databound to a slider control, so that the font size changes as the user slides the slider. As the font size changes, I need the text's baseline to remain at the same location on the canvas (The baseline is the bottom of the font, NOT including the part of certain letters (like g,q,p) that fall below the baseline) The reason for this is that the TextBox is overlayed on an Bitmap that has lines (like the kind you would see in a writing notebook.) The font needs to be aligned so that the font's baseline matches the lines of the notebook image as the font size changes. Does anyone have any idea on how to do this Can someone please point me in the right direction ...Show All

• Windows Live Developer Forums Retrieving Lat & Lon from an address without a map

  I have a web form that enables users to enter an address, and is supposed to return a latitude and longitude for that address. Unfortunately, I've been unable to find any articles or code that can return these values. Any help is greatly appreciated. Thanks! You can of course hide the map, defining the div as: <div id="map" style="display: none;"></div> The user still has to load the map etc (so it will take some time to load) but you can use the Find method :-) ...Show All

• Windows Forms Color attributes with checkbox.appearance=appearance.button

  After my checkbox has been set to have the appearance of a button, it does not respond to the setting of backcolor attribute. How can I fix that Thank you, Ken. I did what you suggested and it worked. Now the question is, why didn't it work before I am examining the code with a magnifying glass and will post the answer, so others will know what to watch out for. ...Show All

• Visual Basic Visual Basic report item limit table rows per page

  I'm trying to accomplish the following in a report (with no success so far): Top half of the page is a collection of text fields to display the name and address of a person. then I have a two in section with a table in it that is to display six rows of related data for this person. Only six on a page. If more then six, then start a new page. The bottom 2 inches is more data just on the one person. This format is needed to hit a pre-printed form, so I can't rearrang the objects. My biggest problems, are: 1- how to limit the table to six rows and then page break (in the query I can probably rig a counter and group on this); but I'm hoping for an easier way. 2- As the table grows, it pushes the objects below it onto another ...Show All

• Visual Studio Express Editions Help Clearing All Textboxes and All Comboboxes

  Greetings: I found this helpful code elsewhere on the forum, but it is only working on the Combo Boxes and not the text boxes on my Form1. Currently I have 4 textboxes and 3 comboboxes on my form. In the editor, when I hover my mouse over "ComboBox" it says "Class ComboBox" and when I hover my mouse over "TextBox" it says "Interface TextBox." Any ideas or help is greatly appreciated. Thanks Glenn Public Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click For Each c As Control In Me .Controls If TypeOf c Is TextBox Then ...Show All

• Visual Studio Express Editions Question about Forms

  Dear All i have developed an application which has mainForm, form1, form2 and form3, in mainForm.cs i created a button and created form1 using the following code form1 frm = new form1() frm.show() now in form1.cs i created a button and created another form as following form2 frm2 = new form2() frm2.show() now in form2.cs i created a button and created another form as following form3 frm3 = new form3() frm3.show() when i am pressing "Alt + Tab", i watch Four forms. My Question is 1) How to see one application form 2) Is there any way that old form be placeholder of newly created form 3) Or any trick An efficent solution will be appretiated Thanks Hi Just call to S ...Show All