Kbase 19670: Common Errors Using Visual Basic and MERANT 3.60
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/25/2008 |
|
SUMMARY:
This solution offers answers to some common error messages that occur
using Progress Version V9.1A on Windows NT4 SP4, ODBC driver MERANT
3.60 32-BIT Progress SQL-92 Version V9.1A and third-party product
Visual Basic 6 SP3.
SOLUTION:
The error messages and solutions are:
-- S1000:[MERANT][ODBC PROGRESS driver][PROGRESS]Column myColumn
in table PUB.myTable has value exceeding its max length or
precision. The data length is greater than the SQL width.
Solution: Adjust the SQL Width (Data Administration).
NOTE: Progress SQL-92 Client cannot access fields with width
values greater than 31995.
-- Client cursor: 11 - No Update tables are specified or
S1109:[MERANT][ODBC PROGRESS driver][PROGRESS]Invalid cursor
position.
Solution: This error often occurs when rdUseClientBacth is
used as CursorDriver. If you use Remote Data Objects (RDO),
instead choose rdUseODBC as CursorDriver. For Recordset use
dbOpenDynamic type for Data Access Objects (DAO).
Reference To Written Documentation:
MSDN Library Visual Studio 6.0.
MERANT Web Site http://www.Merant.com
-- Table/View/Synonym not found (7519)
Solutions:
- Specify the prefix PUB for a table, view or synonym.
Reference To Written Documentation:
Progress Knowledge Base #18813 "SQL-92 Error:
Table/View/Synonym not found ( 7519 )"
- Add the "DefaultSchema" string value set to "PUB" in the
registry:
HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\<your DSN name>
or
HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI\<your DSN name>
This entry allows to keep your existing code written with
ODBC sql-89 Driver.
-- Syntax Error (7587)
Solution: Check your SQL statement. If the field name contains
reserved characters ("), (_) or (-), enclose your field name
in double quotation marks ("). For example, to display all
user names and the user ID, enter this syntax into the
Procedure Editor: "SELECT _userid, _user-name
FROM _user ORDER BY _userid ASC
In Visual Basic, you must use double quotation marks ("):
"SELECT " + Chr(34) + "_userid" + Chr(34) + " FROM PUB." +
Chr(34) +"_user"+Chr(34)