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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-12-05 : 08:47:52
|
| Chris writes "HiI'm trying to Update a Paradox database from data in SQL Server 7. To facilitate this I've setup a linked server and can successfully query the Paradox table.SELECT *FROM OPENQUERY(ParadoxCardsDb, 'SELECT * FROM CARDS WHERE Issue = 5')orSELECT * FROM ParadoxCardsDb.[C:\JanusDb]..Cards WHERE Issue = 9The problem arises when I try to issue either an Insert, Update or Delete statement.DELETE FROM ParadoxCardsDb.[C:\JanusDb]..Cards WHERE Issue = 9which returns the following Error MessageServer: Msg 7390, Level 16, State 1, Line 1The requested operation could not be performed because the OLE DB provider 'MSDASQL' does not support the required transaction interface.I've tried running it with SET XACT_ABORT ONDELETE FROM ParadoxCardsDb.[C:\JanusDb]..Cards WHERE Issue = 9and this didn't work either (same error message)However, I've acheived it in DTS using the same ODBC connection and an Execute SQL Task but I need to perform this task through a SP. Any ideas what I'm doing wrong or even if this can be acheived?RegardsChris" |
|
|
|
|
|
Paradox Linked Server