create a view from a linked table

Question

create a view from a linked table

Biagio Sturiale

Valued Member

Points: 64
More actions
August 9, 2004 at 5:15 am

#164579

How can i save a new view on my local computer that is generated from a linked table?
When i try to do it, the message error displayed is: "The operation could not be performed because the
OLE DB provider 'SQLOLEDB' was unable to begin a distribuited transaction'
Please, someone help me!
Thanks!
Biagio

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

AJ Ahrens SSC-Insane Points: 20676 More actions · Answer 1

Unfortunately, depending on the TYPE of the linked table will depend on this answer...

If the linked table is SQL then YES, IF Excel, Access, Text file, etc... then no. This (I think) is due to the fact that they use the JET engine which doesn't have the functionality built-in..

Good Hunting!

AJ Ahrens

webmaster@kritter.net

Biagio Sturiale Valued Member Points: 64 More actions · Answer 2

Thanks AJ Ahrens for your help!Unfortunately the server that i've linked is a SQL server and sincerely i don't understand the error message.....

Biagio

AJ Ahrens SSC-Insane Points: 20676 More actions · Answer 3

hmmm.

Have you checked both servers and made sure that MS DTC is running?? I would check the linked server and make sure that RPC and (I forget the other) are checked...

Good Hunting!

AJ Ahrens

webmaster@kritter.net

Corie Curcillo SSC-Addicted Points: 418 More actions · Answer 4

What OS versions are on both servers?

Corie Curcillo
MCT, MCDBA, MCSD

veryradiant Grasshopper Points: 11 More actions · Answer 5

I ran into a similar problem a while back when linked to a Oracle server. Depending on how the link was configured, I couldn't access my view within a TRANSACTION. If you are accessing this view within a TRANSACTION, try removing the BEGIN TRANSACTION and COMMIT TRANSACTION.

If you need the TRANSACTION control, try fetching the data into a temporary table first. Then start the TRANSACTION using the temporary table instead of linked view.

Steve

Biagio Sturiale Valued Member Points: 64 More actions · Answer 6

The OS installed on linked server is Windows 2000 Advanced Server ; i've actived also the MS DTC service but nothing is changed......I will try still tomorrow..

Thank to all

Ciao!

Biagio

Biagio Sturiale Valued Member Points: 64 More actions · Answer 7

To create a view from a table that resides in a linked server, execute the query in the query analizer otherwise if you try to save a new view using enterprise manager, it will appear the following error message:

Ciao!

Biagio