Joel Poiron's Q&A profile

• SQL Server public server role

  In exploring permissions that users have, I find that they all have VIEW ANY DATABASE permission which they inherit from the public server role. You can see this by selecting the Permissions page on the Server Properties dialog and highlighting "public". The permission shows as having been granted by sa. This is listed as a server role. However, it does not show in the list of server roles and I can't find any documentation for it (RTM ...Show All

• Visual Studio Team System VS2005 RC1 loses Source Control settings (using TFS Beta 3)

  Since this problems seems to be with Visual Studio 2005 RC1 client, I am posting it here instead of at TFS forums. I open up VisualStudio after a fresh install, go to Tools->Options->Source Control and set the plug in to Team Server. Then I go to Tools->Connect to team server and add our TFS Beta 3 server. At this point, Team Explorer is blank and there is no way to tell that window to refresh its contents. Then I go to File->Source ...Show All

• Visual Basic Bug found in VB.net

  Below is the text a program that contains a very specific bug that I found in VB.NET. It is not present in VB6 but is in VB express edition. The routine shown below determines if the entry in textbox2 is a number. 'value' is the value of the string in textbox2 acquired using the VAL command. 'value' is then compared to the 'textbox2.text' variable directly with an error handler operating to catch a text vs. number comparison error. If the ...Show All

• Visual Studio Express Editions Newbie Trying to get specific data from an sse database

  I am trying to query a specific field from my sse database based on two different variables. And use this information to fill a textbox with an integer. The first variable is a combobox that is filled with data in one of the other tables in the sse database. This table has a PKcolumn that is an integer and the identity of the column. The only other column is a nvarchar(30) string (which is the actual data in the combobox) The second variabl ...Show All

• .NET Development Returning more values in a xml file

  Hello, At this time I am returning a xml file in my web service service.asmx/demo with following content: < xml version="1.0" encoding="utf-8" >   < string xmlns =" http://test.org/ " > 10.01.2006 18:17:36 </ string > Now I want to add more nodes to my xml file and returning more values. I am using this code: <WebMethod()>   Public Function datum() As String    ...Show All

• Windows Forms Threads part Deux and the dreaded UI blocking

  Hi. It seems like I have to worry about calling UI Control Methods/Properties when I make an ASync call to a method IN THE SAME CLASS as the form itself - got it. Qustion: Do I need to worry about it when I make an Async call to  ...Show All

• Visual Studio Express Editions Can I Create an Access DataBase Without Access?

  I don't own Access and this is for Learning Purposes.... Can I create an Access DataBase with my own Schema(I guess that's the word) with VBE or any Other Way I downloaded Northwind.... Can I change Northwind schema without Access Thanks   Yes. I know you could do it with DAO. I'm not sure about ADO. Since ADO.NET is a little less faciliated in persisting, the USE of ADOX has been recommended ...Show All

• Windows Forms List of Generic Collections? Trees?

  Where is there a published list of generic collection classes available in Whidbey If there's no list available, are there any Tree classes such as red-black, AVL or b-trees I realize this is an old post, not sure if anyone is st ...Show All

• Visual Basic OLE, VS6.0, if isError(A.CLSID = B.CLSID) then read

  [OK, Translate & Update] Note 1: I've Edited this Post, The old question is now obsolete. I've got both VB6 and VBE (VB8), the old problem was solved with the new software. Now: Where can I get a Tutorial and Example for Serialization(Old Persistible Objecs) And MarshalByRef Note 2: I dont have Internet access from the my computer (so I can't use OnLine Help)   Que lastima ...Show All

• .NET Development Socket crashes on AccessViolationException when the peer side aborts (net2.0 beta2)

  Hi,   I experienced a weird problem with socket on my machine. On my colleague's it works like a charm.  When I have socket, waiting for incomming data (after I called BeginReceive) and the peer side aborts - eg. I kill the telnet.exe who I used as a client, the socket throws AccessViolationException on unknown module. The crash itself is in > imon.dll!20b0cd39()   did anyone experienced something similar, or it' ...Show All

• Visual Studio Report footer not printing in landscape A4

  I am printing landscape on A4 (width=11.69in, height=8.27in). My page number in the footer shows fine in preview mode in the designer but does not print. What am I doing wrong Tia ...Show All

• SQL Server Newbie question about indexes

  Hi , I have following statement : SELECT * FROM Table WHERE Col1=@Var1 AND Col2=@Var2 ... AND ColN=@VarN How should I design indexes for best performance ( Add one index on columns Col1 till ColN or add N indexes, first for column Col1, second for Col2, ... ) Thanks, for your suggestions Here's what the optimizer guys have to say: One index should be fine if he always has every column in the WHERE condition and he is doing equalit ...Show All

• Visual FoxPro formset=>deployment=>etc.

  Hi there, As a part of an effort to deploy and application I have been trying to do a few tricks. They have been suggested previously by Cetin and Tamar especially. The code is placed in a .prg file. I tried a few things. oNewInstance = CREATEOBJECT('FormSet') oNewInstance.NewObject ("urls","form") <= secondary, child form oNewInstance.NewObject ("cPlusIntrnals","form") <= main form oNe ...Show All

• Visual Basic SQL does not allow remote connections-Error 40 Problem

  Hello, In the MSDN site ( http://msdn2.microsoft.com/en-us/library/2f8abfew(VS.80).aspx ) there is a sample code to teach Stored Procedures in SQL Server. But it doesn't run. When one clicks on the Create Sprocs button one gets the following error message: "An error occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL does ...Show All

• .NET Development Tricky Question Data Access

  Hi all am developing one web application in .net, I want to develop a component a console project which will run as server for any data access.I am confused in how the web server will connect to this data access server for data accessing. I just want to distribute this data processing out side web server ie only a function will be called from web server from the dataaccess server which will be running on different m/c , and function will retu ...Show All