djchapin's Q&A profile

• SQL Server Can't store chinese in SQL Database

  update Food set FoodName = ' 杏仁' where ID = 100 in database as Hi bass, "But this will affect other databases in your server". This could be very dangerous. Good Coding! Javier Luna http://guydotnetxmlwebservices.blogspot.com/ ...Show All

• Microsoft ISV Community Center Forums Running script

  Hello not sure in what forum to ask this question but I was wondering if it is possible for the task scheduler in windows xp professional to do something while no one is logged on to the comuter Thank you very much for your answers. However I just heard that there was something called Task Scheduler but I do not where on the computer that you can find it. I found something in the Control Panel called Scheduled Activities but I suppose that refers to the task already created. Where can you find the Task Scheduler Thanks again! ...Show All

• Visual Studio Team System DataGeneratorTask needs better output

  I'm using the DataGeneratorTask and the output for the MSBuild log is horrible. All it states is "Data Generation Task". That's it. Not if it succeeded (which it did), or failed. Not how many tables it populated, nothing that is helpful other than the fact that the task was run. I've added a suggestion on connect about the issue: https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx FeedbackID=249493 DOH!  Okay, so I get the Homer Simpson award today.  When I set the Verbose=True then I do get additional information. I would be nice if when Verbose is not set to true that it at least indicated it completed rather than just having the task name, but obviously it isn't necessary since if it ...Show All

• SQL Server PowerPoint format possible?

  Hello, we plan to use Reporting Services in the company in the near future. However, management prefers power point reports, a format which reporting services does not support (please correct me if I am wrong here). Is there a third party extenstion tool for RS available which can produce PPT reports Best regards, Michael Fuchs Hello, I'm not aware of any third-party PowerPoint renderer. Can you explain your scenario that calls for PowerPoint rendering Any insight you can offer will help to justify the possibility of providing this functionality in the future. Thanks, Chris ...Show All

• Visual Studio 2008 (Pre-release) "PDF-like" scrolling

  I'm creating an application displaying a map and would like to use the same type of scrolling often used when browsing PDF documents (where the scrollable content is "dragged" by the mose). Is there any support for this or do I have to implement this functionallity from scratch Thanks lester - MSFT wrote: A possible solution is to have an image inside a thumb and then listen to the drag delta event - scroll by the amount of horizontal/vertical change. Thanks for your answer, What exactly do you mean by thumb /Billy ...Show All

• Visual Basic Refreshing SQL 2000 connection in Visual Studio 2005

  I have set up an SQL server database as a data source using the Data Source Configuration Wizard, but when I make changes to the source it does not show in my VB project even after refreshing. Closing and reopening the project makes no difference either. The only solution I can find is to create a new connection. ...Show All

• Software Development for Windows Vista an error about "aspnetwfpageflowexample"

  when i run aspnetwfpageflowexample,input some data,then click the button "page one",then raise an error . Exception Details: System.Workflow.ComponentModel.Compiler.WorkflowValidationFailedException: The workflow failed validation. Source Error: Line 114: wfprms.Add("InitialCommand", oe); Line 115: wfprms.Add("InitialParams", prms); Line 116: WorkflowInstance wi = wr.CreateWorkflow(Type.GetType(_config.Type),wfprms); Line 117: wi.Start(); Line 118: ManualWorkflowSchedulerService ss = wr.GetService<ManualWorkflowSchedulerService>(); just Put a try catch block around the call to CreateWorkflow, catch WorkflowValidationFailedException and look at ...Show All

• Visual Basic WebBrowser Refreshing Problem

  I've got a WebBrowser control in my current program that, every minute and a half, loads a web page and parses some string information out of it. The problem is, after running for a while, it stops reloading the page; everytime it 'loads' the page, it loads the exact same contact the page had the last time it was loaded, although the actual page content has changed. Viewing the page in IE outside the program, I can see visually that the site really has changed; but the program continues only to see an older version of the page. Why is this happening, and how can it be fixed Note: the problem persists when I log on/off the computer, and when I restart the computer entirely. It doesn't happen for all pages being dealt with in thi ...Show All

• SQL Server Unable to Edit Windows Password in Connect to Server dialog

  Hi, I think my description says it all. I have just installed Studio Express for the first time. I want to attach a database. When the connect to server dialog is displayed the user name and password text box is greyed out. The Password box is blank and I need to edit this. I switch to SQL authentication they are enabled but if I switch back to Windows authentication they are both greyed out. I have uninstalled and reinstalled but still no luck, Any help would be great. Hi, I was not aware of that which your answer has now led me to explain something which I should have done earlier. When I attempt to attacht a database and choose one in my own administrator documents folder I am told I ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How to Switch from Visual C++ to Vidual Basic ...?

  Hi, ... ... ... I have the Visual Studio 2005 Standard Edition, Full Version and license... I installed everything, and that include Visual C++, Visual Basics, Visual C# and J#... I can only use the Visual C++ compiler right now... So, now, I'd like to see what the Visual Basic compiler looks like... How do I tell the Visual Studio to SWITCH to Visual Basic compiler so that I can write Visual Basic codes... File/New/Project\ Expand "Other Languages" in the "Project Types" tree Select "Visual Basic". You can now create a Visual Basic based application much the same way as you'd create a Visual C++ based application (different templates...). If you want to ...Show All

• Visual Studio Express Editions Newbie help; Comma seperated numbers

  As of 3 week ago I’m fresh off the turnip truck. I’ve been creating a program that does some calculations based on SQL input and using tts. Problem: tts needs a comma separator in order to say one thousand. I have a TextBox8.Text the tts reads from. I’ve looked and tried, but I’m just not getting it. How can I get this textbox to give comma separators Dim EigthTextBox As Integer Dim Result5 As Integer Try EigthTextBox = TextBox8.Text TextBox8.Text = Result5 Result5 = "" Catch End Try PS: I’m amazed at what I’ve been able to learn from your posting answers. if you have an a ...Show All

• .NET Development Releasing dBase (OleDB) resources

  Hello all. I've digged Inted and found no answer for problem I found. When I connect the dBase files, the directory where dbf files are stored cannot be removed anymore untill the process (application) is closed completly. Closing datareader, connection etc doesn't help. a bit of code: OleDbConnection conn_batch = null; OleDbCommand cmd = null; OleDbDataReader dr_batch = null; conn_batch = new System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + data_dir + ";Extended Properties=DBASE IV;"); conn_batch.Open(); // here the data_dir directory can be still deleted cmd = new System.Data.OleDb.OleDbCommand(); cmd.Connection = conn_batch; cmd.CommandText = "SELECT * FROM BATCH" ...Show All

• Microsoft ISV Community Center Forums Size Form to fit user resolution

  I have several multi-user Access applications. After much time-consuming research I have not been able to find anything that works on this question: How can I get my forms to automatically fit the USER'S screen with their set resolution with the OnLoad event of a form I have already tried me.height, me.width with no success. Anyone have any other suggestions Any help would be greatly appreciated. Thanks! Blue are VB Keywords and purple is identifiers. You can setup custom formatting in the IDE through the options menu to make you coding easier to follow and find issues for yourself! In the Sample above in VB.Net it would be unneccesary to rename anything.... However it will not work insi ...Show All

• SQL Server Using Report Builder On External Web Apps

  Can someone point help me with the requirements for using Report Builder in an external web application In our case, we'd like to give users access to report builder, but the user are coming in anonymously over the web in our app, so they won't have a Windows user account. If there are any articles related to how this must be setup and whether any features are disabled in this mode, I'd appreciate the help! Thanks ...Show All

• SQL Server SQL Server 2005 SP2 install failed now unable to start

  Ran the SP2 locally on a Windows Server 2003 SP1 box that had SQL Server 2005 SP1 install on it. Problem was I ran out of C: drive and it failed in the middle of upgrading the server. I'm unable to start the SQL Server at all now. Is there any way to back this out Don't think I can reapply any patches since the service is dead. Eventlog now shows: One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. If this is an existing database, the file may be corrupted and should be restored from a backup. The log shows it's unable to start SQL (blames it on permisions but it's because SQL can no longer start) Product : Database ...Show All