.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SMO Problem getting list of Servers

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :

We have had code in a number of our apps for a few years that presents end-users with list of Servers to assist them in establishing a connection.  I have included this code at the end of this initial post - as you can see, its very simple...

However, users who have upgraded from SQL 2005 to SQL 2008 found that this formerly trusty code now produces an error.  I contacted Microsoft and was told "Oh, you need your users to load the SQL 2005 Compatibility Pack" - so I downloaded that and alerted those users to the link I was given.

We loaded that pack on our test machines - IT DOESNT WORK.  6 of our customers loaded it too - IT DOESNT WORK.  All machines who downloaded and installed this "Compatibility Pack" have found its useless - it doesnt do what Microsoft's own support tech told us it would, and now, trying to support a mix of both SQL 2005 and SQL 2008 users, we are kind of dead in the water.

Can anyone give me an answer that actually works?  Why does the following code work fine in SQL 2005, and not at all in SQL 2008 - and what do I do to fix this problem?  Here is the VB.NET code...


View Complete Post

More Related Resource Links

problem...i want a list item to populate all data in gridview!!!


i have a dropdownbox and a gridview

what I want is to have a list item which populates all data in a gridview.

I have tried using list item selected value=0 but to no avail.

what is the easiest way to achieve this?

Cascade Drop Down List Problem


I have 4 "cascade drop down linked" each other. The first one is "AccesoryFor", the second "TypeOfAccesory", the third "MarkOfAccesory" and the fourth "ModelOfAccesory".

The problem is that sometimes is possible in the web page I'm programming that a "Session Variable" could have a value that must be selected in one of that ddls. But not only that, the "ddl" or the entire "row" where the ddl is located ,must disappear. The problem is that, when the page does the rendering process, the others "cascade drop down" don't find its "control parents", so they stay disable and without data.

So, what I do in the Load Method:

 protected void Page_Load(object sender, EventArgs e)
        if (!IsPostBack)
            Session["AccesoryFor"] = "cellphone";

 public void loadValuesToUI()
    if (Session["consultarRecursos_AccesorioDe"] != null)
            rowAccesoryFor.Visible = false;

As the row where the first DLL is located dissapears, and error occurs saying that "Control-Parents" are not found. There's no way to "Disable" or make dissapear the ddl in the web-service because

Problem with list controls and update progress template



I have an update panel that surrounds a wizard control which I use in conjunction with a update progress control. Now my update progress control works perfectly, with my animated gif and div tag that lays over my wizard control when the user goes from step to step. However, there is a problem that I am struggling to solve. A number of my steps use controls like list boxes, and when the update progress control fires, the list control is not laying underneath my div an animated gif no matter how high a make my css z-index on the div.

Does anyone have a way of solving this?


Problem with SharePoint Designer 2007 and Custom List Forms


I created several forms (Create/Edit/View) for a SharePoint list, using Custom List Forms.  I'm using Content Types in the list to ensure that each item only has the necessary fields.  When I created the ASPX forms, and inserted the Custom List Forms, I selected the correct Content Type, and I got the right fields inserted in the form.

Now, for some reason I can't identify, every time I create a new form, and insert a Custom List Form, SPD is bringing ALL fields from the list, instead of just bringing the fields included in the selected Content Type.

I have tried many different things to solve the problem, including creating new lists/content types/forms, etc. but SPD is doing the same thing all the time.

Can somebody tell me what may have gone wrong in SPD or MOSS?


c# form problem with list item


I've got a c# form containing a listbox how ever i cant get

listbox1.items.Selected      to work



neither work. both not giving me the option for .selected nor selectedvalue

how does this work on c# forms as it works the above way on webforms....

.Sort a List problem



I have a little problem with sorting a List<String>.

I have put 4 elements like this and now are trying sort them correct. My example below shows the problem. I am not sure of how sort the names so they comes in this order: "Folder1, Folder2, Folder10, Foler11"  ?

List<String> GetNames = new List<String>();

GetNames .Add("Folder1");
GetNames .Add("Folder10");
GetNames .Add("Folder2");
GetNames .Add("Folder11");

GetNames.Sort(); //Sort the list

The sort comes in this order now which is wrong:

How to sort the list to have this order: ?



Sharepoint 2010 List Added Event Problem

Hi All, I have created List Added Event Handler. In that Event I want to Add Custom Field in List as List is created. I get an Error "The Specified Program Requires    a newer version of windows" Is there ant solution for it. I have tried it also creating new instances of spweb and spsite rather than getting it from "Properties" Thanks Saumil Thakkar

Reorder list problem having to do with control placement

I have a page with a FileUpload control that uploads an image to a sql db when Button_Upload is clicked. I also have a reorder list contained within an update panel to display all the images in the database.The problem is with the code as shown below:1. I have the Button_Upload as an AsynchPostbackTrigger for the Update Panel2. The FileUpload.PostedFile=Nothing in Button_Upload_Click and no new image gets loaded.If I remove Button_Upload as an AsynchPostbackTrigger as a trigger then1. image gets added but reorderlist doesn't get refreshed and new picture doesn't appear in reorder list2. if I manually refresh browser button click event fires and image gets added againWhat is the way to place controls/triggers to get reorder list to show new picture when it gets added to the database? Thanks   <%@ Page Title="" Language="VB" MasterPageFile="~/sfcas_nofooter.master" AutoEventWireup="false" CodeFile="ImageUpload.aspx.vb" Inherits="ImageUpload" MaintainScrollPositionOnPostback="true" %> <%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %> <asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server"> <div id='leftside_fixproblem' &g

people picker problem, with multiple select lose the list.

<!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} p {mso-margin-top-alt:auto; margin-right:0cm; mso-margin-bottom-alt:auto; margin-left:0cm; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} @page Section1 {size:612.0pt 792.0pt; margin:72.0pt 90.0pt 72.0pt 90.0pt; mso-header-margin:36.0pt; mso-footer-margin:36.0pt; mso-paper-source:0;} div.Section1 {page:Section1;} --> Hi guys I have a master table with configuration for reports. when I load a InfoPath form (2010) for new report I have a approvers that set ok  , and I have  Notifies (multiple people) when I load a value form master they left me in the field only the first value(people) and lose the others. Do you know if there any way to load a multiple people value in people picker control?   Thank in advance Ramiro

List problem

I have a list in my website and am experiencing 2 strange problems: 1) I can automatically see the "List tool" panels for all the other lists in the site except for this particular list. I need to click on the web-part area hosting the list or an item of the list and only then the "List tool" panel at the top of the page appears. 2) Also, at the end of the list..I see only "+" button and do not see the "Add new item" text besides the "+" button.   Can someone help me please?

problem with displaying items in list view web part

I have a list view webpart at default display form. Default Display form display items (for example) from the contracts documents library. List view webpart also associated with the same documents library (contracts). In such case this webpart doesn't display any item. But if I add another list view web part associated with warrants document library it display item without any problems. Is it possible to bind list view webpart to another data source for contracts document library? Or maybe another solution? Thanks!

problem in Business Data list webpart

<Entity EstimatedInstanceCount="100" Name="Customer">



problem in Business Data list webpart

<Entity EstimatedInstanceCount="100" Name="Customer">



Problem in parameter list while executing the report in sharepoint



I have created one SSRS 2005 report with 3 dependent parameters ,they are BusinessUnit,Account,Project.In SSRS solution file when i click a specific BU name ,then at the same time Account parametr refreshes and shows the corresponding account names and the same for project.

I deployed the report in to sharepoint 2007,that time the account parameter filed is not refreshing paralleling when i click a BU and it shown as inactive.Only when i click the apply parameter acoount fild shows the corresponding account names.Please help me to avoid the issue.Thanks in advance.


Drop Down List Selected Value problem ...



I created an Html Helper that renders 3 drop down lists (Day, Month and Year) for a field of type DateTime:

    public static MvcHtmlString Date(this HtmlHelper htmlHelper, String name, IEnumerable<SelectListItem> days, IEnumerable<SelectListItem> months, IEnumerable<SelectListItem> years, IDictionary<String, Object> htmlAttributes) {

      if (String.IsNullOrEmpty(name)) throw new ArgumentNullException("name", "Name cannot be null");

      StringBuilder fields = new StringBuilder();

      if (days != null)
        fields.Append(htmlHelper.DropDownList(String.Format("{0}.Day", name), days, String.Empty, htmlAttributes));

      if (months != null)
        fields.Append(htmlHelper.DropDownList(String.Format("{0}.Month", name), months, String.Empty, htmlAttributes));

      if (years != null)
        fields.Append(htmlHelper.DropDownList(String.Format("{0}.Year", name), years, String.Empty, htmlAttributes));

      return MvcHtmlString.Create(fields.ToString());     

    } // Date

And I have a DateFor extension:

    public static MvcHtmlString DateFor<TModel, TProperty>(this HtmlHelper<TModel> htmlHelper, Expression<Func<TModel, TProperty>> expression, IEnumerable<S

Problem with Linked servers from sql 2005 to Excel file


I am probably doing something stupid BUT I am creating a linked server to an excel file, I have done this on sql2005sp2x64 using the ace ole 12 provder, and replicated on another machine running sql2005sp2x32 using the jet4 provider and I am having the same problem on both.  I have turned allow inprocess option on on both providers.  I as an administrator on the machine where the database and datafile are residing have no problem accessing the linked server and the file underneath however any enduser that is not in the local administrators group gets the error   Cannot initialize the data source object of OLE DB provier "Either provider I have tried" for linked server    SQL Server Error 7303.  I have checked file permissions, and they are open to the world, I have tried both use existing authentication and use no authentication when accessing the linked server.  and I have tried endless different combinations of providers and provider strings.  I have went as far as having the enduser create a linked server to an excel file on his local machine (which he is admin on and I am not)   and he can access the file .. and I can not.  so I am just assuming there is some sort of security setting somewhere .. that I am just missing.



Getting servers list in the farm in WSS 2.0


I need to get the list of all servers in the farm. Using WSS 3.0 I can do that

                            using (SPSite startSite = new SPSite(ConfigurationSettings.AppSettings["FarmName"]))
                                SPFarm farm = startSite.WebApplication.Farm;
                                foreach (SPServer spServer in farm.Servers)
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend