DBAMANI's Q&A profile

• SQL Server Merge replication foreign key problem

  Hi there. I'm somewhat new to merge replication, and I've been having an issue with one of the scenarios that I've been trying to get working. I am using SQL 2005 on the server, with 2005 express on the client. I have 2 tables: Photo - which has a PhotoID primary key PhotoData - which has a PhotoDataID primary key, and a PhotoID foreign key both primary keys are int, and set to identity. I only want the Photo table to replicate for the merge, because I want the data in the PhotoData table to only be called by demand through a web service (since the images in that table are too large to be included in the normal replication). However, when a client adds a photo to his local database (which adds a record in the photo table, ...Show All

• Visual C# Printing Properties

  Hi, I would like to know the code for printing pictures, as I can't seem to figure it out , the code to print text boxes/RTBs with the font, colours, sizes and formatting options*, how to work a print preview dialog box and a page setup dialog box. Thanx. Eragon. *I have supplied the code for RTBs/Text Boxes that needs to be updated: private void printPage( object sender, System.Drawing.Printing. PrintPageEventArgs e) { StringBuilder data = new StringBuilder (); StringWriter writer = new StringWriter (data); writer.WriteLine(textPad.Text); writer.Close(); float leftMargin = e.MarginBounds.Left; float topMargin = e.MarginBounds.Top; float yPos = 0; Font printFont = null ; printFon ...Show All

• SQL Server Where is DataDirectory ?

  Hello, I see that one of the new features of SSEv is DataDirectory support. Where is DataDirectory pointing to Is it the same directory as the program ".exe" file Thank you Tom Hi, | DataDirectory | (enclosed in pipe symbols) is a substitution string that indicates the path to the database. It eliminates the need to hard-code the full path which leads to several problems as the full path to the database could be serialized in different places. DataDirectory also makes it easy to share a project and also to deploy an application . For example, instead of having the following connection string: "Data Source= c:\program files\MyApp\Mydb.sdf" ...Show All

• Visual Studio 2008 (Pre-release) Invalid Column/Object Name

  I have a Database with over 50 Tables. From this Database I created a C# file with SQLMetal! When I now execute a query over the C# file I get the error ‘Invalid Column Name’ or ‘Invalid Object Name’. I read that there is a problem with SQLMetal but it would be solved with the next version. I have installed the May 2006 CTP. Is there something I can do Can you post or sent me the C# file. If you have narrowed it down to a particulary column/object, is there anything unique about the Column or Object that is being queried upon ...Show All

• Smart Device Development MFC dialog based application closes(pocket pc), how to keep it running

  MFC dialog based application in pocket pc(visual studio 2005 vc++, windows mobile 5.0) closes when i open another appl. from it, i create a process to open vlc, that works fine,but then when i close vlc and try to go back to my main application, this one is no longer running, so i am not able to stop the stream for the vlc. The thing is that my dialog based application has only ok button on the right corner, and i have tried many ways to disply the "X" button but it doesn't work, the only way to do this is if i make an MFC single document application, but i would have to change all my design, so if anybody knows anything about it, that would be great. Silux ...Show All

• Visual Studio Tools for Office How to populate Word 2003 ComboBox / Dropdown list using VSTO C#

  Hi, I am creating dynamic OLE Control ComboBox in Word 2003 using VSTO C#. After creating ComboBox I want to populate it with some values. If I use VBA then I can populate using following codelines. Dim myarray(3) As String myarray(0) = "US" myarray(1) = "AUS" myarray(2) = "UK" ComboBox1.List = myarray But in VSTO when I use following code lines: object objClass = "Forms.ComboBox.1" ; object objMissing = Type .Missing; Word. Shape myShape; myShape = Globals .ThisDocument.Shapes.AddOLEControl( ref objClass, ref objMissing, ref objMissing, ref objMissing, ref objMissing, ref objMissing); // OLE Control is a floating control on document. Embeded Control is not accepted. ...Show All

• Visual FoxPro How can I get the ole_handle from an bmp image file?

  In my application I need to call the method third party control, the method need pass in ole_handle of image file . I try to use h1=fopen("c:\test") and pass in h1. it did't work. In VB6 I can pass in img1.picture.handle and it work fine. Have Anybody has any idea THanks, CetinBasoz, Thank you very much . It work fine. ...Show All

• Visual Studio Team System Each build does an entire get latest

  This will add a bunch of time to my builds since I have a ton of build projects. Is there any way to specify that I would only like the selected sln's to be retrieved "You should be able to sync binaries without any problem." Aaron, what did you mean by this ...Show All

• Visual C++ When can I use my WSABUF and overlapped structures when using WSASendTo on an overlapped socket

  When calling WSASendto on a UDP socket that is overlapped it is difficult to get the right understanding from the documentation provided in MSDN. The question is, will WSASento copy the content of my WSABUF's so I can use them again (Even before the complete routine and the event is signalled) According to http://windowssdk.msdn.microsoft.com/en-us/library/ms741693.aspx this is the case: "The array of WSABUF structures indicated by the lpBuffers parameter is transient. If this operation is completed in an overlapped manner, it is the service provider must capture these WSABUF structures before returning from this call. This enables applications to build stack-based WSABUF arrays." But reading a Microsoft book in c ...Show All

• .NET Development How to Run .NET Executable on a Network Drive?

  I'm sure this is very basic. I have an application, a very basic C# Windows Form test application that runs when I execute locally. However, when I copy it to a mapped network drive, such as S: I see this: Unhandled Exception: System.Security.Policy.PolicyException: Unverifiable assemb ly 'S:\Andrew\test.exe' failed policy check. OK. How do I make the assembly verifiable Does each user need a public key or to have Test.exe added to a security policy Once I clear that hurdle, what libraries do I need to install on S: (or on the user's local machine ) to get .NET 2.0 Framework to work Thank you, Actually, I am facing a very similar problem - my C-Sharp application does use unmanag ...Show All

• Visual Studio Tools for Office Debugging VSTO2007 for Outlook addins...

  Hello all, I have an existing addin that runs/installs fine in Outlook2003 with VSTO2005. I have migrated it over to Outlook2007 with VSTO2007 and it runs in the debugger fine. However when I create the setup project and install the addin, it will not get loaded when Outlook is launched. Is there a way to debug or get more information about why the addin is not getting loaded I tried to set the VSTO_SUPPRESSDISPLAYALERTS=0 and that does not seem to show the more information box like in Outlook2003. Thanks in advance, ~Joe I have this option already turned on. It doesn't seem to do much for showing any errors I have. Is there any other way to get more detailed failure information ~Joe ...Show All

• Visual Studio Tools for Office How to programatically Autorepublish workbook as HTML

  Hi, I am developing a C# vsto 2003 Excel application. How can I programatically save the workbook as HTML file and republish it everytime the workbook is saved I looked into the _WorkBook.SaveAs() function but I cant see a way of republishing it. Any ideas how can I do this Thanks, ...Show All

• Visual FoxPro can VFP9 take data type jpg, gif, or PDF ?

  What do you mean by "manage" VFP can show them and in the case of editing their registered applications are used. ie: An image control can show picture type files. A PDF can show with an activex control or within a web browser control. For browsing those files probably it'd be a good way just to store the fullpaths and show via a web browser control. ...Show All

• Visual Studio Visual Studio 2005 Standard edition Replacement CD's

  Hi Everyone, I had HD crashed and I need to re-install my VS 2005 on my computer. I found that the 2nd CD is damaged and could not be repaired. Is there any link to either download the files for the 2nd installtion CD or to re-order it. Please Help Thank you all for your assistance Moody unfortunately there is no direct download, unless it was from MSDN subscriptions. have you also read this to see if one of the methods would work for your situation http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=778624&SiteID=1 if still no go, I would suggest going back to the place you purchased it and tell them the situation, hopefully they can sort out something alternatively contact MS Support: http ...Show All

• Visual FoxPro How do i use the WHERE clause in remote database connection?

  After connecting to and oracle database i want to select specific records using the where clause as below gctype = 'A' gquery = '1' = SQLPREPARE(gnConnHandle, 'SELECT fssno,floc,fcurrent_address1,fcurrent_address2,; fhome_address,ferno,fquery_code,fdate_approved,fcap30,fbenefit_paid FROM cif_hist; WHERE ftran_type = gctype and fquery_code = gquery','MyCursor') = SQLEXEC(gnConnHandle) It gives me an error message "SQL statement parameter is required for non-prepared SQLEXEC() calls. Can someone help me Thanks for the response but i did as stated above and still does not work. Gives a an error message 'variable LCSQL not found'. All the SQLPREPARE syntax without the where clause works. I'm using VFP 6.0 ...Show All