Furrukh Baig's Q&A profile

• SQL Server Rewite PL/SQL query in SQL Server 2005

  How do I rewrite the folloiwng query of PL/SQL in SQL Server select 1 from sffnd_stdoper a,sfpl_plan_rev b,sfpl_oper_v c                   where b.plan_id = c.plan_id                   and b.plan_version      = c.plan_version    &nbs ...Show All

• Visual Studio Team System Is there any limitation on view state size.?

  Hi,   I have recorded a script using webtest.   Then I have attached .csv file to it for parameterisation.   But while playing back the script, the data is not getting saved.   I suspect size of the view state is very large.   Is there any limitation on the view state .   If yes how do we handle the view state that is more than view state that is more than the maximum size.     FYI I hav ...Show All

• Visual Studio Crystal report doesn't show data from a Project data ( DataSource ) Access DB

  Hello ... i've got in troubles i'm using VS 2005 VB.NET, and i'm trying to do a report with Crystral reports.... my problem is that Crystal report doesn't show data from a Project data ( DataSet ) from my data base that is made with Access DB. i select the DataSet ( with the wizard ) that is in my project and when i execute the report no data is shown. BUT if i select the Access database file and its location (with the wizard ), it work ...Show All

• .NET Development setting up OLE DB connections / drivers

  Ola - I was using the online .Net dev environment and immediately wanted to try to connect to my database (i.e. local to my machine/network, not the online environment's). It wanted an OLE Db connection, as (I understand) .Net doesn't use ODBC any longer (yes, I am just coming up to speed on this ). However, I can't find any clear directions on a) where and which ole DB  drivers to get and b) how to install them or set them up so the .Net d ...Show All

• Visual Studio batching issue

  i'm trying to take a semi colon delimeted string(metadatum) and create and item like this: < CreateItem Include = " %(SolutionToBuild.FoldersToHarvest) " > < Output TaskParameter = " Include " ItemName = " ThisFoldersToHarvest " /> </ CreateItem > < Message Text = " ThisFoldersToHarvest: %(ThisFoldersToHarvest.Identity) " /> The item is successfully created and the contents are sp ...Show All

• Windows Forms Installing 3rd party prerequisite with bootstrapper and multiple MSIs support using ClickOnce

  I have the following scenario. I am trying to install a 3rd party prerequisite that has multiple MSIs and one bootstrapper. I am using VS 2005 Beta 2 with ClickOnce to install this component. Since there are multiple files included in the 3 rd party tool installation, ClickOnce can't just download the 3 party bootstrapper but also needs to download all the 3rd party MSIs that bootstrapper is using. One solution might be combining MSIs and ...Show All

• .NET Development Fill database from XML

  Hello guys, I have a database stored in an XML file (Dataset.WriteXml()). Now i want to recreate the database file from the XML file. I already know how to create a database file using ADOX I also fill a dataset with ReadXML from the XML file i have. What i dont know is: How am i going to fill the database created with ADOX from the XML file. I also know how to create tables in ADOX what i dont know is how to fill the tables with data from the X ...Show All

• SQL Server SQL Agent Hangs

  I have an SSIS .dtsx package that will run fine during debugging, however, when I run it as a job under the SQL Agent the job won't start. To be more specific, the Agent will load the package, ensure that it passes validation (which it does), then sit there without starting the rest of the package. The job will run under the "executing" status until I stop it manually. Does anyone have any idea why it might be doing this ...Show All

• Visual Studio 2008 (Pre-release) Why will LINQ fail ?

  Microsoft tries to helping object developers to close the gap between the relational world and the object world.And they call this " object modelling approach " Dlinq. Using " custom business entities " in enterprise programming with Dlinq might seem the best thing after " sliced bread " but it isn't. For my part I have written my Mappers and used commercial OR/M tools. They mostly provide the same thing. __Read the table from the datab ...Show All

• Visual C++ LNK2019:Unresolved External Symbol when trying to link my DLL

  can anyone help me in this problem. I have a program which i wish to compile to dll. I managed to compile it into a dll format. But in order to ensure the dll is working I wrote a simple test program. But when i compile the test program it give me this error: This is the dll program: #include "stdafx.h" #include <math.h> #include <cmath> #include "caaSfdt.h" #include "caaLinearInbtwn.h" #include "caaFi ...Show All

• SQL Server Visual Studio 2005 Beta 2: Using SQL Server 2000 instead of SQL Express 2005

  Hello I installed Visual Studio 2005 Beta 2 without SQL Express 2005 because I already had SQL Server 2000 Developer Edition. Now I’m getting errors which says that SQL Express cannot create the needed databases when eg. launching a Web Starter Kit. Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. Description: An unhandled exception occurred during the execution of the c ...Show All

• Visual Studio Tools for Office COM Shims

  I am new to creating COM Shims. I want to know for which all asseblies other then Office Extensions that we can create COM Shims. How is it implemented in Application Packaging and how can we find out which assembly requires COM Shim to be created. Sudhir, I am a little bit lost. I assume you are talking about the technique outlined here http://msdn.microsoft.com/library/default.asp url=/library/en-us/dno2k3ta/ht ...Show All

• Windows Forms FrontPage publishing wizard component

  I'm looking for component similar to FrontPage 2003 publishing wizard. Is there any component / code available ...Show All

• Visual Studio 2008 (Pre-release) Calling type extension method recursively

  Hi, Does anyone of you know if it's possible to call a type extension method recursively. Example public static IEnumerable < RegistryKey > GetSubKeys( this RegistryKey registryKey) {   IEnumerable < string > registryKeyNames = registryKey.GetSubKeyNames();   foreach ( string registryKeyName in registryKeyNames)   {     RegistryKey registrySubKey = registryKey.OpenSubKey(registryKeyName) ...Show All

• .NET Development Encryption and decryption in VB.NET 2005

  Hi everyone, I want to have a nearer look on encryption and decryption with VB.NET 2005 with System.Security. I want to decrypt some text into a file and encrypt it some times later with a password. Is it possible Can somebody offer me some code Thanks and a great christmas time Check out the  Cryptography Application Block thats part of the Microsoft patterns & practices Development Center.&n ...Show All