Roopesh Babu Valluru's Q&A profile

• Visual Studio Express Editions Q about appliation and file interaction and structure

  Purpose of application: Pull necessary info from Quickbooks to be used in production scheduling. Use some customer/order info from QB to make/ keep Contact/Communication history and Returns Tracking. Keep track of Shop expenses in a central location, including individual efficiency to be used in calculating bonuses I will be skimming info from a QuickBooks file to be used in this separate app. This skimmed data and new data to be entered will be stored in a separate file/DB (question about that to follow). QB, as far as i know, doesn't allow create tables. Using the QODBC driver, I can connect to the QB data with the supplied app from flexQuarters, can read/write data, but can't create or modify tables to store my specific data. using the ...Show All

• SQL Server Paging in Stored Procedure

  I got this code on internet for Stored Proc paging. This will work if my final result is the order of eployee id. In my case my final result is in the order of emplyee name. What i have to change in below code so i can have paging in SQL plus my order is by name. I dont want to create Temp table. Becuase i think Creating temp table is overhead to sql server and in that case i'll use Datagrid defualt paging and return all rows always.(My total number of rows will not be more than 300 and in 70% cases they are below 100) CREATE PROCEDURE [dbo].[usp_PageResults_NAI] ( @startRowIndex int, @maximumRows int ) AS DECLARE @first_id int, @startRow int -- A check can be added to make sure @startRowIndex isn't > count(1) -- from ...Show All

• SQL Server read data from log

  hi all how i can read all the querys that send to the server exmple insert , update statement need all this statement at the end of the day how can i do that by sqlserver thanks alot Start up SQL Server Profiler. Create a new trace. Specify the desired events. Run the trace. You can collect the events into either a flat-file or a table (useful for issues additonal queries against it for integoration purposes). ...Show All

• Visual C++ DLL registrations errors

  Hi all, I have created a setup and deployment package. In this package, I have included DLLs that are meant to be self-registered upon installation. I have shipped it to someone else and now the person gets the following error: NAS New HAL API > Module C:\Program Files:\NAS New HAL API\NAS New > HAL API\OGT.dll > failed to register. HRESULT -2147010895. Contact your support personnel. I have tried searching for the error on the internet but the best I get is a similar error on support. Basically the suggestion is: To resolve this problem, download the latest Microsoft Data Access Components (MDAC) version. You can download the latest MDAC version from the Microsoft.com Download Center. To do this, follow these steps: M ...Show All

• SQL Server autonomous transactions

  Is there any equivalent to Oracle's autonomous transaction in sqlserver. No. There is no way to do this in SQL Server right now. You can write extended SPs or CLR SPs (SQL 2005) that performs a different connection to the database. But this approach has it's own limitations and scalability problems. One workaround that will work in SQL2000/2005 depending on your requirements is to use a table variable within a transaction to dump the information. Table variables do not participate in user transactions so you can later retrieve the rows and dump them into an error log table for example after the transaction has been rolled back. ...Show All

• Visual Basic Sharing Functions and constants between forms in an application

  I'm sure this is a really easy thing to do but I cannot get it to work. I have declared functions and constants as public in my main form but these cannot be seen by other forms in the application. Could  there be something simple I'm missing as everywhere I've searched just states - if the objects are delared public then they will be available for use in other forms     All help appreciated. Try using the Shared keyword in the function declaration. That way, the other forms won't have to use a reference to your main form to use the functions. For example: Public Class Form1 Public Const pi As Double = 3.14 Public Shared Function WhoIz() As String Return "nobugz ...Show All

• Visual Studio References in Project Templates

  Am I missing something here - I create a Windows App project with a form and a reference to a class library assembly. - I then create a project template from the project. - I then create a new project based on my template. The class library assembly is listed under References but with a yellow icon and no path. - I readd the reference to the new project. - I recreate the project template. - I then create a new project based on this template Now the class library assembly is properly referenced. The How to: Add References to Templates help topic implies this is the proper procedure. So, - A project template created from a project created from scratch will not properly add a reference. - But a project template created fro ...Show All

• SQL Server Performance Issues, "Size" of SSIS-packages

  Hello! I have a general question concerning the impact on the performance of massive parallel data imports in one SSIS-package. We have a Database on a SQL2005 SP1-Server (2 Xeons 3,8 Ghz, 4GB of RAM) for a report web-app which is updated every day with data of the last year/3 years. The data is extracted from several different DBs on multiple machines at different locations. Right now, there are imports/transformations from 7 companies at 3 locations. The table has ~80 columns and about 2 Mio. Rows. I built a SSIS-Package with one companies import and added the others by c&p-ing all the tasks in the package and changing connection parameters and values. Soon there will be 6 more companies to do imports with, and there will possi ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Speech

  Hi. How can i make a program that can be controlled using speech (Like the speech recognition in Office 2003) For example, if the user says 'exit' the application will close. I know this may seem a bit vague but i want to keep it a simple as possible. There are some samples in the speech sdk http://www.microsoft.com/downloads/details.aspx FamilyId=5E86EC97-40A7-453F-B0EE-6583171B4530&displaylang=en I think there’s a newer version but I’ll let you look around for that if there is. ...Show All

• SQL Server SQL Server Management Studio Express - cannot find SQLEditors.DLL

  In SSMS Express, after right-clicking on a table and then clicking on "Open Table" or "Modify", this error was displayed: " The system cannot find the file specified Microsoft.SqlServer.Express.SQLEditors" . This file does exist and is in the same directory as SSMSEE.EXE (C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE). Other context menu items "Script table as" and "Properties" work fine. I did not try the other context menu items. Is this something that is fixable Version Numbers: Microsoft SQL Server Management Studio Express 9.00.2047.00 Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158) Microsoft MSXML 2.6 3.0 4.0 5.0 ...Show All

• Internet Explorer Development Windows Popup

  I'm trying to build a popup menu bar, but I'm having problems figuring the OM. I've used a UL list in the dynamic popup, but trying to style the list items is not possible the usual way.Therefore, I consider I will need to map the styling through the popup script Any suggestions It's alright Lance, a simple re-re-revisit to the Online manual revealed the popup never has focus, so my attempts of that method will not work; so back to standard spanning I suppose. Kind regards ...Show All

• Smart Device Development how to connect this 2 applications?

  Hi expert, I am new in Mobile application development.Can anybody out there teach me how to setup connection between this 2 application. Receiving SMS Creating call events PS: I am using Visual Studio 2005 not Visual Studio .NET 2003. Thanks in advance. ...Show All

• Smart Device Development Error in Accessing SQL CE

  Hi iam using Pidion (BIP 500) using CE NET 5.0. When i try to access Database (SQL CE 2005) in this Device iam Getting a error as Can't find PInvoke DLL 'sqlceme30.dll'. I tried the same application using EMulator its working well out there but only when it's run in the device its giving me the error. I tried to create a new SDF File using Query Analyser and it gave me a error as "Failed to Intialize the Provider. Please Make sure the SQL Server Mobile Edition is properly Installed" Anyone can guide me on this issue. Thanks in Advance Biju There's hot fix for Platform Builder (tool which is used to create Windows CE images) for NETCF V2 from which OEM can figure out required dependenc ...Show All

• SQL Server error with scale-out web server: Invalid object name

  We are adding a second web server to our farm. Reporting Services is installed on one web server as Rpt01 instance and works just fine. We have installed the second web server also with an instance named Rpt01 and are now trying to configure to re-use the same database as the first server. When we restart services we get the error listed below. I was wondering if there was an issue with the same named instances on two different web servers accessing the same ReportServer01 database This is the error that we are getting. Any help would be appreciated. The curious thing is that our databases are named ReportServer01 and ReportServer01TempDB and not the name listed below. ReportingServicesService!schedule!4!1/23/2007-15:40:20:: Unhandle ...Show All

• Visual Basic Problem registering active x control

  I have vb.net application that uses vb activx dll. I need to programmtically register this dll I use following code Dim ProcStartInfo As New System.Diagnostics.ProcessStartInfo ProcStartInfo.Arguments = ""C:\vb Code\activXdll\actdll.dll"" ProcStartInfo.CreateNoWindow = True ProcStartInfo.WindowStyle = ProcessWindowStyle.Hidden ProcStartInfo.UseShellExecute = False ProcStartInfo.FileName = "C:\WINDOWS\system32\Regsvr32.exe" System.Diagnostics.Process.Start(ProcStartInfo) I still keep geting Com exceptions till I manually register it using Regsvr32. What wrong with above code Well the problem was when I use above code my vb.net application throws exception th ...Show All