JackG's Q&A profile

• Visual Studio Team System Always getting "The internal state of the database project..yada yada..."

  That quite annoying as I don’t want to always kill the project from source source and get the latest correct build from the deployment database and build everything on top what was done in the meanwhile. Any suggestion or solution for that in the meantime -Jens. --- http://www.sqlserver2005.de --- Actually you got me wrong, the database was created from a CTP4 Project. The files did not come from there, they were generated from the CTP4 generated database with the "import Database Schema" functionality from scratch. THere was no upgrade / manual copying etc. of the files. It was just a plain SQL2k5 import schema straight forward way to create a CTP5 project. HTH, Jens K. Suessmeyer. --- http: ...Show All

• Visual Studio Team System 64 bit DT

  Hi I am installing TFS DT on a 64 bit machine. THe machine already has SQL Server 2005 and SP1 (64 bit editions)...and YES, it is installed according to the TFS installation guide :).(no reporting services, default instance etc). Now, I am installing the DT on this machine and the installtion complete comes up.But when I open the management studio to check for the databases, none of the databases exist. If I try to install DT again, the Repair/Reinstall or Uninstall options box comes up. Do I need a specific 64 bit installation media for TFS or am I missing something big here (P.S: I have done a couple of Dual server installations in less than 2 hours..on 32 bit machines) I've actu ...Show All

• Visual Studio Tools for Office Unable to add customization to a WordML file when already customized

  Hello. I am unable to add a customization to a WordML file when that file is already customized. All reasonable attempts work on the same file when in the DOC format. Given the client and server exchange these files in the XML format, I need a resolution. We're working with VSTO 2005 v8.0.50727.42, .Net Framework v2.0.50727, VB.Net and Word 2003 (11.8026.8036) SP2. Many thanks for reading on and any ideas you share. A little background to explain why we need to add a customization to a file that is already customized...While questionable, our deployment model is to install everything on the local box. Users define the installation path. In order to support opening a file on boxes with different installation paths, we (a.) remove any exis ...Show All

• SQL Server Webparts, using custom database and secure conection string

  Hello all, i think this is my first post here. I'm on a project development right now. It's about creating a webpart, connecting to a custom database (when i mean custom, i mean created specifically for the webpart), using a normal connection string. This, 'cause i don't want to put SQL code directly on cs files. My point is, if exist a way to secure the connection string putting in on a config file Just like when you put the connection string in a web.config or app.config on regular application / website development, and retrieving it with System.Configuration.ConfigurationSettings.AppSettings for example. I've tried to add an app config file to the webpart project, but when i'm deploying it on sharepoint (using sts ...Show All

• SQL Server Help!!!! Restore file mdf after exec "Drop table..." to previous state.

  Hi all. First, sorry about my poor english. I have a database which above 6 gb data and i have droped all table in my database. I try to restore from log file but my database is set to simple backup and auto shrink so log file doesn't help anymore. I have used some software to recovery from log file too but useless. My only hope right now is mdf file. Please help me. How could i restore my mdf file to state before i droped tables. Thanks I have read the book which you mentioned. I try to find out exactly what you mean when you said i can read pages in mdf file one by one but i don't get it. Could you tell me which tools or language or anything else to perform that idea. Thanks ...Show All

• SQL Server Using SQLExpress on a network

  Hi, I have a VS2005 application that I run with a SQL server 2003 database. In order to make the application distributable, I'm trying to get it to run with SQLExpress. I've installed SQLExpress on a spare machine and changed the connection string in my application to use SQLExpress c:\databases\mydatabase.mdf (and the database is obviously in that location!). This works fine on the spare machine. However the problem is getting the application to run on another machine but using the same database. I note that SQLExpress won't let me put the database on a networked drive. On another machine I've also installed SQLExpress, I've enabled the tcpip stuff and the browser but to be honest don't really know what I'm doing! How do ...Show All

• Visual Studio Team System Error when creating Database Project

  Hi all, I am getting the following error when I attempt to create a SQL 2000 Database Project: The application for project '<a location of my disk>\Database1.dbproj' is not installed. Make sure the application for the project type (.dbproj) is installed I have CTP4, SQL 2005 + BI, and VS Express C# installed. Any suggestions Thanks in advance. Ed Ed - Team Edition for Database Professionals requires Visual Studio 2005 Professional edition or higher SKU. Unfortunately, it will not run on top of the Visual Studio C# Express SKU. I believe that there is a trial version of VS2005 Pro available for download at the same location where you downloaded the CTP4 bits. thanks, ...Show All

• Visual FoxPro How to have a report not to print certain records at BAND level

  I have a report on a table with materials used for production of an good. I only want to see the materials of a certain 'group' (high cost materials). Is there any way I can add an expression at the band level so only the relevant records are printed. (for instance if cost is > 200) If I can do this at band level, I don't have to add a 'print when' condition in each of the fields in the band. Other problem when I add a 'print when' condition an all fields of a band is that the report still shows a 'blanc space' on the printout; even if the 'remove line if blanc' is set on (on all the fields in the band). Any ideas Thanks, >>Is there any way I can add an expression at the band level ...Show All

• Windows Forms How-to embedded Win32 DLLs and .NET DLLs in my Application

  hi how can I embedded (Win32 DLLs and .NET DLLs) in my .NET application exe and use these embedded files when my exe application needs them like the one here http://www.oreans.com/xbundler.php Thanks Actually, since the tool did the exact thing you were asking, it was a reasonable response. You did not clarify by saying "and I don't want to pay for it". How about http://www.codeproject.com/csharp/htmerge.asp then However, that solution will not merge in Win32 DLLs. Also, keep in mind that for signed third party assemblies any solution would have to link in the entire assembly, rather than just the used components. ...Show All

• .NET Development Out of memory exception (c#, .net 2003, large images)

  Hi, I am developing an application (c#, .Net 2003, Framework 1.1) that deals with large images. The application captures multiple image frames and stitch them up into a large hige-res image. We are looking at 50+ frames and sometimes more than 100 frames of 1024x768 color images. I am also using double buffers for edit purposes. To get an idea of what this application does: beyond the image acquisition and stitching, it is very similar to Paint.Net ( http://www.getpaint.net/index2.html ) in providing tools to draw on top of the image. The program is hitting out of memory exceptions -- sometimes even with smaller images. Documentation on LOH seems to explain this observation well, especially with memory fragmentation a likely cause of ...Show All

• SQL Server Domain group logins failing on SQL 2k5 workgroup

  This question is regarding a brand new out-of-the-box SQL Server 2005 Workgroup Edition install. The old SQL Server 2000 server is working properly with regard to the issue we're having: We are using Windows Authentication, and have created SQL logins for about 40 different groups on our domain. We've given those logins the appropriate permissions on the databases they're supposed to be able to access. The SQL Server is not a domain controller, but is a member of the domain, and domain logins do work for Windows-login purposes on this box. The problem is that when users try to connect to the SQL server, they are denied access. An error 18456 is thrown, and logged in the Application event log stating "L ...Show All

• SQL Server How to suft through MSDB folders?

  Hi everyone, Primary platform is Framework 2.0. My target now is to know programatically how many folder exists under MSDB folder as well as its names. How to accomplish this T hanks in advance and regards, this link might help : http://msdn2.microsoft.com/en-us/sql/ms403343.aspx#exists Frank ...Show All

• Visual Studio Express Editions Easiest way to keep track of some numbers and check them

  Hello, I want to save the numbers from 2 text boxes somewhere, they dont need to be opened by anyone but the program needs to be able to read them to make sure there are no duplicates... so for e.g a list of phone numbers when the user clicks save it scans through the list and either saves the number or pops a message box up saying that number allready exists.. Hope someone can help, thanks! I like the sound of the last example. dataset in memory with XML file storage Any chance you could show me an example of this as im new to coding and not sure where to start.. :) Thanks! ...Show All

• Visual C++ C# to C++ WMI

  Does anyone know to convert the following C# code to VC++.Net       foreach(ManagementObject partition in new ManagementObjectSearcher(         "ASSOCIATORS OF {Win32_DiskDrive.DeviceID='" + drive["DeviceID"]           + "'} WHERE AssocClass = Win32_DiskDriveToDiskPartition").Get())     Sorry i am using VC++.Net 2003 i have error after doing this, the error is "error C2107: illegal index, indirection not allowed", pls kindly let me know how to solve it. Thank you ManagementObjectSearcher __gc *partition2 = new ManagementObjectSearcher("ASSOCIATORS OF {Win32_DiskDrive.DeviceID='" + drive[&quo ...Show All

• Windows Forms VB to .net conversion, error in execution

  I have converted visual Basic 6. Project to Vb.net Project, by opening the same project into Vb.net Environment. It converts the project to .net project, but displayed a list of errors (the features not supported by .net). I manually corrected all these errors. After that when I run this project, it opens the MDIform1.Designer.vb window, And in the following part: <Global.Microsoft.VisualBasic.CompilerServices.DesignerGenerated()> Partial Class MDIForm1 //Error in this part #Region "Windows Form Designer generated code " <System.Diagnostics.DebuggerNonUserCode()> Public Sub New() MyBase.New() 'This call is required by the Windows Form Designer. InitializeComponen ...Show All