silentC's Q&A profile

• SQL Server Could not start mirroring on a single laptop with two instances of SQL Server 2005

  I tried to set up mirroring on my laptop. I have got two instances of SQL Server 2005 SP2 on my laptop (the first one is the default instance). Checked configuration running the following scripts SELECT type_desc , port FROM sys.tcp_endpoints ; GO SELECT state_desc FROM sys.database_mirroring_endpoints go SELECT role FROM sys.database_mirroring_endpoints ; GO SELECT 'Metadata Check' ; SELECT EP . name , SP . STATE , CONVERT ( nvarchar ( 38 ), suser_name ( SP . grantor_principal_id )) AS GRANTOR , SP . TYPE AS PERMISSION , CONVERT ( nvarchar ( 46 ), suser_name ( SP . grantee_principal_id )) AS GRANTEE FROM sys.server_permissions SP , sys.endpoints EP WHERE SP ...Show All

• SQL Server SSIS From SQL2K5 to MySQL

  Hi, We recently migrated from a SQL 2K to 2K5. We had an automatic DTS scheduled every night that would transfer data to a MySQL server on one of our client’s machine. It worked like a charm in SQL 2K. I am trying to figure out how I can connect to a MySQL data source using SSIS in 2K5 as I don’t see an ODBC Destination anywhere in the Data Flow Task; and run the same transfer using 2K5. Do I have to add a reference of some kind or does 2K5 doesn’t support ODBC destinations Thanks This thread should explain all: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=106559&SiteID=1 In a nutshell, there is no prebuilt ODBC SSIS destination component... ...Show All

• Visual Studio Team System Virtual Users on a load test

  I still can't understand clearly how load test works...From what I know, when load test runs a set of virtual users are used to simulate the webtests...now my question is, what if my webtest includes a login process, does the load test still create virtual users If not, then is it correct to say that if a webtest in a load test involves a login, then I should use data binding on my web test to simulate multiple users logging in... Another followup to this would be...assuming we have a 10 user load...does this mean that 10 users are using 1 PC or 10 users are using 10 PCs I guess my problem here if 10 users are simulated using 1 PC, then how does load testing handle cookies Coz I tried manually simulating 2 users logging in and b ...Show All

• Windows Forms Adding custom form to installation

  Hi I would like to add custom form to installation proccess. The user should point me to directory where data will be stored. So I need textbox and button which will give the possibility to choose directory. There is no such a form available in user interface dialog. E. It is not an application folder. It is folder where data that will be created for user will be kept. There is no dialog defined where I could use button for chosin directory. ...Show All

• Visual J# Upgrading J++ to J# in Visual studio express

  I have followed the instructions to update a project from J++ 6.0 to J# in Visual studio express but it doesn't seem to work. The project gets unloaded and if I try to reload it I get a message saying "The application for project.vjp is not installed". Am I doing something wrong, or is the wizard not implemented in the Studio Express version so what should one do to upgrade I have an old project that was developed in J++ many years ago, the executable code has been running unchanged for all this time, but now because of the input data format changes we need to update it. The J++ is no longer supported in the company, and I can not load the project in J# Express. thank you in advance ...Show All

• Visual Studio Adding items to a solution folder automatically opens them in the IDE

  When adding a file using ProjectItem item = _folder.Parent.ProjectItems.AddFromFile(destination); Visual studio automatically opens the file. Is there any way of doing this that wont open the file as we have a number of files that use external editors and when they are added to a solution visual studio decides that it wants to launch them automatically I will need to check up on that. I have not been part of the bug triage group for a while now, so I do not see these in our bug DB. I will send some mail around to find out why. Craig ...Show All

• SQL Server updateting DataSet to MSSQL with XML datatype field

  We are trying to update a changed DataSet to at table in MSSQL server The table have an XML field and that gets converted to System.String when we get from the DB when we try to save the dataset the XML field ind the table is set to NULL How can this be, the DataSet can convert it to System.String when we SELECT it from the DB, but when we save, nothing happens and we get an empty field. Not even an SQL error... Hard to tell without knowing your code. Did you let the profiler run during the update This will give you information if the changed data is passed to the server (if not you probably have a problem in your application, otherwise you have it in the server) HTH, Jens K. Suessmeyer. --- http://www. ...Show All

• Visual Basic FileUpload - How do I trap maxfilesize problems

  The fileupload control works well for files < 4MB (maxrequestlength), but if the file is larger than this the program fails with: - the page cannot be displayed, or Server error in '/xxxxx' application Maximum request length exceeded How do I trap this so that I can return a better error message The failure occurs before the Page Load from any callback, so I can't see any way of trapping the error, and I haven't seen any event or property of the Fileupload control that I can set to say "Do this when Max Request Length is exceeded" I don't want to accept larger files, I'm happy to live with the limit. Regards, Robert Barnes ahmedilyas, I'm finding it very diffi ...Show All

• Windows Forms Validation issues (save and new items)

  I implemented validation on my form overriding the OnColumnChanging of the underlying datatable. While this worked ok whenever I step on the control (let's say textbox), put an invalid value, and  leave the control, it  didn't worked in another scenarios: * I want the validation occurs hen I press the Save button * When I do an AddNew on the BindingSource, ColumnChanging event is never fired, so validation does not occur How can I solve these issues Thanks, Matias Any word about this I've just did a proof of concept with the Customers Northwind table. I've overriden OnColumnChanging with this:      protected override void OnColumnChanging(System.Data.DataColumnChan ...Show All

• Visual Studio Jump to report expression (conditional navigation)

  It is possible to enable a navigation link (Jump to report) based on an expression I need to: 1) Disable the jump to link when the value of the textbox is 0 2) Disable the link when exported to excel / pdf (local report urls are botched in excel, but still clickable) #1: Yes, the drillthrough report name can be an expression. For example, =iif(Me.Value = 0, Nothing, "DrillthroughReportName") Note: if the expression evaluates to Nothing, no drillthrough link is shown. Btw, Me.Value is a shortcut to refer to the current textboxes value. #2: No that's currently not possible. -- Robert ...Show All

• SQL Server devenv.exe hangs up with alomost 100% cpu usage

  For some reason my visual studio with SSIS project hangs up with almost 100% cpu usage sometimes immediately after opening the studio. Any resolution Thanks I'm having the same problem and it is driving me nuts! I do a lot of BI work and this has disrupted my project timelines significantly. As best as I can tell. it seems to have start after applying a patch to the .NET framework 2.0. The patch is defined in the KB922770. I'm not sure if this is the culprit by itself or if there are others factors re-enforcing the problem. Let me know if you come up with a resolution. Thanks, Darryl darryl_jewett@msn.com ...Show All

• SQL Server Memory not being used by SQL 2005 EE 64 bit instance

  We have an I64 server with 12 GB of Ram. On this server we have an instance of SQL 2000 Enterprise with max memory set to 6 GB and AWE is turned on from SSMS. This instance seems to be running fine but is always using all the 6 GB of memory according to task manager (if I increase the max memory it will use it). We also have an instance of SQL 2005 Enterprise with max memory set to 3 GB and AWE is turned on from SSMS. I know you don't have to turn on AWE on 64 bit servers but I did just in case. I hope this is enough server info so I'll get on with the problem. The 2005 instance doesn't seem to be running very well and from the task manager I've never seen it use more then 124 MB of memory. It seems to have way too much I\O writes and betw ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Game and GameComponent Feedback

  We've been combing the forums and the Connect database for bugs, feedback and suggestions around the application model. We still have a small amount of time to consider any other feedback you may have. So this is the thread that you post your latest likes or dislikes with Game, GameComponent, services, etc. Please scan the other threads before posting here, I'd like to just gather things that haven't already been discussed or reported elsewhere. Thanks! proposed components to include MenuComponent CameraComponent RadarComponent (2D postion view of objects in 3D world) TerrainRenderingComponent StatusComponent (Display info) and .. SceneGraphComponent Matias ...Show All

• Visual Studio 2008 (Pre-release) a abnormity TextBox

  I saw some posts give the the code of drawing abnormity Button, <Grid> <Grid.Resources> <Style TargetType="{x:Type Button}"> <Setter Property="Width" Value="30"/> <Setter Property="Height" Value="40"/> <Setter Property="Cursor" Value="Hand"/> <Setter Property="Background" Value="Skyblue"/> <Setter Property="Template"> <Setter.Value> <ControlTemplate TargetType="{x:Type Button}"> <Grid> <Ellipse Fill="{TemplateBinding Background}"/> <ContentPresenter VerticalAlignment=& ...Show All

• SQL Server Subscription/Data Sync Error

  Dear All Iam receiving an error message when trying to complete the subscription. Please find the below given error report that I get from SQL server. Synchronizing Data (100%) (Error) Messages · A call to SQL Server Reconciler failed. Try to resynchronize. HRESULT 0x80004005 (29006) The schema script '\\MAIN\snapshot\unc\MAIN_SQLMOBILE_TEST\20060926133385\MembershipData_2.sch' could not be propagated to the subscriber. HRESULT 0x800704CF (0) 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 to the message file. When troubleshooting, restart the synchronization with verbose history logging and specify an output ...Show All