Drew Letcher's Q&A profile

• SQL Server Backup SQL 2000 SP4 and Restore on SQL 2005

  Does anyone know if this works to where the data is viewable/usable I have an application that takes datasets out of the SQL database. We decommisioned our old SQL 2000 SP4 machine and brought in a SQL 2005 Server. What we did was backed up the old database and then restored it on the new Server. Now the application does not see the old datasets but will collect new ones that are viewable. We can import older datasets but we have nearly 27 GB of data, which our DBA can see the old tables in Enterprise Manager but our applciation can't see it. I'm thinking it might be a schema issue or the way that 2005 translate the odler 2000 S ...Show All

• Visual Basic Manage seconds <<

  Hi, I have a problem regards keeping track of seconds elapsed. As shown below I have a loop where it must only enter while less then 5 seconds have passed from when it started. The problem is that if the code is run at 55 seconds or more, the (Waiting + 5) will be 61, 62, 63... and not 1, 2, 3...   Dim serialWaiting As Integer Do While Now.Second < (serialWaiting + 5) Loop   Can someone please help me Thank You Thanks pal (didn't know about the Now.Subtract...). ...Show All

• Smart Device Development DataSet error

  hi all i have a problem in an application that accesses ms SQL Server via a web service using this code Dim handler As New WHService.Service1 Dim query As String Dim result As Integer Dim temp As New DataSet query = "Select .........................." result = handler.queryDB(query) ' Amethod from the web service tested & functioning For Each tempRow In result.Tables(0).Rows ' here is where exception happens 'do something Next the exception is null pointer exception when using table name and it becomes index out of range when using index to get table ...Show All

• Visual Studio 2008 (Pre-release) WCF not working on Windows 2003 IIS

  Hi, I downloaded the latest September CTP WinFX Runtime Components and WinFX SDK, and tried to run an Indigo simple sample.  However, when I use IIS I receive 404 error when browsing to the service.svc file. I found that I needed to do: * aspnet_regiis -i * xws_reg -i * cscript InstallIndigo.js c:\windows\microsoft.net\framework\v2.0.50215 However, the last step gives me an error like this: Reserving the HTTP namespace... Error *** : A runtime error occurred executing command - Some or all identity references could not be translated. ...Deleting registry keys. And I cannot get my Indigo services running. What can I do to make it ru ...Show All

• Visual Studio Team System Error code is 26403

  I get a very generic message during the upgrade about the source possibily being corupt.  --------------------------- Microsoft Visual Studio 2005 Team Foundation Server Setup --------------------------- The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 26403. --------------------------- OK   --------------------------- I checked the install log and found the following error prior to the rollback.  Couldn't load string ID: 2000 From file: CustomText.1033.dll I googled this error and found that it had occurred in prio ...Show All

• .NET Development Create a Shell Extension Handler thumbnail extractor with .net?

  Hi, My application creates nice graphics see http:// www.mavericksplan.com/mavericks  and it saves a custom document type. I'd like to show the contet of the document in Explorer when the user switch to Thumbnail view. To implement this feature I understand I need to create a Shell Extension Handler Thumbnail Extractor that extract the image from my file type to feed Explorer thumbnail vew, which is not easy at all for me. I look on the web and I found 1 C++ example and none in C#. Does anybody have a sample code to create a Shell Extension Handler thumbnail extractor with .net in C# Thank you Andrea ...Show All

• SQL Server Pictures not displaying

  I tried to search for this but couldnt get a satisfactory solution.. We have pictures stored in a table as BLOB files. When I try to display them through RS it just shows 'X' in that field... Any help is appreciated.. I have tried setting MIME type to JPG and doesn't work either. These images are stored in the SQL server as image (BLOB) files. The user just right clicks an image on his computer, select copy and then clicks paste in the ACCESS field to paste the image. This is how it gets to the SQL database. They have been doing this to jpeg files. As I said b4, I tried this with a bmp file ...Show All

• Visual Studio Team System Help... Directory Branching and SCC specific code in solution and project files...

  Hello, I come from a CVS world where a branch is parallel space that has the same structure as the mainline but with different content. I am looking into moving to TFS, but have been struggling lately with the concept of path branching model. Searching the internet, I found some guidance into ‘path branching model’ best practices; however, things seem to quickly breakdown when I start applying the path branching model to real examples. Here are my requirements from TFS: To be able to reference VS projects across TFS projects ie $/TeamProjectA/SolutionA/ProjectA $/TeamProjectB/ProjectB Soluti ...Show All

• Visual Basic Graphics Manipulations

  I am a vb.net 2003 user. I just checked out http://maps.google.com and am very interested in implementing similar graphic manipulation capabilities. They have a map that I can scroll a window into the larger image with the mouse. Precently, I use horizontal and vertical scroll bars and would be interested in knowing how to scroll a large image within a picturebox more efficiently. thanks, Put a PictureBox in a Panel then scroll it by changing PictureBox.Top and PictureBox.Left . Hope this helps a bit. ...Show All

• Windows Forms Passing values between windows forms

  Hi, can anyone please suggest what is the most efficient method of passing values between Windows forms. I am developing an application For smart devices where we dont have the concept of MDI forms. So how do we pass values between windows forms Is static variables the only option. Please reply asap. Thanks, anzrul Usually when you have multiple windows in an application, one form opens another by creating an instance of the new window class, then calling the .Show() method. The first window, the opener, will have a reference to the opened window, so you can use this reference to comminicate. You ...Show All

• Visual C# Login to Domain

  I am developing an application that needs to run in a computer that is not part of the domain but is included in the network. I need to somehow replicate the functionality of the "connect in " dialog box of Windows wherein a user can enter a username and password that can be authenticated by the machine he wants to connect to. Is this possible Can anyone give me something to research on... Thanks. no answer yet... just want to confirm if the LogonUser() only works in users and machines in the same domain.... thanks a lot... ...Show All

• .NET Development Method Authentication for Internet public Web Service

  I need to create a web service to be consumed in the public internet. I woul like to use a declarative mode. From the WSE 3.0 documentation I have two posibilities: UserName or Certificate. I can not use certificates in the actual project, so I have only the UserName option. Is this correct But I need the X.509 certificate in the server, and copy the public part to the clients. Is this correct Thanks a lot for your attention! Hai da I do no why Certificate is not poss in your project . And if certificate is not poss your approach is correct . Note : Reply me why cert ...Show All

• Visual C++ Linking problems using Visual Studio.net 2003

  I have written a program that needs to use DirectX libraries. I am using Visual C++.net 2003. I have compiled it successfully. When I go to "Debug" on the menu bar, down to "start", it says that these project configurations are out of date and would you like to build them. I click "yes" and it comes up with linking errors: Linking... draw.obj : error LNK2019: unresolved external symbol _D3DXCreateTextureFromFileA@12 referenced in function "int __cdecl DoInit(void)" ( DoInit@@YAHXZ ) it gives other LNK2019 errors and one LNK1120 error: Debug/Draw.exe : fatal error LNK 1120: 6 unresolved exte ...Show All

• Windows Forms PrintPreview multiPage .tif

  I can't get PrintPreviewDialog to display properly the pages of a multipage .tif. The following code displays the correct no of pages but they are all the first page. The same callback works fine to actually print the pages. Anyone have it working Private msFile As String Private mPrintImage As Image Private mPrintFDimension As System.Drawing.Imaging.FrameDimension Private miPrintPageNo As& ...Show All

• SQL Server Visual Studio cannot open encrypted package after SP1 applied.

  I have recently applied SQL Server 2005 SP1 to a dev machine, and my workstation, where it rpesumably updated Visual Studio. Since then I cannot open an SSIS package that contains some encrypted data, due to storing a database password. I get various error messages, and Visual Studio reports that it cannot load the package - I never get prompted for the password. My colleague who has not applied SP1 yet has no problem. Has anyone else encountered this problem, and if so do they have a solution Errors below: Error 1 Error loading 'Dim_Staff.dtsx' : The package failed to load due to error 0xC0010014 "One or more error occurred. The ...Show All