Mark Jewett - MSFT's Q&A profile

• Visual Studio Express Editions Setup problem.

  When I launch the msvcs.exe or the msvc.exe they get to the point where it says " Setup is loading installation components. This may take a minute or 2." It's been like 5-10 right now, is there a fix Tyrael Can you post your install log 1. Open Windows Explorer 2. Paste %temp% into the address bar 3. Paste the contents of dd_vsinstall80.txt (only paste the timestamps that are applicable) into a post. ...Show All

• SQL Server Detecting local Sql instances

  I would like to find out what instances of sql are installed on any given machine. For instance, if a machine has SQL Server 2005, SQL Express 2005 and MSDE 2000 installed. I would like to be able to know the versions of each, and ultimately choose the one which is the best for the user to use. For example, I would like to rank the instances, 1. SQL Server 2005 2. SQL server 2000, 3. Sql express, 4. MSDE So I would basically like to default to the best choice available locally for the user. Is there any way to do this using SMO Thanks... Hi Johnny, Yes, you could: DataTable dt; dt = SmoApplication.EnumAvailableSqlServers("JohnnysServer"); for (int i = 0; i < dt.Rows.Count; i+ ...Show All

• .NET Development Time zone conversion problems

  Hi, I'm trying to parse a date time string that is always in ET time zone. The resulting time should be converted to local time. I could do that by backadjusting the ET time and converting to UTC. However, the issue is that I don't know if ET is currently in DST or not, so that I don't know how many hours I have to backadjust. Is there a framework built in way to get the UTC offset for any time zone Thanks, Tom Maybe I expressed myself incorrectly. The file contains values that are stamped in ET. The problem is that the system doesn't know when Eastern changed to DST so that I can account for the DST change in the offset calculations. ...Show All

• SQL Server Cannot open user default database. Login failed

  Hi, I have installed SQL Server 2005 Express edition and when i try to run the web site as http://127.0.0.1/SiteName/Login.aspx . I am using default SQL Provider. Can anyoone please help me i was struck here from last two days. System.Data.SqlClient.SqlException: Cannot open user default database. Login failed. Login failed for user 'XXXXXX\ASPNET'. Regards, Pradeep. Hi         Thank U verymuch for the reply. I have created the ASPNET User using Microsoft SQL Server Management Studio Express but the result is same.       How can i see the default database for ASPNET user.... Regards, Pradeep. ...Show All

• SQL Server Updating a table from a text file

  Hello, I am not sure if this is doable using Transact SQL. I need to update a table from a text file. That is, for each line in the text file, I need to see if the data already exists in the table. If not, I need to add a row to the table for that line. Can this be accomplished through Transact SQL If so how can I do this Any help would be appreciated. Thanks, Dots Hi, get the data transferred in to a a temp table using either BCP or DTS then run the query for record exist , if yes put them in to another table and rest insert in the table you wanted. ...Show All

• SQL Server Cannot fine the object “MSmerge_ctsv_... Because it does not exists or you do not have permission.

  I keep getting the following error message during the initial merge agent. · “The merge process was unable to deliver the snapshot to the subscriber. If using Web synchronization, the merge process may have been unable to create or write the message file, when troubleshooting, restart the sychronzation with verbose history loggin and specify an output file to write. · Cannot fine the object “MSmerge_ctsv_B5ECD41086F24A64B8040A41A75B2DC4”, Because it does not exists or you do not have permission. (source: MSSQLServer, Error number 15151) I do see this view in the publication and if I run the following command on the publisher I get… select * from Msmerge_ctsv_B5ECD41086F24A64B8040A41A75B2DC4 ...Show All

• Visual Studio Team System Work Item Field Naming Conventions

  We have two camps for naming conventions. 1) Add the Work Item name in front of the field name so you can easily identify which Work Item field this field was for. E.g. <FIELD name= " ChangeRequest _ApplicationLevel" refname= "MyCompany.ChangeRequest.ApplicationLevel" type= "String" reportable= "dimension" > Then for Common fields shared among Work Items this camp does: E.g. <FIELD name= " Common _BusinessUnit" refname= "MyCompany.Common.BusinessUnit" type= "String" reportable= "dimension" > 2) The second camp does not have Work Item specific parts in the field name. E.g. <FIELD name= "A ...Show All

• Visual Studio Express Editions How to change the selection back color of winform datagrid row with custom datagrid columns

  Hi, today figured out how to change the row color of a winform datagrid based on a particular column value, using custom datagridcolumn class However, i am not able to change the selectionbackcolor/forecolor of the row. The values for these in datagrid and datagridtablestyle properties are ineffective. In the inherited datagridcolumn class i tried to get the value of the selected row index, but it always throws an exception Public Class ColoredTextBoxColumn Inherits DataGridTextBoxColumn Protected Overloads Overrides Sub Paint(ByVal graph As Graphics, _ ByVal rectbounds As Rectangle, ByVal curmngrSrc As _ CurrencyManager, ByVal RowNumber As Integer, ByVal _ ForeColorBrush As Brush, ByVal BackColorBrush As Brush, _ ByVal ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. .FX files returning values?

  Is there a way to return a value from a shader, or is the data flow one way only The data flow is basically one way only. You could render to a texture and then read from the texture or use the texture in another shader operation. With shader model 3.0 vertex shaders can read from textures so you can use that to communicate data from pixel shaders (render to texture) to vertex shaders (read from texture). The GPGPU site has a lot of information from people who are using the GPU (graphics card) for general purpose computation, which generally needs ways of getting data into and out of the GPU. You might find something interesting there. Cheers, Leaf. ...Show All

• Smart Device Development Prevent Tab Page Change on Tab Control

  Given the absence of many events for the TabControl component (understandable given that it is part of a "Compact" framework) how does one prevent the tab page changing when the user clicks on a different tab My issue is that I have some pre-conditions to be fulfilled before the tab page display (selected tab) should be allowed to change. I can't use a "Mouse click" event to stop the page change since that event is not available. Likewise I cannot hide the other tabs since there is no such property. At present I check the preconditions on the "OnSelectedIndexChanged" event, but by that stage the tab change has already been actioned. If the conditions are not fulfilled then I have to change the tab page back t ...Show All

• .NET Development Using the Row args in SqlRowUpdatedEventArgs

  Hi I am trying to retrieve the information from the Row arg to retrieve the row that is incorrect when using a datadapter to update a database. I have one table which contains the rows to update then I have cloned that table into one to hold replicas of the rows that could not be updated. I am trying to execute the following eSQLRowUpdatedEvent handler to then copy the row data into a new table but keep getting an error message "This row already belongs to another table". I know it belongs to another table which is why I am tring to pass the info into the cloned table, the newSQLErrorRow is receiving the data from args.Row but it is failing when I try to add it to the table due to keep track of the error rows. Can anyone explain ...Show All

• Visual FoxPro Visual Studio 2k5 Database tools problem with Fox pro 9.0 sp1 ole db provider

  I have MicrosoftR Visual FoxProR OLE DB Provider 9.0.0.3504 installed. In the visual database tool, when I run "SELECT DATE() FROM MYTABLE", visual studio will give me the follow error: Error in SELECT clause: expression near ')'. Error in SELECT clause: expression near 'FROM'. Missing FROM clause. Unable to parse query text. However in visual studio 2003 on another machine, everything works fine. I tried to reinstall visual studio 2005 and the fox pro ole db provider many times. I still get the errors. Also, I remember it works on my friend's visual studio 2005. Can someone give me some help to fix this Thanks. Also, "Verify SQL Syntax" returns "This command is not supported by this provider&quo ...Show All

• Microsoft ISV Community Center Forums Can't open regedit

  Hai.... Why if I want open regedit (run>regedit), and then show message error like that The application failed to initialize properly (0xc0000005) Please anybody help me... Jebat Thanks The dutch version would be the same globally. I am wondering if you click start- then run- then type in regedit if you are using capital letters instead of lower case. For example Type in REGEDIT that's all, no exe or period. If it's still not working there are other ways to open regedit, especially if you are running XP pro. I need to know why you want to get into regedit. Is the reason because you are getting error messages when you try to install a new program If so, th ...Show All

• .NET Development FTP w CF 2.0

  Hi all, I am getting an odd error during an FTP. It happens completely randomly. I can sometimes ftp 50 files with no error, and other times 2 errors in a row with the same files. This machine can FTP via CF 1.1 without error as well as with any other FTP method I have tried. Like I said it only happens with the 2.0 and I am at a loss. Any ideas Here is the error; System.Net.WebException: The remote server returned an error: (501) Syntax error in parameters or arguments. at System.Net.FtpWebRequest.SyncRequestCallback(Object obj) at System.Net.FtpWebRequest.RequestCallback(Object obj) at System.Net.CommandStream.Abort(Exception e) at System.Net.FtpWebRequest.FinishRequestStage(RequestStage stage) at System.Net.FtpW ...Show All

• Visual Studio The first record displays multipe times

  Hello, I have a report that was working but now all of a sudden when i run it only shows the first thing returned to the dataset and displays it as many times as there is records if that makes sense. Like if I return 20 rows it will display the first one 20 times. I assume I accidently changed a setting without knowing it. Any ideas Thanks again smithsf22 wrote: Hello, I have a report that was working but now all of a sudden when i run it only shows the first thing returned to the dataset and displays it as many times as there is records if that makes sense. Like if I return 20 rows it will display the first one 20 times. I assume I accidently changed a setting without knowing it. ...Show All