JohnnyP34's Q&A profile

• SQL Server publish report

  Hello, I have create a web base project that will programmatically publish report into report server 2005. But when i run the code, i need to create a shared data source and set the DataSourceReference. Is there any ways else so that i no need to create a shared data source but still can publish the report in report server 2005 using custom data source Thanks. You don't have to use shared datasource. You can just define a report specific datasource, in which case, all the datasource properties are embedded in the rdl. http://msdn2.microsoft.com/en-us/library/ms159165.aspx ...Show All

• Visual Studio Printing the report without showing the report viewer

  I have a user control with the report viewer (ReportsUserControl). I create my ReportsUserControl object, pass the information that needs to be printed, and i would like to offer my users the choice to print, with or without showing the ReportsUserControl. I tried creating a method in Reports UserControl where i call the reportViewer object's PrintDialog() method, but i receive a message saying it's not possible in the current state. Here's another link: http://blogs.msdn.com/bryanke/articles/71491.aspx ...Show All

• Windows Live Developer Forums Send messages to Windows Live Messanger View Web App

  Does the API for Windows Live Messanger allow for the ability to send Messages to a person loged into windows live messanger. I ask because I am looking at creating a mass up to notify people of changes to projects view windows messanger. NerdyNick wrote: Does the API for Windows Live Messanger allow for the ability to send Messages to a person loged into windows live messanger. I ask because I am looking at creating a mass up to notify people of changes to projects view windows messanger. I guess you want to write a application that directly sending MSN instant message, right It seem MSN Plus can do this. or there have many 3rd MSN SDK in web. You may search these in google. ...Show All

• SQL Server Insert issues after restoring 2000 db into 2005

  Hi all, We are experiencing major performance issues after restoring SQL Server 2000 db into newly setup hardware environment. The application is faster on another environemnt running on Windows 2000 server with SQL Server 2000. We have replicated exact same hardware setup, but only fifference is we are running latest version windows server (2003) and latest version of SQL Server (2005). So far we have troubleshooted the bottleneck to be one of the trigger that is inserting data into a table in one of the stored procedures. The same SP takes 9 mins to execute whereas on our env it takes around one hour. If I disable the trigger it executes in 2 minutes. After restoring, we have executed exec sp_updatestats DBCC UPDATEUSAGE ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Alpha Texture to Mesh problem?

  Hi all, Red circle is my problem with below link  . Why some alpha can not display http://bc9389.awardspace.com/error.html   This is my create mesh coding. Please some body help. //Craete Hill hillMesh = Mesh.FromFile("Model/garden.X", MeshFlags.Managed, renderer.Device, out eMaterials); hillTextures = new Texture[eMaterials.Length]; hillMaterials = new Material[eMaterials.Length]; for (int i = 0; i < hillMaterials.Length; i++) {     hillMaterials = eMaterials .Material3D;     hillTextures = TextureLoader.FromFile(renderer.Device, "Images/garden.tga"); } //====================== //Render for (int i = 0; i < hillMaterials.Length; i++)       ...Show All

• Visual Studio 2008 (Pre-release) can't install nor uninstall Beta2

  hi everybody since last week i am unable to do anything with WinFX beta2 I began with FebruaryCTP : all was fine I upgraded to Beta2...after uninstalling using standard uninstall and the uninstall tools. for some unknown reason WCF didn't install and since then it s a nighmare !! I tried everything...read all the posts here and here....nothing succeed.. right now : uninstall tool says : can t uninstall some components...check you have admin rights (I try to translate as the message is in French...) I have admin rights so the problem should be elsewhere... if i try to install again, there is a message : PerformanceCounterInstaller.exe has encountered an error and it ends... i don t know what to do....except perhaps formatting my hard drive ...Show All

• SQL Server Configuring Connection Manager for 6.5 database

  Greetings once again SSIS friends, I am trying to configure a connection manager for a database that is still using SQL Server 6.5 But it is not working properly. I put the server name, user name and pass word, I select the Native OLE DB\Microsoft OLE DB Provider for SQL Server as my provider. When I click Test Connection it says the connection is fine but then the drop down list for the list of databse names hows nothing! Am I using the wrong provider ! I'm confused! First at all; you need to create a DSN to point to the 6.5 DB in the server/computer that would run the package. This is Control Panel->Administrative Tools-->ODBC Data Source Administrator. Make sure you create that DSN as 'System DSN' so is ava ...Show All

• SQL Server Peer-to-Peer Transactional Replication and deadlock

  Hi all, I have implemented Peer-to-Peer Transactional Replication only for two servers.Everything works fine but in highlevel of concurrency some updates are rolled back due to deadelocks(Never comes without replication).Is there any type of document which can guide me to avoid deadlocks (under Peer-to-Peer Transactional Replication env). Replication in general does nothing more than inserts, updates and deletes. Updates and deletes are qualified with primary key lookup, this is as simple as it can get. Without knowing exactly what your SELECT query looks like, or what the exact plan looks like, I can guess that you would get deadlocks whether it was replication or some other application doing the ins/upd/del. If you ...Show All

• SQL Server Template Explorer - Changing file location / Removing Defaults

  I have been unable to remove the default list of SQL Server Templates from management studio. I don't really care about the ones already in there, but have hundreds of my own that i would rather be displayed. I don't like searching through the 25 different folders that microsoft already has out there cluttering up my own folder structure, and would like to see them disapear, however after deleting them, they just come back next time i open up management studio. Does anyone know how I can remove the default templates, or change the template location to point somewhere else so i don't see them in the explorer list anymore Thanks in advance, Chris That's great feedback Chris. I can see how being able to specify a network share ...Show All

• SQL Server accessing result of sp_tables

  When I run exec sp_tables it give me a "list" of tables in databases. In fact the result is a table where one of the columns contains the database table names. It is no problem to access it in a client application but I need to access that column and verify existance of a certain table in SQL Server's user stored procedure . So far anything I tried did not work. FETCH pertains to a cursor and I cannot declare a cursor for this command. The only thing I got so far was @@ROWCOUNT but it is of no use for me. Perhaps there is another way to verify if a table exists from inside a stored procedure . I have the same problem in terms of verifying existence of a user stored procedure from inside another user stored procedure but if I g ...Show All

• .NET Development CLR and thread deadlocks

  Hello, I'm hosting the CLR (.NET 2.0) in an unmanaged C++ app. The CLR is used for calling C# plugin functions through IDispatch. The C# plugins are COM visible classes and are created from the app main UI thread. They are mostly used for accessing the app through a COM primary interop assembly generated with TLBIMP.EXE. The interop between C# and the app is achieved through the default Microsoft COM wrappers. This is all working fine but I'm having a problem when the C# functions are called by the app from a worker thread. At this point the CLR attempts to interop with the app via the UI main thread which is causing a deadlock because that thread is locked while the worker thread is executing. From what I see in the call stack (b ...Show All

• Software Development for Windows Vista Way to get property from an persisted workflow instance

  Dear all, How can I retrieve Workflow Properties from an workflow instance (either loaded and persisted) Please help. Thanks. Andy Ho Andy, Try looking at the QueryUsingSQLTrackingService example in the SDK. There are examples in there on how to query on various fields from the Tracking DB. Hope this helps ...Show All

• SQL Server Drillthrough results conditionning

  Hi, I would like to be able to set a condition to define the results of my drillthrough in AS 2005. Let's use an example to explain what I am trying to do : We got a Cube with 2 dimensions ( Time, Products ) and a measure ( Sales Amount). In our cube we have stored detailed informations about our vendors, customers and stores. The following statement should return all rows from the columns Customers, Vendors and Stores names. DRILLTHROUGH SELECT {[Time].[Time hierachy].} on Columns, {[Products].[Product.hierarchy]} on Rows FROM My_Cube WHERE ([Measures].[Sales Amount] RETURN [Fact].[Sales Amount] ,[$Vendor].[Vendors name] ,[$Customer].[Customers name] ,[$Stores].[Stores name] I wonder if it is possible to set a conditi ...Show All

• SQL Server DateTime Package variable.. only Date no Time?

  I have a package variable that is a datetime... how am I able to set the time of that variable In visual studio on the variables screen if I click on value it brings up a calendar control - I can't seem to edit the time portion of the variable. When I first click open the variables window it will say 9/1/2006 12:00:00 AM - but as soon as I click on the value box the 12:00:00 AM part will disappear and I can't edit it. I've tried on someone elses PC as well to make sure there isn't something wrong with my visual studio Ideas You can edit the time in the Properties window: select the variable in Variables window and then click the Properties window, and type the time in Value property. I'm not sur ...Show All

• .NET Development Virtual Path Problem?

  Pretty much what I'm trying to accomplish is a data backup utility. First I have a treeview on the left, pretty much like Folder Explorer, that lists the drives and so forth. You then can dive down into different directories from there. The files and directories are then put into a listview on the right, after you select one of the nodes. This is where the problems start occuring. I'm including a piece of code here, just as an example to give you a visual understanding of what I'm about to ask. First make your basic windows form app. Add System.IO namespace Add a button Add listview control In your button1_Click event add the following DirectoryInfo tempDir = new DirectoryInfo ( "C:\\WINDOWS\\Downloaded Pr ...Show All