Daniel F.'s Q&A profile

• SQL Server SQL Native Client Issue

  I downloaded and installed Visual Basic 2005 Express Edition, followed by Sql Server 2005 Express Edition. When I ran the command SQLCMD -S SERVER/SQLEXPRESS I got the following error: **** HResult 0x35, Level 16, State 1 Named Pipes Provider: Could not open a connection to SQL Server [53]. Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this fa ...Show All

• Visual Studio Slow Debugging with Template Inline Functions

  Our entire team is experiencing very poor performance debugging a large VC++ 2005 application (43 projects) when stepping into inline template functions that have many different instantiations at the same time the automatic variables window is open. Examples of this include stepping into CComPtr<> and STL template classes with a wide range of different instantiations (probably on the order of >1000). For example, it can take 30 seconds ...Show All

• Windows Forms GridVeiw Delete problem

  Hi I'm using SQL 2005 and VS2005. I added SQLDataSource and GridView on the form and GridView's AutoGenerateDeleteButton is set to True. Suppose a table contains ID(int), Name(Nvarchar(20)) columns. And I add DeleteQuerey of the SQLDataSource to DELETE FROM Test WHERE ID=@ID . When I execute the query in the SQLDataSource wizard, then it's working fine. But I run the application and press Delete button gives exception me ...Show All

• Visual C# BackgroundWorker and SHGetFileInfo

  The SHGetFileInfo function sometimes does not give the appropriate icon when called from by a BackgroundWorker. As far as I have been able to ascertain you get the correct Icon back as long as the Icon is static for a file type. That is, the Icons for .txt, .doc, etc. are the same no matter which file it is. But the Icon for files/shortcuts with the extension .url or .sln (if you have VS 2005 installed) will have Icons which depend on file and ...Show All

• .NET Development Connect using Secure Sockets Layer

  VS 05 - trying to copy to website I clicked on "Connect" There is a check box for "Connect using Secure Sockets Layer" One time I checked it. Now I always uncheck it, but VS still thinks I want to "Connect using Secure Sockets Layer". What to do Thanks in advance! My friend showed me the solution. When I checked the box "Connect using Secure Sockets Laye ...Show All

• .NET Development Why do Configuration.Save need Change Owner permission?

  I'm using the Configuration object to manage my application settings, it all works fine as long as they are stored on the local computer where I have administrator privileges. But as soon as I try to store the configuration on a shared folder on a server I get the UnauthorizedAccessException. I've made sure that my application has FullTrust rights. If I access the shared folder as an administrator I can save my configuration file. The only ...Show All

• Visual FoxPro Working Folder

  With VFP 3.0 I always checked whether the EXE folder sys(16,0) existed in the same folder as the current working folder set("default") + curdir() . If they did not match then I knew that CONFIG.FPW would not be read. So I would exit and display a message telling the user to modify their shortcut. Is there any way in VFP 6.0 and newer to make sure CONFIG.FPW is read regardless of the current folder or method used to start the program ======= ...Show All

• SQL Server varchar (max) - is this correct

  ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/282cd982-f4fb-4b22-b2df-9e8478f13f6a.htm varchar [ ( n | max ) ] Variable-length, non-Unicode character data. n can be a value from 1 through 8,000. max indicates that the maximum storage size is 2^31-1 bytes. The storage size is the actual length of data entered + 2 bytes . The data entered can be 0 characters in length. The SQL-2003 synonyms for varchar are char   varying or character ...Show All

• .NET Development .NET on Linux

  .NET on Linux, is this possible thanks Another option aside from Mono is the shared source CLI ( http://www.microsoft.com/downloads/details.aspx FamilyId=3A1C93FA-7462-47D0-8E56-8DD34C6292F0&displaylang=en ), you can also try searching for "Rotor". I dont believe it is supported on Linux, but it is on osX and BSD. One thing to note is that the license for this is different from the normal redist ...Show All

• SQL Server Can I use ALTER LOGIN in a stored procedure???

  Can the ALTER USER statement be used (without a hack like using EXEC) in a stored procedure I know that the sp_password system stored procedure can not be. Additionally, it is being deprecated anyway. I guess what is boggling me about my attempts so far relate to the errors I am getting due to the user being specified not being in quotes in the syntax. All of the searching I have done so far have come up lame so far; the only examples I have f ...Show All

• SQL Server SSAS service does not start

  Hi I recently installed SQL 2005 . The install proceeded well, but Analysis services service cannot be started on to the machine. When i try to start the service via Configuration manager I recieve and error "An error occured while performing this operation" I have tried to reinstall the product , but that did not help Thanks Sumeet I found this KB article as well and have attempted to h ...Show All

• Software Development for Windows Vista How do you access serial ports above comm9

  When trying to use the win32 api for serial communications there seems to be a limit on accessings serial ports. We have a system with 20 comm ports. Using BuildDCB we can only access ports up to 9, as in comm9:baud=1200... How do you configure the DCB to access ports 10 and above http://support.microsoft.com/kb/q115831/ ...Show All

• Visual Studio Tools for Office VSTO Outlook Addin Setup on Client Workstation

  I created a VSTO Outlook Addin.  With the setup project that was created for me I created a MSI file that is run on all the user workstation as an local admin since users can not install software on their machines.  During the install I pick All Users and the install completed successfully.  I see my addin in Outlook and the addin works fine.  Every other user that sign on to that box for the first time have to ru ...Show All

• Visual C++ conversion of String to LPWSTR

  i want to convert String to LPWSTR. how can i do that, i tried: LPWSTR test = (wchar_t*)ext.toStdWString().c_str(); where 'ext' is string. but it returns garbage value in 'test' please help What is toStdWString Is ext realy a std::string You can usethe ATL conversion fucntions: USES_CONVERSION; LPWSTR test = A2W(ext.c_str()); or if you just need the pointer fur a short time you can use CA ...Show All

• Windows Forms Is ListBox the only control in Forms to allow multiple selections?

  I'm having a terrible job getting a mutli-select listbox to work from a dataset... just keeps crashing my app and it appears to be something to do with the fact I have SelectionMode = MultiSimple.  Before going into my crashes etc here is  ...Show All