Nate879's Q&A profile

• Visual C# Import Excel Spreadsheet Data into SQL Server Database Table

  Hi All, I am trying to import data from an Excel spreadsheet into a SQL server db table though having some issues. This is the code I'm using: private void Button1_Click( object sender, System.EventArgs e) { // Connection String to Excel Workbook string excelConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Book1.xls;Extended Properties=""Excel 8.0;HDR=YES;"""; // Create Connection to Excel Workbook using (OleDbConnection connection = new OleDbConnection(excelConnectionString)) { //OleDbCommand command = new OleDbCommand ("Select ID,Data FROM [Data$]", connection); connection.Open(); OleDbCommand command = new OleDbCommand ("Select ID,Data FROM [Data$]& ...Show All

• SQL Server External Activation and Notification Services

  I have been going over the samples from PDC 2005 and trying to run the External Activator program in section 2 'CLR Services'. After sending a message to the Inventory Queue, I see that 'dm_broker_queue_monitors' table has a row in the table, with the state column shown as 'NOTIFIED', but the ExternalActivator program never gets notified of the event and therefore never launches the 'InventoryServer' program. Querying the [ExternalActivatorQueue] shows no rows. Querying the [Inventory Queue] shows messages are waiting to be received. Executing the 'activator' command in the ExternalActviator program shows Notification service 'ExternalActivator' on SQL Server 'DBSERVER\' and Database 'In ventory' is connected to the database and working. ...Show All

• Visual Studio Team System Problem viewing Team Foundation Server Installation guid

  I downloaded the TFS Installation guide .chm file. When I open the file and click on any of the topics, I get an error message in the frame on the right that says "This program cannot display the web page". I am connected to the internet and seem to be fine network connectivity wise. What could be preventing me from seeing any of the help topics in the file Is there another way to view this installation guide Thanks! Any chance it's the "CHM block" issue If it's not that, you may just want to view the topics on MSDN online since you have internet connectivity already. http://www.microsoft.com/downloads/details.aspx FamilyID=E54BF6FF-026B-43A4-ADE4-A690388F310E&displaylang= ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Creating depth textures and getting back buffer in beta 2?

  Alright, so the API for this is totally different for beta 2. That's fine. But I can't see how you create depth textures now. I'm using them to render shadows. Also, how do you get and restore the back buffer now Do you do something like: RenderTarget2D backBuffer = (RenderTarget2D)device.GetRenderTarget(0); ... device.SetRenderTarget(0, backBuffer);   Rim van Wersch wrote: You can create render targets with SurfaceFormat.Single, which still seems to work as it should. If you create a render target as SurfaceFormat.Single, how do you get the DepthStencilBuffer that you use to set into the GraphicsDevice.DepthStencilBuffer ...Show All

• .NET Development 3 DES with 32 byte key Length with Visual Basic DES Class to decipher an IBM 3624 Pinblock

  Hey guys, I have a problem on my hands at the moment as I am trying to decrypt a string with 16 bytes and 2 key components of 32 bytes. As below: Key component 1 = F457E52AB083BCECA17F230B23B36B34 Key component 2 = 6D52616E5D755B4ADA948F31ECD5107C Encrypted block = 2C187291DCEEB9B9 From what I have picked up the visual basic DES class does not support that. Is any way I get round this. skimming through CCA Release 2.41 on IBM's website may yield necessary information. From what I read about people attacking IBM 3624 there are certain offsets applied before encrypting/decrypting. ...Show All

• Software Development for Windows Vista The UAC Nightmare

  I'm beginning to reach the conclusion that the current implementation of the UAC in Vista is, IMO, a nightmare that creates more problems than it solves. If Microsoft wants developers - and users - to embrace the UAC (instead of just turning it off altogether) then it better come forward with a LOT MORE information and support than it is currently providing! If it doesn't, I will begin to suspect Microsoft only added the UAC so it can tell Windows users 'well, we added the option to secure Windows - you're the ones turning it off' and therefore wash its corporate hands. I would really hate to see this happening. To name just a few of the problems the UAC brings to us developers: 1 - Applications that require Admin privileges are bloc ...Show All

• SQL Server Number Of Business Days

  Hello, Without creating an additional table and with the least amount of code, I'm looking for a way to determine the number of business days in a given month. Thanks Let's start by clarifying that my name is not 'man'. Though I appreciate your willingness to help, it seems you are unable to do so without having every single detail given to you. Possibly I plan to edit the code depending on what holidays are observed by a particular organization. Unless you have a function tucked in your back pocket which automatically excludes certain holidays, I don't see that it matters which ones are used for example purposes. If you do have such a function, we can use whatever holidays it uses. ...Show All

• Visual C++ How do I pass cin values into a constructor function

  I'm right at the beginning of my C++ journey, and I'm having trouble modifying code to do what I want! readers of SAMS will be familiar with the code example, if not the problem! I have a Class (Cat) that can be used to create Cat Objects (Frisky, Shandy, etc.) from header file cat.hpp:- //this is cat.hpp #include <iostream> class Cat { public : Cat ( int initialAge); // Constructor - initialises the class with the variable initialAge ~Cat(); // destructor - does nothing int GetAge() const { return itsAge;} // inline! void SetAge ( int age) { itsAge = age;} // inline! void Meow() { std::cout << "Meow.\n" ;} // inline! private : int itsAge; }; ...Show All

• Software Development for Windows Vista Credential Provider instead of GINA

  Hi, Earlier I had a customized GINA dll , which reads the credential from the smart card and allows the user to login. Now How Can I provide the same functionality on Windows Vista, Can I get the sample code which reads the credential from the Smart card and passes to VISTA. One more thing, Can I use Visual Studio 6.0 for Creating the dll which will use ICredential Provider Any kind of help will be highly appreciated. GINAs were getting some support from winlogon with regards to smartcard events. Credential providers are on their own. The core API for monitoring SC insertion/removal events is SCardGetStatusChange. ...Show All

• Visual Studio Express Editions Stopping Redirects

  For the current project i am working on, I am try to load a webpage that constly redirects to the wrong page. How do I stop this Varix wrote: I tell it to go to www.this.com when it goes to www.that.com This "redirection" might be happening at the HTTP level and it might not be something that you can control from the form. If you open a browser and direct it to http://www.this.com , do you get http://www.that.com as a result The form is probably accessing the same http layer when a URL is being accessed. For a concrete example, try http://nfoWare.com . URLs for that site are automatically web-forwarded to a subdirectory of a different site. There's nothing you can do about ...Show All

• .NET Development ngen display Catastrophic failure

  Hello. When i running "ngen.exe dispay", i have message Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Message in system log .NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Service reached limit of transient errors. Will shut down. Last error returned from Service Manager: 0x8000ffff. I installed latest version .NET from microsoft.. What wrong with my .NET Framework Ngen Queue Status gives: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>Ngen Queue Status Microsoft (R) CLR Native Image Generator - Version 2.0.50727.42 Copyright (C) Microsoft Corporation 1998-2002. All rights reserved. Service name is: clr_optimization_v2.0.50727_32 The .NET Runtime Opt ...Show All

• Windows Forms ClickOnce in .Net 2005

  Hi, I would like to implement automatic updates to my application (which is in C#). I’m quite confused, I heard that there is ClickOnce\ Updater Application Block built in .Net 2005, is it correct How do I use it Were can I find relevant tutorials In the MSDN site I could find only the Updater Application Block for .Net 2003 Thanks, Gil You might want to read some messages in this forum about the issues with ClickOnce and certificate expirations. (I don't have a URL handy. Sorry.) In a nutshell, once your certificate expires, your users will have to uninstall and reinstall the app. to get updates. Renewing a certificate won't work as far as ClickOnce is concerned. The only work around is to generate a t ...Show All

• SQL Server Problem in RSWebApplication.config file

  Hi i used http://msdn2.microsoft.com/en-gb/library/ms160724.aspx MSDN Article sample to enable custom security method in to my report project, also i RSWebApplication.config <ReportServerUrl>http://localhost/reports/pages/folder.aspx</ReportServerUrl> but each time when i login using a correct user name and password from the login page it just automatically redirect to the http://localhost/reportserver url but i need to change it to the http://localhost/reports/pages/folder.aspx url how can i do this task regards sujith Hi Sujith, You misinterpreted the instructions. The ReportServerUrl must point to the report server virtual root, not the report manager vir ...Show All

• Windows Live Developer Forums WiFiIPService/locate.ashx using pure PHP, no JavaScript running on client computer

  Is there any way to call from PHP like this and get the client's lat/lon $httpfile = file_get_contents(" http://local.live.com/WiFiIPService/locate.ashx "); This always returns the web server IP address. This article says to use JavaScript but for my purposes I can't actually run any JavaScript.. http://viavirtualearth.com/vve/Articles/ObtainingVisitorLocation.ashx I need to run pure server-side PHP. I have the client's IP address from the PHP function -- $_SERVER['REMOTE_ADDR'] And I can actually successfully get the IP address using the free HostIP.info service with this syntax.. $httpfile = file_get_contents(" http://api.hostip.info/ ip=".$_SERVER['REMOTE_ADDR' ]); It's just that HostIP ...Show All

• Visual C++ error LNK2019 :/

  Hey everybody I have some linking issues with VS 2005. I have created a static library "V2D", this is a library of a simple 2D Vector. I have compiled it and in the V2D project's debug dir I got the v2d.lib. Now I want to try and use this V2D lib from another project so I have created a win32 console app testing project. I have added the path to the V2D.h file and the path to the V2D.lib file and when i try to build the testing project I get this error: main.obj : error LNK2019: unresolved external symbol "public: __thiscall V2D::~V2D(void)" ( 1V2D@@QAE@XZ) referenced in function _main this is the testing project main.cpp file #include <v2d.h> void main() { V2D v(1,1); ...Show All