Marc Rush's Q&A profile

• SQL Server How to set Multiple Active Results Sets (MARS) enable in ODBC

  hello all there can any body tell me how could i set the Multiple Active results Sets (MARS) option on/yes in case of the ODBC. The thing is i create the connection using the SQL Native(sql sqrver-2005)wizard, i got following when create the DNS Microsoft SQL Native Client Version 09.00.1399 Data Source Name: DM_N Data Source Description: Server: vsnet1 Use Integrated Security: No Database: DM Language: (Default) Data Encryption: No Trust Server Certificate: No Multiple Active Result Sets(MARS): No Mirror Server: Translate Character Data: Yes Log Long Running Queries: No Log Driver Statistics: No Use Regional Settings: No Use ANSI Quoted Identifiers: Yes Use AN ...Show All

• Visual Basic Mount a virtual drive?

  Hello, I'm interested in making a program that has the ability to mount a folder (e.g. C:\MyFolder\) to a drive letter (e.g. F:\). Is this possible with VB If so how do I do it And if not, can it be achieved with C++ or C# robinjam wrote: Ok, I understand I can use subst.exe to mount/unmount drives, but is it entirely safe to do so I've heard horror stories about data corruption from this sort of thing. Subst should not cause data corruption. If you have more specific example of what horror stories you heard maybe it is possible to explain it. I can imagine that a common mistake is that a mapped drive is assumed to always be on the same drive letter. I will try one scenario that might explain something that can ...Show All

• Visual Studio Rename file/item and Modify file/item content (VS SDK Interface)

  Hi All, First is about renaming the file using IVsRunningDocumentTable::RenameDocument, can any of you give me or point me to a sample of implementing this method The second one, is there any way to modify (add, delete, etc) the content of a file using VS SDK interface (any kind of file; C#, XML, text file, etc) Thanks, Hi Herru,   After you install VS SDK December 2006 you can find the file FileNode.cs I mentioned above here: ”C:\Program Files\Visual Studio 2005 SDK\2006.12\VisualStudioIntegration\Common\Source\CSharp\Project\FileNode.cs”   MPF files from “C:\Program Files\Visual Studio 2005 SDK\2006.12\VisualStudioIntegration\Common\Source\CSharp\Project\” path are referenced in projects (for example you can see it ...Show All

• SQL Server Converting an integer field into an Identity field

  I have a table with an integer field (contains test values like 2, 7,8,9,12,..) that I want to convert to an Identity field. How can this be done in t-sql TIA, Barkingdog There is no TSQL statement to change a non-identity field to an identity field, even the designer will do strange things behind the scenes, like creating a new table copying the data to the new one, renaming the new and dropping the old table. SO you either do the same in your TSQL statements or use the gUI which does all the steps for you behind the scenes. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual C++ Open up a VC++6 project in VC++8 express edition?

  MS supportforum 22.02.07 Hi. I'm gonna develop a winform application to visualize some datapackets from the microcontroller Atmel AT90USB1287. Atmel has provided me with an example code written in MS VC++. I'm new to developing winform application and new to VC++. I have downloaded the VC++2005 express edition, I've installed the servicepack 1 for VC++ 2005, installed the SDK sp1, and followed the instruction in "how do I" in VC++ for the SDK integration. I opened the example code projectfile in VC++2005 and tried to compile it (F7). I got the following errormessage: 1>Creating browse information file...1>Microsoft Browse Information Maintenance Utility Version 8.00.50727 1>Copyright (C) ...Show All

• Visual Basic Upgrade Help needed

  Dear VB Community, I am a hobbyist trying to help out at work with an old VB6.0 program that we want to move to VB .NET. The one and only VB6.0 programmer we had left along with our VB6.0 compiler. I have Visual Studio 2005 and VB .NET and do not want to start from scratch. Here is the error I get when I run the upgrade wizard: "Visual Basic Upgrade Wizard error Upgrade failed: Exception occurred: Could not load referenced component: MSMAPI32.OCX (1.1.0) You need to install this component before you upgrade the project. It is recommended that you install VB6.0, with all referenced components, and ensure the application compiles and runs before upgrading." Thanks for any help/guidance you can give. ...Show All

• SQL Server Updating Records Instead of Insert

  Dear All, I want to use SSIS in order to synchronize data. The OLEDB and ADO.NET Destination Adapter just inserts the rows read from the source. Since I have PK Constraint on destination, the tranform fails. How can I ask to update the records in destination DB Regards, Sassan All answered in here: http://www.sqlis.com/default.aspx 311 -Jamie ...Show All

• Visual Studio Express Editions form load event

  How do i trigger the form load event I want users to click a button and the program runs as if loading for the first time. A good attempt, Tall Dude... Demonstrates good use of iterating through forms and removing objects (forms) from a collection by looping thrugh them backwards. But it does demonstrate the hoops one has to jump through to 'reshow' a form from scratch. ...Show All

• Visual Studio Express Editions Complete Newb Question - PLEASE HELP!!

  Begginer C# programmer here (begginer programmer in general). I am currently reading Learning C# 2005 from O'Reilly, and I've come across a stubling block early. When going to compile the helloworld.cs console app, the book instructs me to go to Start, Programs, Visual Studio 2005, Visual Studio Command Prompt so I can run the csc command to compile the app. Problem is, I'm using Visual C# Express 2005, which doesn't have this option, at least not in the same area. I have figured out on my own how to build the app in Visual C#, but the book mentions that 90% of the examples are built as a console app in this way, to simplify learning the language, so I would like to know the proper way to duplicate the process of running the Visual Studio ...Show All

• Visual Studio Express Editions running a new program within mdi

  hi everyone, so as i said a few days ago when i first made a post, im new to VB so im working on a project and also making little apps to just try to figure things out and for practice. i had an idea for a little test app and im having some trouble. here is the idea, if any of you use the graphic program called GIMP you know how its just a bunch of little windows all over the place rather than in one main window. what I want to do is make one main window, Form1, a Mdi and when this window loads have it call up GIMP so that all the windows load within Form1. as i said, im new to VB so I dont know how to get a second program to run within your main app. here is the code i`ve done so far within form1_load but im having trouble, any advice ...Show All

• Visual Basic error converting data type nvarchar to int...

  ...when I try pass date parameter to procedure on SQL 2005 can you help me Thanks Try using the normal add method and specifying the parameter type.   That way you are specifying the type and size of each of the parameters          l_cmm_Comando.CommandText = "proc_ins_Colaboradores"         l_cmm_Comando.CommandType = CommandType.StoredProcedure         l_cmm_Comando.Parameters.Add("@str_Nome", SqlDbType.VarChar, 100).SqlValue = "ssss"         l_cmm_Comando.Parameters.Add("@dat_Nascimento", SqlDbType.DateTime).SqlValue = Now    &nbs ...Show All

• Visual C# ICollection

  Hello everyone I was wondering how to return something in ICollection.. Say I have a method something like this :- public ICollection<string> Something() { // Now how can I add to the Collection and do the return } Please advise. Hi, Harsimrat As John said, you must implement the ICollection in some class or just use the classes which has implement the ICollection interface. You can return all the class instance which has implemented the interface by using "Something()" you mentioned. For example, you can return a List<T> instance since it has implemented ICollection<T> interface: private List < string > list = new List < stri ...Show All

• Internet Explorer Development Installation and registration woes

  Hi, I'm fairly new to IE Add-on development so please go easy on me, any how here's my story: I have a small C# project that basically acts as a auto-filler for web-forms for our intranet so that working fine and dandy. I then converted this app into a BHO by making the winform app into a DLL with the pre-requisite Active and GUID to make a BHO. So that was done and working too. I used regasm MyApp.Dll /codebase and works a like charm on three dev boxes(two XP-pros both running IE 7.0 and one XP Home runninge IE 6.0) but when I release to the two data-entry clerk laptops my BHO app doesn't work at all. The puzzling bit is that it registers as an add-on can be viewed when you goto Tools->Manage Add-Ons->Enable / Disable Add-Ons and i ...Show All

• Visual Studio Team System Bug: Compare schema only able to transfer change in one direction

  I can only choose to transfer changes found in one direction. Other DB-tools, e g Red-gate, are able to transfer in both directions. You must add this functionality as well. Sometime you have 20 differences and you want to transfer 5 of them in one direction and 15 of them in the other direction. You should be able to change the arrow's direction. The default should of course be left-to-right as it is. Best regards Niklas Engfelt Niklas - Did you mean transfer in both directions with a single update As Gert noted, today, you can do this as a 2-step operation. If you have DatabaseA and DatabaseB, use A as the source and B as the target, select the updates you want B to receive and them write updat ...Show All

• Visual C++ winuser.h error

  Everytime i try to include winuser.h i get this: C:\Program\Microsoft Visual Studio 8\VC\PlatformSDK\include\winuser.h(42) : error C2146: syntax error : missing ';' before identifier 'HDWP' C:\Program\Microsoft Visual Studio 8\VC\PlatformSDK\include\winuser.h(42) : error C4430: missing type specifier - int assumed. Note: C++ does not support default-int C:\Program\Microsoft Visual Studio 8\VC\PlatformSDK\include\winuser.h(42) : error C4430: missing type specifier - int assumed. Note: C++ does not support default-int C:\Program\Microsoft Visual Studio 8\VC\PlatformSDK\include\winuser.h(43) : error C2146: syntax error : missing ';' before identifier 'MENUTEMPLATEA' C:\Program\Microsoft Visual Studio 8\VC\PlatformSDK\include\w ...Show All