MichaelP_Oxy's Q&A profile

• Visual Studio Team System Problem caused by SQL 2005 Developer edition?

  I'm receiving an error at the end of the TFS install: "Error 28805 Setup cannot finish the request to the SQL Server 2005 Reporting Service report server. Verify that the report server is installed and running, and that you have sufficient privledges to access it." This is a dual-server installation. The DB Tier was installed to a server with SQL 2005 Developer edition. The App Tier has the Reporting Services installed from the SQL 2005 Standard Edition CD. (Not my choice, the boss demanded it.) Browsing the forum I found this post: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=242318&SiteID=1 and tried ...Show All

• SQL Server Stored Procedure

  Hi, im doing a stored procedure, it's for changing the data type of several columns, specifically the number of decimals, so i want to pass this as a parameter, but i cant use this in the alter column command, example, im doing this create procedure XYZ @decimals int as alter table XYZ alter column XYZ decimal(18, @decimals) go any idea how to make this work you have to use dynamic SQl create procedure XYZ @decimals int as declare @SQL varchar(666) select @SQL ='alter table XYZ alter column XYZ decimal(18, ' + convert(varchar(10),@decimals)+')' exec ( @SQL ) go also make sure you read t ...Show All

• Visual Studio Team System TFS not seeing all accounts properly

  I'm having multiple issues that all seem to point to TFS not seeing all the accounts it should.  First up, when I run reports, I get the following errors: An error has occurred during report processing. (rsProcessingAborted) Cannot impersonate user for data source 'CurrituckDS'. (rsErrorImpersonatingUser) Logon failed. (rsLogonFailed) For more information about this error navigate to the report server on the local server machine, or enable remote errors Secondly, the list for the "Assigned To" dropdown doesn't include a large majority of the accounts that should be in the Team Foundation Valid Users group.  For at least on ...Show All

• Smart Device Development Can we use Arraylists in CF?

  Hi. I have some images as Byte arrays in my application. Can anyone tell me if it is possible for me to store those images in a Arraylist So that I can just run a for loop and insert those images one by one to the SQL CE database Thanks. Yes, you can. By the way, why could not you just insert them into SQL CE database right away instead of storing them in the list This way you will save some memory as images won't be in the RAM all at once. ...Show All

• Visual Studio Express Editions Return data between two different delimiters.

  Hi Guys, I am trying to read a string that is between two different delimiters. e.g. =surname;postcode,telephone* I have played around with the Split function and tried to research this but how would I return the text contained with the = and the ; (in this example surname) Any help would be greatly appreciated. hi, you can do something like this Public Sub spliter() Dim spliter As String = "=;,*" Dim s As String = "=surname;postcode,telephone*" Dim items() As String = s. Split (spliter.ToCharArray) For Each z As String In i ...Show All

• Visual C# is there any software to convert from C++ source to C# source?

  any software you know If you can compile the C++ code in Managed C++, you should be able to use Reflector to read it in C#. Of course, the result would not take advantage of C#'s language features (properties, events...) or the .NET base class libraries. ...Show All

• Visual J# OLEDB 64, 32 (SQL 2005/64 / Jet)

  Hello. I want to read access db from within SQL Server 64-bit. On 32-bit, I can do: SELECT f1, f2 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'd:\db.mdb';'admin';'',SomeTableOrQuery) This fails on 64-bit because there are no jet oledb for 64-bit. I need to do this, and I suspect I am not the only one. !! Please compile a 64-bit Jet oledb provider !! For now, I will try to query through a 32-bit SQL Server (express) on the same machine, it might work, but is a card-house of a solution. How about a generic OLEDB32 provider I could write my query like SELECT f1, f2 FROM OPENROWSET(   'Microsoft.Generic32.1.0',   ' ...Show All

• SQL Server SMO Scripter generated script does not run on SQL 2000

  I seem to be running into a problem getting a script (of the entire db) generated by SMO to run on 2000.  It looks like it puts all kinds of SQL 2005 specific TSQL in the script, which fails on 2000.  Any ideas Angelo Thanks Peter, I can't believe I missed that. Looks like it did the trick. Angelo ...Show All

• .NET Development Socket.EndReceive question - in which scenarios does it return 0 (zero)?

  Hi, I have an application that works just fine. I am puzzled by the following issue though - in certain scenarios, Socket.EndReceive returns 0 bytes. According to the documentation, this happens when the remote host calls Socket.Shutdown or closes the Socket in another manner. Generally, I observe this to be correct . However, there are several types of apps (remote hosts) for which this does not hold (the code is not mine so I cannot see what these apps are doing). Even though EndReceive returns 0 (zero) bytes, the remote host is still connected (Connected property of the Socket is true). Not only that, but if I call BeginReceive agai ...Show All

• Visual Studio Tools for Office XMLNode instances in Word Document

  As I understand it, if a Word Document has an XSD attached and an XML Element is added to the document, VSTO makes a specific XMLNode instance available for direct access to that node.  This is really great, but I have 2 questions in this regard: 1) How do you dynamically discover what nodes have an instance (together with the instance name) in the current document 2) How do you add code relating to a specific node that is not in the doucment at design time As an example, I have a MedicalDocument node which is added to the document at design time.  I also have a Letter node which is not added at design time, but will be adde ...Show All

• Windows Forms Prohibit resizing of child windows??? C#

  I have a parent window and two child window tiled horizontally. How can I prohibit to resize and move this child windows inside the parent window except for one thing: I need to allow to move the bottom line of the upper window up or down and allow to move the upper line of the bottom window up or down  Maybe somebody knows   ...Show All

• Visual C# remove specified character [] from string

  Hi, I need to know How can I excluding any characters of a string except a specified set of characters defined by Char[ ]. Example: if I have Char[ ] x = {..,..,..,.........}; string y; and y is a mixture of characters in x and other characters not in x so how can I return a string z that contains only the characters belong to x and excluding all others Thanks in advance for any help. Aya. Some self-explaing code: public void ExcludeCharacters( string y, char [] x ); {     StringBuilder buffer = new StringBuilder( y.Lenght );      & ...Show All

• Windows Forms Using Dataset from another form

  Hi all, I am the follow cenario: A form with DataGrid and a Typed DataSet already filled by DataAdapter where I show the data to the user. When I click in the Edit button, I open another form with Textboxes to edit the data. How can I bind the DataSet from the first form to the controls of second form at design time I tried to do the follow: - Create an instance of the Dataset in the second form - Bind the controls to this Dataset - After create de second form as follow: frmLng vFormLng = new vFormLng(); frmLng.dsData = this.dsData; frmLng.BindingContext = this.BindingContext frmLng.Show(); However, the co ...Show All

• SQL Server Converting a type into another one

  Hello, I've got two tables. An old one an a new one. Called "tbl_Filme" and "tbl_Filme2". The differents are that the data types are a little bit smaller as in the old one. So I've got a column wich should contains a datetime. Unfortunattley the datatype is just a normal date and not "smalldatetime" (the "tbl_Filme" was created with MS Access 2003). So I get an error message: 1> INSERT INTO tbl_Filme2 (Titel, Genre, Medium, Anzahl, Qualitat, Filmlange) 2> SELECT Titel, Genre, Medium, Anzahl, Qualitat, Filmlange 3> FROM tbl_Filme 4> go Meldung '298', Ebene '16', Status '1', Server ' ...Show All

• Visual Studio 2008 (Pre-release) ObjectDataProvider

  Hello all, I have a custom collection that inherits from ObservableCollection -- the collection constructor pulls data from a sql database and fills itself from the query. From what I've gleaned from MSDN and other documentation sources, if your collection constructor is set up to fill itself with data, and you declare an ObjectDataProvider in your window xaml file, the collection object will get instantiated and proceed to populate itself with data. But I'm not 100% sure about this, could someone confirm this Do you still need to go into the code behind file of your xaml window to set the data context property of your window or whatever ch ...Show All