Omar Darwazeh's Q&A profile
SQL Server SQL mail using external mail server
Hello We are using SQL Server 2000 SP4 Standard Edition and would like to use the e-mail function to monitor certain alerts. However, an e-mail server (SMTP server) is not installed on that box, but on a different IP address within the network. I have set up the e-mail operator, enabled e-mail in SQL Agent and set the Mail Configuration in Support Services. However, on testing I get the following error : Error 18030: xp_test_mapi_profile : Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default mail client. As I cannot install Outlook on this server, I am now stuck. Has anyone a suggestion how I can overcome this issue ...Show All
Windows Forms Changing data in DataTable does not update bound DataGridView
I have a C# program with a DataGridView on a Form, and another object that contains a DataTable. The object creates a new Thread and periodically changes the data in the DataTable. The DataGridView is bound to the DataTable, but only updates when the Form is forced to redraw. It seems as if the changes to the DataTable do not fire an event off to the DataGridView. I use the following command to bind my DataTable to my DataGridView: gridView.DataSource=dataTable; and I change the data in my DataTable using: dataTable.Rows[row][col]=value; dataTable.Rows[row].AcceptChanges(); * Is there an alternate way of changing the data that guarantees an event is fired * Or is there an alternate way of binding the DataTable to the DataGridView * I ...Show All
.NET Development Generating xml pages using c# in a web service.
Hi, I can't seem to find anything on the web about this. I am currently working on a web service(server) where a client sents a request to the the web service and the web service responds in an xml format. The tricky bit is this response has to be in a certain format that is compattable with the client. The format is outlined below < xml version="1.0" encoding="ISO-8859-1" > < xml-stylesheet type="text/xsl" href="search/dsp_does_not_exist.xsl" > <wfmcase> <case_details> <caseid>9504356638</caseid> <archive_status/> </case_details> <error_status> <error>1</error> <error_type>Application</error_type> <er ...Show All
.NET Development Determine Caller name
Hi, is it possible via reflection to determine the calling class/form that called the present method Caller know to which it is calling, how the callee will know that I'm called by XXX assembly Dont think so, its possible!!! BTW is it a requirement for your work or you are just digging to learn Best Regards, ...Show All
SQL Server Cannot have two flat file destinations in a package (possible bug)?
During my development of a ssis package i've noticed that when creating two control flows that pulling data from seperate tables, each going to its own flat file, that the second keeps the attributes of the column names from the first. So when I create my second flat file, not only does it have the names of its correct columns but has the name of the the first flat file. I'm hoping that I've explained the correctly. I'll provide more info "OR" I can provide the code to package if anyone would like. Bogey1 wrote: During my development of a ssis package i've noticed that when creating two control flows that pulling data from seperate tables, each going to its own flat file, that t ...Show All
Smart Device Development socket programming
hai everybody iam trying to connect to ftp server from ftp client, the connection is establishes also and i can download the files from ftp server also but , i downloaded the files from particular path "c:/inetpub/ftproot" only. iam unable to access / download the files from other paths. if i want to do download the files from other paths in the ftp server what i have to do.. Can anybody help in this regard hello , Thanx for ur help... iam running sql server in one LAN A at port 1433 i wrote a normal client program at LAN B .. Using tcp/ip socket programming i connected to sql server running at 1433.. how can i pass the queries to the sql ser ...Show All
Visual Studio Tools for Office Controlling Ink API in Word
I have a tablet pc. IBM Thinkpad that is running XP/Office 2003. I am doing some research on Ink Development. There is already some Microsoft functionality in Word that recognizes your ink and turns it into valid text. Is there a way to disable this functionality programmatically in word Is there a way to interface with this functionality and have it behave differently Thanks. Properly, since this question has nothing to do with the VSTO technology, you should be asking this question in one of the Word programming groups, such as http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.word.vba.general&lang=en&cr=US FWIW, Word doesn't provide any of the Ink functi ...Show All
Visual Studio Team System reset work items refnames
hi, i`m defining work-items with specific refnames. but i`m not satisfied with my naming conventions and want to change the names of some fields. but this is not possible and i get the following error: tfs does not support renaming of fields. i thought i just could delete the project where i imported the work-items. but the refnames are obviously remembered and i can`t redefine them. so my question is: is it possible to reset tfs relating to refnames of work-items maybe delete all projects ok i didn`t really deleted the project, i just removed it from team explorer :) TFSDeleteProject /Server:atvie-tfs01 /force test5 this cmd he ...Show All
Visual Studio Team System Project members want to see Iteration list with associated Work items
Heya, I've just added a new team project with a couple of iterations. I've also added some work items to each iteration. Now my project members wants to see a list of iterations including the work items in order to know what to start with. However, I can't find a good list of iterations with work items anywhere, the closest I can find is the Development Plan, but that is an Microsoft Project file and they do not have Microsoft Project installed.. Surely there is a page on the Project Portal which lists the iterations and associated work items, where is it :) Cheers, Chris Hi Chris, You are quite right. We had envisioned project as the place to get this information. However, this would ma ...Show All
SQL Server Accessing a SQL Server Web Service
Has anyone attempted to access a SQL Server web service using the Web Task Whenever I attempt to access a web service I get "401 Unauthorized". If I try to put in credentials I get "501 Not Implemented" If I access it from a .Net desktop application it works. Thinking it might be due to needing to be able to pass SQL Server authentication from the SSIS package, I attempted to implement SSL for testing with no luck. Below is what I attempted if anyone can see anything wrong or has a link to getting SSL working it would be great also. CREATE ENDPOINT TestWS2 STATE = STARTED AS HTTP ( PATH = '/TestWS' , AUTHENTICATION = ( BASIC , INTEGRATED ), PORTS = ( SSL ), SITE ...Show All
Windows Forms Can we Add ListItem objects to ListBox ?
Dear friends i have basic doubt that is can we add ListItem's to ListBox (or) is ListItem's are only for ListView any suggetions Thanks Ranadheer Matthew Watson wrote: That would be ok if it was a ListView the OP is using, but I think he's using a ListBox. It'll work for ListBox too because see this signature ListBox.Items.Add(object obj); So you can put any object of any type in ListBox. Best Regards, Rizwan aka RizwanSharp. ...Show All
SQL Server Installing Sql 2005 on Vista - checkboxes grayed out.
When I try to install SQL 2005 Enterprise edition on Vista - the checkboxes for everything but what i think is the client tools are grayed out. I get 3 warnings - Sql server edition os system compatibility iis feature requirement edition change check IIS is enabled, i have installed sp1(i thought this would fix the compatibility issue) and i think the edition change is because i have redone this about 6 times now - and it detects that i have done this before. so i click next on the install wizard and get to the check box tree and the only one available to check is the workstation components. what am i doing wrong Enterprise Edition isn't supported on Vista, which is why it's gr ...Show All
SQL Server Installing MSDTC Resource after installing SQL Server 2000 cluster
Is it possible to install and configure the MSDTC resource in a SQL Server 2000 cluster after SQL is installed and running When I recently went through a rebuild of my cluster, I forgot to install the resource before installing SQL Server. Now, if I install and bring online the MSDTC resource the SQL disk groups will not fail over correctly. The SQL Server resource will not come online. Thanks in advance for any help. I would really like to avoid rebuilding again. Andy I am not an expert on clusters but you might want to check out the following article http://support.microsoft.com/kb/294209/en-us Michelle ...Show All
Windows Forms can i Connect multi table on the datagridView
please answer me can i connect multi table with dataGridview if can give me example thanks Private Sub Form1_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load Dim dsOrdersAndDetails As New DataSet() Dim daOrders As New SqlClient.SqlDataAdapter() Dim daDetails As New SqlClient.SqlDataAdapter() Dim conn As New SqlClient.SqlConnection() Dim tblOrders As New DataTable() Dim tblDetails As New DataTable() dsOrdersAndDetails.Tables.Add(tblOrders) dsOrdersAndDetails.Tables.Add(tblDetails) conn.ConnectionString = "Data Source=(local);Initial Catalog=Northwind;Integrated Security=SSPI" ...Show All
Internet Explorer Development ViewLink Object in IE7
I created a viewlink HTC long time ago, it works fine with IE5.5 and IE6. But the line of code below just doesn't work in IE7. if (TitleStyle != null) document.styleSheets(0).rules(1).style.cssText = TitleStyle; In IE7, after assigning a value to the rule of a style sheet, the rule will become blank (empty string). Anyone can help Here is the source code for PopCalendar.htc <html> <head> <public:component tagName="Calendar"> <public:defaults viewLinkContent /> <public:defaults viewInheritStyle="false" /> <public:property name="selectedDate" get="get_selectedDate" put="set_selectedDate" /> <public: ...Show All