ActiveX Script Running DTS Causes Error

Hello All,

I have an ActiveX script that runs DTS pachkages. In the event that a package fails I want to display the error message. I found the following code (in bold) for doing this but I keep getting an error message as follows.

Type mismatch 'oSoStep.GetExecutionErrorInfo'

All help appreciated.

Thanks, Gary

Could you post your code?
Jason
|||For Each oStep In oPkg.Steps
If oStep.ExecutionStatus = DTSStepExecStat_Completed Then
If oStep.ExecutionResult = DTSStepExecResult_Failure Then
oStep.GetExecutionErrorInfo lErrNum, sSource, sDescr
msgbox(sDescr)
End If
End If
Next

Active Entries in Transaction Log

How can I display the current active entries in the transaction log?Mannie
DBCC TRACEON (3604)
DBCC loginfo(number) -- select db_id('pubs')
"Mannie" <anonymous@.discussions.microsoft.com> wrote in message
news:4429A6B9-2E10-4972-AD57-AED13E3DD808@.microsoft.com...
> How can I display the current active entries in the transaction log?|||you can use third party tools to explore the transaction log entries like
Lumigent Technologies Lumigent Log Explorer
harshal.
"Mannie" <anonymous@.discussions.microsoft.com> wrote in message
news:4429A6B9-2E10-4972-AD57-AED13E3DD808@.microsoft.com...
> How can I display the current active entries in the transaction log?

Active Entries in Transaction Log

How can I display the current active entries in the transaction log?Mannie
DBCC TRACEON (3604)
DBCC loginfo(number) -- select db_id('pubs')
"Mannie" <anonymous@.discussions.microsoft.com> wrote in message
news:4429A6B9-2E10-4972-AD57-AED13E3DD808@.microsoft.com...

quote:

---

> How can I display the current active entries in the transaction log?

---

|||you can use third party tools to explore the transaction log entries like
Lumigent Technologies Lumigent Log Explorer
harshal.
"Mannie" <anonymous@.discussions.microsoft.com> wrote in message
news:4429A6B9-2E10-4972-AD57-AED13E3DD808@.microsoft.com...

quote:

---

> How can I display the current active entries in the transaction log?

---

Accessing Values Parameter Values from another report

Hi, How can I display a value of a report parameter from one report into a textbox on another report?

If you are calling the 2nd report from the first, setup a parameter in the 2nd report, and pass that value to it from the first report. You can set this up in the navigation window.

BobP

accessing report server programmatically

Hi friends
I have .net app ,where i display reports from my report server in a screen .,which works fine.
I added a web reference to my report server ,to my solution to get it work.

since i know my report server name on machine i added webreference to my project. but when i deploy at site ,as you can guess, the server name can be different.

is it possible add web reference programmaically so that i dont need to hard code report server name ?

am using sql server standard 2005,VS2005 standard edition.
Thank you very much for your help

in the place where you instantiate the webservice client:

MyReportServer rs = new MyReportServer();
rs.Url = "http://myservername/reportserver/blabla.asmx";

|||

Alexandre

Thanks for the post.

do you happen to know any sample code i can refer to.

Thanks for your help again.

|||Alexandre
i cant find "MyReportServer" namespace!
what library i need to give reference to?
Thanks for your help
|||try web.config file... i think u got it... define it in web.config file and change it whenever the server name changes|||

When you add a web reference VS will add a C# file to your project with web service endpoint definition. Then in some place in your program you make a call to the web service. the web service will be represented by an object. I refered to the type of the object MyReportServer, mostlikely it will be called differently in your app. This object has Url property that you may assign any new report server URL you want. Just find the place where the object is created.

By default, "MyReportServer" class pulls webservice URL from your config file. You can reset it by assigning new url via Url property

|||

You can use the following in your web.config:

<appSettings>
<add key="ServerURL" value=http://someServer/path/method.aspx />

</appSettings>

And in your code:

reportService.Url = ConfigurationSettings.AppSettings["ServerURL"];

|||Alexandre
if i understood you correctly, i just need to add a web reference to one of in-house report servers ,to our solution but when using it at client sites i need update "URL" property of the web service object by reading either from a config file or from a database field.
is this correct ?
Thanks for your help|||Hi Jay
its a windows app and i dont have a web.config.|||

>> if i understood you correctly

yes.

|||Thanks Alexandre
i already tried and it works nicely.
Thank you very much for your help :)

Accessing Replication Logs via RMO

Hello! I am writing an app with C# that is using SQL Server 2005's RMO objects. I want to display a tree control with say a log history (last successful sync, dates, etc...). I know that the server stores this kind of info somewhere but I'm not sure how to access this via RMO.

Can anybody point me in the right direction? Thanks!

Hi,

The following page in BOL might include the information you need: "How to: prorammatically Monitor Replication (RMO programming)" (http://msdn2.microsoft.com/en-us/library/ms147926.aspx).

-Peng

|||That's it thank you!!!|||

You may also find this helpful...

http://msdn2.microsoft.com/en-US/library/ms146899.aspx

accessing records

Hi

Would anyone be able to advise me on the best way in which i am able to display the information from a Search in sqlce database and allow the results be displayed in a specified location.

An example is in my program there is a list of id which the user can search. They search for a record by id so only one record will return. I would like this information to then be displayed in the textboxes which are on the screen.

Any problems understanding what i am trying to do please ask. Any help would be appreciated

Thanks

I'm going to move this thread to a SQLCE forum. You should have better responses there.|||

Most of the .NET Compact Framework controls support data binding to an underlying data source which can be a DataTable populated by a SqlCeDataAdapter. Even simpler, you could query SQL CE/SQL Mobile with the ID the user provides, (ExecuteQuery), and use the SqlCeDataReader to extract the values you wish to display in the textbox. I would recommend you have a look at some of the sample applications available here:

http://msdn.microsoft.com/netframework/programming/netcf/netcfsamples/default.aspx

Darren

Accessing RDL Reports from Visual Basic 6.0 Application

Hai! I don't know is this a silly question. Is it possible to execute and display the rdl (Sql server 2005 reporting services) report from visual basic 6.0 application.

I have a full fledged Visual basic windows application and using crystal reports. I want to create the reports using SQL server 2005 reporting services and access it from my Visual Basic 6.0 Windows application.

Thanks in advance

I'm afraid VB6 support has ended, and so VB6 questions are off topic here. Try www.vbcity.com instead.