albewar's Q&A profile

• SQL Server SSIS not detecting Oracle Stored Procedure failure

  Hi, I figured out a way to execute an Oracle Stored Procedure from an Execute SQL Task by using Declare Begin SomeStoredProc( , , ); End; with an OLE DB connection using the Oracle Provider for OLE DB. The parameters are getting passed in and the procedure executes but if for some reason it fails SSIS is painting the task green and keeps processing. I'm guessing that's because the outer Declare/End statement completed sucessfully. I couldn't get it to work as a function with a return value. :( Is there another way to execute an Oracle stored procedure that I missed Can you call an Oracle stored procedure from a Script Ta ...Show All

• Visual C++ Mouse Events!

  Hello together! I am sorry, but I am new to Visual C++ and I would like to know how can I react on a mouse click, like a mouseListener in Java. I would also appreciate helpfull links and a few lines example code. Thanks for you help. For what are you trying to catch the mounse event   Is this sort of thing any use _ui_object->MouseClick+=gcnew System::Windows::Forms::MouseEventHandler(this, &DetailedTableView::datagridview_MouseClick); void DetailedTableView::datagridview_MouseClick(Object^ sender, MouseEventArgs^ e) { {    if(e->Button==::MouseButtons::Right) { ...Show All

• Visual Basic Why don't answer: Showing Form as Field Lookup

  Hi! I made a form with only one combo box which loads data from database. well problem is that i want to show that form as a lookup control for the datagrid, i can show that form on another form but i can't align that form just under/over the active cell of datagrid on another form. please help me solve this problem. Shani. Hi Bill! Thank you, atleast for answering my post. I'll try to check that way. Shani! ...Show All

• Visual C# UserControl.Region property question

  Hi, I am making a custom datagrid control which consists of two usercontrols, one which is the frame and a child control to display the actual data. However when the number of rows exceeds the visible area, the child control needs to slide under the frame. Basically the data is only in the client area of the frame. I do this by adjasting the Region property of the child control whenever the user scrolls. However, this method introduces a flicker which is quite visible when I have more data. Does anybody know how to implement this "SlideUnder" effect more efficiently Any ideas and suggestions are welcomed. Angel Kafazov I thought a bi ...Show All

• SQL Server How can I get the actual line number from inside flatfile sources for each record?

  hi all, maybe this is not a serious problem, but I tried for days to come toi a solution without success. My Problem: I have have several flatfile sources I need to import into a sql-server 2005 DB. It is very important for me to have the original line number from inside the source file for each record. The rowcount transform doesn't fit in for this task, because it accumulates all rows until the end of the dataflow. I tried script components and it works fine if i assume there are no errors in my source. then I simply could declare a local variable and count it up and add a custom collumn to my output. But for errors in m ...Show All

• Microsoft ISV Community Center Forums Open a Word Document

  Hello i need to find out how to open a word document from my access database any one know a good solution. i have an ole object and you can drag and drop the file onto it but i need a way to have it load up in Word so it can be read/written/printed via word 2003. The following code actually opens a Word document in Microsoft Office Word 2003 from a ASP.NET 2005 /Framework 2.0 Webform. Imports System Imports Microsoft.Office.Interop.Word Imports System.Windows.Forms Partial Class Test_Area_OpenDoc Inherits System.Web.UI.Page Public Shared Sub DocUp() Dim oWd As Microsoft.Office.Intero ...Show All

• Visual Studio Express Editions How to install my application on Windows XP SP1?

  Hi to everybody! I made an application with vb.net express and SQL express and deployed it through VB.NET Express. Everything went well and the program is running on my PC (XP SP2). But a friend of mine tried to install and run it on his computer and got an error message, telling him that he must install XP SP2. I haven't seen the error message myself, I've been told. My question is this: Is there a way to make applications, made in VB.NET and SQL Express ,run under XP SP1 or is it necessary to have XP SP2 Thanks in advance for your responses, Efraim Kyriakidis ...Show All

• Visual FoxPro Changing Report Label Text At runtime using ReportListeners

  Hi, I want to change the Text of the Labels in the Report using Report Listener. My exact scenario is like this. The application which i am working is a international product and used in various languages, i want to change the report Text, Label and Static Text to the Corresponding Language selected in the application. Is there any way using ReportListener we can dynamically change the static content in the Report especially Labels and TextBoxes Thanks in advance -Venkat I don't use listeners so I don't know if listeners have an easier solution. What I do is to get a copy of the frx, change labels on the fly ...Show All

• Visual Basic Text file-most recent will be top of the textfile

  Hello all, I want to know how to append my data into text file(C:\). My problem is when I append a data into text file, The data are appended in bottom of the Notepad text file. I want most recent appened data will be added into top of the file. My code follows, Dim s As String s = RsP.Fields("birthday") & vbTab & RsP.Fields("SEX") & vbTab& RsP.Fields("Weddate") & vbTab & RsP.Fields("spouse") & vbTab & RsP.Fields("marriage") & vbTab & RsP.Fields("DATE1") & vbTab & RsP.Fields("DATE2") & vbTab & Rs ...Show All

• SQL Server SET ARITHABORT OFF functionality

  Hi All, The SET ARITHABORT OFF stmt. is executed before INSERT stmt.. INSERT INTO drivers('jun','williams', 2/0 ,'f1'). A error "Divide by zero error encountered. The statment has been terminated" was thrown without inserting null value in the DRIVERS table. But, T-SQL Reference says that on setting the ARITHABORT variable to OFF and executing the above INSERT stmt. will return a error and also inserts null value in the DRIVERS table. Can anyone throw light on this Cheers, Anand. Srik answer is correct, although the syntax is actually SET ANSI_WARNINGS OFF Regards, Clifford Dibble ...Show All

• .NET Development Use of HealthMonitoring in non-Web apps

  I'm looking into logging options for a set of libraries used by both Windows and Web apps (as well as the apps themselves). I was tending toward log4net but just discovered the HealthMonitoring framework in System.Web.Management. It looks quite good, but I'm concerned about it's "web-centricity" (excuse me). The basic functionality doesn't seem particularly web-oriented, yet it's certainly presented as such (not in the least by being in that namespace). I know that I'd miss out on the default configuration in the base web.config. I know that the heartbeat doesn't work (at least I assume it doesn't, unless I build a heartbeat into t ...Show All

• .NET Development soap:address and how to change

  I have a .net 2 Web Service which is only accessibly through HTTPS. When I browse to the asmx file over https it all looks fine and works, however when I try to add a web reference to another project in Visual Studio it throws an error and seems to change the https to http. ie. I enter https://myservice/service.asmx in the url, but the error says it cant download http://myservice/service.asmx wsdl Having a look through the wsdl in a browser all the URLS look fine except the < soap:address element points to http rather than https, even when viewing over https. Is there any way to set this property manually, or how to I get i ...Show All

• Windows Forms DataGridView Detail Row Saving

  Code snip: Me .BindingSourceDrivers.DataSource = MyDataSet.Tables( "Drivers" ) Me .BindingNavigatorDrivers.BindingSource = Me .BindingSourceDrivers Me .DataGridViewDrivers.DataSource = Me .BindingSourceDrivers MyDataSet.Relations.Add( "DriverToCars" , MyDataSet.Tables( "Drivers" ).Columns( "ID" ), MyDataSet.Tables( "DriverCars" ).Columns( "DriverID" ), True ) Me .DataGridViewDriverCars.DataSource = Me .BindingSourceDrivers Me .DataGridViewDriverCars.DataMember = "DriverToCars" Chris, Did you get an answer to this I'm having a very similar problem ...Show All

• SQL Server DataStage Vs SSIS

  Hi, We are in a process of migrating a process running in Ascential Data Stage to SSIS. The database server is ORACLE 9i. We need samples/guide on the following datastage equivalent features. 1. Calling a function/script/routine from task's Data Flow transformer as Before/After Stage event. 2. Complex XML parsing and loading into sequential files. 3. Creating a batch & based on the condition calling the tasks. For example, if condition=YES then call task 'A' or call task 'B'. 4. Any shared container concept. (A portion of activity will be used by most of the tasks) 5. In the Data Flow Destination, is we have feature like insert ...Show All

• Visual Basic Ingres ADO question

  I'm creating a VB.NET (2005) app using Ingres r3 as the backend db. I'm using the Ingres ODBC driver and ADO from Microsoft. I can read data from the db with no problem, but I can't write it back. (err msg says it is a read only driver, but Ingres tech support says it's a read/write). Anyone trying to do the same thing Hi Tarne, I am sorry if I made any confusion. This is the general troubleshooting steps. As I state before, I am not familar with Ingres DB. So we checked ODBC driver and high level ADO,ADO.NET. Every DB have their own ODBC drivers. You may try to run odbcad32, it will open the ODBC Data S ...Show All