Gumbatman's Q&A profile

• Visual FoxPro No Connection Sting handle

  I cannot figure out why I cannot get a valid handle for a connection I am able to establish in Command Window as well as in a method. The question mark statement consistently returns -1 which means: no handle (error). OPEN DATABASE ("D:\vfp_Projects\Data\d_data\histdata.dbc") CREATE CONNECTION Myconn DATASOURCE "MyFoxSQLNT" USERID "Administrator" PASSWORD "" IF EMPTY (DBGETPROP ("Myconn","CONNECTION","ConnectString")) myUserID = 'Administrator' myPassword = "" STORE SQLSTRINGCONNECT ('dsn=MyFoxSQLNT;uid=myUserID;pwd=myPassword') TO gnConnHandle gnConnhandle ENDIF The connection is being established because otherwise I would have gotten an error at DB ...Show All

• SQL Server Can NOT login in to SQL2005 with SQl Server Mangement Tool

  I get the following error when trying to connect to my server that is on my local maching: provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233 It happened after I changed the allowed remote connections to 1.  It appears tha I can not log into the server at all.  Any way to fix this besides reinstalling SQL Server Thanks, Doug   You do not need to re-install. Start here for a complete tutorial: http://msdn2.microsoft.com/en-us/library/ms345332.aspx And then check here as well: http://support.microsoft.com/default.aspx/kb/265808/ If you've done all that, make sure your firewall is set up, as refere ...Show All

• SQL Server Best way to learn SQL Mobile?

  I am an experienced web developer using PHP and MySql have experience with VB. What is the best way for me to learn programming pocket pc's Is using sql server mobile the best offline database to use as I will be using MySql Compact framework to connect direcly to our Linux server. Any help is much appreciated as I can't seem to find any useful tutorials on quering an sql databse to update, insert, read or delete. I have created a datebase however, I just don't know how to use it. Thanks in advance. Mark Hi Mark, Below is a specific link to IBuySpy Sample app available on MSDN http://msdn2.microsoft.com/en-us/library/ms174006.aspx IBuySpy Delivery 2005 Sample Application (SQL Server M ...Show All

• Visual Studio Team System test rig error when submitting test to controller machine

  We are having this error when attempting to submit a test to a controller machine: Error Returned: The server has rejected the client credentials. VS GUI shows this as test run error: Failed to Queue Test Run 'DOMAIN/user1 (2006-12-14 15:29:33)' with id {58cc3b3c-a512-4ac0-8110-7c4bbc6846b6}: System.Security.Authentication.InvalidCredentialException: The server has rejected the client credentials. Security Scenario DOMAIN/user1 is a domain account added as a user on controller machine, and is a member of administrators/power users/and all groups created during controller installation. Also added to agent machine. Also, a local account named user2 was created on workstation,server and ...Show All

• Visual Studio Right mouse click on model results in a HRESULT E_FAIL

  When I click on the right mouse button on a model in the debugger, this results in the following exception. - $exception {"Error HRESULT E_FAIL has been returned from a call to a COM component."} System.Exception {System.Runtime.InteropServices.COMException} The ErrorCode = -2147467259 This occurs since the migration to the June SDK, but only in one of our DSL's. The migration was successfull, except of this behavior. I have tried it on several pc's (with both XP and vista) but that made no difference. I do not have a clue what can be the cause. Hopefully you have! By the way, this is the call stack: [External Code] Microsoft.VisualStudio.Shell.dll!Microsoft.VisualStudio.NativeMethods.ThrowOnFailure(int hr = - ...Show All

• Visual Studio Tools for Office Distributing Excel Workbook created by VSTO

  I've done a search through the forums, but I haven't managed to find the answer I'm looking for. I have a relatively simple Excel file that I created using VSTO. In the startup event of one of the sheets, I add a button to the toolbar, and when I click that button, it opens up a form. When I fill in the form and click the run button, it grabs data from a stored procedure and dumps it into Excel, formatting it correctly. When I run it in VS.NET, it works fine. When I go to the bin folder and open the Excel file there, the button appears, and clicking on it works like a charm. But... if I take the Excel file and the dll and copy them to another place on the same workstation (My Documents), then when I open up the Excel file, no butt ...Show All

• .NET Development SqlDependency and which rows actually changed?

  I have a question about SqlDependency. When using the SqlDependency class to get a notification of a change to a table, what is the best way to actually find out what data has changed Is this even possible We are working on a stock trading system in which stocks are valued based upon notifications in the changes of the price, quantity, etc. Any light that you could shed would be helpful! Thanks a ton! Ryan Heaney rheaney@sgfallc.com Yeah, I don't know much about this... I imagine you would have to use the SqlNotificationsEventArgs somehow. e.something Steve ...Show All

• Windows Forms Autocomplete ComboBox

  Is there a way to set the size of the autocomplete dropdown You know when you type in a text in the combobox it will suggest come values in a dropdownlist. Can the size of the thing be set Thanks, does someone already know how to do this I want to manually specify the width of the autocomplete dropdownlist, here is how my autocomplete dropdownlist looks like in this moment: http://img364.imageshack.us/img364/1429/muestraincorrectoautocoix4.png but I can't find how to do it, I only found this thread ...Show All

• Smart Device Development SIP Icon Hides

  Hi, all I am facing a strange problem regarding the SIP Button in WM 5.0 device, the SIP icon(Button) hides from the CommandBar after a mesage box is displayed. And after opening another form or change the Display mode, SIP icon is visible again. This is happening at both position of SIP icon(centre as well as on the right corner). If anybody else is facing this problem or has the solution for this do reply. Thanks. regards Amish Jarod, Thanks for your patience in trying to help us figure out what's going on here. I took your code, compiled, and ran it on a JasJar, and was able to get it to consistently repro under both V2 and V2 SP1. Unfortunately, I then did various things wh ...Show All

• Microsoft ISV Community Center Forums Ajax in CRM

  Hi, i have a problem in CRM. I have a custom field named "new_number" and this field is disabled in form Order. I want to fill this field with autonumbering system which it must working with CRM Web Services, so i make a code that will return the new_number data into the field new_number in CRM Order form. To do that, i think i must working with AJAX (for example if the last record of new_number is A0001, then ajax will return A0002), where i can write my ajax code in Order Form Properties (onSave function at Save button). This is my AJAX code : function OnSave() { var xmlHttp = null; if (window.XMLHttpRequest) xmlHttp = new XMLHttpRequest(); else if (window.ActiveXObject) xmlHttp = new ActiveXObject("Microsoft.XMLHTTP&quo ...Show All

• Visual FoxPro Selecting specific column from active row in a grid

  I have a grid that is "read only" and does not "allow cell selection". When the user clicks on an entry displayed in the grid, then that row is highlighted. The information I would like to retrieve based on the row the user selects is in column1 of this grid. I have found that unless the user clicks on the cell in the column of the active row, then I cannot determine its value. As a result I keep getting the value for Column1, Row1 instead of the row the user selected. Currently the code I am using to retrieve this value is: THISFORM.Grid1.Column1.Text1.value and this returns the text located in column1 of whichever row the user clicked on (assuming they click on column1). So basically if they click on Column5, ...Show All

• .NET Development CustomAttributeData.GetCustomAttributes throws exception when type has a WebService attribute

  Hello, I'm trying to access the CustomAttributeData of a class that has the WebService attribute defined. If the WebService attribute has a Namespace parameter + any of the other WebSercice parameters defined (Name or Description), it throws a CustomAttributeFormatException "Binary format of the specified custom attribute was invalid." exception. If the WebService attribute has only the Namespace parameter defined, it works. If the WebService attribute has does not have the Namespace parameter defined, it works. The code bellow reproduces the problem, does anybody know if there's a workaround or a hot fix for this Thanks Gabo ------- using System; using System.Collections.Generic; using System.Reflect ...Show All

• Windows Search Technologies Improving the users' experience of window desktop search

  I am into design of interface to improve "users' experience" in using a software. I was studying the 2 Desktop search from both side, Microsoft & Google. While the great engineers of both company create a great product, I see that both are now offering a common function. As we know, Desktop search primary objective is to capture users for the search engine and the functionality of easy-search in our desktop is just additional functionality to ensure web search is readily available in our computer. What else the great engineers from Microsoft can add to Windows desktop to ensure it is selected over the other competing desktop search My suggestion is to add dictionary that will be available even the users are offline. As we k ...Show All

• Audio and Video Development Set Cursor Image

  How can I add an image to the cursor I've tried: CursorManager.setImage(" file:///dvddisc/ADV_OBJ/cursor.png "); and CursorManager.Image=" file:///dvddisc/ADV_OBJ/cursor.png "; but that won't work. Also I've attached an optical mouse to the Toshiba's USB port but it doesn't seem to work but using the remote controller in cursor mode works. Hello, I believe setImage takes more than one argument, and the file uri may have to point to something in file:///filecache , but unfortunately I am out of the office and don't have a spec in front of me. However, I will look into it on Tuesday when I'm back in the office. --Rankin ...Show All

• SQL Server indexes question

  Assume we have a sales table, which contains a OrderID(char(8)) and a OrderDate(smalldatetime) field. Each day, hundreds of thousands of records needs to be inserted into this table. We need a daily sales report, and the OrderID is not necessarilly sequentially entered (every data operator has a range of OrderID, so for each data operator, it is sequential, but globally, it is not). So, I would like to create a clustered index on OrderDate, and the Primary Key is on OrderID. I think it is good for generating the daily sales report. However, when an order is entered, we need to quickly check if the OrderID already exits, because the unique index on OrderID is built on the clustered index (on OrderDate), which means the Database Engine will ...Show All