Kbase P166941: Error using MS SQL DataServer having DB2 linked database with table containing a dot '.' character i
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/9/2010 |
|
Status: Unverified
SYMPTOM(s):
Error using MS SQL DataServer having DB2 linked database with table containing a dot '.' character in the table name
S0002:[Microsoft][ODBC SQL Server Driver][SQL Server] Invalid Object name 'TEST_AS400.USERABC.SOMETA.BLENAME'.
FACT(s) (Environment):
Windows
OpenEdge 10.x
CAUSE:
This is expected behavior. OpenEdge MS SQL Server DataServer does not handle table names that contain "." a dot character in the table name.
FIX:
OpenEdge MS SQL Server DataServer has not been tested and certified using other foreign linked databases.
Various workarounds might be used, but should issues occur during the operation in such an environment,
Progress would require reproducing the problem in an supported environment.
In cases like this, Progress recommends using 2 separate DataServer instances: One to be used for accessing MS SQL Server database and another one (ODBC DataServer) to be used for accessing DB2 database.