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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Updating a linked server

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-07-24 : 08:32:59
Chuck writes "I am having a problem updating a linked paradox database using ss7. I have attempted to issue a:

update openquery(assist,'select [bf-desc] from billfreq ')
set [bf-desc] = 'worthless'

Server: Msg 7399, Level 16, State 1, Line 3
OLE DB provider 'MSDASQL' reported an error. The provider did not support an interface.


...would it be possible using openrowset? if so, what is the syntax to hit a Paradox db???

thanks"
   

- Advertisement -