wenxincao's Q&A profile

• SQL Server Wrong version returned

  When I execute the query "Select @@VERSION as 'SQL Server Version'" from SQL Server Management Studio Express, I get '2005 - 9.00......." returned as the version. When I execute the same query from a VB 6 program, I get "Microsoft SQL Server 2000 - 8.00.760 (Intel X86)" returned. What is odd is the VB 6 program had been returning '2005' within the last two weeks. I have not uninstalled or re-installed 2005 in my environment. I also executed the following at the command prompt and recieved SQL 2000: "C:\Documents and Settings\Administrator>sqlcmd -S MARKB-LTXP -U SA -P medw.1 -q "select @@version" -------------------------------------------------------------------------------- -------------------- ...Show All

• Visual Studio Express Editions Working with threads

  Hi, I need to know, how can I work with threads, because I'm developing an application using sockets, and i want to create a thread for the tasks of the application, and another thread, for execute the socket operations in order to avoid blocking the execution. Thanks! JuKiM wrote: Peter Ritchie, my question is.. With asyncronous sockets.. I can emulate the winsock control With the events thrown when data arrives, or when socket disconnects... Or I will have to put timers and keep watching at every moment the "state" of the socket Thanks! And referring to the examples given.. What "means" client.BeginSend(byteData, 0, byteData.Length, 0, New AsyncCallback(AddressOf SendCallback), client ...Show All

• Software Development for Windows Vista RPC calls between applications running at different integrity levels?

  Hi guys, Does anyone know how the Remote Procedure Calls (RPC) is affected by Process Isolation in Vista Can an application running at a lower integrity level make an RPC call into an application with higher integrity level Are these possible: Low -> Medium Medium -> High Low -> High Thanks!! RPC works indeed well for processes running at different isolation levels. And I believe the RPC is a Microsoft-recommended IPC mechanism for making applications talk to the services bundled into a single product. The reason is whatever you define as communication protocol with RPC is completely customized and tailored to each appliction so the application itself is re ...Show All

• Visual Studio Team System TFS errors after enabling SP1 ISAPI filter

  I'm trying to get this SP1 ISAPI filter working, but when I enable it I have connection problems with the TFS. I can still connect, but can't see work items or source control. I have the ISAPI filter configured like this: [config] RequireSecurePort=true ProxyIPList=192.168.1.1; There is an event log entry that says it has started correctly with that configuration. Here are the event log messages that start showing up when I try to connect with the ISAPI filter installed: Detailed Message: TF53002: Unable to obtain registration data for application VersionControl. Web Request Details Url: https://tfs.domain.net/VersionControl/v1.0/repository.asmx [method: POST] User Agent: Team Foundation (devenv.exe, 8.0.50727.147) Heade ...Show All

• Windows Forms scroll-bar on a datagrid needs to show most recent item added

  My datagridview cotrol is large enough for 10 rows after which the vertical scroll bar appears. The problem is that my datagridview then does not show the last item added, instead the scroll bar maintains it's position showing all of the entries at the top and not the most recent at the bottom. Is there a way to always show the last Item added to the grid Many thanks My datagridview is also bound, what kind of error are you getting the only error you can get from setting the currentCell is if you set it to an out of bounds cell I guess you can't use .firstdisplayedScrollingRowIndex ...Show All

• SQL Server Lost Messages ?

  Hi There What happens to messages that go to error I know that they are returned to the queue of the service that sent them, but the message it the queue is the error message and description. Transmission queue is empty. Where is the actual message that was sent In my case if the message went to error i must resend it. But there is no error when you send the message, transmission queue is clear, the error just comes back to the queue but i need the original message so that i can resend it after the error is fixed but i cannot find it anywhere Thanx Hi Remus Sorry for wasting your time, ever write sql with an obvious problem and you just never saw it no matter how many times you looked o ...Show All

• .NET Development Implement "cut", "copy", "paste" menu commands in Windows Form application

  Hellow all. Sorry for this simple question, but I nowhere can found the answer. I want to implement "cut", "copy", "paste" menu commands in my basic application. I use VS.NET for development. well you can use the ClipBoard to setText/data then copy it to your destination. Example: ClipBoard.SetText("New Text"); this.theTextBox.Text = ClipBoard.GetText(); this will set the text into the clipboard (like cut/copy) and then you can use GetText() to get the data from the clipboard and paste it to wherever you like. As well as this, the textbox controls do have a Cut, copy and paste methods. These however require you to set the selection length/position in order to cut/copy. this.th ...Show All

• Visual Studio Team System Not seeing mapped users in TFS after VSS migration

  Hi, I did a VSS to TFS migration following the steps listed in the TFS admin guide. The migration itself was pretty smooth. However, my list of users do not seem to have converted even though I provided a user map file. I wanted to map VSS users to their domain names. I did an analysis prior to running the migration and there were no complaints about the user map file. TFS has been installed in domain mode. Here is a sample line: <UserMap From="TlaytonTo="MyDomain\Tlayton"/> The migration report even listed the user map file at the end. There were no errors regarding the user mapping either. Is this case sensitive Or is there anything else I'm missing Thanks! Dilip I am confused by the question "Did the u ...Show All

• SQL Server Granting a user permissions to create and Drop a table

  How do I allow a user (or group of users) permission to create/drop a table I have found the 'GRANT CREATE TABLE TO username' command, which will (I assume) allow a user to create a table, but how to I allow a user to 'DROP' the created table as well 'GRANT DROP TABLE TO username' doesn't work and I want the users to be able to DROP/DELETE this table (temporary table created just for printing purposes) as well. thanks See permission section of the DROP TABLE article in BOL. Permissions would have to be reassigned - they are dropped when the table is dropped. You should script all your database operations and manage script files with a source code control product. Thanks Laurentiu ...Show All

• SQL Server Unable delete remote files using FTP Task

  I can create remote folder and delete it I also can create remote files but i can not delete remote files error warning is like subject any ides thanks Hi everyone, I recently had to investigate this problem and already filed a bug for this. The problem is SSIS FTP Task uses backslashes as directory separator characters when issuing a DELEte command against the FTP server. Most Unix based FTP servers only understand forward slashes as directory separator characters, so the FTP server normally returns a 550 FTP error to the client because it cannot find a file named xxx\yyy\zzz.txt. This behavior is independent of the character you use as directory separator in the SSIS FTP Task property that you ...Show All

• SQL Server SQL stored procs

  can anyone help me out.... i need to compare a date that was retrieved from the database and the system date then it must be coded in the stored procs of the database.. help!!!! thank you so much!!!! it worked!!! your a big help... im really glad.... ...Show All

• SQL Server One format can connect to Sql Server but others cannot

  I have setup a SQL Server 2000 database on a remote machine. In the SQL's Enterprise manager I can connect remotely to the database and perform operations. In Visual Studio 2005 I can create a new data connection only using ODBC to connect. Also I can ISQL to the remote machine with no problems. But when I try to connect using the driver Microsoft SQL Server (SQL connect) as the underlying connection platform in VS Studio, it cannot create a data connection that way, nor can I programmatically connect to the database using the .Net data driver. They timeout.... Setups Windows Authentication used. On remote Windows 2003/IIS6 I have local admin privlidges (domain/username) . My remote account (domain/username) is an admin in the database R ...Show All

• Visual Studio 2008 (Pre-release) UserNamePasswordValidator and custom authentication

  Hello, All! I have a service that is based on BasicHttpBinding. It also exposes metadata, so others can see its WSDL. Now I want to apply custom authentication that will be based on HTTP basic athentication. The problem is that my custom validator is not being called, to perform validation ( authentication ), and client gets 403 error. So, I setup my BasicHttpBinding, like so httpBinding.Security.Transport.ClientCredentialType = HttpClientCredentialType.Basic; httpBinding.Security.Mode = BasicHttpSecurityMode.TransportCredentialOnly; Then, I've setup ServiceHost to perform authentication. The code is: //setting the credentials behavior ServiceCredentials sc = new ServiceCredentials(); Validator validator = new Val ...Show All

• SQL Server query

  hi, i want to achive the IIF functionality. example select iff(employee.empid is not null,'sdfsdf',iif(employee.deptid is not null,'dssdf','sdfsd')) as 'sdsd' from employee how to solve this. thank you IFF is not a part of TSQL syntax as far as i know...though this function is provided in sql server 2005 reporting services (thats the place i used it)... finctionality of IFF is IFF(mycondition , ValueWhenMyConditionTrue, ValueWhenMyConditionFalse) IFF can also be nested...so for ValueWhenMyConditionFalse u can write another IFF...as is done in ur case...i hope u'll be able to 'decode' ur actual code now... ...Show All

• Visual Studio Express Editions Default Application

  Hello, I have a list of files in my app. I'm keeping track of thier URI and their name. I'm wondering how can I open the files using thier associated default reader. I realize that I can code this myself (either with if statements or introduce different FileTypes each with its own default application), but is there a way I can hookup into existing OS call Thanks Houman you can start an external process, giving it the filepath or link which should execute assuming that the type is registered in Windows: System.Diagnostics.Process.Start(" fileNameOrLink "); would this be something you are after you can also use the assistant class, ProcessStartInfo, to customize the wa ...Show All