D--'s Q&A profile

• SQL Server Editing in Querry Analyzer not in EM

  Hello, In SQL if we want to edit a row in a table then we have two ways to do the same, 1. Execute a command to Update the records in sql through querry analyzer. 2. Go to enterprise manager and then open the table and update a new row. But can't we do the editing in the querry analyzer is there any way to do this. That means i select all the records from my table using the following querry. Select * from MyTable and then performs editing in the querry analyzer without executing any update command and without using the Enterprise manager. Can we do this Bye and TC Yes. You can do this. In the Query Analyzer, expand the Object Browser (left side pane of your QA window) upto your desired table. ...Show All

• .NET Development difficulty accessing Excel spreadsheet via ODBC

  trying to access a spreadsheet on a network share. ODBC connection string: "Driver={Microsoft Excel Driver (*.xls)};DriverId=790;DefaultDir=\\sdi-fs2\Bypass\4ANAMEDONOTDELETE;DBQ=\\\sdi-fs2\Bypass\4ANAMEDONOTDELETE\0e89da37-180c-4214-af37-632cce8dc476.xls" Produces the following error: ERROR [HY000] [Microsoft][ODBC Excel Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x7b4 Thread 0xabc DBC 0x348274 Excel'. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR [HY000] [Microsoft][ODBC Excel Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x7b4 Thread 0xabc DBC 0x348274 Excel'. ERROR [HY000] [Microsoft][ ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Connecting to port on Controller or Main console

  I have a USB device I can send packets to from windows. How can I communicate to it from XNA Is there a DDK for xbox Ralf, Is there a specification to build custom device to Does XNA support device drivers ...Show All

• Visual Studio Express Editions Developing .NET 1.1 applications

  I already found someone speaking about VS2005 targeting .NET 2.0 only. The question is, is there a way to bypass this restriction, and develop .NET 1.1 targeted apps using VS express Unfortunally, I can't afford the full version... I was thinking about using the command line compiler (csc.exe) that comes with .NET 1.1 on my VS express C# application. Is it possible Thanks Ran. If you develop an application with .NET 1.1 compatible syntax/classes, then sure you can compile it with the C# 1.1 compiler. I'm pretty sure that you have to use the command line compiler (or you can check the command line parameters you can provide to the compiler from Project Settings). But I can't see a reason to d ...Show All

• SQL Server datefirst in syslanguages

  The accounting calandar for my project requires that weeks start on Saturday, not Sunday (which is the default for English). I want to set datefirst to 6 (Saturday) in syslanguages for English so that I don't have to set it for each date transaction. In SQL 2000 I hacked it by editing the British language to set datefirst to 6 and dateformat to mdy. Then I set all users of my database to use the British language. This has worked fine for years. In 2005 I don't know how to edit sys.syslanguages to make these changes and I don't know any other way to globally set the datefirst to 6 (for English preferrably). I am very frustrated with SQL Server 2005. Any help would be appreciated. Thanks, Sue ...Show All

• .NET Development problem in data logging from within HttpListener

  Hi friends, I have tried to host a web service using HttpListener of .NET 2.0 (with help from the article http://msdn.microsoft.com/msdnmag/issues/04/12/ServiceStation/default.aspx ). The server runs fine, accepts and responds to requests just fine. I'm using the synchronous model (GetContext). One of my requirements is to log the incoming data to a text file. For this I create a separate thread in the same namespace to send the data to via a message queue. This thread logs the data to file while it is being processed simultaneously. Data is written to the file correctly, the correct response is generated and sent to the client. Around 2 secs after this the server crashes with the exception - System.AppDomainUnloadedException: The ...Show All

• SQL Server How to Automate Synchronizing logins after failover

  Since the logins/jobs do not get stay in sync between principal and mirror after a failover (when using sql logins), is there a workaround to schedule a job or something to automate dropping, re-creating and autofixing logins I've read somewhere that an alert can be setup to run (after a failover) and a job can be executed, but cant seem to get this to work. Does anyone have any helpful hints on a solution to this I have been following and using KBA How to transfer logins and passwords between instances of SQL Server http://support.microsoft.com/kb/246133 http://support.microsoft.com/kb/246133 and see this http://groups.google.com/group/microsoft.public.sqlserver.server/browse_frm/thread/3 ...Show All

• Microsoft ISV Community Center Forums opc

  I am trying to develop an opc - da client using .net technology. Have gone through the documents on opc and opc client and all, but am still not sure how to implement it, can someone give me a direction on how to start with it Genius That's a wee bit over the top, let's just say I've experienced a thing or two about OPC. However, if you're fishing for a response, flattery will get you everywhere :) As the other replies pointed out, the question is a bit open ended. 'using .NET technology' offers a few possibilites, depending on your develpoment language C#, VB.NET, managed C++, etc. The easiest way, would be to make use of the OPC Client .NET wrapper supplied by the OPC Foundation. You do have to b ...Show All

• SharePoint Products and Technologies Publishing Site Template

  I changed the default.aspx of a "publishing site with workflow" site and saved it as my custom site template. When I create a site from my template, its default page comes as "published state." Original template's (Publishing with workflow) default page comes as "draft-checked in" state. It should also come as draft state, I think. Template site's default page becomes published when saving site as custom site template. Is there a way for a site template whose default page is unpublished ...Show All

• Visual C++ WriteFile on a console handle always fails. Why?

  I am trying to understand why the following code does not work. I have created a win32 console application using Visual Studio 6 on Windows XP Pro and it always fails when I try to write something to the console. The "WriteFile" does prints the strings on the screen but still reports that operation was not successfull and always returns the error 12: ERROR_INVALID_ACCESS Why is that Here is the output of the programm: ------------------------ Hello World! 1 Write from hfile1 failed: 12 Hello World! 2 Write from hfile2 failed: 12 Hello World! 3 Write from hfile3 failed: 12 ------------------------- Here is the source code: -------------------------- #include "stdafx.h" #include &qu ...Show All

• Visual Studio Team System Minimum previlege required to Deploy database project into Database Server

  hi, I want to know what are the minimum SQL permissions required to deploy database project onto the database. Can a user with ddl_admin access do the deployment I am very new to databases. Not much aware of the administration part of it... Please help... Thanks. It appears from your script that you are using CTP6. We had a known issue with the db_chaining and trustworthy options prior to CTP7 - these require sysadmin permissions to execute. We now wrap these up and skip 'em (with a warning) if the user trying to execute the script doesn't have the sysadmin role - the rest of the script should complete successfully. I'm guessing that the ALTER DATABASE statement that's throwing on you is not the first one, but the big ...Show All

• SQL Server SSIS File Validation

  Hi, I have migrated a DTS pakage into SSIS. The DTS package validates a Textfile Source File using an ActiveX Script task. Could somebody tell me how to validate a FlatFile in SSIS. Based on whether the file exist or if exist then whether its empty or not, I have to execute a database proc. It'll be very helpful if somebody can assist me in this. Thanks in advance. Neetu Use the script task from the toolbox and do the validation code in vb.net. If the task result is successful, define the workflow to continue to Execute Sql task, wherein you can call a stored proc. Ramani ...Show All

• Visual C# ** Problem with calling unmanaged C++ DLL from C# on a network drive. **

  Hello, I write a C# program which calls a C++ unmanaged DLL. Actually, I write both of them. I put both of C# exe and C++ DLL to a Network folder. When I run the C# exe. The Program gives me an exception. "An exception 'System.Security.SecurityException' has occurred in <my program>." But if I put both the exe and DLL to my local hard disk, the program runs with no problem. Anyone have any idea how to solve this exception Look forward s to hear from you. Thank you, Hello, No, it just say "Exception cannot be handled" But I find that this error only occurrs in some machine, but not in the others. This must be some kind of machine setting or user setting thing problem. Many many ...Show All

• Windows Forms How to Secure Connection Strings using DataProtectionConfigurationProvider or RSAProtectedConfigurationProvider?

  ASP.Net 2.0 natively support the encryption and decryption in web.config. Is there any way to use this feature in WinForms app.config file Many thanks. Alan you can encrtpt some section like connection string look at http://msdn2.microsoft.com/en-us/library/89211k9b.aspx and also look for this thread http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=208820&SiteID=1 ...Show All

• Windows Forms How can I install my program files into "C:/Program Files/"?

  How can I install my program files into "C:/Program Files/" In VCS Express only ClickOnce deployment is included. ClickOnce doesn't allow you to control where it is installed. There's quite a few reasons for it, and searching MSDN for ClickOnce documentation will help explain it better than I can. Some of the reasons include: Enables ClickOnce to manage the "Cache", Rollbacks, and such. Enables ClickOnce to work when you aren't an admin on the machine, and you can't install to C:\program files ...Show All