rabbitoh's Q&A profile

• Visual Studio Express Editions MouseClick(Hold) Move Form?

  I have a form with out a BorderStyle and there also is a PictureBox and what I would like to do is have the Form move when you hold down the left Mouse Click on the PictureBox. Thanks In Advance!   Public Class Form1     Private MouseDown1 As Boolean     Private PosDiff As Point     Private Sub Form1_Load( ByVal sender As Object , _                    ByVal e As System.EventArgs) Handles Me .Load         Me .TopMost = True     End Sub       Private Sub PictureBox1_MouseMove( ByVal ...Show All

• Smart Device Development send and recive data via USB Port

  Hi How can i send and recive data via USB Port on my Pocket PC with Windows Mobile 5 Install Active Sync and you should be ready to go :) http://www.microsoft.com/windowsmobile/activesync/activesync42.mspx Thanks, Achal VSD, Microsoft ...Show All

• SQL Server Use VPN to connect remotely to SQL Express server

  Hello, I'm using a Windows XP Home laptop to connect to a network of one of my customers. The administrator of the customer has given me a username and password for a VPN connection. I've got the VPN connection working and I can ping the SQL Express server. This server is using Windows Authentication. For the users of my VB application we have added a group to the Active Directory and added this group as a user to the SQL Express Server. This works and the users can access the database from within the application. The SQL Express Server allows remote connections and the browser service is also running. I would like to use the SQL management Studio Express on my laptop to access the remote SQL Express server and manage the database ...Show All

• .NET Development DynamicMethod's as Dynamic Event Handlers aren't all removed; Possible Framework bug?

  Hello, I have a simple RPC system that supports events from server to client. I use DynamicMethods to generate an event handler for server-side events on behalf of a client. I am seeing odd behavior when more than one dynamic event handler is attached to an event at the same time. Basically, the last event handler that is attached is never removed despite a call to the remove function. In my application this causes a delegate to be called long after its 'host object' is destroyed. I have replicated this issue in the following code segment. The program attaches 3 dynamic handlers to a test event and then fires the event. It then removes all 3 handlers and fires the event again. The last handler added is still called. This does not hap ...Show All

• SQL Server Reference dimensions are creating too many joins

  I have orders fact; customer, location and age dimensions. I am using age and location as reference dimensions through customer dimension. If I don't use reference dimension cube processing SQL would be like following select * from factOrders If I use reference dimensions SQL would be like following select * from factOrders, dimCustomer as customer1, dimCustomer as customer2 where factOrders.customerid = customer1.customerid and factorders.customerid = customer2.customerid If I have 6 reference dimensions through customer there will be 6 joins. Is there any way I can eliminate these joins as I need only one join to get all the information I can create a view between factOrders and dimCustomer and use the reference dime ...Show All

• SQL Server HTTP: 401 Unauthorized when trying to use Reporting Services and MOSS2007 in integrated mode

  Sorry for the long post, but I'm trying to include as much info as possible. I'm having trouble getting SQL Server 2005 Reporting Services and MOSS 2007 working together in integrated mode. Everything seems to be ok, but we get a 'HTTP 401 Unauthorized' error when using the 'Set server defaults' link from MOSS 2007 Central Administration. None of the other links give this error, but I'm not sure whether MOSS just eats the error message... Here's the background: Sql Server 2005 is installed on a separate box, let's call it SERVER1. This Sql Server hosts both the MOSS content database as well as the reporting services database. MOSS 2007 is installed on a different box, let's call it SERVER2 I've installed all the required components for b ...Show All

• SQL Server [SQL Server 2005] Primary vs Secondary file-groups - deciding which table goes where

  I created a set of primary and secondary data-files and organized them into file-groups. Now, I want to decide which tables to allocate to which file-group. What should be the factors on which I ought to decide this Is there a significance of choosing the primary group over the secondary ones or vice versa What is the impact of the choice in either case filegroups in general are all about PERFORMANCE. you can gain significant performance gains if you leverage multiple disks with the multi-filegroup feature of sql server. there is no hard and fast but the general idea is to spread the workload evenly over the disks and to leverage faster disks/cache for the more intensive files ...Show All

• SQL Server Relational Data import into SQL Sever from an XML File

  Hi All, I have an XML file which contains data about lots of different types of cars, same format multiple nodes Fiesta, Escourt etc etc Can anyone enlighten me on the best way to get this into SQL Server I have failed to make any usable headway and so desperate I have migrated back to MS Access 2007 - which did read the file and generate all the tables - but no relational links!! so it means nothing!! No-one wants Fiesta wheels on an Escourt!! I am presuming that as the file read into MS Access - the XML and Schema are correct - and the tables it generated all looked OK - just the fundamental Relationships issue - both in Access and more fundamentally nothing in SQL Server - Please help I know this will be easy! Thanks in Adv ...Show All

• Visual Studio Express Editions .ToString

  Hi everyone, I used the following code and got a problem: double Q = 38.5367; label19.Text = Q.ToString("0.00 x 10^-6 m^3/s"); the zero at the "x 1 0 ^-6 m^3/s" will display the third decimal place of Q. It is possible to let it display zero Thanks. Hi, Do you want output 38.54 x 10^-6 m^3/s format of Q Try this way: label19.Text = Q.ToString("0.00")+" x 10^-6 m^3/s"; Cause every zero in the ToString method is regarded as valid digit of the number. ...Show All

• Windows Forms TextBox/ComboBox control height

  Hi! I have created a UserControl that has a TextBox and ComboBox in it. The TextBox is ontop of the ComboBox (I want a combobox you can write in, this is for CompactFramework). I'm using the following code in a overridden OnResize event to fix the width of the textbox (I want the down-arrow of the ComboBox to be visible): this.txtEdCmb.Width = this.Width - m_iTextBoxWidthReduction; iTextBoxWidthReduction = 13. The height of the TextBox is however always 21 and the Height of a combobox is 22 which causes the border to be double either at the top or at the bottom of the control. The best would be a borderless TextBox, as you wouldn't see the vertical border line to the left of the combobox down-arrow, but this causes either the bottom or to ...Show All

• SQL Server SQL Server 2005 - SQLagent Log message

  We are seeing the following in our SQLAgent log every minute. I cannot find any information anywhere about this error message. [298] SQLServer Error: 599, WRITE: The length of the result exceeds the length limit (2GB) of the target large type. [SQLSTATE 42000] (LogToTableWrite) DO you have a job that runs every minute HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SQL Server SQL Server 2005 Standard Login Error

  When I was using winXP Pro I installed a copy of SQL Server Standard and had it working correctly with Windows authenication logon. I subsequently upgraded to Windows Vista business edition. I also upgraded to SQL Server sp2. Now I get the dreaded "SQL Server, Error: 18456" when trying to connect to the instance of SQL server on my machine. On solution seems to be to login to the original instance and use a stored procedure to update subsequent instances of SQL server. My subsequent instance is my original instance with the new OS. I do not have a clue how to edit registry entries or any othe methods of overcoming this problem. Anyone have a solution that I could use Help would be very much appreciated. ...Show All

• SQL Server How to create a Report Model based on SSAS ?

  I'm following the steps from Books Online ( http://msdn2.microsoft.com/en-us/library/ms159118.aspx ), and I'm stumbling on the following: In the Connection string box, enter the connection string that points to the Analysis Services cube How does the connection string need to look like My other connections is RS projects are OLE DB connections, but Books Online says that the connection type must be Microsoft SQL Server Analysis Services. I've tried "Data Source = MyServer\MyInstance", but that won't work. Can someone help Hello. This problem have left me spending a few hours to look for answeres. If you download the SP2CTP of Books on Line you will find  the answeres. My descri ...Show All

• Visual Studio Express Editions Friendly Drive Names

   I am trying to write code that will list all connected flash drives on a machine..BUT some drives list as fixed and not removable... So I thought I could provide a combo box with a list of all drives and their friendly names....Lexar USB...or Iomega Zip or whatever but I can't find a method to do this. This one has me stumped...any ideas anyone ...Mark "The glass isn't half full or half empty..It's the wrong containment vessel for the fluid in question" I'm not sure about friendly names but to get a list of the removable drives. Dim allDrives() As System.IO.DriveInfo = System.IO.DriveInfo.GetDrives() For Each d As System.IO.DriveInfo In allDrives If d.IsReady = ...Show All

• Visual FoxPro ActiveX control created in multithreaded VFP COM dll

  I just can't to solve the problem. May anyone say why a MSWinsock control isn't work in VFP COM dll. In common exe this all works fine, but in the COM dll nothing happens, while I invoking Connect method. Really nothing! The State property remains 0 at all. Help if you know   cosmmm wrote: I just can't to solve the problem. May anyone say why a MSWinsock control isn't work in VFP COM dll.   I just understood one thing: I organized a loop to wait an answer from the server and used the INKEY(.1) command. In this case all works fine. But in COM dll INKEY command causes the error "User-interface operation not allowed at this time". So MSWinsock control doesn't have idle ...Show All