Kbase P78991: Invalid object name when running ProToMSS due to a reserved word
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/17/2004 |
|
Status: Unverified
FACT(s) (Environment):
Windows
Progress 9.1B
Progress 9.1C
Progress 9.1D
OpenEdge 10.0A
MS SQL DataServer
MS SQL
SYMPTOM(s):
S0002 errors running ProToMSS
S0002: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'table-name'.
S0002: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot create an index on 'table-name', because this table does not exist in database 'db-name'.
Migrating a Progress Database to MS SQL Server
Running the ProToMSS Schema Migration Tool
A word such as "DENY" is used as a field name in the Progress database
This same word is also the name of a method within SQL Server
It has not been internally included in the Data Administration's list of reserved words for SQL Server
CAUSE:
Bug# 20040503-023
FIX:
1- Upgrade to Progress 9.1E or OpenEdge 10.0B
2- If migrating is not an option, then rename the field containing the reserved word in Data Dictionary before running ProToMSS. For instance, "DENY" becomes "DENY_"