raja786's Q&A profile
SQL Server Client tools, what is it for and what bring us?
hi everyone, Client Tools brings a BIDS platform TIA yeah, of course. I was talking about whether Client Tools as a set of programs carries BIDS application in order can build SSIS packages. thanks for your understanding ...Show All
SQL Server How to make a File Share Subscription running on Vista?
I recently migrate to Vista. I had a bunch of reports with file share subscriptions that were running fine on XP. After installing reporting services on vista (that part only was a challenge), I re-created my subscriptions using the report manager. As expected, when a subscription is executed, the ‘last run’ column shows the last time the report output has been delivered to the file share and the ‘status’ column shows ‘New Subscription’. I thought that this was the signature of a successfully configured subscription. But surprisingly, there is nothing in the file share. The directory is empty. Anybody has an idea why Anybody knows how I could possibly find information on my ...Show All
.NET Development Problem in displaying HTTPS traffic using Sockets
Hi, I have a proxy in VB.NET using Sockets. I listen to HTTP/S traffic and then forward it to the webservers, recieves the response and return back to the client. I am displaying the HTTP/S request/responses to the user before forwarding it to server/cleint. I can read the HTTP requests/responses but cant read the HTTPS requests/responses. What is the easy way to enable the program using sockets to read the HTTPS traffic. when HTTPS requests comes, it shows me only "CONNECT ..." and i cant see anything in response stream. Thanks It is not intended, and therefore would be very very difficult, for an HTTP proxy to decrypt the data being transferred in a proxy tunnel created with the C ...Show All
Commerce Server CommerceProfileSystemException: Failed to initialize profile service handle
Hi, We are working so thad whe have an integration server on with Commerce Server and SQL Server are running. Each developer has now local his own Commverce Server and connects to the database on the integration server. Everything was running fine till last week and now we get a rely strange error. If i start the Website on the server itself it loads and works correctly but if I start the local website on a developers PC I get the error that it Failed to initialize profile service handle. Its so strange then the code of the website is at the momment exactly the same as on the Developer's PC and i get the error way before it really goes into the code. What could here be the Problem It was really working fine last week even the Prof ...Show All
Visual C# IEnumerable issue
Hello, I am trying to compile my code(a console application) with the following class, and it gives me the error (CS0536) as shown below. However, if the CityCollection class is implemented as a regular class without any inheritance from the IEnumerable interface, it compiles OK. Any ideas/thoughts Thanks!! Code: CityCollection.cs using System; using System.Collections.Generic; using System.Text; namespace TestIEnum { public class CityCollection : IEnumerable<string> { string[] m_Cities = { "New York", "Paris", "London" }; public IEnumerator<string> G ...Show All
SQL Server Using outer join
Hi Wonder if any could help be putting together a SQl select statement. I have 2 tables of road-data, one having default data for the area, and one with actual data. They look like this: Create table AreaDefaults { AreaCode Int(3), RoadCode Int(3) } Insert into table AreaDefaults values (34, 21); Insert into table AreaDefaults values (35, 21); Insert into table AreaDefaults values (36, 21); Insert into table AreaDefaults values (37, 21); Create table AreaRoadCode { AreaCode Int(3), RoadCode Int(3), ZipCode Varchar(20) } Insert into table AreaRoadCode values (34, 12, '2800 L'); Insert into table AreaRoadCode values (34, 13, '2900 K'); Insert into table AreaRoadCode values (36, 18, '0900 O'); I would like to make an SQL select ...Show All
Smart Device Development Dll Import from Regular C++ to C#
Hello, I am developing a smart device application in VS.NET 2003 and want to import dll from C++ program. [DllImport("mydllimportTest.dll")] public static extern int GetInt(); While the import command works fine with normal windows application project, the following error is generated in smart device application. "An unhandled exception of type 'System.MissingMethodException' occurred in.." Can you please help me out Thanks Tijnars Hello, I installed vs.net 2005 and still at the same point. With VS.NET 2005, the error message is more descriptive. " COM object with CLSID '{2AF1578B-3628-49E8-B0FF-6C86A41C8F8A}' cannot be created due to the fo ...Show All
SQL Server Primary Key in View
how to create view in sql server 2005 that recognize Identity And Primary key of base table SELECT COLS.table_schema ,COLS.Table_name ,COLS.COLUMN_NAME ,cols.CONSTRAINT_NAME ,ac.IS_identity FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS COLS INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS CONS ON COLS.CONSTRAINT_NAME = CONS.CONSTRAINT_NAME JOIN sys.all_columns ac ON OBJECT_NAME(ac.object_id) = COLS.table_name AND ac.name=COLS.COLUMN_NAME WHERE CONS.CONSTRAINT_TYPE LIKE 'PRIMARY KEY' ORDER BY COLS.CONSTRAINT_NAME, COLS.ORDINAL_POSITION as i wrote this pretty quick and didnt test it fully.. using it is on your own risk ;) Guldmann, platon.dk ...Show All
SQL Server Does the index exist after restore? (ie Does RESTORE destroy the indexes?)
We performed re-indexing at beginning of month We had to restore from last night's backup and are seeing performance issues, so I am wondering if the clustered indexes are lost after the restore operation Do we need to re-index again in short, does BACKUP backups the indexes does RESTORE restore the indexes Hi Jerry, The BACKUP DATASE command will backup all database objects, including indexes, users, diagrams etc. that exist at the time the backup command is executed. So, in short BACKUP does backup indexes and RESTORE does restore indexes Cheers, Rob ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Could this be used to make a Morrowind scale RPG?
Hello, I was just wondering if XNA could be used to make an Morrowind scale RPG Mousegp wrote: so even if you use the vast amount of materials already available from the PC version Would be really all that hard honestly... cause i was planning on doing a mod with it... Judging from the scope of the game you want to do, I'm guessing you're not just going to do it for your personal education purposes. Stealing assets from a published game is not only illegal, if you violate Fair Use laws, the publisher is likely to sue you into oblivion (no pun intended). You'd better talk to a lawyer before you do something like that, before lawyers come talk to you. ...Show All
Visual Studio Team System Multiple Problems in Same Class?
Hi, I have a rule where I want to return multiple Problems for the same class. Adding new Problem instances to the Problem collection is allowed, however only ONE problem is ever reported. For example, given the following rule: public override ProblemCollection Check( Class c) { Problems.Add( new Problem (GetResolution( "Problem 1" ))); Problems.Add( new Problem (GetResolution( "Problem 2" ))); Problems.Add( new Problem (GetResolution( "Problem 3" ))); return Problems; } The output is only ever "Problem 1" for each class. Is this a known issue Thanks, Duncan Dunca ...Show All
Game Technologies: DirectX, XNA, XACT, etc. XNA and its runtime libraries
I haven't heard anything on the runtime files that would be needed to fully execute a XNA program, at least, officially. Managed DirectX caused three runtime files before which I think stopped a ton of programs from being released. Little Timmy wanted to show his friend a Pong game that he wrote, but he needed the .NET framework installed, the Managed DirectX files and the DirectX runtime itself. Add each one up and it was roughly an extra 80mb (I'm guessing). Downloading the games from the web was easy, but executing them had requirements like "you have to download this, this and this." I would have skipped to another game. Is this going to be the same issue with XNA How does the installation process differ ...Show All
Windows Forms capture node of treeview in textbox??
Hi... I have created a tree view, and its nodes are getting populated from the sql server database. Now i wanted to capture the node which is selected and show it in the textbox. I used the selectednode option to retrieve the node in a textbox, but i am not getting the node name in the textbox.. My code is as follows: using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient; public partial class _Default : System.Web.UI. Page { protected void Page_Load( objec ...Show All
SQL Server "Package Configurations" Problem
Hi all, I have just set up my first deployment utility for the Integration services package i've been building. I seem to be getting problems with the package Configurations. I added an XML config file so that i could change the values of my SQL connection manager at deployment time. This was so that i could deploy it on both a test environment and the live environment. Any other variables can be changed in code by the calling application. As soon as i added the options for the sql connection manager and enabled package configuration i got errors when running the application: [Execute SQL Task] Error: Failed to acquire connection "InternalProductionData Connection Manager". Connection may not be configured correctly or you may no ...Show All
Visual Studio 2008 (Pre-release) Dependency Property's
this is a follow up post about my problems with custom controls. essentially i am creating a graph custom control, however the graph must display any number of lines, consequently i cannot say (in generic.xaml) <Canvas> <Polyline.............../> <Polyline.............../> <Polyline.............../> ................... </Canvas> because i never know how many lines to create. this means that i need to change my CS code to allow for any number of lines. this will mean i have a situation whereby either the company who uses this software can say <lineChart......................> <linePoints................/> <linePoints................/> <linePoints................/> ....... ...Show All
