Kbase P38310: Connecting to Progress via SQL SERVER encounters error "INSU
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/09/2003 |
|
Status: Unverified
FACT(s) (Environment):
MERANT 3.50 32-BIT Progress SQL-89
FACT(s) (Environment):
MERANT 3.70 32-BIT Progress SQL-89
SYMPTOM(s):
Attempting to connect to Progress via SQL SERVER.
SQL SERVER prompts for userid and password.
"MicroSoft DTS IMPORT/EXPORT WIZZARD ERROR:
ERROR SOURCE: MS OLE DB PROVIDER FOR ODBC DRIVERS
ERROR DESCRIPTION: [MERANT][Progress ODBC] INSUFFICIENT INFORMATION TO CONNECT
TO DATA SOURCE.
Database security is not enabled.
CAUSE:
When no PROGRESS (database security) _User records have been created in the
database, it may be necessary to uncheck the "Security Required" option in the
'Advanced' Tab of the PROGRESS ODBC driver setup.
This setting determines whether the logon ID (UID) is required in the connection string.
FIX:
Under the advanced tab on the ODBC administrator, uncheck the "Security
Required" option.