Joshua Blake's Q&A profile

• SQL Server SSMA - Access to SQL Svr Decimal COnv Problem

  I am hoping I am missing some simple setting here. In using SSMA to convert Access 2003 tables to SQL Server 2005 tables, all of my fields of the type decimal are having the scale set to zero and losing the numbers to the right of the decimal when the table is loaded to the SQL Server data base. I have one decimal field set to 13, with a scale of 5. When I look at the table in SQL server, the structure is 18,0 and the decimals are gone. EG 12.12345 in Access becomes 12 in SQL Server. Is there anyone who has seen this problem or who know of a possible problem. Thanks Mike Thomas Check the log created by SSMA for this behaviour, also http://sqlserver2000.databases.aspfaq.com/what-are-the-main-differences-bet ...Show All

• .NET Development Server Admin

  Hi I am creating a simple client/server application using the remoting library. What I want is if the server admin types a message into the server console, the message will be delivered to all clients (Example: say the admin needs to bring down server for a few minutes, he can type a message into the console, which will then send a message to all clients saying the server is coming down) I was wondering what the easiest way to do this would be I was thinking about setting it up so that when the admin enters the message, the server sends it off to the service, and then then have a timer control on the client that checks the service every 30 seconds for new messages and then displays a Message Box with the message. But I was thinkin ...Show All

• .NET Development Best timeout approach for worker thread?

  Hi all, I'm currently working on a C# app which makes uses another team's component to make a call to a web service. This web service request sometimes takes a long time to return, so I need to have a timeout on the request. Initially I implemented this by making the request in a new worker thread, then calling workerThread.join(timeout). However, this is giving me very unpredictable behaviour. Sometimes the timeout works fine, but often it never times out, or takes a very long time to timeout. When I saw this behaviour, I tried another test. I put a sleep(2*timeout) call in the worker thread before it makes the web service call. With this in place, the timeout works correctly all the time. Would I be right in thinking this is ...Show All

• Visual Studio 2008 (Pre-release) How to apply control template in external libraries dynamiclly?

  In my scene, I have two Buttons. Then I create two control templates in different ResourceDictionary xaml files, each of them is in an independent control library. During run-time, I hope to apply the two templates to the Buttons dynamiclly according to user's input. (Maybe template1 for button1 while template2 for button2). Any idea to do this Thanks following will help http://nerddawg.blogspot.com/2005/11/resources-in-windows-presentation.html http://nerddawg.blogspot.com/2005/12/more-on-resource-loading-in-wpf.html ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA project hard freezes XBOX360

  A game I have been developing works perfectly fine on windows, however, causes my xbox to hard freeze (all controls stop responding and the device can only be shut off from the power button on the xbox itself), which in turn detaches the debugger. This seems to happen after an arbitrary amount of time, and thus leads me to perhaps memory issues. I haven't been able to find anyone else with a similar problem, but if anyone has experienced similar problems, I'd be interested in knowing how you went about debugging and or solving this issue because I'm having lots of difficulty isolating the problem to any one block of code. At any rate, it seems odd that my managed code (no shaders either) would cause the entire xbox to freeze considering it ...Show All

• Smart Device Development Visual Studio 2005 and Mobile 5.0

  Hi there, i've installed "Windows Mobile 5.0 Pocket PC SDK.msi", and supposely it would include some sort of plugins for VS2005. However, in VS, on smart device's projects, i only have: - pocket pc 2003 - smartphone 2003 - windows CE 5.0 Also, on "Device Emulator Manager", i also only see these emulators... Do i need to install something else Tnks Nelson, should installation indeed run without problems we would not be having this little chat and you would be using templates and emulators just fine, right So obviously installation was not OK even though it did not hang. That’s because your anti-malware silently blocks the script instead of ...Show All

• .NET Development Serialize/Persisting SystemColor

  Hi Whats the best way to persist/serialize system colors. I want the user of my application to be able to set colors of certain elements of the application. If they choose a standard color such as Colors.Red I can save this as the RGB value so I know what to reload and use next time the application is run. But if they set an application element to say for example SystemColors.Control how do I save this so that its always the Control property of SystemColors and is robust for any future changes to this class. Thanks Steve Steve, I just noticed I might have misunderstood your question. Are you worried about that the user choosing a system color which is serialized as RGB, later on changes sys ...Show All

• Visual C# Connection string for MS Access database having password to open

  Hi every body I m try to make a windowns form application named" Persional Diary" using MS Access database and C# ( Oledb provider) because this is an example for low level secret infomation so that I set password to my Access file ( Using MS Access toolmenu / security...so no one could open without password) But then now I can not acess this database using c# anymore. Could you help me to modify the Connection String in this problem, or give me an another way Thank you DongMT, VietNam if you have a look at www.connectionstrings.com there are examples of opening a passwroded database. You should then be able to change there strings to match the database config that you have. ...Show All

• Visual Studio Express Editions find maximum value that was input into text boxes

  I have three text boxes and I would like to click a button and have the highest value returned to a fourth textbox. Thanks in advance for your help. Dim num1, num2, num3, high As Integer Integer.TryParse(TextBox1.Text, num1) Integer.TryParse(TextBox2.Text, num2) Integer.TryParse(TextBox3.Text, num3) high = num1 If num2 > high Then high = num2 If num3 > high Then high = num3 TextBox4.Text = Convert.ToString(high) ...Show All

• Visual Studio Team System Error Index was outside of bounds of the array in a smartdocument applicaton

  We are encountering an error in an application when we are trying to import XML data Te application is an Excel smart document. The error is being reproduced all the time. The sheet data is being populated but with an exception that returns "Index was outside of bounds of the array" error Microsoft.Office.Interop.Excel. XlXmlImportResult xl = new Microsoft.Office.Interop.Excel. XlXmlImportResult (); xl = Globals .ThisWorkbook.XmlImportXml(XMLDataset, out xmlMap1, true , range1); Thank you, Dmitry Hello Dmitry, This forum is for Team Foundation Server Integration with Excel. For excel specific issues please post the question in Office Excel forum. Sorry we cannot be of any help here. Regard ...Show All

• Visual Basic Fill Table Adapter

  If you are enter new data into a datatable only, and you are not using any control to view the data with on your form, do you have to call the fill method I was thinking about that last night, if you dont that would save a data trip from your app to the server. Davids Learning That's not relevant to the question. Per David's question, he want's to know if Fill() must be called before creating a new record and updating the database. In order for him to even have a Fill() method to call, he must have a TableAdapter configured with a Select command. And since he's asking about performing an update, it can be assumed that the TableAdapter also has Insert, Update, and Delete commands; probably ones au ...Show All

• Visual Studio Tools for Office Disable save alert in Excel

  When the user exits my VSTO workbook, I want to disable the save alert "Do you want to save the changes you made to xxxx ". Is there a way to do that I don't want to disable all alerts, just this one. Thanks! I set the Saved property to true in the event handler for BeforeClose, and that did the trick! ...Show All

• SQL Server Sending SQL Mail

  Hi, I am using SQL Server 2005. I have configured my email on Database Mail. when I am trying to send email using xp_sendmail I am getting problem error as: Msg 17925, Level 16, State 1, Line 0 xp_startmail: failed with mail error 0x80040111 I am using following sql statement master . dbo . xp_startmail 'myaccount' , 'mypwd' master . dbo . xp_sendmail 'tomail1@mail.co.in' , 'test' where myaccount and mypwd is my password on my email profile. 'tomail1@mail.co.in' is the destination email address.. thanks Hi Jens Suessmeyer, Thank you for your reply. The user I had logged on is having full privilige, both windows authentication, and sql authentication with sa user i have tried. and another thing is I am ...Show All

• SQL Server How Start/Stop shortcuts in system tray ?

  Hi, I want to tell to user about SQL Server Configuration Manager and wants to allow him "START / PAUSE / STOP" for SQL Server Express in system Tray. It is easy for the end user who don't know SQL Server. Thanks hi, you can perhaps have a look at http://www.sqldbatips.com/showarticle.asp ID=46 , a replacement for the "old" SQL Server Service Manager available for SQL Server 7.0 an 2000... as a side note, remember that users require admin permission to start/stop Windows services, and usually you'll not grant them this high level membership to traditional interactive users.. so SQL Server should already be started as they log in (as it actually does), and they should be ...Show All

• SQL Server How do I get the Table Name the column belongs to in SMO?

  Hi guys, I am writing some sort of tool and I need to get the table a column belongs to.Before you ask for certain reasons too long to explain I need to get it from the column. I have found out that the following will give me the answer however before I start splitting the string which it could be messy. is there another way to do it My way so far: col.Urn.Value Gives: "Server[@Name='MYServer']/Database[@Name='MyDB]/Table[@Name='UserTable' and @Schema='dbo']/Column[@Name='Surname']" So now .How can I split it to get the table Name or better is there a cleaner way to do it Thanks again for your time in advance col.Parent will return you a SqlSmoObject which you can ca ...Show All