Access to variables in Custom Log Provider?

Hello,

I found one post from the past asking this question, but didn't see an answer, so I am hoping someone can shed some more light on it:

I am writing a custom log provider in C#. Is it possible give this custom log provider access to the variables collection (via a variabledispenser object)? First glance at the log provider classes would tell me that this is not possible, though I would like confirmation. Also, if I am correct in thinking it is not possible, what was the reason for leaving this out?

Thanks!

Indeed this does not appear to be possible. What is it you are trying to acheive? Some more info may help us evaluate this as a feature request for the future.

Donald

|||

Donald,

Thanks for the response. A brief explanation of my thought process below:

I have a package with a number of variables that are evaluated during package execution via property expressions. When a component of the package logs a warning or failure, I would like to be able to identify what state each variable was in at the time of that warning/failure. I had hoped to be able to create a custom log provider to log this information to a database along with the warning/failure message. If the VariableDispenser object was passed into the Log method of my custom log provider, I would be able to accomplish this.

Thanks again.

David

Access to the ADO.net Managed Provider SqlClientFactory was denied

In a previous post in Installation and Setup I was having problems just getting an ASP.NET 2.0 app to run on my web server. Now I'm having some different weird security issues.

I'm getting this message when just trying to open a database and put its contents into a gridview.

Access to the ADO.net Managed Provider 'SqlClientFactory' was denied in the data source with ID 'sqlEmployees' because of security settings.

I think this may have to do with our web server and our SQL server being separate machines. That always gives us issues. But I have impersonation=true in my web.config along with windows authentication and I have SQL Server configured with Windows and SQL authentication so things should be right, I'm thinking.

Any ideas??

I guess I stumped everyone. Thanks anyways.|||

Did you find the solution? If so please post it, so that it will help others :)

|||Had the same problem. There was a web.config in the root directory, deleted it and solved the problem

Access Remote SQL SERVER

Hi :)

Is there a way that i can use to connect to SQL SERVER of my WebService Provider ??

I mean how do i upload my database to the SQL SERVER of my WebService Provider ?

ThanksIf the ISP has allowed you to (by opening port 1433) you can.

Otherwise, you should check with the ISP to see how they suggest uploading databases.|||Thanks for the reply :)

They have given me the port number witch its not 1433 ..its another one ...but what software could i use ...i mean a manager ...i have some trials instaled ...but on the connection option theres no place for the port number ...

is there a correct way to do the connection ?

Thanks|||You can use Enterprise Manager. If you have the SQL Server client installed, there is a Client Network Utility that will allow you to set a port for the connection. Without the SQL Server client installed, I am not sure how the other tools you may have work. I would pick up the SQL Server developer's edition, which I think sells for US$40.00 or so.

Access linked server

I am new to SQL. I am trying to setup a linked server but whenever I try to
view the tables it gives me an error saying
error 7399 : OLEDB provider 'microsoft.jet.oledb. 4.0' reported an error
OLEDB Error Trace
ThanksHi,
have you linked a server using
sp_addlinkedserver and after that have you map logins for and from both
server in order to access it properly using
sp_addlinkedsrvlogin
read BOL for more on this .
Andy Davis
Active Crypt Team
---
SQL Server Encryption Decryption Software
http://www.activecrypt.com
activecrypt@.gmail.com
"Amit" wrote:

> I am new to SQL. I am trying to setup a linked server but whenever I try t
o
> view the tables it gives me an error saying
> error 7399 : OLEDB provider 'microsoft.jet.oledb. 4.0' reported an error
> OLEDB Error Trace
> Thanks