Kbase 21088: Error 91 with MS SQL Server DataServer after schema pull when scheme holder case sensitiviy does not
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
05/05/2006 |
|
Status: Verified
FACT(s) (Environment):
MS SQL Server DataServer
Progress 9.1B
Progress 9.1C
SYMPTOM(s):
Error 91 running a specific query
** No <file-name> record is available. (91)
Querying character fields within MS SQL Server
SQL server is defined as case insensitive
The query does not return results when there are results which are case insensitive
Schema is pulled from MS SQL Server into Progress schema holder
CAUSE:
When a table is pulled into the schema holder from SQL Server, all character fields are defined as case-sensitive. SQL Server case depends on the code page selected, and at the time of the schema pull, there is no way for the Data Dictionary to know if SQL Server is case-sensitive or not so we have assumed it is case-sensitive.
FIX:
Change character fields to be case-insensitive. Please reference following solution for details.
Progress Solutions:
P7262, "How to identify if a schema is case-sensitive or not with SQL Server?"