Kbase P15084: OLE DB provider returned message unknow error when linking Progress database in MS SQL Server
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
07/06/2005 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
Accessing Progress database with Merant ODBC SQL 92 driver from SQL Server fails
Linking a Progress database from within MS SQL Server
Configuring a Progress database as a linked server
Tables are shown within MS SQL Server 2000 but cannot get selected
OLE DB provider MSDASQL reported an error. Provider did not give any information about the error.
OLE DB provider returned message unknown error
CAUSE:
User account used was sysprogress.
FIX:
Use user account pub . The pub user account owns the by 4GL created Progress database tables.