Kbase P576: Edit SQL File to Resolve Error 08004 When Migrating Progress to Sybase
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1B
ODBC DataServer
SYMPTOM(s):
08004:[MERANT][ODBC Sybase ASE driver][SQL Server] Attempt to
locate entry in sysdatabases for database 'DSN Name' by name
failed - no entry found under that name. Make sure the name is
entered properly.
Error 08004 is seen when migrating Progress db to Sybase db, although error does not prevent the migration from completing.
User cannot name ODBC datasource name to be the same as the database name.
CAUSE:
The .sql file that is generated by the ProtoOD tool contains a line similar to the following after the error occurs:
use test
where 'test' is the datasource name and not the database name.
FIX:
When the message box appears;
"Output completed. See .log for more information", do not hit RETURN.
Open the .sql file, delete the line referenced above.
It should be the first line in the .sql file.
After editing the file, save the file and then PRESS RETURN.