Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
elenabul
Starting Member
7 Posts |
Posted - 2009-06-22 : 15:50:06
|
hi
there is the code:
set @sql='select PUB.so_mstr.* from PUB.so_mstr where so_due_date='''''+@Yesterday+''''' and not so_ship_date is null' select @sql
declare @finalquery varchar(8000) SET @finalquery = 'SELECT * FROM OPENQUERY(MFGPRO,' + '''' + @sql + '''' + ')'
insert into [serve].[SOTransfer].[dbo].[so_mstr] exec(@finalquery) I didn't put all ghe details. All the declarations are done properly. The linked server is Progress database.
The same task works perfectly whe executed with that code:
insert into [s-pentaho].[SOTransfer].[dbo].[so_mstr] SELECT * FROM OPENQUERY(MFGPRO,'select PUB.so_mstr.* from PUB.so_mstr where so_due_date=''06/21/2009'' and not so_ship_date is null')
Do you have any idea how I can fix that? Thanks
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2009-06-22 : 15:51:43
|
what is the error you are receiving? |
 |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-06-22 : 15:52:58
|
What does PRINT @FinalQuery return?
E 12°55'05.63" N 56°04'39.26" |
 |
|
elenabul
Starting Member
7 Posts |
Posted - 2009-06-22 : 15:54:40
|
"The partner transaction manager has disabled its support for remote/network transactions"
Sorry I forgot to mention that |
 |
|
elenabul
Starting Member
7 Posts |
Posted - 2009-06-22 : 15:57:02
|
the final query is :
SELECT * FROM OPENQUERY(MFGPRO,'select PUB.so_mstr.* from PUB.so_mstr where so_due_date=''06/21/2009'' and not so_ship_date is null') |
 |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-06-22 : 16:19:45
|
Have you configured support for distributed transactions?
E 12°55'05.63" N 56°04'39.26" |
 |
|
elenabul
Starting Member
7 Posts |
Posted - 2009-06-22 : 16:31:31
|
I cannot make any configuration for the progress database but I do not think I need it because the 2 versions of the code are distributed transactions, right? Therefore, the question is: What is the difference between them that makes the first one treated differently from the second one? Thanks |
 |
|
|
|
|