Whoisit's Q&A profile

• SQL Server Users are unable to connect to SQL Server 2005 unless they are in the sysadmin group

  We are running SQL Server 2005 in a Windows 2003 domain and I have a situation where some of my users are unable to connect to the SQL Server unless they are a member of the sysadmin group. Any attempts by these users to login result in a login failed, Error: 18456, Severity: 14, State: 11 Which indicates that it is a valid user who does not have access to this SQL Server. I have been able to narrow the failures down to the following situation: Create a user, TestUser1, as a member of 1 domain local group TestGroup1 Give TestGroup1 access to SQL (standard public access to master) All good. Login succeeds. Add TestUser1 to another domain local group TestGroup2 Attempt to login to SQL Server -> login failed. Add ...Show All

• Windows Forms DateTimePicker how to show Date AND Time

  Hi on the winForm dateTime picker how (is it possible) to set it so that a user can select a Date AND time Thanks If you want to be able to edit both the date and time without the keyboard, I don't know of any way to do this. But if you set your format to something like 'MM'/'dd'/'yyyy' 'hh':'mm' 'tt' and the ShowUpDown property to False, you can set the date using the dropdown MonthCalendar and set the time using the up and down arrow keys. Tony ...Show All

• Software Development for Windows Vista Text Wrapping in Custom Activity

  I've built a custom activity but the Name value won't wrap like the default activities do. Here's my code: private Rectangle CalcImageRectangle() { Rectangle bounds = Bounds; Size sz = new Size(32, 32); Rectangle rcImg = new Rectangle(); rcImg.X = bounds.Left + 4; // ((bounds.Width - sz.Width) / 2); rcImg.Y = bounds.Top + ((bounds.Height - sz.Height) / 2); rcImg.Size = sz; return rcImg; } private Rectangle CalcTextRectangle() { Rectangle bounds = Bounds; Rectangle imgRect = ImageRectangle; Size sz = Image.Size; int room4Image = bounds.Left + 20 + sz.Width; return new Rectangle(room4Image, bounds.Top, bounds.Width - 4 - room4Image, bounds.Height); } My base size is 175 x 60, so the height is ...Show All

• Visual C++ there is a _CrtDbgReport Error when changing the Character Set

  i get a new application without using Unicode Character Set, and later, i chang the Character Set from Use Multi-Byte Character Set to Use Unicode Character Set. build is ok, but when i debug the application, TRACE don't work, and a error arise: _CrtDbgReport: String too long or IO Error. my TRACE is :TRACE(_T("fdsafdsafdsa%s\n"),"ly"); but the string isn't too long . How can I make TRACE work It seems the macro does not support all of characters. You can try this instead: ::OutputDebugString(_T("中文\n")); If it still does not display characters correctly, then I am afraid you will not be able to show your text in Output window of Visual Studio. ...Show All

• Visual Basic Need help on call fx in a do loop

  I am trying to call 4 functions together in a loop With a 2s delay in between each fx However only the last fx is called What is goin on Timer2.Start() Do While Timer2.Enabled = True Call RLeg_Up() If Timer2.Enabled = False Then Call RLeg_Down() Timer2.Start() If Timer2.Enabled = False Then Call LLeg_Up() Timer2.Start() If Timer2.Enabled = False Then Call LLeg_Down() 'Only LLeg_Down is called Timer2.Start() End If End If End If Application.DoEvents() Loop Still a noob btw This is how i think the code should be i tried this PRIVATE SUB FX dim i as integer = 1 Call Walk0(i) Thread ...Show All

• SQL Server TableAdapter and variable

  Hello, I want to do something like this in a TableAdapter's SQL Statement: SELECT Type.* FROM Controllers INNER JOIN @Type AS Type ON Type.ConfigurationId = Controllers.ActiveConfig INNER JOIN Tank ON Controllers.ControllerId = Tank.ControllerId WHERE (Tank.TankId = @TankId) But I get an error because of the @Type variable. Is there any other way to choose a table in a TableAdapter with variables Thanks for your help! skuehner wrote: Additional information: @Type is a Function that returns a table... but that might not be the problem. If You want to execute this command in first You may put this command into a string (use concatenate + fo ...Show All

• SQL Server Management Studio Express - error when attempting to run a query

  Hi, I have installed Visual Studio 2005 on my PC, and SQL Server 2005 Express was also installed. I decided to install the Management Studio Express, and the installation completed without any error messages. I created the ASPNET account after having installed the Northwind database on my PC, and I have created a test web site (ASP.NET) that creates a SqlConnection, and retrieves some data from the Products table in the Northwind database. The query returns the results i ask for, so that means that the accound has been set up properly. My problem appears when I try to run queries using the Management Studio Express. I have managed to add the sql server, and I can browse this in the object explorer, getting a listing of all the tab ...Show All

• Windows Search Technologies Accessing WDSQuery.dll from MSAccess

  Hello, we would like to integrate desktop search queries in one of our MSAccess applications through the visual basic interface. The SDK does not help, we cannot reference WDSQuery.dll, how could we do Hello Jean-Claude, If you are willing to use VB.net you can follow the instructions that one of our developers has posted in his blog here: http://brandonlive.com/2005/07/13/calling-the-wds-api-from-vb-net/ Are you looking to use VB.net or are you specifically wanting to use the VBA that is available in Access Paul Nystrom - MSFT P.S. I'm also interested in finding out more about your company and your plans for Windows Desktop Search.  If you're willing to discuss this please send a ...Show All

• Visual C++ Check a checkbox by default

  Hi ! Here is my problem : I have had a checkbox in a dialog box (using the toolbox in Visual C++) and I want it to be checked by default. The code I'm working on it's not mine , and I just have to had this checkbox... Can someone help me Cheers, This is hardly related to the C++ language. Such questions are better fit for the newsgroups, at http://msdn.microsoft.com/newsgroups . Anyway: depending on the program (whether it is using MFC or not), you can set the check state either through the message BM_GETCHECK, or some wrapper class. http://windowssdk.msdn.microsoft.com/en-us/library/ms673559.aspx . ...Show All

• Visual Studio Tools for Office Disable VBA script "on click"

  System: Microsoft Office 2003 Word VSTO Solution using Document Template. I have developed several custom WinForm controls that canbe added to a word document from a "controls toolbar". When the template is opened to be edited and the form is placed in design mode, if the user double clicks on one of these controls in the Word document, Word opens the VBA editor. Is there a way I can prevent that from happening I would have thought this would be easy to resolve, but the solution seems to be avoiding me at the moment. That's a challenge :-) As far as I know, short of removing VBA from the installation, there's no way to prevent this, directly. However, it appears sinking the WindowsBeforeDoubleClick event should work. I tes ...Show All

• Visual Studio Team System Permissions at the work item level

  I am wondering if there is a way to restrict users to creating a particular type of work item. For example, I have a project group called Testers and I only want to allow them to create work items of the type "Bug". I can restrict their access to an Area called Bugs, but they can still create any work item in there they want, including Requirements, Change Requests, etc. Is it possible to allow them write access to only a certain type of work item You can use transistion security to prevent users from creating a particular type. Check transitions and security section in our help http://msdn2.microsoft.com/en-us/library/ms243849.aspx and basically you can set "for" and "not" ru ...Show All

• Smart Device Development Notification for Change in Contacts

  Is there a way to get notification for change in contacts ..So that i can update the contacts my app is maintaining I hope you are using Compact Framework 2.0 and Windows Mobile 5.0. If you are using Pocket PC 2003, I don't know what it is with that.... Check this out: http://msdn.microsoft.com/library/default.asp url=/library/en-us/mobilesdk5/html/T_Microsoft_WindowsMobile_PocketOutlook_ContactCollection_Members.asp . See the event ListChanged, it should do the trick. Ok, the steps: 0) Add references to Microsoft.WindowsMobile.PocketOutlook -assembly 1) Create OutlookSession object 2) Get ContactFolder from session, (Contacts property) 3) Get ContactsCollection from folder (Items property) 4) Register the ListChanged -event handle ...Show All

• .NET Development specifying credentials for reading file from UNC path

  Hi there; My question revolves around connecting to an UNC path and reading a file there. I'm using VS C# 2005 Express and c#. Importantly, I need to be able to programmatically specify the username and password for this connection; the logged-on user most likely will not have the requisite permissions. p-code: string strUser = bob; string strPass = bobspassword; Streamreader readme = new StreamReader (   @"\\server\share\path.txt", strUser, strPass ); while ((line = readme.ReadLine()) != null )  {    process lines;  } readme.Close(); The highlighted bits are where I'm confused. How do I specify the credentials to go get the file I'm used to specifying credentials for WMI via Co ...Show All

• Visual Studio Team System No empty catch blocks?

  We currently have a development standard that states: No Empty Catch Blocks Catch blocks shall implement explicit handling for the exceptions they catch. Does anyone have a problem with this dev standard We are thinking about creating our own FxCop rule for this, but just wanted a sanity check. We have thought about this rule and will likely implement this in a future version of Visual Studio/FxCop. There are few things you will need to note: There are valid situations where having an empty catch block is exactly what you want when catching a very specific exception, such as FileNotFoundException or FormatException. You need to take into consideration instructions that should be considered as empty, such as nop (No operat ...Show All

• Visual C# Calling C/C++ DLL function Entry Point Error

  I have a dll that was made for C/C++ in Borland. The problem is that I keep getting an "entry point not found" error when I run the program. When I compile, I get no errors. I use DllImport like this: [DllImport("C:\\Program Files\\SPF\\SpfIIDll.dll", CallingConvention = CallingConvention.Cdecl, CharSet = CharSet.Ansi, EntryPoint = "InitSpfII", ExactSpelling = true)] static extern unsafe int InitSpfII(char* cSpfCfg, char* cHardwareCfg); When I call the function, I do it to allow a char* by doing this: fixed (char* spfcfgpath = spfpath.ToCharArray()) { fixed (char* hardwarecfgpath = hardwarepath.ToCharArray()) { initValue = InitSpfII(spfcfgpath, hardwarecfgpath); } } I know that the function exists and I have the heade ...Show All