Hi Mike,
This error can happen when the database has been detached and attached onto
a different server and SQL Server is unable to find the correct login
associated with the dbo for that database. If this is the case for you,
then you can fix the problem by using sp_changedbowner to reassociate dbo
with a valid login like so: exec sp_changedbowner 'sa'. Making the error
message more clear is on track to be fixed in a future service pack. Hope
this helps.
Steven
"FwMsdn" <FwMsdn@.discussions.microsoft.com> wrote in message
news:537F22F0-200F-4D1C-96AD-E7A211C75644@.microsoft.com...
> hello together!
> currently we are developing a server database which is using an assembly
> with some very simple clr-functions (eg check regular expression or
> converting local time to universal time).
> from some indefinite time we receive the following errormessage each time
> calling such a clr-function:
> Msg 10314, Level 16, State 11, Line 1
> An error occurred in the Microsoft .NET Framework while trying to load
> assembly id 65706. The server may be running out of resources, or the
> assembly may not be trusted with PERMISSION_SET = EXTERNAL_ACCESS or
> UNSAFE.
> Run the query again, or check documentation to see how to solve the
> assembly
> trust issues. For more information about this error:
> System.IO.FileNotFoundException: Could not load file or assembly
> 'myassembly, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null' or one
> of
> its dependencies. The system cannot find the file specified.
> System.IO.FileNotFoundException:
> at System.Reflection.Assembly.nLoad(AssemblyName fileName, String
> codeBase, Evidence assemblySecurity, Assembly locationHint,
> StackCrawlMark&
> stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)
> at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef,
> Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean
> forIntrospection)
> at System.Reflection.Assembly.InternalLoad(String assemblyString,
> Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean
> forIntrospection)
> at System.Reflection.Assembly.Load(String assemblyString)
> the only way to get the assembly working again is to restart the sql
> server
> engine or the whole server.
> sometimes even multiple restarts are needed.
> we tried several things to get rid of this message but without any access:
> - drop and re-create the assembly and all functions in the database (with
> visual studio deployment, with t-sql statements loading the assembly from
> a
> file or in binary)
> - change of the assembly permission_set according to the error message
> (even
> there is no external access or unsafe code - there is even no database
> access
> at all)
> - restrict the maximum server memory at the server options
> - we already tried to setup the whole database on a complete different
> independent server with a complete fresh sql server installation
> - update the sql server with service pack 1
> - building the assembly with platform x64 instead of any cpu
> configuration of our two test systems
> - WIN2003 SP1 ENT + SQL2005 STD X64 RTM clustered
> - WIN2003 SP1 ENT + SQL2005 DEV X64 SP1 single
> any ideas or recommendation regarding this problem? - thanks in advance
> mike s.hello together!
currently we are developing a server database which is using an assembly
with some very simple clr-functions (eg check regular expression or
converting local time to universal time).
from some indefinite time we receive the following errormessage each time
calling such a clr-function:
Msg 10314, Level 16, State 11, Line 1
An error occurred in the Microsoft .NET Framework while trying to load
assembly id 65706. The server may be running out of resources, or the
assembly may not be trusted with PERMISSION_SET = EXTERNAL_ACCESS or UNSAFE.
Run the query again, or check documentation to see how to solve the assembly
trust issues. For more information about this error:
System.IO.FileNotFoundException: Could not load file or assembly
'myassembly, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null' or one o
f
its dependencies. The system cannot find the file specified.
System.IO.FileNotFoundException:
at System.Reflection.Assembly.nLoad(AssemblyName fileName, String
codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark&
stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)
at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef,
Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean
forIntrospection)
at System.Reflection.Assembly.InternalLoad(String assemblyString,
Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean
forIntrospection)
at System.Reflection.Assembly.Load(String assemblyString)
the only way to get the assembly working again is to restart the sql server
engine or the whole server.
sometimes even multiple restarts are needed.
we tried several things to get rid of this message but without any access:
- drop and re-create the assembly and all functions in the database (with
visual studio deployment, with t-sql statements loading the assembly from a
file or in binary)
- change of the assembly permission_set according to the error message (even
there is no external access or unsafe code - there is even no database acces
s
at all)
- restrict the maximum server memory at the server options
- we already tried to setup the whole database on a complete different
independent server with a complete fresh sql server installation
- update the sql server with service pack 1
- building the assembly with platform x64 instead of any cpu
configuration of our two test systems
- WIN2003 SP1 ENT + SQL2005 STD X64 RTM clustered
- WIN2003 SP1 ENT + SQL2005 DEV X64 SP1 single
any ideas or recommendation regarding this problem? - thanks in advance
mike s.|||Hi Mike,
This error can happen when the database has been detached and attached onto
a different server and SQL Server is unable to find the correct login
associated with the dbo for that database. If this is the case for you,
then you can fix the problem by using sp_changedbowner to reassociate dbo
with a valid login like so: exec sp_changedbowner 'sa'. Making the error
message more clear is on track to be fixed in a future service pack. Hope
this helps.
Steven
"FwMsdn" <FwMsdn@.discussions.microsoft.com> wrote in message
news:537F22F0-200F-4D1C-96AD-E7A211C75644@.microsoft.com...
> hello together!
> currently we are developing a server database which is using an assembly
> with some very simple clr-functions (eg check regular expression or
> converting local time to universal time).
> from some indefinite time we receive the following errormessage each time
> calling such a clr-function:
> Msg 10314, Level 16, State 11, Line 1
> An error occurred in the Microsoft .NET Framework while trying to load
> assembly id 65706. The server may be running out of resources, or the
> assembly may not be trusted with PERMISSION_SET = EXTERNAL_ACCESS or
> UNSAFE.
> Run the query again, or check documentation to see how to solve the
> assembly
> trust issues. For more information about this error:
> System.IO.FileNotFoundException: Could not load file or assembly
> 'myassembly, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null' or one
> of
> its dependencies. The system cannot find the file specified.
> System.IO.FileNotFoundException:
> at System.Reflection.Assembly.nLoad(AssemblyName fileName, String
> codeBase, Evidence assemblySecurity, Assembly locationHint,
> StackCrawlMark&
> stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)
> at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef,
> Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean
> forIntrospection)
> at System.Reflection.Assembly.InternalLoad(String assemblyString,
> Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean
> forIntrospection)
> at System.Reflection.Assembly.Load(String assemblyString)
> the only way to get the assembly working again is to restart the sql
> server
> engine or the whole server.
> sometimes even multiple restarts are needed.
> we tried several things to get rid of this message but without any access:
> - drop and re-create the assembly and all functions in the database (with
> visual studio deployment, with t-sql statements loading the assembly from
> a
> file or in binary)
> - change of the assembly permission_set according to the error message
> (even
> there is no external access or unsafe code - there is even no database
> access
> at all)
> - restrict the maximum server memory at the server options
> - we already tried to setup the whole database on a complete different
> independent server with a complete fresh sql server installation
> - update the sql server with service pack 1
> - building the assembly with platform x64 instead of any cpu
> configuration of our two test systems
> - WIN2003 SP1 ENT + SQL2005 STD X64 RTM clustered
> - WIN2003 SP1 ENT + SQL2005 DEV X64 SP1 single
> any ideas or recommendation regarding this problem? - thanks in advance
> mike s.|||hi steven,
first many thanks for your quick response and support!
you're right the database has been detached and attached on different
servers during development many times
can i check this case with the system catalog views?
when i take a look at the sys.databases catalog view the owner_sid is 0x01 -
according to the sys.server_principals and sys.database_principals views the
sid 0x01 belongs to the login sa and the user dbo
anyway i will try to change the dbo according to your statement and hope
that this error won't occur in the future
thanks again,
mike s.
"Steven Hemingray [MSFT]" wrote:
> Hi Mike,
> This error can happen when the database has been detached and attached ont
o
> a different server and SQL Server is unable to find the correct login
> associated with the dbo for that database. If this is the case for you,
> then you can fix the problem by using sp_changedbowner to reassociate dbo
> with a valid login like so: exec sp_changedbowner 'sa'. Making the error
> message more clear is on track to be fixed in a future service pack. Hope
> this helps.
> Steven
>
> "FwMsdn" <FwMsdn@.discussions.microsoft.com> wrote in message
> news:537F22F0-200F-4D1C-96AD-E7A211C75644@.microsoft.com...
>
>|||hi again,
after changing the dbo like you describe above it only takes some hours and
now the error occurs again
any other ideas or suggestions?
thanks in advance,
mike
"FwMsdn" wrote:
[vbcol=seagreen]
> hi steven,
> first many thanks for your quick response and support!
> you're right the database has been detached and attached on different
> servers during development many times
> can i check this case with the system catalog views?
> when i take a look at the sys.databases catalog view the owner_sid is 0x01
-
> according to the sys.server_principals and sys.database_principals views t
he
> sid 0x01 belongs to the login sa and the user dbo
> anyway i will try to change the dbo according to your statement and hope
> that this error won't occur in the future
> thanks again,
> mike s.
> "Steven Hemingray [MSFT]" wrote:
>|||hi steven,
first many thanks for your quick response and support!
you're right the database has been detached and attached on different
servers during development many times
can i check this case with the system catalog views?
when i take a look at the sys.databases catalog view the owner_sid is 0x01 -
according to the sys.server_principals and sys.database_principals views the
sid 0x01 belongs to the login sa and the user dbo
anyway i will try to change the dbo according to your statement and hope
that this error won't occur in the future
thanks again,
mike s.
"Steven Hemingray [MSFT]" wrote:
> Hi Mike,
> This error can happen when the database has been detached and attached ont
o
> a different server and SQL Server is unable to find the correct login
> associated with the dbo for that database. If this is the case for you,
> then you can fix the problem by using sp_changedbowner to reassociate dbo
> with a valid login like so: exec sp_changedbowner 'sa'. Making the error
> message more clear is on track to be fixed in a future service pack. Hope
> this helps.
> Steven
>
> "FwMsdn" <FwMsdn@.discussions.microsoft.com> wrote in message
> news:537F22F0-200F-4D1C-96AD-E7A211C75644@.microsoft.com...
>
>|||hi again,
after changing the dbo like you describe above it only takes some hours and
now the error occurs again
any other ideas or suggestions?
thanks in advance,
mike
"FwMsdn" wrote:
[vbcol=seagreen]
> hi steven,
> first many thanks for your quick response and support!
> you're right the database has been detached and attached on different
> servers during development many times
> can i check this case with the system catalog views?
> when i take a look at the sys.databases catalog view the owner_sid is 0x01
-
> according to the sys.server_principals and sys.database_principals views t
he
> sid 0x01 belongs to the login sa and the user dbo
> anyway i will try to change the dbo according to your statement and hope
> that this error won't occur in the future
> thanks again,
> mike s.
> "Steven Hemingray [MSFT]" wrote:
>|||The way to check for the problem is to see if the owner_sid in sys.databases
does not match the sid for dbo in sys.database_principals.
use YOUR_DATABASE
go
select d.name, dp.name, d.owner_sid, dp.sid from sys.databases d,
sys.database_principals dp where d.owner_sid = dp.sid and dp.name = 'dbo'
and d.name = 'YOUR_DATABASE'
If you're still seeing this problem and the above query indicates that the
sids match, then it must be a different problem and I'd have to do some
investigation on what else could cause this to fail repeatedly and on
different independent servers.
Steven
"FwMsdn" <FwMsdn@.discussions.microsoft.com> wrote in message
news:EB0942FA-39B3-4590-B7F8-73D59A1A0794@.microsoft.com...[vbcol=seagreen]
> hi again,
> after changing the dbo like you describe above it only takes some hours
> and
> now the error occurs again
> any other ideas or suggestions?
> thanks in advance,
> mike
> "FwMsdn" wrote:
>|||The way to check for the problem is to see if the owner_sid in sys.databases
does not match the sid for dbo in sys.database_principals.
use YOUR_DATABASE
go
select d.name, dp.name, d.owner_sid, dp.sid from sys.databases d,
sys.database_principals dp where d.owner_sid = dp.sid and dp.name = 'dbo'
and d.name = 'YOUR_DATABASE'
If you're still seeing this problem and the above query indicates that the
sids match, then it must be a different problem and I'd have to do some
investigation on what else could cause this to fail repeatedly and on
different independent servers.
Steven
"FwMsdn" <FwMsdn@.discussions.microsoft.com> wrote in message
news:EB0942FA-39B3-4590-B7F8-73D59A1A0794@.microsoft.com...[vbcol=seagreen]
> hi again,
> after changing the dbo like you describe above it only takes some hours
> and
> now the error occurs again
> any other ideas or suggestions?
> thanks in advance,
> mike
> "FwMsdn" wrote:
>|||hi steven,
as mentioned in an earlier post the dbo mapping seems to be ok (according to
the system catalog views)
here is the result of your statement similar to my query
Name name owner_sid sid
Core dbo 0x01 0x01
what else can i try?
mike
"Steven Hemingray [MSFT]" wrote:
> The way to check for the problem is to see if the owner_sid in sys.databas
es
> does not match the sid for dbo in sys.database_principals.
> use YOUR_DATABASE
> go
> select d.name, dp.name, d.owner_sid, dp.sid from sys.databases d,
> sys.database_principals dp where d.owner_sid = dp.sid and dp.name = 'dbo'
> and d.name = 'YOUR_DATABASE'
> If you're still seeing this problem and the above query indicates that the
> sids match, then it must be a different problem and I'd have to do some
> investigation on what else could cause this to fail repeatedly and on
> different independent servers.
> Steven
>
> "FwMsdn" <FwMsdn@.discussions.microsoft.com> wrote in message
> news:EB0942FA-39B3-4590-B7F8-73D59A1A0794@.microsoft.com...
>
>
Showing posts with label unable. Show all posts
Showing posts with label unable. Show all posts
Thursday, March 8, 2012
.net data provider / Data processing extention
Is there somewhere a real usable sample application for this?
I found some samples, but I'm unable to do anything with it.
There are some source code files in the knowledge base. But I don't know how
to apply the Instruction on compile them.
I need realy step by step instructions for a novice. A hint for a good book
would be ok too.
(I'm wonder about the jumbs between gradients in all the documentation and
articles. Example: Open Visual Studio, select ..., to add a class do..., then
implement correct marshaling, use all the named pipes correct, find and
implement Windows APIs and thats realy all, just doit! References: Blind link
Nr 1; Blind link Nr 2; ...)There is a section in msdn describing process of creating a data extension:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_16g2.asp
There is also a sample that is shipped with RS:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_8spu.asp
I will work with you thru the steps. Let's start with trying to compile and
run the sample.
Let me know where you get the first problem.
--
Alex Mineev
Software Design Engineer. Report expressions; Code Access Security; Xml;
SQE.
This posting is provided "AS IS" with no warranties, and confers no rights
"Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
news:F2E68AC2-DEFE-4593-A3AE-FD6FF3CB93F2@.microsoft.com...
> Is there somewhere a real usable sample application for this?
> I found some samples, but I'm unable to do anything with it.
> There are some source code files in the knowledge base. But I don't know
how
> to apply the Instruction on compile them.
> I need realy step by step instructions for a novice. A hint for a good
book
> would be ok too.
> (I'm wonder about the jumbs between gradients in all the documentation and
> articles. Example: Open Visual Studio, select ..., to add a class do...,
then
> implement correct marshaling, use all the named pipes correct, find and
> implement Windows APIs and thats realy all, just doit! References: Blind
link
> Nr 1; Blind link Nr 2; ...)|||Thank you very much!!!
This seems to be a good tip. I try it on monday and post a feedback.
"Alexandre Mineev [MSFT]" wrote:
> There is a section in msdn describing process of creating a data extension:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_16g2.asp
> There is also a sample that is shipped with RS:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_8spu.asp
> I will work with you thru the steps. Let's start with trying to compile and
> run the sample.
> Let me know where you get the first problem.
> --
> Alex Mineev
> Software Design Engineer. Report expressions; Code Access Security; Xml;
> SQE.
> This posting is provided "AS IS" with no warranties, and confers no rights
> "Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
> news:F2E68AC2-DEFE-4593-A3AE-FD6FF3CB93F2@.microsoft.com...
> > Is there somewhere a real usable sample application for this?
> > I found some samples, but I'm unable to do anything with it.
> >
> > There are some source code files in the knowledge base. But I don't know
> how
> > to apply the Instruction on compile them.
> >
> > I need realy step by step instructions for a novice. A hint for a good
> book
> > would be ok too.
> >
> > (I'm wonder about the jumbs between gradients in all the documentation and
> > articles. Example: Open Visual Studio, select ..., to add a class do...,
> then
> > implement correct marshaling, use all the named pipes correct, find and
> > implement Windows APIs and thats realy all, just doit! References: Blind
> link
> > Nr 1; Blind link Nr 2; ...)
>
>|||Now I know the steps required to deploy the assembly. That's an part of the
whole way.
It is still to much for me to get this transfered so I can create a
Dataprovider for a connection to a Oracle database.
I found an article about .net dataprovider with sample files for all classes
(it's called DotNetDataProviderTemplate). I found no way to get this sample
compiled and runing. Although I'm not try to implement the reporting services
interface.
I created a new Project and added all the sample .vb files. But compile this
seems to be imposible, what ever I'm doing. Error are "Type '...' not
defiened and classes are ambiguous. But the Types are defined and the
classenames are unique.
If I would overcome all immediate barriers, I don't know how to set
permission to access a oracle database. I recognized that it is necessary to
set permission. But documented is only SQL Server, not oracle.
I'm using allways VB, a VB Sample would be great. But if the sample is
complete enough C# will be ok too. It seems, that C# is easy to understand.
If no oracle sample is available a complete sample to access a SQL Server
database will be also good.
Thank you for your effort.
"Alexandre Mineev [MSFT]" wrote:
> There is a section in msdn describing process of creating a data extension:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_16g2.asp
> There is also a sample that is shipped with RS:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_8spu.asp
> I will work with you thru the steps. Let's start with trying to compile and
> run the sample.
> Let me know where you get the first problem.
> --
> Alex Mineev
> Software Design Engineer. Report expressions; Code Access Security; Xml;
> SQE.
> This posting is provided "AS IS" with no warranties, and confers no rights
> "Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
> news:F2E68AC2-DEFE-4593-A3AE-FD6FF3CB93F2@.microsoft.com...
> > Is there somewhere a real usable sample application for this?
> > I found some samples, but I'm unable to do anything with it.
> >
> > There are some source code files in the knowledge base. But I don't know
> how
> > to apply the Instruction on compile them.
> >
> > I need realy step by step instructions for a novice. A hint for a good
> book
> > would be ok too.
> >
> > (I'm wonder about the jumbs between gradients in all the documentation and
> > articles. Example: Open Visual Studio, select ..., to add a class do...,
> then
> > implement correct marshaling, use all the named pipes correct, find and
> > implement Windows APIs and thats realy all, just doit! References: Blind
> link
> > Nr 1; Blind link Nr 2; ...)
>
>|||Implementing RS IDbConnection, IDbCommand etc interfaces is easier than full
interfaces defined in System.Data.
The "type not found" errors are probably coming for RS interfaces. You need
to copy two dlls from reportserver/bin:
Microsoft.ReportingServices.Interfaces and ...DataExtensions.dll and you
need to add references to both of the dlls to your project
--
Alex Mineev
Software Design Engineer. Report expressions; Code Access Security; Xml;
SQE.
This posting is provided "AS IS" with no warranties, and confers no rights
"Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
news:33E43A47-1654-4879-9590-0FEE8BF911BC@.microsoft.com...
> Now I know the steps required to deploy the assembly. That's an part of
the
> whole way.
> It is still to much for me to get this transfered so I can create a
> Dataprovider for a connection to a Oracle database.
> I found an article about .net dataprovider with sample files for all
classes
> (it's called DotNetDataProviderTemplate). I found no way to get this
sample
> compiled and runing. Although I'm not try to implement the reporting
services
> interface.
> I created a new Project and added all the sample .vb files. But compile
this
> seems to be imposible, what ever I'm doing. Error are "Type '...' not
> defiened and classes are ambiguous. But the Types are defined and the
> classenames are unique.
> If I would overcome all immediate barriers, I don't know how to set
> permission to access a oracle database. I recognized that it is necessary
to
> set permission. But documented is only SQL Server, not oracle.
> I'm using allways VB, a VB Sample would be great. But if the sample is
> complete enough C# will be ok too. It seems, that C# is easy to
understand.
> If no oracle sample is available a complete sample to access a SQL Server
> database will be also good.
> Thank you for your effort.
>
> "Alexandre Mineev [MSFT]" wrote:
> > There is a section in msdn describing process of creating a data
extension:
> >
> >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_16g2.asp
> >
> > There is also a sample that is shipped with RS:
> >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_8spu.asp
> >
> > I will work with you thru the steps. Let's start with trying to compile
and
> > run the sample.
> > Let me know where you get the first problem.
> >
> > --
> > Alex Mineev
> > Software Design Engineer. Report expressions; Code Access Security; Xml;
> > SQE.
> >
> > This posting is provided "AS IS" with no warranties, and confers no
rights
> >
> > "Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
> > news:F2E68AC2-DEFE-4593-A3AE-FD6FF3CB93F2@.microsoft.com...
> > > Is there somewhere a real usable sample application for this?
> > > I found some samples, but I'm unable to do anything with it.
> > >
> > > There are some source code files in the knowledge base. But I don't
know
> > how
> > > to apply the Instruction on compile them.
> > >
> > > I need realy step by step instructions for a novice. A hint for a good
> > book
> > > would be ok too.
> > >
> > > (I'm wonder about the jumbs between gradients in all the documentation
and
> > > articles. Example: Open Visual Studio, select ..., to add a class
do...,
> > then
> > > implement correct marshaling, use all the named pipes correct, find
and
> > > implement Windows APIs and thats realy all, just doit! References:
Blind
> > link
> > > Nr 1; Blind link Nr 2; ...)
> >
> >
> >|||Thank you, but somehow it doesn't work, wath ever I try.
What exactly must be written in:
Public Sub Open() Implements IDbConnection.Open
to open the connection to database?
As mentioned in my first post I'm a novice in .net and reporting services
too. Something very simple must be wrong. And I only find help like you must
implement ...Interface. But I can't find how to do this exactly.
"Alexandre Mineev [MSFT]" wrote:
> Implementing RS IDbConnection, IDbCommand etc interfaces is easier than full
> interfaces defined in System.Data.
> The "type not found" errors are probably coming for RS interfaces. You need
> to copy two dlls from reportserver/bin:
> Microsoft.ReportingServices.Interfaces and ...DataExtensions.dll and you
> need to add references to both of the dlls to your project
> --
> Alex Mineev
> Software Design Engineer. Report expressions; Code Access Security; Xml;
> SQE.
> This posting is provided "AS IS" with no warranties, and confers no rights
> "Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
> news:33E43A47-1654-4879-9590-0FEE8BF911BC@.microsoft.com...
> > Now I know the steps required to deploy the assembly. That's an part of
> the
> > whole way.
> >
> > It is still to much for me to get this transfered so I can create a
> > Dataprovider for a connection to a Oracle database.
> >
> > I found an article about .net dataprovider with sample files for all
> classes
> > (it's called DotNetDataProviderTemplate). I found no way to get this
> sample
> > compiled and runing. Although I'm not try to implement the reporting
> services
> > interface.
> > I created a new Project and added all the sample .vb files. But compile
> this
> > seems to be imposible, what ever I'm doing. Error are "Type '...' not
> > defiened and classes are ambiguous. But the Types are defined and the
> > classenames are unique.
> >
> > If I would overcome all immediate barriers, I don't know how to set
> > permission to access a oracle database. I recognized that it is necessary
> to
> > set permission. But documented is only SQL Server, not oracle.
> >
> > I'm using allways VB, a VB Sample would be great. But if the sample is
> > complete enough C# will be ok too. It seems, that C# is easy to
> understand.
> > If no oracle sample is available a complete sample to access a SQL Server
> > database will be also good.
> >
> > Thank you for your effort.
> >
> >
> > "Alexandre Mineev [MSFT]" wrote:
> >
> > > There is a section in msdn describing process of creating a data
> extension:
> > >
> > >
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_16g2.asp
> > >
> > > There is also a sample that is shipped with RS:
> > >
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_8spu.asp
> > >
> > > I will work with you thru the steps. Let's start with trying to compile
> and
> > > run the sample.
> > > Let me know where you get the first problem.
> > >
> > > --
> > > Alex Mineev
> > > Software Design Engineer. Report expressions; Code Access Security; Xml;
> > > SQE.
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights
> > >
> > > "Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
> > > news:F2E68AC2-DEFE-4593-A3AE-FD6FF3CB93F2@.microsoft.com...
> > > > Is there somewhere a real usable sample application for this?
> > > > I found some samples, but I'm unable to do anything with it.
> > > >
> > > > There are some source code files in the knowledge base. But I don't
> know
> > > how
> > > > to apply the Instruction on compile them.
> > > >
> > > > I need realy step by step instructions for a novice. A hint for a good
> > > book
> > > > would be ok too.
> > > >
> > > > (I'm wonder about the jumbs between gradients in all the documentation
> and
> > > > articles. Example: Open Visual Studio, select ..., to add a class
> do...,
> > > then
> > > > implement correct marshaling, use all the named pipes correct, find
> and
> > > > implement Windows APIs and thats realy all, just doit! References:
> Blind
> > > link
> > > > Nr 1; Blind link Nr 2; ...)
> > >
> > >
> > >
>
>
I found some samples, but I'm unable to do anything with it.
There are some source code files in the knowledge base. But I don't know how
to apply the Instruction on compile them.
I need realy step by step instructions for a novice. A hint for a good book
would be ok too.
(I'm wonder about the jumbs between gradients in all the documentation and
articles. Example: Open Visual Studio, select ..., to add a class do..., then
implement correct marshaling, use all the named pipes correct, find and
implement Windows APIs and thats realy all, just doit! References: Blind link
Nr 1; Blind link Nr 2; ...)There is a section in msdn describing process of creating a data extension:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_16g2.asp
There is also a sample that is shipped with RS:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_8spu.asp
I will work with you thru the steps. Let's start with trying to compile and
run the sample.
Let me know where you get the first problem.
--
Alex Mineev
Software Design Engineer. Report expressions; Code Access Security; Xml;
SQE.
This posting is provided "AS IS" with no warranties, and confers no rights
"Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
news:F2E68AC2-DEFE-4593-A3AE-FD6FF3CB93F2@.microsoft.com...
> Is there somewhere a real usable sample application for this?
> I found some samples, but I'm unable to do anything with it.
> There are some source code files in the knowledge base. But I don't know
how
> to apply the Instruction on compile them.
> I need realy step by step instructions for a novice. A hint for a good
book
> would be ok too.
> (I'm wonder about the jumbs between gradients in all the documentation and
> articles. Example: Open Visual Studio, select ..., to add a class do...,
then
> implement correct marshaling, use all the named pipes correct, find and
> implement Windows APIs and thats realy all, just doit! References: Blind
link
> Nr 1; Blind link Nr 2; ...)|||Thank you very much!!!
This seems to be a good tip. I try it on monday and post a feedback.
"Alexandre Mineev [MSFT]" wrote:
> There is a section in msdn describing process of creating a data extension:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_16g2.asp
> There is also a sample that is shipped with RS:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_8spu.asp
> I will work with you thru the steps. Let's start with trying to compile and
> run the sample.
> Let me know where you get the first problem.
> --
> Alex Mineev
> Software Design Engineer. Report expressions; Code Access Security; Xml;
> SQE.
> This posting is provided "AS IS" with no warranties, and confers no rights
> "Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
> news:F2E68AC2-DEFE-4593-A3AE-FD6FF3CB93F2@.microsoft.com...
> > Is there somewhere a real usable sample application for this?
> > I found some samples, but I'm unable to do anything with it.
> >
> > There are some source code files in the knowledge base. But I don't know
> how
> > to apply the Instruction on compile them.
> >
> > I need realy step by step instructions for a novice. A hint for a good
> book
> > would be ok too.
> >
> > (I'm wonder about the jumbs between gradients in all the documentation and
> > articles. Example: Open Visual Studio, select ..., to add a class do...,
> then
> > implement correct marshaling, use all the named pipes correct, find and
> > implement Windows APIs and thats realy all, just doit! References: Blind
> link
> > Nr 1; Blind link Nr 2; ...)
>
>|||Now I know the steps required to deploy the assembly. That's an part of the
whole way.
It is still to much for me to get this transfered so I can create a
Dataprovider for a connection to a Oracle database.
I found an article about .net dataprovider with sample files for all classes
(it's called DotNetDataProviderTemplate). I found no way to get this sample
compiled and runing. Although I'm not try to implement the reporting services
interface.
I created a new Project and added all the sample .vb files. But compile this
seems to be imposible, what ever I'm doing. Error are "Type '...' not
defiened and classes are ambiguous. But the Types are defined and the
classenames are unique.
If I would overcome all immediate barriers, I don't know how to set
permission to access a oracle database. I recognized that it is necessary to
set permission. But documented is only SQL Server, not oracle.
I'm using allways VB, a VB Sample would be great. But if the sample is
complete enough C# will be ok too. It seems, that C# is easy to understand.
If no oracle sample is available a complete sample to access a SQL Server
database will be also good.
Thank you for your effort.
"Alexandre Mineev [MSFT]" wrote:
> There is a section in msdn describing process of creating a data extension:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_16g2.asp
> There is also a sample that is shipped with RS:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_8spu.asp
> I will work with you thru the steps. Let's start with trying to compile and
> run the sample.
> Let me know where you get the first problem.
> --
> Alex Mineev
> Software Design Engineer. Report expressions; Code Access Security; Xml;
> SQE.
> This posting is provided "AS IS" with no warranties, and confers no rights
> "Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
> news:F2E68AC2-DEFE-4593-A3AE-FD6FF3CB93F2@.microsoft.com...
> > Is there somewhere a real usable sample application for this?
> > I found some samples, but I'm unable to do anything with it.
> >
> > There are some source code files in the knowledge base. But I don't know
> how
> > to apply the Instruction on compile them.
> >
> > I need realy step by step instructions for a novice. A hint for a good
> book
> > would be ok too.
> >
> > (I'm wonder about the jumbs between gradients in all the documentation and
> > articles. Example: Open Visual Studio, select ..., to add a class do...,
> then
> > implement correct marshaling, use all the named pipes correct, find and
> > implement Windows APIs and thats realy all, just doit! References: Blind
> link
> > Nr 1; Blind link Nr 2; ...)
>
>|||Implementing RS IDbConnection, IDbCommand etc interfaces is easier than full
interfaces defined in System.Data.
The "type not found" errors are probably coming for RS interfaces. You need
to copy two dlls from reportserver/bin:
Microsoft.ReportingServices.Interfaces and ...DataExtensions.dll and you
need to add references to both of the dlls to your project
--
Alex Mineev
Software Design Engineer. Report expressions; Code Access Security; Xml;
SQE.
This posting is provided "AS IS" with no warranties, and confers no rights
"Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
news:33E43A47-1654-4879-9590-0FEE8BF911BC@.microsoft.com...
> Now I know the steps required to deploy the assembly. That's an part of
the
> whole way.
> It is still to much for me to get this transfered so I can create a
> Dataprovider for a connection to a Oracle database.
> I found an article about .net dataprovider with sample files for all
classes
> (it's called DotNetDataProviderTemplate). I found no way to get this
sample
> compiled and runing. Although I'm not try to implement the reporting
services
> interface.
> I created a new Project and added all the sample .vb files. But compile
this
> seems to be imposible, what ever I'm doing. Error are "Type '...' not
> defiened and classes are ambiguous. But the Types are defined and the
> classenames are unique.
> If I would overcome all immediate barriers, I don't know how to set
> permission to access a oracle database. I recognized that it is necessary
to
> set permission. But documented is only SQL Server, not oracle.
> I'm using allways VB, a VB Sample would be great. But if the sample is
> complete enough C# will be ok too. It seems, that C# is easy to
understand.
> If no oracle sample is available a complete sample to access a SQL Server
> database will be also good.
> Thank you for your effort.
>
> "Alexandre Mineev [MSFT]" wrote:
> > There is a section in msdn describing process of creating a data
extension:
> >
> >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_16g2.asp
> >
> > There is also a sample that is shipped with RS:
> >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_8spu.asp
> >
> > I will work with you thru the steps. Let's start with trying to compile
and
> > run the sample.
> > Let me know where you get the first problem.
> >
> > --
> > Alex Mineev
> > Software Design Engineer. Report expressions; Code Access Security; Xml;
> > SQE.
> >
> > This posting is provided "AS IS" with no warranties, and confers no
rights
> >
> > "Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
> > news:F2E68AC2-DEFE-4593-A3AE-FD6FF3CB93F2@.microsoft.com...
> > > Is there somewhere a real usable sample application for this?
> > > I found some samples, but I'm unable to do anything with it.
> > >
> > > There are some source code files in the knowledge base. But I don't
know
> > how
> > > to apply the Instruction on compile them.
> > >
> > > I need realy step by step instructions for a novice. A hint for a good
> > book
> > > would be ok too.
> > >
> > > (I'm wonder about the jumbs between gradients in all the documentation
and
> > > articles. Example: Open Visual Studio, select ..., to add a class
do...,
> > then
> > > implement correct marshaling, use all the named pipes correct, find
and
> > > implement Windows APIs and thats realy all, just doit! References:
Blind
> > link
> > > Nr 1; Blind link Nr 2; ...)
> >
> >
> >|||Thank you, but somehow it doesn't work, wath ever I try.
What exactly must be written in:
Public Sub Open() Implements IDbConnection.Open
to open the connection to database?
As mentioned in my first post I'm a novice in .net and reporting services
too. Something very simple must be wrong. And I only find help like you must
implement ...Interface. But I can't find how to do this exactly.
"Alexandre Mineev [MSFT]" wrote:
> Implementing RS IDbConnection, IDbCommand etc interfaces is easier than full
> interfaces defined in System.Data.
> The "type not found" errors are probably coming for RS interfaces. You need
> to copy two dlls from reportserver/bin:
> Microsoft.ReportingServices.Interfaces and ...DataExtensions.dll and you
> need to add references to both of the dlls to your project
> --
> Alex Mineev
> Software Design Engineer. Report expressions; Code Access Security; Xml;
> SQE.
> This posting is provided "AS IS" with no warranties, and confers no rights
> "Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
> news:33E43A47-1654-4879-9590-0FEE8BF911BC@.microsoft.com...
> > Now I know the steps required to deploy the assembly. That's an part of
> the
> > whole way.
> >
> > It is still to much for me to get this transfered so I can create a
> > Dataprovider for a connection to a Oracle database.
> >
> > I found an article about .net dataprovider with sample files for all
> classes
> > (it's called DotNetDataProviderTemplate). I found no way to get this
> sample
> > compiled and runing. Although I'm not try to implement the reporting
> services
> > interface.
> > I created a new Project and added all the sample .vb files. But compile
> this
> > seems to be imposible, what ever I'm doing. Error are "Type '...' not
> > defiened and classes are ambiguous. But the Types are defined and the
> > classenames are unique.
> >
> > If I would overcome all immediate barriers, I don't know how to set
> > permission to access a oracle database. I recognized that it is necessary
> to
> > set permission. But documented is only SQL Server, not oracle.
> >
> > I'm using allways VB, a VB Sample would be great. But if the sample is
> > complete enough C# will be ok too. It seems, that C# is easy to
> understand.
> > If no oracle sample is available a complete sample to access a SQL Server
> > database will be also good.
> >
> > Thank you for your effort.
> >
> >
> > "Alexandre Mineev [MSFT]" wrote:
> >
> > > There is a section in msdn describing process of creating a data
> extension:
> > >
> > >
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_16g2.asp
> > >
> > > There is also a sample that is shipped with RS:
> > >
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_8spu.asp
> > >
> > > I will work with you thru the steps. Let's start with trying to compile
> and
> > > run the sample.
> > > Let me know where you get the first problem.
> > >
> > > --
> > > Alex Mineev
> > > Software Design Engineer. Report expressions; Code Access Security; Xml;
> > > SQE.
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights
> > >
> > > "Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
> > > news:F2E68AC2-DEFE-4593-A3AE-FD6FF3CB93F2@.microsoft.com...
> > > > Is there somewhere a real usable sample application for this?
> > > > I found some samples, but I'm unable to do anything with it.
> > > >
> > > > There are some source code files in the knowledge base. But I don't
> know
> > > how
> > > > to apply the Instruction on compile them.
> > > >
> > > > I need realy step by step instructions for a novice. A hint for a good
> > > book
> > > > would be ok too.
> > > >
> > > > (I'm wonder about the jumbs between gradients in all the documentation
> and
> > > > articles. Example: Open Visual Studio, select ..., to add a class
> do...,
> > > then
> > > > implement correct marshaling, use all the named pipes correct, find
> and
> > > > implement Windows APIs and thats realy all, just doit! References:
> Blind
> > > link
> > > > Nr 1; Blind link Nr 2; ...)
> > >
> > >
> > >
>
>
Sunday, February 19, 2012
...unable to begin a distributed transaction
I have two SQL Server 2003 servers with SQL Express 2005 installed. The
servers are not on the same network (and not on a VPN), so they are
communicating across the Internet. On both servers, MSDTC is properly
configured, the Windows firewall is turned off, credentials are setup
properly, etc. The servers are linked. Suppose the servers are named A and B.
When I execute the following query from within SQL Server Management Studio
Express on server A, it works:
begin transaction
set xact_abort on
select * from B.MyDatabase.Dbo.MyTable
commit transaction
But when I execute the following query, it does not work:
begin transaction
set xact_abort on
update B.MyDatabase.Dbo.MyTable set MyColumn = 'NewValue' where MyColumn =
'OldValue'
select * from B.MyDatabase.Dbo.MyTable
commit transaction
I get the following error:
OLE DB provider "SQLNCLI" for linked server "B" returned message "No
transaction is active.".
Msg 7391, Level 16, State 2, Line 3
The operation could not be performed because OLE DB provider "SQLNCLI" for
linked server "B" was unable to begin a distributed transaction.
Can someone help me with this issue?
Corey Young
Hi
I see you have posted this in many locations without much success! It sounds
like you have your servers open to the internet without a firewall, this
would not be recommended!
Did you check out
http://support.microsoft.com/default...b;en-us;306212 on how to
debug 7391 errors. I suggest that you try and get it working on two servers
on the same network before making the issue wider. My guess would be that it
could be a permissions issue. Can you do your updating with a remote call to
a stored procedure with the EXECUTE ... AT linked server command?
John
"Young, Corey" wrote:
> I have two SQL Server 2003 servers with SQL Express 2005 installed. The
> servers are not on the same network (and not on a VPN), so they are
> communicating across the Internet. On both servers, MSDTC is properly
> configured, the Windows firewall is turned off, credentials are setup
> properly, etc. The servers are linked. Suppose the servers are named A and B.
> When I execute the following query from within SQL Server Management Studio
> Express on server A, it works:
> begin transaction
> set xact_abort on
> select * from B.MyDatabase.Dbo.MyTable
> commit transaction
> But when I execute the following query, it does not work:
> begin transaction
> set xact_abort on
> update B.MyDatabase.Dbo.MyTable set MyColumn = 'NewValue' where MyColumn =
> 'OldValue'
> select * from B.MyDatabase.Dbo.MyTable
> commit transaction
> I get the following error:
> OLE DB provider "SQLNCLI" for linked server "B" returned message "No
> transaction is active.".
> Msg 7391, Level 16, State 2, Line 3
> The operation could not be performed because OLE DB provider "SQLNCLI" for
> linked server "B" was unable to begin a distributed transaction.
> Can someone help me with this issue?
> --
> Corey Young
servers are not on the same network (and not on a VPN), so they are
communicating across the Internet. On both servers, MSDTC is properly
configured, the Windows firewall is turned off, credentials are setup
properly, etc. The servers are linked. Suppose the servers are named A and B.
When I execute the following query from within SQL Server Management Studio
Express on server A, it works:
begin transaction
set xact_abort on
select * from B.MyDatabase.Dbo.MyTable
commit transaction
But when I execute the following query, it does not work:
begin transaction
set xact_abort on
update B.MyDatabase.Dbo.MyTable set MyColumn = 'NewValue' where MyColumn =
'OldValue'
select * from B.MyDatabase.Dbo.MyTable
commit transaction
I get the following error:
OLE DB provider "SQLNCLI" for linked server "B" returned message "No
transaction is active.".
Msg 7391, Level 16, State 2, Line 3
The operation could not be performed because OLE DB provider "SQLNCLI" for
linked server "B" was unable to begin a distributed transaction.
Can someone help me with this issue?
Corey Young
Hi
I see you have posted this in many locations without much success! It sounds
like you have your servers open to the internet without a firewall, this
would not be recommended!
Did you check out
http://support.microsoft.com/default...b;en-us;306212 on how to
debug 7391 errors. I suggest that you try and get it working on two servers
on the same network before making the issue wider. My guess would be that it
could be a permissions issue. Can you do your updating with a remote call to
a stored procedure with the EXECUTE ... AT linked server command?
John
"Young, Corey" wrote:
> I have two SQL Server 2003 servers with SQL Express 2005 installed. The
> servers are not on the same network (and not on a VPN), so they are
> communicating across the Internet. On both servers, MSDTC is properly
> configured, the Windows firewall is turned off, credentials are setup
> properly, etc. The servers are linked. Suppose the servers are named A and B.
> When I execute the following query from within SQL Server Management Studio
> Express on server A, it works:
> begin transaction
> set xact_abort on
> select * from B.MyDatabase.Dbo.MyTable
> commit transaction
> But when I execute the following query, it does not work:
> begin transaction
> set xact_abort on
> update B.MyDatabase.Dbo.MyTable set MyColumn = 'NewValue' where MyColumn =
> 'OldValue'
> select * from B.MyDatabase.Dbo.MyTable
> commit transaction
> I get the following error:
> OLE DB provider "SQLNCLI" for linked server "B" returned message "No
> transaction is active.".
> Msg 7391, Level 16, State 2, Line 3
> The operation could not be performed because OLE DB provider "SQLNCLI" for
> linked server "B" was unable to begin a distributed transaction.
> Can someone help me with this issue?
> --
> Corey Young
Labels:
database,
distributed,
express,
installed,
microsoft,
mysql,
network,
oracle,
server,
servers,
sql,
theservers,
transaction,
unable,
vpn
...unable to begin a distributed transaction
I have two SQL Server 2003 servers with SQL Express 2005 installed. The
servers are not on the same network (and not on a VPN), so they are
communicating across the Internet. On both servers, MSDTC is properly
configured, the Windows firewall is turned off, credentials are setup
properly, etc. The servers are linked. Suppose the servers are named A and B
.
When I execute the following query from within SQL Server Management Studio
Express on server A, it works:
begin transaction
set xact_abort on
select * from B.MyDatabase.Dbo.MyTable
commit transaction
But when I execute the following query, it does not work:
begin transaction
set xact_abort on
update B.MyDatabase.Dbo.MyTable set MyColumn = 'NewValue' where MyColumn =
'OldValue'
select * from B.MyDatabase.Dbo.MyTable
commit transaction
I get the following error:
OLE DB provider "SQLNCLI" for linked server "B" returned message "No
transaction is active.".
Msg 7391, Level 16, State 2, Line 3
The operation could not be performed because OLE DB provider "SQLNCLI" for
linked server "B" was unable to begin a distributed transaction.
Can someone help me with this issue?
Corey YoungHi
I see you have posted this in many locations without much success! It sounds
like you have your servers open to the internet without a firewall, this
would not be recommended!
Did you check out
http://support.microsoft.com/defaul...kb;en-us;306212 on how to
debug 7391 errors. I suggest that you try and get it working on two servers
on the same network before making the issue wider. My guess would be that it
could be a permissions issue. Can you do your updating with a remote call to
a stored procedure with the EXECUTE ... AT linked server command?
John
"Young, Corey" wrote:
> I have two SQL Server 2003 servers with SQL Express 2005 installed. The
> servers are not on the same network (and not on a VPN), so they are
> communicating across the Internet. On both servers, MSDTC is properly
> configured, the Windows firewall is turned off, credentials are setup
> properly, etc. The servers are linked. Suppose the servers are named A and
B.
> When I execute the following query from within SQL Server Management Studi
o
> Express on server A, it works:
> begin transaction
> set xact_abort on
> select * from B.MyDatabase.Dbo.MyTable
> commit transaction
> But when I execute the following query, it does not work:
> begin transaction
> set xact_abort on
> update B.MyDatabase.Dbo.MyTable set MyColumn = 'NewValue' where MyColumn =
> 'OldValue'
> select * from B.MyDatabase.Dbo.MyTable
> commit transaction
> I get the following error:
> OLE DB provider "SQLNCLI" for linked server "B" returned message "No
> transaction is active.".
> Msg 7391, Level 16, State 2, Line 3
> The operation could not be performed because OLE DB provider "SQLNCLI" for
> linked server "B" was unable to begin a distributed transaction.
> Can someone help me with this issue?
> --
> Corey Young
servers are not on the same network (and not on a VPN), so they are
communicating across the Internet. On both servers, MSDTC is properly
configured, the Windows firewall is turned off, credentials are setup
properly, etc. The servers are linked. Suppose the servers are named A and B
.
When I execute the following query from within SQL Server Management Studio
Express on server A, it works:
begin transaction
set xact_abort on
select * from B.MyDatabase.Dbo.MyTable
commit transaction
But when I execute the following query, it does not work:
begin transaction
set xact_abort on
update B.MyDatabase.Dbo.MyTable set MyColumn = 'NewValue' where MyColumn =
'OldValue'
select * from B.MyDatabase.Dbo.MyTable
commit transaction
I get the following error:
OLE DB provider "SQLNCLI" for linked server "B" returned message "No
transaction is active.".
Msg 7391, Level 16, State 2, Line 3
The operation could not be performed because OLE DB provider "SQLNCLI" for
linked server "B" was unable to begin a distributed transaction.
Can someone help me with this issue?
Corey YoungHi
I see you have posted this in many locations without much success! It sounds
like you have your servers open to the internet without a firewall, this
would not be recommended!
Did you check out
http://support.microsoft.com/defaul...kb;en-us;306212 on how to
debug 7391 errors. I suggest that you try and get it working on two servers
on the same network before making the issue wider. My guess would be that it
could be a permissions issue. Can you do your updating with a remote call to
a stored procedure with the EXECUTE ... AT linked server command?
John
"Young, Corey" wrote:
> I have two SQL Server 2003 servers with SQL Express 2005 installed. The
> servers are not on the same network (and not on a VPN), so they are
> communicating across the Internet. On both servers, MSDTC is properly
> configured, the Windows firewall is turned off, credentials are setup
> properly, etc. The servers are linked. Suppose the servers are named A and
B.
> When I execute the following query from within SQL Server Management Studi
o
> Express on server A, it works:
> begin transaction
> set xact_abort on
> select * from B.MyDatabase.Dbo.MyTable
> commit transaction
> But when I execute the following query, it does not work:
> begin transaction
> set xact_abort on
> update B.MyDatabase.Dbo.MyTable set MyColumn = 'NewValue' where MyColumn =
> 'OldValue'
> select * from B.MyDatabase.Dbo.MyTable
> commit transaction
> I get the following error:
> OLE DB provider "SQLNCLI" for linked server "B" returned message "No
> transaction is active.".
> Msg 7391, Level 16, State 2, Line 3
> The operation could not be performed because OLE DB provider "SQLNCLI" for
> linked server "B" was unable to begin a distributed transaction.
> Can someone help me with this issue?
> --
> Corey Young
Labels:
database,
distributed,
express,
installed,
microsoft,
mysql,
network,
oracle,
server,
servers,
sql,
theservers,
transaction,
unable,
vpn
...unable to begin a distributed transaction
I have two SQL Server 2003 servers with SQL Express 2005 installed. The
servers are not on the same network (and not on a VPN), so they are
communicating across the Internet. On both servers, MSDTC is properly
configured, the Windows firewall is turned off, credentials are setup
properly, etc. The servers are linked. Suppose the servers are named A and B.
When I execute the following query from within SQL Server Management Studio
Express on server A, it works:
begin transaction
set xact_abort on
select * from B.MyDatabase.Dbo.MyTable
commit transaction
But when I execute the following query, it does not work:
begin transaction
set xact_abort on
update B.MyDatabase.Dbo.MyTable set MyColumn = 'NewValue' where MyColumn = 'OldValue'
select * from B.MyDatabase.Dbo.MyTable
commit transaction
I get the following error:
OLE DB provider "SQLNCLI" for linked server "B" returned message "No
transaction is active.".
Msg 7391, Level 16, State 2, Line 3
The operation could not be performed because OLE DB provider "SQLNCLI" for
linked server "B" was unable to begin a distributed transaction.
Can someone help me with this issue?
--
Corey YoungHi
I see you have posted this in many locations without much success! It sounds
like you have your servers open to the internet without a firewall, this
would not be recommended!
Did you check out
http://support.microsoft.com/default.aspx?scid=kb;en-us;306212 on how to
debug 7391 errors. I suggest that you try and get it working on two servers
on the same network before making the issue wider. My guess would be that it
could be a permissions issue. Can you do your updating with a remote call to
a stored procedure with the EXECUTE ... AT linked server command?
John
"Young, Corey" wrote:
> I have two SQL Server 2003 servers with SQL Express 2005 installed. The
> servers are not on the same network (and not on a VPN), so they are
> communicating across the Internet. On both servers, MSDTC is properly
> configured, the Windows firewall is turned off, credentials are setup
> properly, etc. The servers are linked. Suppose the servers are named A and B.
> When I execute the following query from within SQL Server Management Studio
> Express on server A, it works:
> begin transaction
> set xact_abort on
> select * from B.MyDatabase.Dbo.MyTable
> commit transaction
> But when I execute the following query, it does not work:
> begin transaction
> set xact_abort on
> update B.MyDatabase.Dbo.MyTable set MyColumn = 'NewValue' where MyColumn => 'OldValue'
> select * from B.MyDatabase.Dbo.MyTable
> commit transaction
> I get the following error:
> OLE DB provider "SQLNCLI" for linked server "B" returned message "No
> transaction is active.".
> Msg 7391, Level 16, State 2, Line 3
> The operation could not be performed because OLE DB provider "SQLNCLI" for
> linked server "B" was unable to begin a distributed transaction.
> Can someone help me with this issue?
> --
> Corey Young
servers are not on the same network (and not on a VPN), so they are
communicating across the Internet. On both servers, MSDTC is properly
configured, the Windows firewall is turned off, credentials are setup
properly, etc. The servers are linked. Suppose the servers are named A and B.
When I execute the following query from within SQL Server Management Studio
Express on server A, it works:
begin transaction
set xact_abort on
select * from B.MyDatabase.Dbo.MyTable
commit transaction
But when I execute the following query, it does not work:
begin transaction
set xact_abort on
update B.MyDatabase.Dbo.MyTable set MyColumn = 'NewValue' where MyColumn = 'OldValue'
select * from B.MyDatabase.Dbo.MyTable
commit transaction
I get the following error:
OLE DB provider "SQLNCLI" for linked server "B" returned message "No
transaction is active.".
Msg 7391, Level 16, State 2, Line 3
The operation could not be performed because OLE DB provider "SQLNCLI" for
linked server "B" was unable to begin a distributed transaction.
Can someone help me with this issue?
--
Corey YoungHi
I see you have posted this in many locations without much success! It sounds
like you have your servers open to the internet without a firewall, this
would not be recommended!
Did you check out
http://support.microsoft.com/default.aspx?scid=kb;en-us;306212 on how to
debug 7391 errors. I suggest that you try and get it working on two servers
on the same network before making the issue wider. My guess would be that it
could be a permissions issue. Can you do your updating with a remote call to
a stored procedure with the EXECUTE ... AT linked server command?
John
"Young, Corey" wrote:
> I have two SQL Server 2003 servers with SQL Express 2005 installed. The
> servers are not on the same network (and not on a VPN), so they are
> communicating across the Internet. On both servers, MSDTC is properly
> configured, the Windows firewall is turned off, credentials are setup
> properly, etc. The servers are linked. Suppose the servers are named A and B.
> When I execute the following query from within SQL Server Management Studio
> Express on server A, it works:
> begin transaction
> set xact_abort on
> select * from B.MyDatabase.Dbo.MyTable
> commit transaction
> But when I execute the following query, it does not work:
> begin transaction
> set xact_abort on
> update B.MyDatabase.Dbo.MyTable set MyColumn = 'NewValue' where MyColumn => 'OldValue'
> select * from B.MyDatabase.Dbo.MyTable
> commit transaction
> I get the following error:
> OLE DB provider "SQLNCLI" for linked server "B" returned message "No
> transaction is active.".
> Msg 7391, Level 16, State 2, Line 3
> The operation could not be performed because OLE DB provider "SQLNCLI" for
> linked server "B" was unable to begin a distributed transaction.
> Can someone help me with this issue?
> --
> Corey Young
Subscribe to:
Posts (Atom)