Daikoku's Q&A profile

• SQL Server Management Studio External Tool throws exception

  I created a simple command-line program to generate a giud, that way I could just click Tools > Quick Guid Gen and a Guid will be printed to the output window so I can just copy/paste it into the ID column. When I use the new tool I get the following exception: TITLE: Microsoft SQL Server Management Studio ------------------------------ Value does not fall within the expected range. (SQLEditors) ------------------------------ Program Location: at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.GetDsRef(Urn urn) at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.Save(VSSAVEFLAGS dwSave, String strSilentSaveAsName, IVsUIShell pIVsUIShell, IntPtr punkDocDataIntPtr, Str ...Show All

• SQL Server Microsoft .NET Data Provider for mySAP Business Suite, PROPER Version ???

  This is available at http://www.microsoft.com/downloads/details.aspx familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en Currently this is tagged as pre-release software. A preview version. When will a fully licensed version be available Also, has anyone used it Any experiences to share Thanks -Jamie Has there been any update for the release schedule for this data provider I've downloaded and tested the preview version and am very impressed with the outcome. Flawless, fast, and automated importing of SAP data to our test repository. One word: WOW! JP ...Show All

• Smart Device Development Unable to connect Web Services with Pocket PC 2003 Emulator in vs2005RC

  The output window: A first chance exception of type ' System.IO.FileNotFoundException' occurred in Mscorlib.dll A first chance exception of type ' System.Net.WebException' occurred in System.dll A first chance exception of type ' System.Net.WebException' occurred in System.Web.Services.dll Test of the Web Services in IE is good How to resolve this problem Hello, Let me rephrase the question once again 1. You are getting exceptions as you mentioned above My Comments:- I acknowledge that exceptions are coming as mentioned by you. I have filed a bug on your behalf for further investigation on why those exceptions are coming. 2. Call to web service ...Show All

• Visual Studio Express Editions copy and paste listbox items

  i am creating a program that runs a game and then lists the 'results' in a listbox. i want the end user to be able to copy and paste the items in the listbox to another program, say, word. i have changed the select to multi, so i can select all the rows, but can't do anything with them. can anyone help me out. thanks in advance. btw, i'm using vb 2005 express edition. no worries at all. Well the code above does that. The clipboard contents will not be lost as its using the standard Windows clipboard, so you can paste it into word. The above code does pretty much get the items selected and puts it into the clipboard for the user to paste into another application, for example. in regards to right clic ...Show All

• Windows Forms DataGridView Seek

  Hi, Is some way that I can make a search in a datagridview not whit Loops (For, while). I remember that the datagrid in VB 6 has a Find or Seek method that does this. I don’t remember the correct syntax but it was something like this: DataGrid1.Seek = “field LIKE ‘” & textbox1.text & “%’” Datagridview has that method or is some way that i can do this In this case I'm not sure. I understand you want to highlight the rows perhaps - this can be done using the Rows[] property of the datagridview, and setting the "Selected" value to true to highlight that row. The query above as said will show you all the matches found in the criteria and will only show ...Show All

• Visual Basic Error Message that I can't resolve...

  I am fairly new to writing in VB and in reality it is actually my first true language that I am trying to learn. I am currently writing a small application for where I work that will be used internally by only a couple of people. The purpose of this project is to record and maintain records for troubleshooting calls. This is in essence a CYA (cover your *ss) ploy that also helps us maintain with compliance rules. So essentially what I did was create a small program that would refernce back to a database out on one of our servers. This was supposed to be something that I assumed would be very easy, and at first it did seem to be working properly. Now I have run into a problem that I do not have a solution for. The following is the error I g ...Show All

• .NET Development Using Machine.Config Connection String For Data Connection

  I have added a DataSet to my project and then dragged one of the Data Connections from the Server Explorer and dropped it on the DataSet Designer. This gives me a schema to work with. My problem is that I want to use a connection string from the machine.config file and not the connection associated with the Data Connection I setup in the Server Explorer. When I try to modify the connection, the only options to Log on to the server are 1) Use Windows Authentication and 2) Use SQL Server Authentication. There is no option to use a connection string from the machine.config file. In my code I am using a table adapter and overriding the default connection string. This works but I think there must be a better way. Here is a snippet out of ...Show All

• SQL Server Cannot connect to localhost using Windows Security Group as login

  I have a test environment set up at home with a small windows server 2003 Active Directory domain. I created a windows security group on the dc and added myself and another user to the group. I then use this group as a login for SQL Server and add the login to the sysadmin server role. This works exactly as I would expect on the Windows Server computer (which is also the Domain Controller) regardless of which computer I use to connect to this Windows Server computer. However, when I set up the exact same login on the local sql server instance of my client laptop running windows xp pro, the I get an error message (Login failed for user MYDOMAIN\dgolds...) when I attempt to connect to the local instance of SQL server, even though I am able t ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Tutorials Thread

  If it's not too much trouble, could this topic be stickied I am just wondering if we could have a main thread that carries links to all the tutorials. In other words, someone makes a thread with a new tutorial, and then, they post the link to it here with a description of the tutorial. That way, others don't have to search through a whole forum for just one topic. Just an idea to make it easier on everyone.   On a side note, I plan on linking this thread to another thread titled: First XNA Program Development Team (FXPDT). Take a look at it. Thanks for your time. Also, I've added some tutorials for you all for now.   P.S. Since the tutorials are publicly viewed and linked to, I don't think you need permission to ...Show All

• Visual Studio Team System Suggestion: Refactor across a whole project

  The schema that I am currently working with has over 1000 tables in it. It was created using scripts that have been adapted from oracle scripts. Obviously the person that did the conversion didn't bother about things like best practice and just did a find and replace on the Oracle script until it got to a syntax that SQL Server would accept. Hence we have the following problems now inherent: Every field that should be an integer is a numeric(8,0) We have VARCHAR(1) fields. This is bad practice - they should be CHAR(1) These VARCHAR(1) fields contain the value "Y" or "N". This would be better represented as a bit field. Loads of others... I am not going to go through 1000 tables to search for all ...Show All

• SQL Server How to calculate the percentage?

  In my cube, I've a date dimension and a time dimension. I would like to know how can I calculate the percentage of order count for a specific time I can get this. Hour 11/6/06 11/7/06 9am 60 10 10am 80 10 11am 60 20 But how can I get this. Hour 11/6/06 11/7/06 9am 30% 25% 10am 40% 25% 11am 30% 50% I would like to use the calculation feature in available in the cube. How can I do this Thanks! Depends on whether the percentage is always based on the time hierarchy, regardless of which query axis it lies on, or is based on whichever hierarchy is on rows - Axis(1). In the former case, something like: Member [Measures].[OrderFractionByTime] as '[Measures].[Order Count]/ ([Measures].[O ...Show All

• SQL Server c# reusing parameters

  I have a select statement which requires numerous parameters. here is a snippet. SqlCommand cmd = new SqlCommand("SELECT this from MyTable WHERE Answer1 = @Att 1AND Answer2 = @Att2 AND Answer3 = @Att3", connection) my parameters are added as follows. SqlParameter Att1 = new SqlParameter("@Att1", SqlDbType.VarChar, 50); Att1.Value = Attributes1; cmd.Parameters.Add(Att1); and so on... What I would like to do is be able to remove a parameter and re-run the SELECT statement if the number of entries retrieved is less than 5 (or any number) I tried just having a new Sql command like this. SqlCommand cmd2 = new SqlCommand("SELECT this from MyTable WHERE Answer1 = @Att 1AND Answer2 = @Att2, connection) and then did this.. ...Show All

• Windows Forms Under terminal services remote session, some users can run my application, other can't.

  I wrote a small GUI based application (in VB.NET 2005) that uses the new .NET 2.0 settings architecture. Users execute this application from a windows terminal server. Some users can run my application with no problem. A few others encounter this error message when starting up the application: "Only administrators have permission to add, remove, or configure server software during a terminal services remote session. If you want to install or configure software on the server, contact you network administrator" Can not being able to read/write to the config file location generate this sort of message What's going on Thanks for any help or information. ...Show All

• Visual C# After using BeginInvoke and End Invoke the timer code does not work

  I am using Asynchronous programming to do an upload.After i did BeginInvoke to start the upload and then End Invoke when upload is over.After that i have other C# code that need to run in the timer_tick event. But that does not run at all. Pls help me .It is very crucial for me. Sorry, but you have given way too little information for us to make any useful diagnosis. ...Show All

• SQL Server Drill through works eradically

  I've got a report that drills through to itself, passing different parameters when drilling through. The report work flawlessly in development, flawlessly when you call the report server directly via url, but doesn't always drill through correctly when the report is called using the report viewer on web site. I've gone as far as to create a single aspx page web site that only has this report on it and it still doesn't work. The drill through works about 1/2 of the time when viewing through the report viewer. But the other half of the time it takes you back to a previously visited parameter, instead of the parameter you clicked on. So a series of clicks might work like this: Parameter Clicked - Resultant page A - Correct "A ...Show All