Jason Sacks - MSFT's Q&A profile

• SQL Server Installing/Configuration

  Hi, I'm pretty new to this reporting services thing. I've installed it on my PC and it runs fine. However, other PCs on my LAN can't access the reports through their browser. I think there is an issue with IIS also involved because they cannot even browse to the default website on my PC. There may also be some security related issues as well (with IIS, Reporting Services and my SQL Server 2005 database). Is there any step by step guide on how to configure all these three things properly for remote access available that anyone can recommend Or can anyone give me advice Thanks, Frank Does the URL use the IP addy or machine name when they try to access the default website If uses the machine name, try the IP address. Are y ...Show All

• Visual C++ Making a window be a child of an already existing window

  Hey. I've come across a case where I need to make a window I've created in c++ act as the child of another window that already exists (and that I didn't create). That is, it should take on all of the behaviors of child windows, including having its exit method called when the parent window is called. I've seen applications that have done this, but don't have the clearest idea of how about ot go about it. If I had the source code for the parent frame, I'm sure it would be easy. But, I don't. One example technique for doing this that I've seen is through various windows commands. That is, using FindWindow to get a handle to the window: HWND parentWin = FindWindow(NULL, "Calculator"); and then using SetParent to make the ...Show All

• Visual Studio 2008 (Pre-release) TreeViewItem: hide item when it is the last node in the tree level

  I have a TreeView and for the TreeViewItem I have created a style with a ControlTemplate in it. One of the elements is a line to connect all the tree nodes (visually, that is). But for the last node in the tree level it should hide this line, because there is no other node to connect to. The way I was thinking to do this, is to set the Visibility of the line element by using a Binding string/statement/whatever it is called: Visibility="{Binding Path=..., RelativeSource={...}}" RelativeSource should then point to a property of some sorts which tells me if the current TreeViewItem is the last node in that level. Is there such a property available Or has anyone done something like this before and knows how to do it ...Show All

• SQL Server Always two queues?

  I'm just getting around to understanding notification services in sql 2005 and I have been working through some examples.  I'm curious as to why there are always two queues and two corresponding services being set up even when both queues/services exist in the same database.  Here is my ultimate goal.  I want to have triggers put messages on the queue for various stored procedures to handle asynchronously - i.e. table xyz is updated, and I need a stored proc to take the updated values and possibly generate or update rows in another table.  When I tried to set up one queue and one service, nothing ever seems to get put on the queue: Create Message Type TestMessageType Validation = Well_Formed_XML; Create Contract T ...Show All

• Visual Studio Setting installation drive

  Would anybody please tell me how to set installation drive for VS2002. It is always installing in C drive(System drive) VS2002 For most VS products/versions, there is a point in the installation process where you can specify where to install to. However, there will always be some files installed on C:. -Tim <MSFT> ...Show All

• Visual Studio 2008 (Pre-release) XBAP working on XP, but not Vista

  got a large XBAP app that we've been developing on XP. it works fine on XP, but Vista is giving me a 'white screen'. on a Vista client, the ClickOnce deploy seems to work fine, but the apps Page never renders. if i click on the View menu for IE, it only shows the reduced menu items for XBAP (Status Bar, Stop, Refresh, Full Screen) ... so that makes me think the XBAP app really is loaded. so what would keep it from rendering what are some of the known differences between running XBAP on Vista and XP NOTE if i deploy a simplified XBAP app from the same server, then it works fine on both Vista and XP. Thanks, casey How are you trying to run the XBAP on Vista, locally, off a web server, from VS If VS ...Show All

• .NET Development This Error Appears: Format of the initialization string does not conform to specification starting at index 0.

  I have saved the database connection string to a key named 'ConnectionString' allowing to access it by calling 'configurationSettings.AppSettings("ConnectionString") But a red line comes under the configuration in the part of the : 'configurationSettings.AppSettings("ConnectionString")'. When i run it this error appears: Format of the initialization string does not conform to specification starting at index 0. and says: Line 4: Public Shared Function GetCategory() As SqlDataReader Line 5: Dim connection As New SqlConnection(connectionString) Line 6: Dim command As New SqlCommand("GetCategory", connection) Line 7: command.CommandType = CommandType.StoredProcedure Line 8: connection.O ...Show All

• Visual C# remove element from an array of string

  hi everybody, I have an array of string myArray[0] = "Hello World"; myArray[1] = "This is a sample code"; myArray[2] = "Delete me"; how do I delete element 2 or I need to copy everything but element 2 I don't know what would be best in this case and if I have a lot of informations. thanks Hi.,      Please try this: int index = Array.IndexOf( myArray, "Delete me"); if ( index != -1 ) { string [] copyStrArr = new string [myArray.Length - 1]; // copy the elements before the found index for ( int i = 0; i < index; i++ ) {      copyStrArr[ i ] = myArray[ i ]; } // copy the element ...Show All

• Visual Studio 2008 (Pre-release) Cannot delete record.

  Playing with demo application and trying to test delete-insert-delete scenario. delete orders where order_id = 2 insert into orders ( order_id , order_date ) values ( 2 , GetDate ()) delete orders where order_id = 2 Got the following error: Msg 2627, Level 14, State 1, Procedure orders_delete_trigger, Line 3 Violation of PRIMARY KEY constraint 'PK__orders_tombstone__0425A276'. Cannot insert duplicate key in object 'dbo.orders_tombstone'. The statement has been terminated. I Isn't it possible to delete the same PK twice It is possible, it just a limitation in the demo application. If you look at the demo.sql you will see that it created a trigger on ta ...Show All

• Visual C++ Problems with delay-loading DLLs

  Hi. I have a DLL module.dll and I want my application to use delay-loading. The idea is that the module may be missing and the app should detect that and continue with limited functionality. I'm using the example from here: http://msdn2.microsoft.com/en-US/library/8yfshtha.aspx However I'm seeing 2 problems: 1) The __HrLoadAllImportsForDll function uses memcmp instead of stricmp to compare the argument with the list of delay-loadable modules. It turns out the string in the table is "module.DLL". So how do I know in advance what is the correct case Is it guaranteed to be that, or can it sometimes be "Module.dll", "MODULE.DLL", or something else Where does the case come from 2) Contrary to the exa ...Show All

• SQL Server Sql Agent stops jobs after connecting with Remote Desktop in "console" mode

  We have SSIS (file system) packages scheduled on a Sql2005 server in SQL Agent. Everything works ok until someone logs into the box via Remote Desktop in console mode. Once that person logs out, SQL Agent stops all scheduled packages and we have to connect to the box via Management Studio and manually restart all of them. This only happens with RD in console mode. Any ideas as to what would cause this TIA I use the Remote Desktop too to configurate the SQL Server. But i use the SSIS Packages not on the Filesystem (develope to SQL Server directly). With this development i have no Problems with the SQL Agent. I would try SSIS not with the file system Maybe this helps ...Show All

• Visual C++ visual studio 2005 c++ adding onprint function

  I would like to add the onprint function to visual studio 2005 c++ code. Class wizard doesn't seem to exist. Suggestions on how to do this Thanks. Merlinv I might be wrong but: Go the File menu of your view (in resource), it should contain Print already. Right click the Print menu, select Add Event Handler. Now you can select between COMMAND/UPDATE_COMMAND_UI, the fucntion name, the class where to place the function. Class Wizard does not exist as it was in VC 6.0 but its functionality is present in various places. ...Show All

• SQL Server Problem: SSIS, ODBC and Progress Database

  Hi, The project I’m working needs to import data from a Progress Database. I had configured my ODBC ( MERANT 3.60 32-BIT Progress SQL92 v9.1D ) driver and everything seems to be ok. But when I tried to create a DataRearder Source pointing to my ODBC Data Source,  and open the next tab I received this error message: “Error at Data Flow Task [DataReader Soucer [135]]: Cannot acquire a managed connection from the run-time connection manager” Anyone can help I had a similar issue, the error I was getting: "Error at Data Flow Tast[DataReader Source [35]]: Cannot acquire a managed connection from the run-time connection manager.& ...Show All

• .NET Development .Item property doesn't exist for ArrayLists???

  I'm getting compiler errors when trying to reference the .Item property for ArrayLists in my code. All the documentation I can find says this property does exist. But C# is telling me otherwise. If I say: ArrayList MyList = new ArrayList(); Object o = MyList.Item[3]; I get the compile-time error: System.Collections.ArrayList does not contain a definition for "Item" And as I'm entering my code and type "Mylist.", the IDE's auto-complete popup suggests "IsSynchronized" or "LastIndexOf" as the members at the place I'd expect to see the .Item property. I'm a bit of a C# newbie. Thanks for any help... It is true that the ArrayList class has an ...Show All

• Visual Studio Express Editions Graphical operations

  I am looking for some application notes or code samples for graphical operations such as drawing on a form (in VC++ Express). I do see that there is a .NET library namespace called "System::Drawing", so I suspect there is some built-in support for drawing... Also, how easy is to implement graphical operations in a Windows Forms application vs. an MFC application Do I need to migrate to the Standard/Professional editions (and develop an MFC application) to get good graphics support Just to give you an idea, here is roughly what my application needs to do: Allow users to draw a "schematic" (on a Form) consisting of an arbitrary number of rectangles connected by lines (preferably using some predefined shapes) ...Show All