Will Sullivan's Q&A profile

• SQL Server SQL Server Express: Configure concurrent multi-APPLICATION access?

  Hi Everyone, I have a software solution that consists of two separate applications that share a SQL Server Express database on a single computer. Everything is working great, except when both of the applications want to access the database at the same time. All I can find is information on configuring multi-user access in a distributed system. I'd appreciate any information on configuring multi-application access on a single computer... Thanks, Mike A Lesson in User Instances Here is what I have learned after researching my situation. The following summary came from a great article at: http://msdn.microsoft.com/sql/express/default.aspx pull=/library/en-us/dnsse/html/sqlexpuserinst.asp I h ...Show All

• Visual C++ Changing Static properties.. Is this impossible?

  Hi there.. I have been trying for days now to change the property of visible on a static text control in my application to false during runtime. I have researched this and researched this, and even posted on Expert Exchange, but no one seems to know how to do this.... I'll post the answer I was given on EE.com, and hopefully someone here will know more about it. I have only been programming in C++ for a week now, so forgive me if this is a stupid question.... I have several static text controls setup in my application (DirectX pong game) to report various stats that assisted me in creating the game and diagnosing troubles that may arise setup in a console.rc resource in my project. These are displayed in a control panel beneath the ...Show All

• SQL Server Is SQL Server CE really the solution?

  Hi,   So far, with other programming platforms, I used to have the facility, embedded within application .exe, to:        1- Interface with already existing "multi-user" database (ex: Oracle, Access, etc.)        2- Create/access "local"/"Single-User" files for processing purposes.  (try to minimize network trafic...)   So far, I've read a lot about SQL Server products (SQL Server, Sql Server Express, SQL Server CE), at least all articles I could find, and would like to have your opinion on what would be the best approach        1- What SQL version to use for "multi-user" databases &n ...Show All

• Visual Studio Team System Error with TFS build, but not when I manually build with Visual Studio

  I created a solution and included two projects into it which build just fine using Visual Studio. These projects were created under my TFS Project. I then created a build task for that solution and the build task fails with the following: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Microsoft.Common.targets(0,0): warning MSB3245: Could not resolve this reference. Could not locate the assembly "ABS.Common". Check to make sure the assembly exists on disk. If this reference is required by your code, you may get compilation errors. BusinessClasses\EngineExecutionEnumHelper.cs(21,11): error CS0234: The type or namespace name 'Common' does not exist in the namespace 'ABS' (are you missing an assembly reference ) Busin ...Show All

• SQL Server Trouble with Transfer SQL Server Objects task

  I am struggling to copy a 2000 DB to 2005 using transfer sql server objects task. I can get it to work, but without the foreign keys, which I also need. When also copying the foreign keys, I get the following message:" [ Transfer SQL Server Objects Task] Error : Execution failed with the following error : "ERROR : errorCode=0 description=There are no primary or candidate keys in the referenced table 'SVS' that match the referencing column list in the foreign key 'FK_WRM_SVS_WRM_SVS'. helpFile= helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}" . Apparently, SQL tries to create a foreign key on the WRM table, while the primary key on SVS is not there yet. Since ...Show All

• Audio and Video Development Audio Device Enumeration inconsistent in Vista

  Hi, I have build a application which enumerates all the audio devices installed in the system and searches for a particular PnP audio output device. To provide this feature I make use of 'DSPROPERTY_DIRECTSOUNDDEVICE_ENUMERATE_DATA' data structure. I populate this data structure and register it with dsound.dll. As a result of it a callback registered by me is invoked depending upon the number of audio devices present in the system. This approach is working perfectly find in Window's XP and 2K. But on Windows Vista (32 bit) I am facing some unique problems. Though there are 2 audio devices present in my system but sometimes the callback registered is invoked just once. Hence I loss the other device. What may be the reason for this Followin ...Show All

• Visual Studio Express Editions form2 combobox

  Hi,i am new to programming i am having trouble with the following. i have a form with a splitcontainer i have added 2 usercontrols "usercontrol1" and "usercontrol2" i have set the usercontrols to fill splitcontainer panel2 i have a second form "form2" i have a combobox on form2 with collection items "conttrol 1" and "control 2" i am saving the selected text of the combobox to a user setting "startupcontrol" if i put the combobox on form1 on splitcontainer panel1 i get the results i want. But if i move it to form2 where belongs it does nothing. Please see the code below. The first part is working with the combobox on form1 splitcontainer panel1 T ...Show All

• Visual C# Form files accidentally split up

  Hi all, I've had this come up a few times, and it seems like it should have an easy fix, but I'm absolutely baffled. So at the risk of sounding stupid, I could use some help! While working in Solution Explorer, I somehow accidentally dragged the .resx and .Designer.cs files of a form out of place, so they're not no longer children of the parent form... they're siblings in the project folder. My code compiles fine, but when I try viewing the form in Designer mode, the form shows up blank. Plus, the misplaced files add clutter to my project directory. I can't for the life of me figure out how to move these files back into place as children of the form.cs file. Does that make sense Anyone know a solution Thanks! Mark Jacobsen ...Show All

• SQL Server Providing database to client without SQL Server

  Hi I'm new to SQL Server but not to VB or Access, but would like to design a database in SQL Server for a set of users who currently do not have SQL Server loaded on any of their networked machines or their Network server. Can I design a database on my machine which has SQL Server and then load it all onto their server without them having SQL Server, or do I have to load SQL Server onto their server Thanks for any help. Hi, The could use SQL Server 2000 MSDE or SQL Server 2005 Express Edition. Both are free. That's the way to go Regards, Worf ...Show All

• SQL Server Is server downgrade possible?

  Hello, my question is simple, i guess, if anyone can help me solve this problem: I just installed Windows 2003 SBS Premium R2 but i have a software using SQL Server 2000 and not the one included in this version, 2005 wich is not compatible with. How can i downgrade, where cand i get the older server if the downgrade is possible and what else can i do before i shoot myself Is there any license issue that will not allow me the downgrade Thank You!!! Don't you love it when they omit the details! Here's a link to MSDE 2000 download... http://www.microsoft.com/downloads/details.aspx FamilyID=413744D1-A0BC-479F-BAFA-E4B278EB9147&displaylang=en MSDE is the equivalent of SQL Server 2000 Engine, but o ...Show All

• .NET Development .NET EXE--->Dll---->::CoCreateIstance Fails

  I'm calling a method whitin my .exe managed code: MSgate.initObjects() then, intObjects() calls a function inside an unmanaged dll function which i import through: [ DllImport (dllPath, EntryPoint = "initObjects" , CallingConvention = CallingConvention .Cdecl, ExactSpelling = true )] public static extern void initObjects(); In the unmanaged code, inside that function there is a call to ::CoCreateIstance which fails returning me E_NOINTERFACE error: ::CoCreateInstance (CLSID_MLWriter,NULL,CLSCTX_INPROC_SERVER,IID_IMLWriter,( void **)&g_IMLWriter) I don't undestand why, the dll exposing COM is correctly registered and when i try to use it from a .exe unmanaged code the CoCreateInstance works ...Show All

• Visual Studio "Unexpected error" dealing with vss in vs2005

  I get the following error when I try do do getLatestVersion or "Change source control" on a vss linked web app --------------------------- Microsoft Visual Studio --------------------------- Unexpected error encountered. It is recommended that you restart the application as soon as possible. Error: Unspecified error File: vsee\pkgs\vssprovider\cmsscciabstractionlayer.cpp Line number: 5906 --------------------------- OK --------------------------- Any idea on how to correct this Crasch, We have seen at least 4 reports of similar problems, but we don't know what's causing it. We have never been able to reproduce it in house. The only thing we know is that it we had more reports ...Show All

• SQL Server Newby JOIN question

  I'm attempting to use a JOIN for the first time and I'm getting about 94,000 rows returned when I should only be getting about 270. Something must not be unique (possible DSN) but I can't figure out why the join is not working. I know it must be difficult to determine the problem without actually seeing the tables but could somebody with a lot of SQL experience spot any glaring problems with this query Thanks! SELECT DS.DSNName AS DSN, S.ServerName AS WebServer, DBs.DBName, A.ServerName AS SQLServer FROM DSNs DS, Servers S, DBs, DSNs LEFT OUTER JOIN Servers A ON DSNs.SQLServerID = S.ServerID WHERE DBs.Status = 1 AND DS.WebserverID = S.ServerID AND DBs.DBID = DS.DBID ORDER BY DSN ...Show All

• Software Development for Windows Vista Getting a Device Context to call ExtEscape?

  Is is possible to get a device context from the XPS subsystem so you can call ExtEscape() win32 function from within a print job while doing normal XpsDocumentWriter calls Sorry I'm replying so late. About the PrintTicket, are there some good examples or resources you can point me to I really appreciate your reply, it seems the WPF forum is bubbling with support but XPS isn't getting any help. It's kind of frustrating to be working with such a dead community--thanks again! ...Show All

• Windows Forms Visual Inheritance problem with FlowLayoutPanel Control

  Hi, I've a base Form with a FlowLayoutPanel which contains some controls.I need to inherit this form and add some more controls to the FlowLayoutPanel in the inherited Form. But i'm unable to edit any of the properties of the FlowLayoutPanel in the inerited form.I'm alos unable to add any more controls to the FlowLayoutPanel.I've set the modifiers as Protected in the base Form. Is it not possible to alter the FlowLayoutPanle in the dervied Form Thanks, Suresh. Not able to change any of the properties(all properties are disabled) and not able to add any more controls in it. Thanks, Suresh. ...Show All