Scott Allison's Q&A profile

• SQL Server Workbench won't connect

  I am having problems with SQL Workbench not being able to connect to remote SQL servers. I can connect fine on the localhost. An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 1265) If I reboot the machines enough times it seems to start working. However I will soon be moving into production and will be unable to reboot the machines. I found a 3 part blog post on troubleshooting this but it didn't help. Any ideas Steve Sorry there were some ...Show All

• SharePoint Products and Technologies SP Gugu: How to Programmatically change a list item's ContentType by WSS WebService?

  Please, help! I can't find any information on MSDN under WSS3 webservices List.UpdateListItems topics how to  programmatically change a list item ContentTypeId   Calling SharePoint list service like: (adding a list item)   XmlElement elBatch = doc.CreateElement("Batch"); elBatch.SetAttribute("OnError", "Continue"); elBatch.SetAttribute("ListVersion", "2"); XmlElement el1 = doc.CreateElement("Method"); el1.SetAttribute("ID", "1"); el1.SetAttribute("Cmd", "New"); XmlElement field1 = doc.CreateElement("Field"); field1.SetAttribute("Name", "ID"); field1.InnerText = "New"; XmlElement field2 = doc.CreateElement("Field"); field2.SetAttribute("Name", "emp_no"); ...Show All

• .NET Development SoapException throws differently by server

  I have a ASP.NET 1.1 web site calling a ASP.NET 1.1 web service on the same server and the SoapExceptions being thrown between the service and the site are different between two of our servers. This application has been working fine on Windows 2000 and on the first Windows 2003 IIS 6 implementation but when we began the migration we started having issues. Are there any settings in IIS 6, .NET, or WIndows 2003 that impact how SoapExcpetions are thrown/handled between a .NET web site and a .NET web service Thanks for the help! The problem server throws SoapExceptions with a message of System.Web.Services.Protocols.SoapException: 10003 The message we are looking for is: 10003 . We take the num ...Show All

• Visual Studio Express Editions considering installing Express Editions - have question

  I am a classic .asp programmer and want to dive into .net. I am thinking about downloading and installing what I need at home to get my feet wet. What I don't understand is the .net framework part of the Express Editions picture. If I install the Express Edition of Visual Web Developer or Visual Basic does it install the .net framework too I have a separate box at home that I want to use set up with IIS and run as a separate webserver instead of running IIS on my development box. Is this possible with the Express Editions (installing the IDE on my workstation) Does the .net framework go on my server box Can I install SQL Server Express on this other server box too I'm just not sure how configure all this. I'd be very thankful if someon ...Show All

• Internet Explorer Development IE hangs executing native code within custom .net toolbar control

  I've got a fairly simple IE bandobject that I wrote using .net 2.0 and the BandObjectLib control from CodeProject ( http://www.codeproject.com/csharp/dotnetbandobjects.asp ) - one of the things the toolbar does is parse the HTML of every page that is loaded and attempts to identify known patterns of data (SSNs for example) and assigns a custom behavior to them to provide Smart Tag like functionality (this is custom tool for our internal users to make it easier to jump between applications using known data). The problem I'm having is that IE will occassionally hang at various points while traverssing the DOM. The code that traverses the DOM is in a separate thread. A short snippet is below (I don't know if the failure is always in the same ...Show All

• Visual Basic MSScriptControl Question

  In VB6 you ran VBScript subroutines/functions through the MSScriptControl by using: ScriptControl.Run Sub_Name, Arg1, Arg2 I've noticed in VB 2005, it now takes an array for the arguments, in the form of ScriptControl.Run(Sub_Name, ArrayWithArguments) The argument field is required though, and if I try to supply an empty array it gives me the error Exception from HRESULT: 0x800A01C2 . Supplying a null or "nothing" doesn't work either. How should I handle the calling of subroutines and functions that have no arguments Is this from the MSScriptControl.ScriptControl class I'm not really familiar with it, but the Run method signature seems to be: Run(ProcedureName as String,ByRef Paramar ...Show All

• Windows Forms packaging sql server express with .net application

  how can i include sql server express and required database in my setup project Thanks You can set the prerequisity on SQL Express in the setup project properties. So when installing application a message will popup with information and a link from where it can be downloaded. For database, you need to pack .mdf file and also .ldf file. Probably your ldf file is big so it's better to create a new one before packing it. You can pack only .mdf file, but you will have problems with next installations. ...Show All

• Architecture SOA - Availability vs. consistency

  Hello, I had an architectural question: Could someone please explain the tradeoff between Availability and consistency in SOA Thanks Houman Houman, with respect of trade-offs and considerations, I'd suggest you the following resources Principles of Service Design: Service Patterns and Anti-Patterns (article) http://msdn.microsoft.com/architecture/default.aspx pull=/library/en-us/dnbda/html/soadesign.asp Service Orientation in Enterprise Computing (article) http://msdn.microsoft.com/architecture/default.aspx pull=/library/en-us/dnbda/html/soa_vb-1.asp MSDN Architecture Webcast: Connecting Your Business with Service Orientation (webcast) http://msevents.microsoft.com/cui/w ...Show All

• Visual Studio Tools for Office Mail message error.

  Hi, I am trying to notify the all users when any one of them modify the sheet value (from VSTO application). below is the code i am using it to notify.And I am getting error message as "Error occured in sedning mail". Inner exception message is : "System.net.scokets.socketsException:An established connection was aborted by the software in your host machine." I am using a proper SMPT server for mail message. Private Sub CreateTestMessage4() Dim from As New MailAddress("x.y@xyz.com") Dim towhom As New MailAddress(" x.y@xyz.com ") Dim message As New MailMessage(from, towhom) message.Body = ("Hello - Testing") message.Subject = "Using the SmtpClient clas ...Show All

• Visual Basic of oledbadapters and oledbcommand

  Hi, I am not sure if this is the right place to ask this question so I hope the moderator could direct it to the right group if it isn't. Can an oledbadapter share/use more than one oledbcommand I know that nnormaly we would do something like: myCMD.connection = myConn Dim aAdapter as new oledbadapter aAdapter.SelectCommand = myCMD where myCMD is the command string, myConn the database connection. If I have another command string that I want to implement called myCMD2 and I am still refering to the file connected in MyConn, can we do something like this: myCMD.connection = myConn Dim aAdapter as new oledbadapter aAdapter.SelectCommand = myCMD aAdapter.SelectCommand = myCMD2 or do I need to create another oledbadapter for myCMD2. It s ...Show All

• Windows Forms creating label

  System.Windows.Forms public void CreateMyLabel() { // Create a new label and create a bitmap. Label label1 = new Label(); Image image1 = Image.FromFile("c:\\MyImage.bmp"); // Set the size of the label to accommodate the bitmap size. label1.Size = new Size(image1.Width, image1.Height); // Initialize the label control's Image property. label1.Image = image1; // ...Code to add the control to the form... } in windows forms is it possible to create new label with its properties ;; i want to change my web form label image is it possible without using css like this Hi Radith, What do you mean by Radith wrote: ...create new label with its properties ... Web form, you mentioned Can ...Show All

• Visual C++ can I add a component that I have created to the toolbox?

  Hi, I'm learning VC++2005, I wanted to create a component that I can drag and drop from the toolbox, when I use a windows form application. As I can drag and drop a button, I wanted to drag and drop an opengl window on the form. It is possible where can I find article about it I have serched a lot on google but didn't lucky... thanks thanks, I'll try :) another on component, when I make a new project clr->windows form application, I draw a new windows form that inherit from windows::system::forms::form...but it didn't shown in the tolbar...perhaps I have didn' understood well... what i have understood is: when i make a new class that inherit from a class of the toolbar, when i compile it, it w ...Show All

• Smart Device Development Unknown Error in Cryptographic classes

  Hi, I'm trying to implement a Cryptography Application in the .NET Compact Framework in C#. I'm using an RSACryptoServiceProvider to try and set up Asymmetrical Encryption. So far I can encrypt using the Public Key and decrypt using the Private Key without any problems, but if I try to do the reverse, Encrypt with the Private Key and decrypt with the Public Key, I get an Error message I've not encountered before: "Unknown Error '80000000'." I've not been able to find any reference to this error message anywhere on the internet, does anyone know what it means The code for my small sample application is as follows: RSACryptoServiceProvider recipientPublicKey = new RSACryptoServiceProvider (); RSAPa ...Show All

• Visual Studio SOLUTION - Visual Studio 2005 Pro - Sql Server Reporting Services ????

  Following is my setup: Windows Server 2003 Sql Server 2005 Sql Repoting Services IIS Development Machine Visual Studio 2005 Pro How do I get the Business Intelligence Project types to show up in the Visual Studio 2005 Pro installed on the development machine I know that SSRS is installed correctly on the server, went through the config and then used the version of Visual Studio installed by Sql Server and successfully created a sample report against my db. Thanks ... David L. Collison Any day above ground is a good day! After many hours of searching through various web sites, I finally found a reference in an article on a web site indicating that the needed Business Intelligence tools were included in the SQL Server ...Show All

• Visual Basic MediaPlayer and Read Movie Files

  I want to read media files and this files show as link in datagrid. example C:\Movies Movies directory in exist all files break into to datagrid Thanks For Help you can get the list of files in the directory: Dim theFiles() as String = System.IO.Directory.GetFiles( DirectoryPath ) then to display it in the datagridview, try: Me.theDataGridView.DataSource = theFiles does this help ...Show All