Nickeay's Q&A profile

• Visual Basic Frustrating hex problem

  I am using a modbus command that requires a specific value Dim Err As Short ' return error Err = Me.SmrnControl1.MbForceSingleCoil(7, 3, &HFF00) ' turn on The code above is from the suppliers examples. I cannot get VB to accept this format or do any conversions. I am feeling rather stupid as this is so simple. Has anyone got a suggestion as to what I am doing wrong. The values in brackets are all shorts. I have tried decalring a short and converting the hex value but it simply generates an error. Hi All, Finally managed to get hold of the company that designed this add in. The answer was quite simple really. They knew of the problem and the solution is to use -256 to give the correct bit pattern out. ...Show All

• SQL Server generating XML from SQL

  Hi all, Can anybody advice me how can i go about creating an XML from SQL . The need arised when our jobs which create Xmls from the select statement using vbscript hang in the executing state because the file gets a sharing voilation so we have to change the generated filename on the vbscript code frquently so i thought about can i generate it directly from SQL...... Any ideas this solution would be very helpful for me Thanks in ADVANCE Jacx This may help you XML support in SQL Server 2005 (just in case you're not familiar with what is available): http://msdn2.microsoft.com/en-us/library/ms345117.aspx#sql2k5xml_topic3 Constructing XML using SQL: http://msdn2.microsoft.com/en-us/ms178107. ...Show All

• SQL Server Returning all selected values in multi-valued parameter

  How does one return all selected values in a multi-valued parameter Right now i have a filter on the dataset where (Expression) =Fields!LOCATION_ID.Value (Operator) = (Value) =Parameters!Loc.Value(0) This is just giving me data from the first value that is selected in the multi-valued dropdown. I need all returned from the parameter. Any ideas. Unfortunatly, this returns nothing. I believe it returns nothing becuase its not seperating the multiple values selected. Its combinding the values selected from the parameter together as one, which there isnt a valid record for that in the table and therfore returns nothing. I have read something about the split function: Split("a b c", " ") but ...Show All

• Smart Device Development Recommended libraries for internet streaming

  I'd like to get my hands on some libraries that can handle general purpose networked mp3 streaming. WMP on a Smartphone doesn't work. FMOD doesn't do networked streaming on Windows CE, Java's Media Framework doesn't work right, and any other libs are basic mp3 readers with no network ops. Does something like this exist This is for a C++ project under WM5. ...Show All

• .NET Development Error installing .NET 3

  When I try to install .NET Framework 3 on a Windows 2003 Server R2 new instalation (no betas on it) I get an error. The error log file contains [02/01/07,12:39:58] Windows Communication Foundation: [2] Error: Installation failed for component Windows Communication Foundation. MSI returned error code 1603 [02/01/07,14:29:54] Windows Communication Foundation: [2] Error: Installation failed for component Windows Communication Foundation. MSI returned error code 1603 [02/01/07,14:30:03] WapUI: [2] DepCheck indicates Windows Communication Foundation is not installed. [02/01/07,14:32:34] Windows Communication Foundation: [2] Error: Installation failed for component Windows Communication Foundation. MSI returned error code 1603 [02/01/ ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Redist Question

  If I make a game that uses the XNA Framework, what redists are necessary on the client machine Do they need both the DX redist as well as the XNA Framework redist, or is just the XNA redist adequate Yes, but I get on machine where XNA is not installed this exception: An unhandled exception of type 'System.TypeInitializationException' occurred in Microsoft.Xna.Framework.Game.dll Additional information: The type initializer for 'Microsoft.Xna.Framework.Graphics.GraphicsAdapter' threw an exception. ...Show All

• Smart Device Development Is it possible to build a db program without Activesync?

  As title, I need to build a project without Activesync. But how to update the DB file with the DB server Can I use USB connection the share the local computer connection (so that i dun need to build wi-fi network). But in that way, can i connect with out activesync I understand it is possible to change the setting on Pocket PC emulator to share the internet connection with local PC, but how about real Pocket PC device  Please help If you're not using AS it's best to forget about USB connection. Consider it useless unless there’s AS on another side to back it up. It might be somewhat functional under WM 5.0 but not as functional as with AS. If you have Wi-Fi (or any other TCP/IP network) Pocket ...Show All

• Visual Studio Express Editions Need help adding DateTimePicker at runtime

  I have a DataGridView with a column of dates.  When I doubleclick on one of the cells in the date column, I want a DateTimePicker control to come up, so that the user can select a new date.  I then want the DTP to go away.  I have this code so far, but it's not bringing up the DTP as expected.  Can anyone help me out with this   Thanks... Private Sub DataGridView3_CellMouseDoubleClick( ByVal sender As Object , ByVal e As System.Windows.Forms.DataGridViewCellMouseEventArgs) Handles DataGridView3.CellMouseDoubleClick If e.ColumnIndex = duedate_column.Index Then Dim newDTP As New System.Windows.Forms.DateTimePicker newDTP.Visible = True Me .Controls.Add(newDTP) End ...Show All

• SQL Server Progress Reporting in an external application

  I have a custom external application that executes some packages. I would like to display the execution progress as it would appear in the Progress tab of the SSIS designer. How would I do that Any help is appreciated. Implement IDTSEvents interface (the simplest way is inherit from DefaultEvents class, and override the methods you need), then call package.Execute(,,IDTSEvents,) method passing your object. Process the events from package and show the progress in the way you want. ...Show All

• SQL Server SQL Server 2005 install keeps failing to install SQL Services (i.e. the main engine!).

  I am currently running Windows XP Professional Service Pack2. It already has MSDE & SQL Server 2000 installed (although I just uninstalled MSDE in the vain hope that it might present the installer with a more straightforward upgrade). I have tried installing with the default instance & a new instance (I don't really care - I just need to install the darn thing). I just want the basic database & Books On-line, nothing fancy. Here is the Summary log, for what it's worth: Microsoft SQL Server 2005 9.00.1399.06 ============================== OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600) Time : Tue Feb 06 16:45:14 2007 Machine : ANTHONYY1 Product : Microsoft SQL Server Setup Supp ...Show All

• Visual C++ MFC80D.DLL not found. New Twist

  I am writing an managed C++ DLL that is to load an unmanged C++ DLL using LoadLibrary. The managed DLL uses Standard Windows Libraries, not using ATL, using Unicode. The unmanged DLL to use the Standard Windows Libraries, Not using ATL, not using CLR. When I invoke LoadLibrary, I get a message box indicating that the DLL can't be loaded because MFC80D.DLL can not be found. I've checked both DLLs, both have manifests imbedded that look ok. I've got another project that does the same thing but works. I checked all settings between the two projects and they look the same. The one that works was originally done in VS 2003. I've even tried copying the lines that indicate the project inherits the property sheets from upgrading fro ...Show All

• Windows Forms selecting display/screen device for form how?

  I'm working with a multi-head system and would like to position my application form on a display other than the primary display when it is created/Show()'n for the first time on application startup. How is this done Thanks Tyler Ahhh, I tried that before except I didn't realize I needed to set FormStartPosition.Manual. Thanks for the help, works perfect. Tyler ...Show All

• .NET Development Web Services & Partial Encryption

  i am developing a set of web service methods which return reporting data. ideally i do not want to use HTTPS due to the extra performance hit. what would be ideal is to encrypt only that data which is sensitive. for example, 1 particular report has 12 columns of data. but only 1 column of data really needs to be encrypted over the wire (the client name). at the moment my web service method returns a dataset. although i can change this, if it is easier to implement partial encryption by returning a different type. please could anyone advise if it is possible to perform partial encryption in .NET2.0 like this if so i would be grateful for any advice, URLS, etc. to get me off on the right foot. thanks ...Show All

• .NET Development MS Access function MonthName causing error in VB

  Greetings: I have an Access 2002 database query that works fine within Access, returning the name of the month, the year, and some summarized data grouped by month. However, when I call that query to populate a DataSet in my VB front end, an error is thrown "Undefined function 'MONTHNAME' in expression". What's up with that I could work around this, and have VB do the month names, but I'd rather it all be handled within the query. Thanks! That’s an interesting point. I don’t know whether the Jet (Access) OleDb provider supports stored procedures. I also assume your CommandText is simply “QueryName”. I don’t know Access that well, and I don’t know how it would behave. I would ...Show All

• SQL Server ADOMD.net 9.0 (client) and CubeDef.LastProcessed

  What is this property (CubeDef.LastProcessed) supposed to return as it does not return the date the cube was last processed Does AMO provide this info more reliably TIA Dave Hi Dave, It's a bug - CubeDef.LastProcessed returns the last time the server was restarted as far as I know. See http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx FeedbackID=124606 ...for more details. Take a look at the comment posted by furmangg on April 28th on this entry on my blog for some code which does what you want: http://cwebbbi.spaces.live.com/Blog/cns!7B84B0F2C239489A!675.entry It's also available in the Analysis Services Stored Procedure Project here: http://www.codeplex.com/Wiki/View.asp ...Show All