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 |
|
dav101
Starting Member
10 Posts |
 Posted - 2004-05-30 : 23:23:15
|
| I set up a linked server using a VFP ODBC Driver. I can see the table in EM.In QA I can do a select using:Select * from Openquery(LinkedServerName,'Select * from MyTable order by Col_PK')This update statement fails:select * from openquery( LinkedServerName, 'update MyTable set misslink=1 where Col_pk=322') with the message belowError MessageCould not process object 'update MyTable set misslink=1 where Col_pk=322'. The OLE DB provider 'MSDASQL' indicates that the object has no columns.I noticed in EM that the Schema column is empty??Did I set this up wrong?Can I do updates and inserts in this fashion or is there something I'm missing?TIA,Mike |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-05-30 : 23:45:10
|
| Try using different notation:SELECT * FROM LinkedServerName...MyTable ORDER BY Col_PKUPDATE LinkedServerName...MyTable SET misslink = 1 WHERE Col_pk = 22This works fine for Access, so I'm assuming it works for FP.Tim |
 |
|
|
|
|
|
Linked Server and MSDASQL Update problem