Kbase P20673: Schema pull against Sybase does not bring the fields information
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/14/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
FACT(s) (Environment):
ODBC DataServer
SYMPTOM(s):
Schema pull against Sybase does not bring the fields information
[MERANT][ODBC Sybase ASE driver][SQL Server]"DB_NAME"."dbo"."TABLE_NAME" not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
CAUSE:
Use of double quotes in the db objects is not supported by the ODBC Driver
FIX:
This error may occur if the Sybase identifiers are double quoted, to avoid this problem make sure your field names does not contain dashes in their names, if no dashes are included in the names go to the Advanced settings for the Sybase ODBC Datasource then unset the Enable Quoted Identifiers checkbox.
Pull the schema again and you should be able to retrieve all the information about the tables and the fields.