Robert Beaubien's Q&A profile

• SQL Server Creating a DECLARE variable with SMO

  How can I create this stored proc with the SMO StoredProcedure class It doesn't want to work and I think it has something to do with the DECLARE statement. Anyone know how I can get this to work Cheers Jon storedProc.TextBody = "DECLARE @GroupID int" + "SELECT @GroupID = GroupID FROM Groups WHERE (GroupName = \"Administrator\")" + "INSERT INTO gworkshop.Users" + "(GroupID, Username, Password, Active, Deleted)" + "VALUES (@GroupID,@Username,@Password,@Active,@Deleted)" ; If you are debugging, you can break on the exception it's throwing, then look at the inner exception(s) of that exception to find out exactly what the se ...Show All

• SQL Server how to insert int variable...

  hi, I have two question string a; int i; insert into sss (id, name) values(.....) as id is integer and name is nvarchar in the database. how can I write this variable within the values paranthesis 2) how to adjust a column in sql server 2005 to auto number thanks Do you want to know how to exactly insert them in .NET or TSQL TheI Insert should be straight forward using something like insert into sss (id, name) values(i,a) You can’t cahnge the id column to a autonumber (in SQL Server it is called identity column), you will have to add a column and assign the identity value while the creation to it. Thats actually what the designer like SSMS does behind the scenes, creating a new ...Show All

• Visual C++ LNK4098 and static libraries using different runtime types

  I've inherited a project that has various problems. This project is a DLL linking with the MT run-time libraries. It also links to several static libraries that are outside of my control but I believe they're all compiled with the same version of Visual C++. I'm assuming the LNK4098 warning is being dumped out because one or more of the other static libs were compiled with a different runtime type (assuming single threaded). The dox for LNK4098 mention "...prevent mixing different [run-time] types... You receive this warning if you try to use different types ... of the run-time library...". A warning doesn't seem like prevention to me. It then goes on to describe the NODEFAULTLIB option and what run-time libraries to ignore wh ...Show All

• Software Development for Windows Vista How can we control the "Enhancements" page under device Properties page?

  There will be a "Enhancements" tab on the device Properties page if we use APO to add some sound effects.( ex: Speaker or Microphone) And I want to control the checkbox in the "Enhancements" tab. The question is : how can we get the interface of this page I know the "Enhancements" will add a "FxProperties" folder under the device registry. But I can't find the header of this IPropertyStore interface. I have tried SHGetPropertyStoreFromParsingName to get the interface. Like this: IPropertyStore *pProps = NULL; CString string = L"HKEY_LOCAL_MACHINE\\....\\FxProperties"; // The registry path. SHGetPropertyStoreFromParsingName ( string, NULL, GPS_DEFAULT, __uuidof( ...Show All

• Software Development for Windows Vista Where can I get the latest Platform SDK

  I am frantically looking for a new platform sdk that i can use to learn the latest technologies and write it for Visual C++ 6.0 SP6 Compiler. Can I know the sources through which I can get the SDK. And July CTP for Windows Vista can be downloaded from here, http://www.microsoft.com/downloads/details.aspx FamilyId=67BB7FD9-52B1-4688-AB7B-F488FCEEEB86&displaylang=en Nikola ...Show All

• .NET Development Adding new Data Source Problem - happens with VStudio (C#) and Express (C#)

  Hello- I am receiving the same error message within Visual C# Express Edition as well as Visual Studio 2005 when I attempt to add a new data source in my project. The error I keep recieving in both Visual C# Express and Visual Studio is "An error occured while creating the new data source: Could not get the type information for 'Lesson09.Database1DataSet' ". Why is that and what does that mean I cannot proceed with my lessons because I cannot get past this point to participate. I have also tried opening a sample project which uses the same techniques and also recieved errors while loading it into Visual Studio as well as C# Express Edition. I get the following build errors: 1- Error 1 Source file ...Show All

• Windows Forms Having some threading issues

  Hey guys, I'm trying to read a file and add some nodes to a treee view control. I would like the GUI to remain interactive and have a progress bar and text box be updated with info as the file is read. I'm using a threadpool thread and reading the file from there. However, I seem to be running into some problems. Sometimes the GUI seems to be updating/repainting fine but than all of a sudden stops responding. Also, if the open file dialog is on top of the form, it doesn't repaint at all. Below is the code I am using. Any help is greatly appreciated. delegate void UpdateProgressBarCallback(decimal percentDone); delegate void UpdateFlexbarTree(string line); ...Show All

• Visual Studio 2008 (Pre-release) WS-AT - getting Disabled address for Registration Service

  Hi, I tried searching the web as well this forum before posting this question. As i didn't find answer anywhere, i'm posting it here. I'm trying to interact with a transaction enabled WCF service from a transaction initiator WCF client. I've done all that is required to enable interoperable endpoint for WS-AT. when i run wsatconfig ./show command i get the following output: WSAT enabled: True DotNet port enabled: True TCP port: 2372 Kerberos GACL: NT AUTHORITY\Authenticated Users Interop port enabled: True HTTPS Port: 2373 Identity certificate: 04363965BA1912B17B2619E56861BADE30AA9ECE Accepted certificates: BDY5ZboZErF7JhnlaGG63jCqns4= Default timeout: 60 ...Show All

• Visual C# How to return a string[] from a function?

  Hello, Each time that function MyFunc is called, MyFunc fills a string[] with a unknown number of items. (all serial ports on my computer) How do I define MyFunc, to have it return this filled string[] //MyFunc tryout: public string[] MyFunc(){ string[] PortNames=System.IO.Ports.SerialPort.GetPortNames(); return PortNames; //calling string[] MyString=someclass.MyFunc(); raises an exception when called the 2nd time. Should I use MyFunc with some 'ref' argument, if so, how Henk Oh I',m sooo sorry, through my mess of coding I had set FormA's reference to null in my callback function! ;-) (shame shame) my believe in C# is back.... thanks for li ...Show All

• SQL Server SSIS Visual Studio

  I am having a problem developing a SSIS package in Visual Studio and SQL Server 2005 Enterprise Edition. Validation is happening after I have set ValidateExternalMetadata = FALSE causing and error My package writes to a SQL Server table with a handfull of rows and columns using OLE DB destination. One of the columns in the table is a 'NOT NULL' data type. I have a trigger on the table handling any null condition. (see below) (I know the trigger works because I have tested it by inserting rows manualy within SQL Server Mgnt Studio) When I “Execute Package” (DEBUG) my data flows through till the OLE DB destination, which turns red, errors out, and does not attempt to write the data !!! !!! Ideas, sugg ...Show All

• Visual Studio Visual Studio IDE Navigator on Vista

  Hi all, According to MS plan, VS will provide a new IDE Navigator with thumbnail feature, which is that we will have a thunmbnail and some custom definitions on the bottom panel when we press Ctrl+TAB to call out IDE navigator. We have our embedded designer, which associates with a certain file type. I have been told that if we responded to WM_PRINT message properly we can get this feature for free. Could anyone please give me more detailed information Thanks. That is correct, if you handle WM_PRINT you will get this for free in an upcomming version however that version is not associated with any Vista release. When it is made available it will also work on WinXP. Most managed controls already ha ...Show All

• Visual C++ purifiy warns about free mismatched memory

  Hello, When I compile the small program below that just allocates and deletes an object I get an error message under purify. There is no problem when I don't include any header file, but as soon as I include <memory>. It turns out that what makes the difference is in <iterator>, and in turn in <xutility>, .... , and ultimately it is that inside <use_ansi.h> a lib is linked. The problem appears with VC 7 Microsoft (R) 32-bit C/C++ Optimizing Compiler Version 13.10.3077 for 80x86 and with /MD, and it appears in debug and release mode. There is no problem with /ML or /MT //#include <memory> //#include <iterator> //#include <xutility> //#include <climits> //#include <yvals.h> //#include &l ...Show All

• Visual Studio Team System team system version control for non microsoft products

  Is it possible to use the version control used by team system in non microsoft development setups For instance java or coldfusion developers. Does working with the source control require visual studio I could have sworn i read somewhere that you only need team explorer. Does anyone have a link that describes this Thanks. Robert is correct that TFS is integrated into 3rd-party IDEs thanks to partners like TeamPrise. Also, I could have sworn i read somewhere that you only need team explorer. Yes, that's true too. If you install just Team Explorer, you get a VS-like shell from which Team Explorer and Source Control Explorer work just like they do in VS Pro / VSTS. (Solution Explorer is not supported because ...Show All

• Visual Studio Sdc.Tasks SetEnvironmentVariable - Why wont it set environment variables for me?

  I have a small project which I call to set environment variables (for various 3rd party tools in our build process, etc.). I use the Sdc.Tasks.SetEnvironmentVariable which executes fine, and I know it's stepping in there because it throws an error if I call it with a bad property-name etc. Problem is, it doesn't seem to do anything, i.e. when MSBuild returns back to the command line, and I type 'set foo' there is no env-var created. In fact, the only env-var output from this project is 'USERNAME' which obviously already exists. What am I missing... Many thanks, Duncan Smith. <Project DefaultTargets="ValidateConfiguration" xmlns="http://schemas.microsoft.com/developer/msbuild/2003"> <UsingTask TaskName=" ...Show All

• Visual C++ What can be done not to lose messages with udp?

  I am receiving messages from a server by udp rapidly. Sometimes i miss some messages. What can be done not to miss messages i am using CAsynSocket. i call ReceiveFrom() in OnReceive() function and i process the messages. When i call ReceiveFrom() in OnReceive() and don`t make any other processes with the messages and only junk them and don`t make any other processes with computer, i don`t miss any message. i see that i have problem with speed, maybe i should upgrade the rams but what else can be done Can buffer size be managed i try SetSockOpt() with parameter SO_RCVBUF. What should be the best buffer size and receive timeout You'll probably never win this battle. If you can't afford to lose packets, don' ...Show All