Kbase 20825: Use ODBC Datasource Name As The Database Name to Resolve Error 08004 when Migrating Progress to Syba
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
23/07/2003 |
|
Status: Unverified
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.
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. However, this error does not prevent the migration.
FIX:
To avoid the error, use an ODBC datasource named as the database name.