Monday, March 26, 2012
MSRS2000 Extension Compiled Under VS2005?
1.1). We have updated our extension and compiled it under VS2005 (.NET 2.0).
We now use the extension under MSRS2005.
We would like to use the same, .NET 2.0-compiled extension dll under
MSRS2000, but receive errors when attempting to configure the extension
(presumably because MSRS2000 uses on .NET 1.1).
Is there a way to configure MSRS2000 to use a .NET 2.0-compiled extension
(without having to maintain two separate code bases - one for the .NET 1.1
extension and one for the .NET 2.0 extension)?
Thank you in advance for any suggestions / ideas.
Bill BThe RS2000 is built on .NET1.1 and runs only under .NET1.1. So, you cannot
have code built with .NET2.0 to run inside RS2000.
If your extension is compiled under 1.1 (VS2003), it might run with RS2005,
depending what the extension does and needing to test it thoroughly, but if
compiled with 2.0, then it can only run with RS2005, not RS2000.
"Bill B" <Bill B@.discussions.microsoft.com> wrote in message
news:495A7A23-F66E-40AA-8C4E-ADA58425AEB8@.microsoft.com...
> We have an MSRS2000 extension that was originally written under VS2003
> (.NET
> 1.1). We have updated our extension and compiled it under VS2005 (.NET
> 2.0).
> We now use the extension under MSRS2005.
> We would like to use the same, .NET 2.0-compiled extension dll under
> MSRS2000, but receive errors when attempting to configure the extension
> (presumably because MSRS2000 uses on .NET 1.1).
> Is there a way to configure MSRS2000 to use a .NET 2.0-compiled extension
> (without having to maintain two separate code bases - one for the .NET 1.1
> extension and one for the .NET 2.0 extension)?
> Thank you in advance for any suggestions / ideas.
> Bill B|||Thanks Norman. I thought that was the case, but wanted to confirm that there
is no update (or planned update) to Reporting Services 2000 to run on .NET
2.0 (and hence support 2.0 extensions).
"Norman Yuan" wrote:
> The RS2000 is built on .NET1.1 and runs only under .NET1.1. So, you cannot
> have code built with .NET2.0 to run inside RS2000.
> If your extension is compiled under 1.1 (VS2003), it might run with RS2005,
> depending what the extension does and needing to test it thoroughly, but if
> compiled with 2.0, then it can only run with RS2005, not RS2000.
>
> "Bill B" <Bill B@.discussions.microsoft.com> wrote in message
> news:495A7A23-F66E-40AA-8C4E-ADA58425AEB8@.microsoft.com...
> > We have an MSRS2000 extension that was originally written under VS2003
> > (.NET
> > 1.1). We have updated our extension and compiled it under VS2005 (.NET
> > 2.0).
> > We now use the extension under MSRS2005.
> >
> > We would like to use the same, .NET 2.0-compiled extension dll under
> > MSRS2000, but receive errors when attempting to configure the extension
> > (presumably because MSRS2000 uses on .NET 1.1).
> >
> > Is there a way to configure MSRS2000 to use a .NET 2.0-compiled extension
> > (without having to maintain two separate code bases - one for the .NET 1.1
> > extension and one for the .NET 2.0 extension)?
> >
> > Thank you in advance for any suggestions / ideas.
> >
> > Bill B
>
>|||Well, the update that runs on 2.0 is RS 2005.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bill B" <BillB@.discussions.microsoft.com> wrote in message
news:F3DAFA28-E5DA-40FD-8897-8E661FC77E09@.microsoft.com...
> Thanks Norman. I thought that was the case, but wanted to confirm that
> there
> is no update (or planned update) to Reporting Services 2000 to run on .NET
> 2.0 (and hence support 2.0 extensions).
> "Norman Yuan" wrote:
>> The RS2000 is built on .NET1.1 and runs only under .NET1.1. So, you
>> cannot
>> have code built with .NET2.0 to run inside RS2000.
>> If your extension is compiled under 1.1 (VS2003), it might run with
>> RS2005,
>> depending what the extension does and needing to test it thoroughly, but
>> if
>> compiled with 2.0, then it can only run with RS2005, not RS2000.
>>
>> "Bill B" <Bill B@.discussions.microsoft.com> wrote in message
>> news:495A7A23-F66E-40AA-8C4E-ADA58425AEB8@.microsoft.com...
>> > We have an MSRS2000 extension that was originally written under VS2003
>> > (.NET
>> > 1.1). We have updated our extension and compiled it under VS2005 (.NET
>> > 2.0).
>> > We now use the extension under MSRS2005.
>> >
>> > We would like to use the same, .NET 2.0-compiled extension dll under
>> > MSRS2000, but receive errors when attempting to configure the extension
>> > (presumably because MSRS2000 uses on .NET 1.1).
>> >
>> > Is there a way to configure MSRS2000 to use a .NET 2.0-compiled
>> > extension
>> > (without having to maintain two separate code bases - one for the .NET
>> > 1.1
>> > extension and one for the .NET 2.0 extension)?
>> >
>> > Thank you in advance for any suggestions / ideas.
>> >
>> > Bill B
>>
MSQuery Question
He uses MSquery to extract from a SQl 2003 DB. That part I understand
and I can duplicate. The hard part, is that for each row that is
displayed three additional columns show up (in all seven queries) and
in one case he changes the sorting of the query as well. These
functions use the columns output by MSquery. There very simple
functions and tests. In the SQL I can not find them or any reference to
them. There is no module in VBA. No add-in, just the MSQuery. How can
he do this. What should I be searching in Google to understand this
feature?On 23 Jun 2005 08:28:04 -0700, catsinheat wrote:
> I have a worksheet written by another programmer that I have to modify.
> He uses MSquery to extract from a SQl 2003 DB. That part I understand
> and I can duplicate. The hard part, is that for each row that is
> displayed three additional columns show up (in all seven queries) and
> in one case he changes the sorting of the query as well. These
> functions use the columns output by MSquery. There very simple
> functions and tests. In the SQL I can not find them or any reference to
> them. There is no module in VBA. No add-in, just the MSQuery. How can
> he do this. What should I be searching in Google to understand this
> feature?
What is sql 2003?
It helps if you post some SQL and examples.
Tony
--
http://www.dotnet-hosting.com
Free web hosting with ASP.NET & SQL Server
No ads - No trials - Innovative features
Wednesday, March 21, 2012
Msg 9002, Level 17, State 4, Line 2
SQL Server has to log every data modification operation, every insert,
update and delete. If the log is full, nothing can be written to it and no
data modifications can be done. This has nothing to do with the tool you are
using.
Just do what the messages says. Look at the sys.databases view and tell us
what the log_reuse_wait_desc says. Also look at the recovery model
SELECT log_reuse_wait_desc, recovery_model_desc
FROM sys.databases
WHERE name = 'EventSentry'
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://blog.kalendelaney.com
"fiaola" <fiaola@.mail.com> wrote in message
news:uLj2q0WUIHA.4768@.TK2MSFTNGP02.phx.gbl...
> I'm trying to clear some data from a SQL DB table, but i'm getting this
> error:
> I'm just running a Delete Query using Date Diff function. I read in some
> web site that this maybe a problem with SQL Server Management Tools. I
> appreciate any help to get around this and any suggestions would be great.
> Msg 9002, Level 17, State 4, Line 2
> The transaction log for database 'EventSentry' is full. To find out why
> space in the log cannot be reused, see the log_reuse_wait_desc column in
> sys.databases
> Thanks for answering.
>
It might just be that your log is not big enough for the operation you were
doing.
How big is your log file, and is it set to autogrow?
You can get the information in the sys.files view in the database that is
having the problems.
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://blog.kalendelaney.com
"fiaola" <fiaola@.mail.com> wrote in message
news:uH1ss$YUIHA.5816@.TK2MSFTNGP06.phx.gbl...
> Thanks for the quick reply, here are the results.
> Log_Reuse_Wait_Desc = NOTHING
> Recovery_Model_Desc = SIMPLE
> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
> news:eMohs$WUIHA.4768@.TK2MSFTNGP02.phx.gbl...
>
sql