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
|
| hithere 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 @sqldeclare @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 |
|
|
|
|
|
|
Open query problem