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 |
|
funketekun
Constraint Violating Yak Guru
491 Posts |
 Posted - 2007-10-12 : 16:33:25
|
| I have a query that doesn't work when i use 4 name convention instead of a openquery. The msg is below. Anyone know what is going on?Both queries are the same but one doesn't work.-- worksSELECT TOP 1 * FROM OPENQUERY(AS400_PROD, 'SELECT * FROM PPTREASUSA.ORDDET')-- doesnt workSELECT TOP 1 * FROM AS400_PROD.S1030Y3M.PPTREASUSA.ORDDETServer: Msg 7399, Level 16, State 1, Line 1OLE DB provider 'MSDASQL' reported an error. [OLE/DB provider returned message: Unspecified error][OLE/DB provider returned message: [IBM][iSeries Access ODBC Driver][DB2 UDB]CPF5715 - File ORDDET01 in library QTEMP not found.]OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBSchemaRowset::GetRowset returned 0x80004005: ].http://www.sqlserverstudy.com |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-12 : 23:10:16
|
| Provider issue, not every provider works with 4-part name. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-19 : 22:17:55
|
| Use whatever works. |
|
|
|
|
|
|
linkserver doesn't work.