vbhatia's Q&A profile
SQL Server Managing Scheduled Jobs from Management Studio Express
I'm working on a backup solution for my company. Right now we have three servers in three locations running SQL Server 2000. For testing purposes, I created a scheduled job on one of these servers. It worked fine but I'd like to tweak the job some, tinker with the timing and save locations. I'm using Management Studio Express on my laptop to remotely work with these databases but I can't seem to find a decent way to work with existing jobs. Am I missing something or does SSMSE lack the "manage jobs" functionality SSMSE only exposes functionality that is available in SQL Express. Since Express doesn't include Agent, SSMSE doesn't include the ability to manage Agent jobs. The SQL 2005 Feature Pack includes some DTS 2000 ad ...Show All
Visual Studio 2008 (Pre-release) Is it possible to localize a WPF dll (Custom Control Library)?
Hi All, I have been trying to translate an application to a foreign language. App = XAML GUI, C# code and resx stringtables. If the app is an executable, I can translate and see the app in foreign language. All OK (even though it's a very lenghty process). If the app is a dll, I can translate and everything is fine including the generation of a merged satellite assembly. BUT it will always default to English. I cannot make my dll to display in a foreign language. Never. And I am surely setting the UICulture as necessary. Has anyone succeeded in localizing a WPF dll Anyone Regards, Ari ...Show All
Visual FoxPro Ideas for Desktop Wallpaper using JPEG, TIF, HTML, Etc., vs BMP?
Hi all; much thanks in advance for any specific or general thoughts on Desktop Wallpaper automation of VFP-9 reports. Now that report listeners (VFP-9) create TIF files from reports I wonder if peradventure it might be easier to automate Desktop Wallpaper from such reports. Currently I use bitmaps as allowed by the dll: PCT_DLL.dll (see below). This works but requires akward 'Print Screen' automation do wallpaper with 'reports\visit\schedmo' && below FUNCTION wallpaper LPARAMETERS a,a1,a2,a3,a4 _SCREEN.AlwaysOnTop = .T. lstate=(_screen.WindowState) IF EMPTY(a1) or EMPTY(a2) &&etc lcBuffer=Space(22)+Chr(0) If GetPrivStr("Screen","WallPaperDimensions","", @lcBuffer, Len(lcBuffer), Cur ...Show All
Visual Studio Express Editions Can't seem to change opacity of window
In this code: http://nomorepasting.com/paste.php pasteID=74503 I'm trying to simply change the opacity of any window. But that doesn't seem to be working. Anyone know what I'm doing wrong and/or how to get this to work I'm not talking about changing the opacity on the forms my app spawns, thats easy, but any other window, like mIRC, or internet explorer. ...Show All
Game Technologies: DirectX, XNA, XACT, etc. xna and xbox 360
hello for all, i have a little question here, i'm making a game for windows with the xna framework 1.0 but in the future i will want to port it to xbox 360, with the xna framework i will can sell the game or i need another framework or sdk to make a xbox 360 comercial game i 'm a new indie game programming and i need help with this topic, i want to know if there will be another version of the xna or another sdk to make comercial xbox 360 games and the cost of this software. Thank you in advance.. To sell the game on the 360, you will need to have the professional version of XNA and be certified by Microsoft. It is not clear how you go about doing this as an indie at present. XNA express will only al ...Show All
Visual Studio Sand Castle with ASP.NET 2.0 Applications
Hello, I am developing asp.net 2.0 application and want to use sand castle for documentation purpose. Sandcastle takes in dll as the input. I am not compiling the application in to a dll but thinking of deploying the application on the server by copying the folder. So how do i develop the documentation. Kindly help me out. Thanks!! SqlNew Typically the .aspx page is converted into a class and compiled into an assembly. Generating an assembly for a particular .aspx resource is a two-step process. First, the source code for the class is created by merging the content of the <script> section with the code-behind file, if any. Second, the dynamically generated class is comp ...Show All
.NET Development How to Catch Invalid UserID/Password on Client (WSE 3.0) ?
I have a Web service and a windows client that calls the service. I am using WSE3, x509 to encrypt with a custom UserNameToken. I am trying to figure out how to specifically catch a wrong UserID/Pwd so I can display a friendly message. I call my WS method with a Try/Catch, specifically catching exceptions of type "ResponseProcessingException". ResponseProcessingException.Fault.Message contains, in part, the text: "WSE565: The password provided by the SecurityTokenManager does not match the one on the incoming token." Besides parsing text, I see no obvious way to detect an invalid UserID/Pwd. Is there a better way to get what I am looking for Is there a better way to handle WS exceptions on the client ...Show All
.NET Development write database data row by row into excel
Hi, I have created an application where I can write to a particular cell in an excel spreadsheet. How can I loop through each row of the excelsheet so that I can place the database row data into each row of the sheet something like: foreach excelsheetRow (i) //i represents the row number cell(Ai).value = DataRow(i).column(i); cell(Bi).value = DataRow(i).column(i+1); cell(Ci).value = DataRow(i).column(i+2); ... Thanks I would take a look at the below MS KB article. You may want to change your approach. How To Use ADO.NET to Retrieve and Modify Records in an Excel Workbook With Visual Basic .NET ...Show All
Windows Forms ClickOnce Error On Client Machine
Hi All, I don't know if this is a serious problem or if it is a quick fix. I have successfully published a Windows App from my development PC to a file share on the network. I began the installation of the app from a client machine and everything went fine, installed all the prerequisites (.NET 2.0, Windows Installer3) and then the following error was displayed: The following error occurred attempting to install C:\Documents and Settings\comp\Desktop\app.application "The System cannot find the specified file" The target machine is running Windows XP Pro SP2. Is this a setting that I setup during the publishing process Should the setup.exe be run from it's current location or saved and then run Thanks P.S. Here is the log file entry t ...Show All
Windows Forms Deployment Help
Hi could someone please help, Ive deployed my application to my webserver using the clickonce installation within Vb. 1 .When I goto the website i can install no probs 2. My mate can go to the website and install no probs 3. But a select few when they click on the install button, it will display a xml file rather then downloading. Could someone please explain the reasons for this Find out if they have .net frame work 2.0 and if they don't have ask them to install .net 2.0 and try again. The second issue could be their .application association in the file association or you can look at the registry and make sure it is associated with application deployment. Thrid, someothers also have the ...Show All
Visual Basic Compilation error
Hi ,I get an compile error , cannot find a project or a library ,with the following line highligted in the code ,Implements ISubclass. Do you have the implements statement on your properties, sub, or functions Public Interface ISubClass Function MyFunction() As Integer Sub MySub() End Interface Public Class TheTestClass Implements ISubClass Public Function MyFunction() As Integer Implements ISubClass.MyFunction Return 0 End Function Public Sub MySub() Implements ISubClass.MySub End Sub End Class ...Show All
SQL Server Dynamic lookup with periodical (Yearly) data using JOIN
Hi, I am generating a dynamic SQL query to perform a lookup based on criterias entered by the user. The quey is generated by a C# application and the target database is Sql Server 2005. Basically I have 2 tables: --Cie-- (Over 40k companies, 1 rows per companies, total 40k rows) ( CieId int not null, Symbol varchar, CieName varchar ) Primary key(CieId) --YearlyData-- (Over 40k companies, 20 years of data per companies, total 800k rows) ( CieId int not null, Year int not null, Revenue currency, NetIncome currency, [... over 170 columns ] )Primary key(CieId, Year) //Sample Case: The user want to get the list of all the compagnies (CieId) where YearlyData.NetIncome > 25k for YearlyData.Year 2005 and YearlyData.Revenue &g ...Show All
Smart Device Development Avoiding/Eliminating the "OK to Reinstall dialog box"
I've built an enterprise solution that includes both a WinForms app and a Pocket PC app. To facilitate the installation of the mobile app, the WinForms app copies the Mobile CAB file over to the device and then executes it. It works fine except that whenever and update is being installed, it presents the following dialog box: Blah-blah-blah is already installed. Re-install OK Cancel I'd very much like to find a way to eliminate this dialog box. Does anybody know how Robert Werner Vancouver, BC Hmmm ... I used the "Run" mode on my Dell Axim and manually exited "wceload" but no combination could avoid that dialog box. To be precise, this is what I ...Show All
Visual C# In the .net class framwork, there is a number of class ,Is there any best practise to get familar with these classes?
In the .net class framwork, there is a number of class such as System.Runtime.Remoting etc, Is there any best practise to get familar with these classes I want to know where can i get all the sample programs to be familar with the .net class library. I appreciate your help. use the following site: http://www.codeproject.com they have a lot of artclise from beginners to experts and you can browse them by technology, language, and so on. ...Show All
SQL Server sql express and sql enterprise on same machine
Is it possible to install both an enterprise instance of sql 2005 (MSSQLSERVER) and an express instance of sql 2005 (SQLEXPRESS) on the same machine Ryan Yes. They can be installed side by side successfully on the same machine. But their instance names should be different. Hereby, MSSQLSERVER is the dafault instance name for Enterprise and SQLEXPRESS is the default instance name for Express. ...Show All
