Ash McConnell's Q&A profile

• Visual Studio Tools for Office How to override Outlook Security

  Hi I am developing an application (VisualStudio 2003) which needs to add x number of e-mails to the Outlook 2003 Outbox on the user's machine. So far so good. I can develop this functionality but not override the security settings in Outlook that displays a security message asking me if I want to allow the program to run (one security message per time I access security protected properties - in my case 3 message boxes per mail). Does anyone know of a way to override the security settings in Outlook Thanks. dampbarn See http://www.outlookcode.com/d/sec.htm for your options with regard to the "object model guard" security in Outlook 2000 SP2 and later versions. You may want to c ...Show All

• SQL Server Merge Replication and SQL 2005, help!

  I'm working on developing a software solution using Mobile Client Software Factory. Let me start off by saying that this package is such a dream come true, and I can't thank the guys who put this together enough. The problem is, we're having some trouble getting the components setup for the Framework to work, in particular with SQL Server 2005. We have SQL Server 2005 running on a machine, and we have our entire database setup what I believe to be correctly. Last night, we tried for hours to get the PPC Emulator running our version of the Framework to connect to the SQL Server (On another machine on the same LAN) to no avail.  We published just one table to test with, we have the snapshot created, the web service is running, and ...Show All

• .NET Development Update Query not updating or issuing exceptions

  Hey guys I have this Access Query I am trying to run in C# windows app the Query from access UPDATE tblStaff SET tblStaff.Record_Password = [ NP], tblStaff.LastUpdatedBy = [ LB] WHERE (((tblStaff.CorpID)=[ CD]) AND ((tblStaff.Record_Password)=[ CP])); C# code OleDbConnection objConn = new OleDbConnection(); objConn = Config.ConnBuilder(); OleDbCommand oCmd = new OleDbCommand(Query,objConn); oCmd.Connection = objConn; oCmd.CommandType =CommandType.StoredProcedure; oCmd.CommandText = "PwChange"; oCmd.Parameters.Add(" NP" , OleDbType.VarChar).Value = newPass; oCmd.Parameters.Add(" LP" , OleDbType.VarChar).Value = updatedBy; oCmd.Parameters.Add(" CD" , OleDbType.VarChar).Value = corpId; oCmd.Parameters.Add(" CP" , OleDbTy ...Show All

• SQL Server Exporting data to a fixed-width flat file

  Hi, There's a lot of information on importing data from text files, but not a lot on exporting data to text files... I've checked but found no info on this. I'm trying to export data from SQL Server to a fixed-width flat file and wondering if I'm doing it the right way. I use a view as source (using a OLEDB connection manager) and I can see the data without problem. I defined a Flat File Destination (using a flat file connection manager). When setting up the flat file connection manager, I am asked for a file... Does this mean one should create manually a template file with the desired output format So I used a production file as template since we're replacing an existing process. After having set up everything, I run the SSI ...Show All

• .NET Development Remoting Client Exception !!! "The remoting application name "XYZ" has already been set."

  Hi, I am getting an exception when I am trying to configure the Remoting Client using the xml configuration file. Code: System.Runtime.Remoting. RemotingConfiguration .Configure( @"C:\Server.config" , false ); Exception: Remoting configuration failed with the exception 'System.Runtime.Remoting.RemotingException: The remoting application name, 'RemotingServer', had already been set.\r\n at System.Runtime.Remoting.RemotingConfigHandler.set_ApplicationName(String value)\r\n at System.Runtime.Remoting.RemotingConfigHandler.ConfigureRemoting(RemotingXmlConfigFileData configData, Boolean ensureSecurity)'."} System.SystemException {System.Runtime.Remoting.RemotingException} This application runs fine on ano ...Show All

• Visual Basic Creating an Excel Object using VB.NET.

  Hi everyone, This is my problem: I am trying to create an excel object so I can run an excel macro. This is the code I a using: Dim oExcel As Excel.ApplicationClass Dim oBook As Excel.WorkbookClass Dim oBooks As Excel.Workbooks Dim missing As Object = System.Reflection.Missing.Value Me .TextBox1.Text = Me .TextBox1.Text + " Report Creation in progress Please Wait..." + vbCrLf 'Start Excel and open the workbook. oExcel = DirectCast (CreateObject("Excel.Application"), Excel.Application) oExcel.Visible = False oBooks = oExcel.Workbooks oBook = oBooks.Open("C:\Developpement\Project_RCP\RCP_App\Job Bruts\Job RCP.xls", missing, missing, missing, missin ...Show All

• SQL Server Drives in a cluster environment

  Hi, I have a SAN and configuring a cluster on SQL 2005. I initially created a Quorum drive when setting up the cluster and now added 4 more drives to the physical node but when I try to install SQL that drive cannot be located. Do we need to create all the drives when installing the cluster or what is the way to add the drives later on. Thanks Anup   Kevin Farlee wrote: For failover clusters, you always need to think in terms of "units of failover".  If you put the MSDTC data on the same drive as the quorum, you would need to tie MSDTC to the cluster service.  You then create dependancies between MSDTC and the cluster service that shouldn't be there. Just to reinforce - this is no ...Show All

• SQL Server Save only the date in a datetime field

  Hello. A question please. Can I save only the date in a datetime field I don't want the hours. My recommendation is to save the [Time] value. You can ignore it for your current reporting needs, and if you even in the future decide to use the [Time] value, it will be in the database. (Business needs do often change. Adding [Time] values to existing data will, most likely, be impossible. ...Show All

• SQL Server sql script

  Hello I want to create sql script for my database. I know about “ Generate SQL Server Scripts Wizard ” but it just give me script for structure of my database and I want all records of my tables too. And I’ve tried “Script table as / Insert to“via right click on my table too and it doesn’t give me a script to insert all records! How can I create script to insert all records of a table to another table with same column properties Thanks in advance. There is no funtionality for that, try to use this well-known script to accomplish your goals: http://vyaskn.tripod.com/code.htm#inserts HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Studio Express Editions RichTextBox - two questions.

  Hi I am using 3rd party dll to receive string messages and displying them in RichTextBox. How can I limit the amount of lines to be in specific number (let's say 100) and in case 101 message arrived delete the first one and insert the new message at the bottom How can I autoscroll the scrollbar in the RichTextBox to the last message that arrived (on every message that arrived the cursor move to the first line). Thanks in advance Asaf. Yes, I that you can change the color of every line. It takes a little art but all you have to is to specficy a font class for the listview element and fillin the information for the font class. There are still limitation to what I am suggesting. The ...Show All

• Windows Forms How do I create an object from a row in a DataGridView / BindingSource?

  I would like to create an Object (say Client) from the currently selected row in a DataGridView. The DataGridView's DataSource is a BindingSource, for which the DataSource is a DataSet containing a single Table of Clients. I have been advised to use the BindingSource.Current property to get the selected item (or row), rather than the DataGridView. I have tried the following: DomainClient c_client = (DomainClient)c_bindingSource.Current; which results in an exception. How can I get around this Thanks in advance, JackStri. Remember that BindingSource , in your case, is binded to a DataSet . Therefore the current object would be a DataRow in the data set. You'll therefore need to conver the dat ...Show All

• Audio and Video Development iHDSim "-cs" option is not implemented?

  I noticed the presence of a new "-cs" commandline option (to force case sensitivity for resources) listed in the help dialog, but it seems to not be implemented yet. Is this the, uh, case Resource loads are always case sensitive (per the spec); using that flag didn't seem to make a difference. I will see if it is a known issue. Thanks for the report! ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Error running app - PGORT80.DLL was not found

  Hello, I have made a Dx9 application and when I try to run "app.exe" I get an error that "This application has failed to start because PGORT80.dll was not found. Re-installing the app may fix the problem". I added quite a lot of stuff to app recently so I have no idead what causes this, but few months ago there was no problem. DO you have any ideas how to resolve this Maybe I have to configure the Build settings somehow so it includes this dll. Peto ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Custom GameComponent properties greyed out in designer

  I created a custom game component which represents a sprite and has three properties. private Vector2 position; public Vector2 Position { get { return position; } set { position = value; } } private Color color; public Color Color { get { return color; } set { color = value; } } private string filePath; public string FilePath { get { return filePath; } set { filePath = value; } } The problem is, in designer mode, I can only edit the FilePath. The Color and Position properties are grayed out. picture My guess is that the designer doesn't have access to Vector2 and Color because they arent included in the 'using' statements. What's the best way get this working I don't believe that the properties pane ...Show All

• Visual FoxPro Change default printer works only once

  This one is weird... I use the followin function to change my default printer: FUNCTION SetaImpDefa(imp,muda) Declare long WriteProfileString in "kernel32" ; string lpszSection, string lpszKeyName, string lpszString Declare long SendMessage in "user32" ; long hwnd, long wMSg, long wParam, String lParam if muda HWND_BROADCAST = -1 WM_WININICHANGE = 26 endif printer_name = imp printer_buffer = space(200) * len_ret = GetProfileString("PrinterPorts", printer_name, "", ; @printer_buffer, Len(printer_buffer)) printer_buffer = left(printer_buffer,len_ret) * printer_driver = left(printer_buffer,at(',',printer_buffer)-1) printer_buffer = substr(printer_buffer,at(',',printer_buffer)+1) * printer_port = left(printer_buffer,at(',',printer_ ...Show All