twonjosh's Q&A profile

• .NET Development .net runtime 2.0 error reporting

  I'm getting a runtime error on a window's service that I wrote to handle querying and updating a SQL database. I use system.data.oledbcommands to accomplish this, and I have no idea how to research the cause of this runtime error. Where should I post the error message to get some help Thanks! well its a database exception (oledb) so you would be best in, if you haven't, using try catch blocks to catch exceptions and handle them. You can also say write to eventlogs the exception errors and analyze them later on which will give you more indepth detail of what the error is ...Show All

• SQL Server Backup Software

  Hi We are getting ready to rollout a new system in the next few months and I have started to look at backup and recovery strategies for SQL Server 2005 on which this new system will be housed. The proposal is to by Veritas Backup Exec with the server this system will be housed on however my knowledge is "limited" to the backup and restore options available directly from SQL. I have been unable to find any opinion on using third party software to backup and restore SQL Server 2005 databases. Can anyone help to give me an objective opinion on this subject. Should I simply use SQL Server and the tools it ships with or do these third-party applications make it easier Many thanks in advance of your help Cheers Danny ...Show All

• Visual Studio Team System SQLCMD :connect not allowed?

  In a post-deploy script, I want to connect to another server using :connect $(TargetServer) which works in the sql management console SQL editor window. But during build, I get the following error: Error TSD164: Syntax checking failed : Incorrect syntax near :. Also: if I use a variable which is declared in the DBPROJ file, BUILD crashes: C:\Programme\MSBuild\Microsoft\VisualStudio\v8.0\TeamData\Microsoft.VisualStudio.TeamSystem.Data.Tasks.targets(49,5): Error MSB4018: The "SqlBuildTask" task failed unexpectedly. ManagedBatchParser.ParserException at ManagedBatchParser.Parser.Parse() at Microsoft.VisualStudio.TeamSystem.Data.Common.ExecutionEngine.BuildFileBatchParser.GetStatementsFromFile(String ...Show All

• Visual Basic Anyone know about Regular Expressions

  ^(\w([-_+.']*\w+)+@( \w(-*\w+)+\.)+[a-zA-Z]{2,4}[,;])*\w([-_+.']*\w+)+@(\w(-*\w+)+\.)+[a-zA-Z]{2,4}$ i have this regular expression that validates multiple e-mails on my form.......but it allows for emails like some..email@hotmail.com .... I know i can just remove the . from the [ ] but then i wont be able to have e-mails like some.email@hotmail.com Is there a way i can still add the . to the first component of the RegX without keeping it in the [ ] There's a whole forum dedicated to the subject : .NET Development > Regular Expressions http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=1212&SiteID=1 (I would move your post, but I've not had good success with that, so I'll just post t ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA Book ( In Progress )

  For reasons I cannot exactly put into words, I’ve decide to write a (free) book about how to use XNA.   It is defiantly a work in progress and thus far only includes two chapters and associated source code. I truly hope that my work is advantageous to some people out there. I am in part doing this as a practice towards writing technical documentation.   I am not accomplished in writing instructions for other people that may not have the same level of technical skill sets as myself.   I hope that with this book I learn a whole lot and more in that regard. Granted, if you are a diehard game programmer, what I have written is probably not for you, at least, not yet! Yet I would value your input.   If you feel like c ...Show All

• Visual Studio Team System View last result for all tests?

  We have a test project with multiple unit, manual and web tests that get executed for each release over several days. I'd like to see a list of all tests in the project with the resulst of the last execution of that test (may be a current or previous release) and the date of execution. Is there any way to do it Thank you for the reply. Hopefully there also will be a way to schedule a test to be executed for an Iteration or a Build, in the version I have I can associate an Interation with a test, but can't display it on Test Manager, which renders it mostly useless... Do you know when this next version will be released ...Show All

• SQL Server ODBC Excel Driver

  dear all: I used ADO to connection excel file(excel2003); below is the source code: Dim Conn,Driver,DBPath,Rs, defaultPath defaultPath=Replace(xlsFile, "\VQAUser.xls", "") Set Conn = Server.CreateObject("ADODB.Connection") Driver="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & xlsFile & ";Extended Properties=""Excel 8.0; HDR=yes;"";" Driver="DBQ="&xlsFile&";DRIVER=Microsoft Excel Driver (*.xls);UID=admin;UserCommitSync=Yes;Threads=3;SafeTransactions=0;ReadOnly=0;PageTimeout=5;MaxScanRows=8;MaxBufferSize=2048;FIL=excel 8.0;DriverId=790" Driver="DRIVER=Microsoft Excel Driver (*.xls);DriverId=790;DefaultDir="&de ...Show All

• Visual Studio Express Editions HTML in a Resource File?

  First of all, I am a beginner with VB 2005 Express. I want to create a stand-alone executable app with a webbrowser control that displays embedded (resource file ) html files. In VB6 I can use the RC Wizard to create a resource file that contains my HTML files. I can then compile a stand-alone executable app that displays the HTML Files. My questions is: With VB 2005 Express, how do I create a resource file that contains HTML files and then include it in the final .exe file Perplexed, Bennie Bennie, According to your create resource file question, I suggest you to take a look at the ResourceManager Class included in System.Resources namespace that provides convenient access to culture-specific resources at runt ...Show All

• SQL Server T-SQL without cursors

  Hi there, Say i have a table with the following structure: Store Customer OrderNo 1 1 100 1 1 201 2 2 122 2 2 223 2 2 222 2 3 333 Is there an easy way to select sequences as below per Customer without using cursors Store Customer OrderNo TransNo 1 1 100 1 1 1 201 2 2 2 122 1 2 2 223 2 2 2 222 3 2 3 333 1 Thanks create table CustomerOrder ( Store int, Customer int, OrderNo int ) Go Insert INto CustomerOrder values (1,1,100) Insert INto CustomerOrder values (1,1,201) Insert INto CustomerOrder values (2,2,122) Insert INto CustomerOrder values ( ...Show All

• Visual C# Timer

  Hi, I want to make just a simple example.... I have two TextEdit and one button,and one timer.... In timer's properties I have declared the time as 8000 (8sec)... and this I want is when I press the button the timer to start counting and after 8 sec to copy the text from textEdit1 into textEdit2..Just that :).. My example code, which it doesn't work :( , is: namespace WindowsApplication3 { public partial class Form1 : Form { bool flag = false; public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { timer1.Start(); timer1.Tick += new EventHandler(timer1_Tick); if (flag == true) { textBox2.Text = textBox1.Text.ToString(); } ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Color Banding

  I am getting color banding issues when viewing my project on my Xbox 360. The textures look perfect when the app is ran on windows, using the same XNA source just in a different project. But when I display the textures on an Xbox 360, I get serious color banding. These issues are most pronounced when my Xbox is set to output at 720p or higher resolutions, but the color banding is still there even if the Xbox is set to 480p. The following code is what I am using to setup my 'prefered' values for my graphics device. If you got any idea what could be causing this, I would appreciate the input. graphics.IsFullScreen = true ; graphics.PreferredBackBufferFormat = graphics.GraphicsDevice.DisplayMode.Format; graphics.PreferredBackBufferH ...Show All

• Visual Basic EMAIL

  I am using this code in vb.net 2005 to sent an email but an error FAILURE SENDING MAIL is allways appearing. Can someone show me where I am duing wrong. Try Dim SmtpClient As New System.Net.Mail.SmtpClient SmtpClient.Host = "localhost" SmtpClient.Port = 25 SmtpClient.UseDefaultCredentials = True SmtpClient.Send("glennzarb@gmail.com", "glenn_zarb@hotmail.com", "Test", "hi") MsgBox("sent") Catch ex As Exception MsgBox("Send failure:" & ex.Message) End Try I haven't installed any other programs or smpt's Again, it does not matter about the email service that a person is using but rath ...Show All

• SQL Server SQL Agent Job to refresh Analysis Services Cubes

  This was a very easy task in SQL 2000, but I can't figure out how to create a job that will process AS cubes in 2005. Does anyone have a reference for how to set this sort of thing up in SQL 2005 You can definitely use SQL Agent job to process your cubes. For that you go into SQL Management studio run processing dialog and then use "Script" button to generate XMLA command for processing your cubes or dimensions. Then you go and create new SQL Agent job and create Analysis Services execution step where paste your processing command. Here an article that talks about backup but at the end show how would you do that. http://www.microsoft.com/technet/prodtechnol/sql/2005/bkupssas.mspx Edward. ...Show All

• Software Development for Windows Vista Problems with CreateWorkflow method using XOML

  Hi, I'm trying to do a simple test to create a workflow and I'm getting this error: error 1564: 'x:Class' cannot be used when the markup is executed directly without creating a new activity type. The code is: using(WorkflowRuntime workflowRuntime = new WorkflowRuntime()) { TypeProvider typeProvider = new TypeProvider(null); typeProvider.AddAssembly(...); workflowRuntime.AddService(typeProvider); XmlReader reader = XmlReader.Create("MyWorkflow.xoml"); WorkflowInstance instance = null; try { instance = workflowRuntime.CreateWorkflow(reader); } ... The error occurs when I call the createWorkflow method, but when I call this method passing a System.Type instead of XmlReader works. Coul ...Show All

• Audio and Video Development Problem in Monitor Control API's in Vista

  I have ATI card on my VISTA system, I want to control the monitor parameters using Monitor configuration functions. As a result in my appilcation I have loaded the dll, like LoadLibrary ("dxva2.dll") I also get the proc address of following functions GetNumberOfPhysicalMonitorsFromHMONITOR = (tGetNumberOfPhysicalMonitorsFromHMONITOR) GetProcAddress (hModule, "GetNumberOfPhysicalMonitorsFromHMONITOR"); GetPhysicalMonitorsFromHMONITOR = (tGetPhysicalMonitorsFromHMONITOR) GetProcAddress(hModule, "GetPhysicalMonitorsFromHMONITOR"); GetCapabilitiesStringLength = (tGetCapabilitiesStringLength) GetProcAddress(hModule, "GetCapabilitiesStringLength"); When I try to use these function, follo ...Show All